Month 5 of 7 · 21–24 hours
Power BI for Data Analysis
Power BI is Microsoft's business intelligence tool for building interactive reports and dashboards. This course follows the same path a real report takes: import data, clean it in Power Query, connect tables in a data model, write simple DAX measures, and present the results with KPI cards, charts and interactive features.
Weeks
- Week 1Power BI Basics and Data ImportInstall Power BI, find your way around, and load your first dataset.4–5 hours · 3 videosDone
- Week 2Power Query and Data TransformationClean and reshape data in Power Query so it is ready to model.5–6 hours · 2 videosDone
- Week 3Data Modeling, Table Relationships and DAX BasicsConnect your tables properly and write your first calculations.6 hours · 4 videosDone
- Week 4KPI Cards, Data Visualization and Interactive DashboardsPresent your model as a clear, interactive dashboard that answers business questions.6–7 hours · 5 videosDone
- FinalInteractive Sales Dashboard in Power BIGraded project with a rubric.
What you will be able to do
- Navigate Power BI Desktop's Report, Table and Model views.
- Import data from Excel and CSV files.
- Clean and transform data with Power Query.
- Build a star schema data model with correct table relationships.
- Write basic DAX measures such as total sales, profit margin and counts.
- Design an interactive dashboard with KPI cards, charts, slicers and drill-through.
Before you start
Prerequisites: Course 1 (Excel) is strongly recommended. Course 2 (SQL) helps with relationships.
Tools: Power BI Desktop (free download for Windows from Microsoft). Mac users can run it through a Windows virtual machine or a lab computer. Use a free sample dataset such as Microsoft's Financial Sample workbook or a Superstore sales file.
Schedule
| Week | Topics | Time |
|---|---|---|
| Week 1 | Power BI Basics and Data Import | 4 to 5 hrs |
| Week 2 | Power Query and Data Transformation | 5 to 6 hrs |
| Week 3 | Data Modeling, Table Relationships and DAX Basics | 6 hrs |
| Week 4 | KPI Cards, Data Visualization and Interactive Dashboards | 6 to 7 hrs |
Each week includes learning objectives, plain-language lessons with examples, beginner videos, a practice activity, a self-check quiz with answers and a graded assignment.