Power BI Data Modelling: Build a Star Schema (and Why Your Report Is Slow Without One)
Learn the star schema for Power BI: fact and dimension tables, one-to-many relationships, filter direction, a proper date table, and how to turn a…
Read article →Power BI & DAX
Power BI Desktop, data modelling and DAX measures explained for Excel users.
DAX CALCULATE Explained: Filter Context Without the Headache
DAX CALCULATE Explained: Filter Context Without the Headache
A deep, practical guide to CALCULATE in Power BI and Power Pivot: filter context, row context, ALL, REMOVEFILTERS, KEEPFILTERS, time intelligence and the patterns…
Read article →Power BI Lesson 1: Desktop Tour and Loading Data
Power BI Lesson 1: Desktop Tour and Loading Data
Install Power BI Desktop, learn the Report, Table and Model views, load several Excel tables through Power Query, check data types, and save a…
Read article →Power BI Lesson 7: Time Intelligence for the Indian Financial Year
Power BI Lesson 7: Time Intelligence for the Indian Financial Year
Year-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, SAMEPERIODLASTYEAR, DATEADD…
Read article →Power BI Time Intelligence for the Indian Financial Year (April–March)
Power BI Time Intelligence for the Indian Financial Year (April–March)
Build FY-aware Power BI reports: a marked Calendar table with FY columns, FYTD with a 31 March year end, previous year and growth, FY…
Read article →Power BI Lesson 10: Publish, Refresh and Share (Project)
Power 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, share via…
Read article →Power BI Lesson 9: Slicers, Drill-Down, Tooltips and Bookmarks
Power BI Lesson 9: Slicers, Drill-Down, Tooltips and Bookmarks
Make 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 saved views.
Read article →Power BI Lesson 8: Visuals That Communicate
Power BI Lesson 8: Visuals That Communicate
Choose and format Power BI visuals: cards and KPIs, bar vs column vs line, tables and matrices, maps, conditional formatting, consistent themes and page…
Read article →Power BI Lesson 5: Your First DAX — SUM, COUNTROWS, DIVIDE
Power BI Lesson 5: Your First DAX — SUM, COUNTROWS, DIVIDE
Write the core measures every report needs: total sales with SUMX, cost and margin, order counts with COUNTROWS, distinct counts, averages, and safe ratios…
Read article →Power BI Lesson 4: Measures vs Calculated Columns
Power BI Lesson 4: Measures vs Calculated Columns
Understand the difference that confuses every beginner: calculated columns compute per row and are stored; measures compute on the fly in filter context. When…
Read article →Power BI Lesson 3: Relationships and Filter Direction
Power BI Lesson 3: Relationships and Filter Direction
Connect tables in the Model view: one-to-many relationships, cardinality, single vs both cross-filter direction, active and inactive relationships, and fixing the blank row and…
Read article →