Lessons
1Getting started with Power BIInstall Desktop, load and clean a sales file, build your first visuals and publish the report to share it.7 min
2Shaping data with Power Query and MClean, unpivot, merge and append messy sales files in Power Query before they ever reach the model.8 min
3Data modeling & DAXTurn flat tables into a star schema, join them with relationships, and write your first DAX measures.7 min
4Star schema & relationship cardinalityModel FMCG sales as one fact table surrounded by dimensions, and avoid the bi-directional trap.7 min
5CALCULATE and filter context in DAXUnderstand filter context, context transition, and why measures beat calculated columns.7 min
6Time intelligence with a proper date tableBuild an Indian fiscal date table and compute MTD, YTD and same-period-last-year correctly.8 min
7Dashboard design tipsLay out a report people actually use: one message per page, the right chart, restrained colour and fast performance.7 min
8Publish to the service: refresh, gateways & RLSMove your report to the Power BI service and control refresh, gateways, workspaces and who sees which rows.7 min