Power BI turns Excel and database data into interactive dashboards that update themselves. This course takes an Excel user through the parts that matter: a proper data model, relationships, DAX measures, CALCULATE, Indian financial-year time intelligence, good visuals and publishing.

All lessons use one practice data model (Sales, Products, Customers, Calendar) with expected results to check your measures.

1. 1Power BI Lesson 1: Desktop Tour and Loading DataInstall Power BI Desktop, learn the Report, Table and Model views, load several Excel tables through Power Query, check data types, and…
2. 2Power BI Lesson 2: The Data Model — Facts, Dimensions and a Star SchemaDesign a Power BI model that works: fact tables vs dimension tables, why a star schema beats one big flat table, keys,…
3. 3Power BI Lesson 3: Relationships and Filter DirectionConnect tables in the Model view: one-to-many relationships, cardinality, single vs both cross-filter direction, active and inactive relationships, and fixing the blank…
4. 4Power BI Lesson 4: Measures vs Calculated ColumnsUnderstand the difference that confuses every beginner: calculated columns compute per row and are stored; measures compute on the fly in filter…
5. 5Power BI Lesson 5: Your First DAX — SUM, COUNTROWS, DIVIDEWrite the core measures every report needs: total sales with SUMX, cost and margin, order counts with COUNTROWS, distinct counts, averages, and…
6. 6Power BI Lesson 6: CALCULATE and Filter ContextUnderstand filter context, then change it with CALCULATE: sales for one category, ignore a filter with ALL and REMOVEFILTERS, share of total,…
7. 7Power BI Lesson 7: Time Intelligence for the Indian Financial YearYear-to-date, previous year and year-on-year growth for an April–March financial year: mark the date table, TOTALYTD with a 31 March year end,…
8. 8Power BI Lesson 8: Visuals That CommunicateChoose and format Power BI visuals: cards and KPIs, bar vs column vs line, tables and matrices, maps, conditional formatting, consistent themes…
9. 9Power BI Lesson 9: Slicers, Drill-Down, Tooltips and BookmarksMake reports interactive: slicers and sync across pages, cross-filtering and edit interactions, drill-down hierarchies, drill-through detail pages, report-page tooltips and bookmarks for…
10. 10Power BI Lesson 10: Publish, Refresh and Share (Project)Finish and share the course project: build a one-page sales dashboard, publish to the Power BI service, schedule refresh with a gateway,…

Related: your first Power BI report, CALCULATE explained, star schema, Indian FY time intelligence.