COURSE CURRICULUM
Week 1: Foundations of Data & Power BI
- What is Data Analytics?
- Introduction to Power BI Interface
- Connecting to Different Data Sources
- Basic Data Cleaning in Power Query
- Your First Dataset: Load & Explore
Week 2: Data Preparation & Transformation
- Deep Dive into Power Query Editor
- Work with multiple datasets from different sources
- Clean, Filter, Split, and Merge Data
- Append & Combine Multiple Tables
Week 3: Data Visualization
- Power BI Visual Types: Bar, Line, Pie, Map, Matrix, etc.
- Interactive Features: Slicers, Filters, Drill-through
- Visual formatting & Storytelling
- Best Practices for Data Dashboards
Week 4: DAX & Data Modeling
- What is DAX? (Data Analysis Expressions)
- Measures vs. Calculated Columns
- Common DAX Functions: SUM, IF, CALCULATE, etc.
- Build KPIs & Custom Calculations
Week 5: Dashboards & Publishing
- Create real world Interactive Dashboards.
- Publish Reports to Power BI Service
- Create & Share Workspaces
- Introduction to Paginated Reports in Power BI Report Builder.
- Power BI resume tips.
- Establishing a Portfolio Website.