Course Introduction
Data Analytics & Python
With 3.5 months of intensive training, this course will focus on building a solid Data Analytics mindset for you to be ready to fight anywhere, confidently applying for fresher/junior Data Analyst/Business Intelligence Analyst positions.
Curriculum
Week 1:
- SQL – Introduction to SQL
- SQL – Aggregation in SQL
Week 2:
- SQL – Joins & Unions
- SQL – Subqueries
Week 3:
- SQL – Functions
Week 4:
- SQL – CASE statements
- SQL – CTEs
Week 5:
- SQL – Database Design Fundamentals
Week 6:
- PYTHON – EDA Process, Python libraries for EDA
- PYTHON – Data exploration & validation
- PYTHON – Statistics
- PYTHON – Data quality issues
- PYTHON – Data summarisation
Week 7:
- PYTHON – Data manipulation/ transformation/ engineer
- PYTHON – Missing/ duplicated values
- PYTHON – Outliers
- PYTHON – Scaling/Normalisation
Week 8:
- PYTHON – Relationship in data
- PYTHON – Correlation matrix
- PYTHON – Heatmap
- PYTHON – Time series
Week 9:
- PYTHON – Personal project
- PYTHON – Personal project
Week 10:
- POWER BI – Introduction to Power BI and its use
- POWER BI – Building blocks and navigate Power BI
- POWER BI – Data transformation with Power Query
- POWER BI – Data modeling and relationship
Week 11:
- POWER BI – DAX calculations
- POWER BI – DAX calculations
Week 12:
- POWER BI – Visual best practices and building
- POWER BI – Visual best practices and building
Week 13:
- POWER BI – Visual control and interaction
- POWER BI – Personal project
Week 14:
- POWER BI – Personal project
- POWER BI – Personal project
Week 15:
- Effective Resume
Amazing Pricing
Affordable Pricing
Let's Work Together
IT Service Agency
