FreeBeginner to intermediate

Power BI Fundamentals

Power BI turns data into dashboards. Learn the full workflow: import and clean data with Power Query, relate tables in a model, write DAX measures, and design a dashboard that tells a clear business story.

About 12 hours
14 lessons
Final project
Certificate of completion

Curriculum

01Introduction to Business IntelligenceWhat Power BI is, its parts (Desktop, Service, Mobile), the workflow you'll follow in this course, and how to get set up.20 min
02Power BI InterfaceThe four views of Power BI Desktop, the panes you'll use constantly, and how report pages work.20 min
03Importing DataLoad CSV files into Power BI, choose between Load and Transform Data, and check that what arrived is complete and correctly typed.25 min
04Power QueryShape data with Power Query - applied steps, types, custom columns, merges - and profile columns to spot problems.35 min
05Data CleaningClean a messy export with Trim, Capitalize Each Word, Replace Values, locale-aware dates and case-sensitive duplicate removal.40 min
06Data RelationshipsConnect tables with one-to-many relationships so filters flow from customers and products to orders.30 min
07Data ModellingFinish the star schema with a proper date table, sort months correctly, and tidy the model so reports are easy to build.35 min
08DAX FundamentalsThe difference between calculated columns and measures, how filter context works, and the core DAX functions.40 min
09MeasuresChange the filter context with CALCULATE, build percentage-of-total, year-to-date and year-on-year measures.45 min
10VisualizationsThe visuals you'll use most, how to configure and format them, and how visuals interact on a page.35 min
11Dashboard DesignLay out a report page people understand in five seconds - hierarchy, consistency, restraint and accessibility.30 min
12Business StorytellingTurn a report into an argument - context, finding, cause and recommendation - with titles, annotations, bookmarks and navigation.30 min
13Publishing ReportsPublish to the Power BI Service, share safely, keep data fresh with scheduled refresh, and show your work in a portfolio.30 min
14Final Dashboard ProjectPlan and start a practice-management dashboard for a law firm, checking your model against known numbers before you build.45 min

Loading…