If the report below doesn't load within a few seconds.
Getting started
1. What is Power BI?2. Explore your data in Table view3. Your first visual: a card4. Practice: find the numbers5. Skill check: Getting startedVisuals
6. Compare categories with bar charts7. Trends with column and line charts8. Parts of a whole: pie charts9. Exact numbers with table visuals10. Practice: pick and build the chart11. The matrix: rows, columns and totals12. Practice: build a matrix13. Sum, average and count14. Slicers and cross-filtering15. Format visuals: titles, colors, labels16. Practice: filter a page17. Skill check: VisualsData model
18. Tables and relationships19. Facts and dimensions20. Create a relationship21. RELATED and RELATEDTABLE22. How filters flow23. Good model design24. Practice: connect and use a dimension25. Skill check: Data modelPower Query
26. Your first query27. Clean an export: rows, types, errors28. Fix text: trim, case, split, replace29. Append and merge queries30. Unpivot wide spreadsheets31. Fix report-style Excel sheets32. Practice: shape a sales table33. Skill check: Power QueryDAX basics
34. Your first measure: SUM35. AVERAGE, MIN and MAX36. Practice: SUM, AVERAGE, MIN, MAX37. Counting with COUNTROWS and DISTINCTCOUNT38. COUNT and COUNTA39. Profit margin with DIVIDE40. ROUND: tidy numbers41. IF: make a decision42. AND, OR and NOT: combine conditions43. SWITCH: many cases44. Blanks: ISBLANK and COALESCE45. Practice: write the measure46. Calculated columns and RELATED47. Practice: calculated columns48. Skill check: DAX basicsCALCULATE and filter context
49. CALCULATE: change the filters50. CALCULATE with several filters51. CALCULATE inside a visual52. ALL and percent of total53. Practice: CALCULATE54. REMOVEFILTERS and share of a group55. FILTER and VALUES56. ALLEXCEPT, ALLSELECTED and KEEPFILTERS57. Dynamic titles with SELECTEDVALUE58. Fix wrong totals: HASONEVALUE and ISINSCOPE59. Skill check: CALCULATEIterators and row context
60. SUMX and the X functions61. AVERAGEX, MINX and MAXX62. Iterate over groups with VALUES63. Variables, IF and SWITCH64. Practice: iterators65. Skill check: iteratorsTime intelligence
66. Date tables67. Year-to-date with TOTALYTD68. Quarter-to-date and month-to-date69. Compare with last year70. Previous month and DATEADD71. Practice: YTD and last year72. Year-over-year growth, done right73. Skill check: time intelligenceRanking, text and formatting
74. Rank with RANKX75. Top N and lists76. Text functions and FORMAT77. Text functions: LEFT, LEN, SEARCH, SUBSTITUTE78. Conditional formatting79. Practice: rank and label80. Skill check: ranking and formattingShare and secure
81. Publish and share82. Refresh and gateways83. Row-level security84. Row-level security, hands-on85. Skill check: share and secureJob 1: Sales Analyst
86. Monthly sales reportJob 2: Financial Analyst
87. Profitability reviewJob 3: BI Developer
88. Fix the data modelJob 4: Take-home test
89. Analyst take-home testAdvanced DAX
90. Context transition, for real91. Virtual tables: ADDCOLUMNS and SUMMARIZE92. Running totals and rolling windows93. Pareto and ABC classification94. Inactive relationships: USERELATIONSHIP95. Everyday functions: dates, lookups, text96. Budget vs actual: TREATAS97. What-if parameters98. Window functions: OFFSET, WINDOW, INDEX99. Statistics: median, percentiles, spread100. Average of ratios vs ratio of sums101. Top N and the rest102. Compare with the averagePerformance and enterprise
103. Make slow reports fast104. Write faster DAX105. Calculation groups and field parameters106. Incremental refresh and deployment107. Semi-additive measures: balances and stockPower Query in practice
108. Custom and conditional columns110. Group, sort and rank116. Broken steps and robust queries130. Project: the monthly sales fileReport design
109. One page, one story111. Titles that say something112. Color that means something113. The right chart for the question114. Numbers people can readFix the dashboard
115. The numbers don't add up117. Four things the manager asked for118. The year-on-year numbers are wrong119. Repair the query behind the report120. Finish the sales dashboard121. Finish the profit review122. Finish the year-on-year dashboardDAX interview prep
123. Row context vs filter context124. CALCULATE replaces, KEEPFILTERS keeps125. Ranking with ties: Skip, Dense and tie-breakers126. Fiscal years and moving averagesDashboard challenges
127. Challenge 1: Retail performance dashboard128. Challenge 2: CFO target tracker129. Challenge 3: The CEO one-pagerJob 5: Operations Analyst
131. Shipping performanceJob 6: FP&A Analyst
132. Budget vs actual packJob 7: Pricing Analyst
133. Discount scenarioJob 8: Monthly business review
134. Monthly business reviewJob 9: Senior Analyst
135. Executive KPI scorecardJob 10: Analytics Engineer
136. Fix a slow, wrong reportJob 11: Lead BI Developer
137. Secure and ship the sales modelJob 12: Senior interview
138. Senior technical interviewIf the report below doesn't load within a few seconds.
Hint
Thank you
We read every report and fix confirmed problems. You can skip this step meanwhile; your progress is kept.
Full solution