Course details
Power BI
Learn how Power BI turns raw exports into a report people can rely on. You follow one small tea-shop chain from its first CSV files to a star-schema model and DAX measures: connecting to sources, cleaning with Power Query and M, relating tables, and writing calculations that respond to every filter.
Course curriculum
Introduction to Power BI3 lessons
Meet the Power BI family — Desktop for building, the Service for sharing, Mobile for viewing — then install Desktop the right way and work out which licences a team really needs.
Getting Data In4 lessons
Bring in files, databases, cloud services and APIs, work out which sources need a gateway, then choose between Import, DirectQuery, Dual and Direct Lake storage.
Cleaning Data with Power Query4 lessons
Use Applied Steps as a repeatable recipe, set data types on purpose, remove duplicates by the right columns, and profile columns to find and fix errors at their cause.
M Language Basics4 lessons
Read a whole query in the Advanced Editor, tidy text and split columns, fix number units and extract date parts, and add conditional and custom columns with short M formulas.
Data Modeling4 lessons
Split a wide export into facts and dimensions at a clear grain, prefer a star to a snowflake, merge and append queries correctly, and connect tables with relationships that filter the right way.
DAX Fundamentals5 lessons
Tell DAX from M, read DAX syntax, choose between calculated columns and measures, use aggregators, iterators, logical functions and variables, and change filters with CALCULATE.