Power BI
Interactive reports and dashboards from data: Power Query, modelling, DAX
Walk the whole path in Power BI from raw data to an interactive report: connect to sources and clean data with Power Query, build a star-schema model and write DAX measures. By the end you will design dashboards, publish and share reports securely, measure DAX performance and build a sales analytics project end to end.
Course content
Getting started and Power Query
BeginnerWhat BI is, Power BI components and licences, connecting to sources, cleaning data, combining queries and M language basics.
- 1What is Power BI: BI, components and workflowLearn what business intelligence means, how Power BI Desktop, Service and Mobile differ, which licences exist, the views of Desktop and the five-step path from data to a shared report.16 min
- 2Power Query: connecting to and cleaning dataConnect to Excel, CSV, SQL Server and a web page, then fix types, remove, split and merge columns, replace values, fill gaps, pivot and unpivot — every action stays in the Applied Steps list.18 min
- 3Power Query: combining queries and M language basicsStack branch files with Append, attach the product catalogue by a key with Merge, choose the right join kind, and read and improve the M code behind the Applied Steps with a parameter.18 min
Data modelling and DAX
IntermediateThe star schema, fact and dimension tables, relationships and the date table, measures, row and filter context, CALCULATE and time intelligence.
- 4Data modelling: star schema, relationships and the date tableSeparate fact and dimension tables, arrange them into a star schema with 1:* relationships, choose cardinality and filter direction correctly, and create and mark your own date table for time intelligence.18 min
- 5DAX: measures, calculated columns and contextLearn the difference between a calculated column and a measure, row and filter context, SUM, AVERAGE, COUNTROWS and DISTINCTCOUNT, VAR/RETURN variables and safe division with DIVIDE on a small sales dataset.20 min
- 6DAX: CALCULATE, ALL, FILTER and time intelligenceChange the filter context with CALCULATE, compute shares of a total with ALL and ALLEXCEPT, learn when FILTER is needed, and build year-to-date totals and comparisons with last year using TOTALYTD, SAMEPERIODLASTYEAR and DATEADD.22 min
Reports, sharing and governance
AdvancedChoosing visuals, slicers, drill-down, tooltips, bookmarks and dashboard design, plus publishing, workspaces, scheduled refresh, gateways and row-level security.
- 7Visualisation: choosing charts, interactivity and dashboard designPick the visual that fits the question, put key numbers forward with cards and KPIs, make the report interactive with slicers, drill-down, tooltip pages and bookmarks, and make it readable at a glance with conditional formatting and design rules.20 min
- 8Publishing, sharing and governance: workspaces, refresh, RLSPublish a report to the Service, assign workspace roles, tell reports from dashboards, set up scheduled refresh and a gateway, show each manager only their own city with row-level security (RLS), and distribute content as an app.20 min
University level: advanced DAX and a capstone
UniversityIterators, RANKX, context transition, optimisation with Performance Analyzer and DAX Studio, an end-to-end sales analytics dashboard and Copilot.
- 9Advanced DAX and performance: iterators, RANKX, context transitionLearn the mathematical meaning of the SUMX, AVERAGEX and RANKX iterators, when context transition happens and where it traps you, and measure and speed up query time with Performance Analyzer and DAX Studio.25 min
- 10Capstone project: a sales analytics dashboard and CopilotBuild a sales dashboard end to end — from requirements to KPIs, from Power Query and a star model to the measure layer, from report pages to publishing, RLS, refresh and an app — reconcile the numbers and learn what Copilot can do.25 min