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 8 hours
14 modules
1 badge
Final project
Optional verified certificate
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.15 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.20 min
05Data CleaningClean a messy export with Trim, Capitalize Each Word, Replace Values, locale-aware dates and case-sensitive duplicate removal.20 min
06Data RelationshipsConnect tables with one-to-many relationships: cardinality, filter direction, active and inactive relationships, and the star schema of facts and dimensions.15 min
07Data ModellingComplete the star schema with a date table built in DAX, explained piece by piece; mark it, sort months properly, add a hierarchy and tidy the model.20 min
08DAX FundamentalsHow DAX thinks: calculated columns versus measures, filter context and row context, SUMX, DIVIDE, SWITCH, RELATED and variables, with Kolanut's real results.25 min
09MeasuresChange the filters with CALCULATE: fixed segments, shares of the total with REMOVEFILTERS and ALLSELECTED, and time intelligence for year to date and year on year.20 min
10VisualizationsThe visuals you'll use most, how to configure and format them, and how visuals interact on a page.15 min
11Dashboard DesignLay out a report page people understand in five seconds - hierarchy, consistency, restraint and accessibility.20 min
12Business StorytellingTurn a report into an argument - context, finding, cause and recommendation - with titles, annotations, bookmarks and navigation.15 min
13Publishing ReportsPublish to the Power BI Service, share safely, keep data fresh with scheduled refresh, and show your work in a portfolio.15 min
14Final Dashboard ProjectPlan and start a practice-management dashboard for a law firm, checking your model against known numbers before you build.20 min
Final assessmentPass it (60% or more) to earn the Power BI Fundamentals course completion badge.