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 columns109. Group, sort and rank110. Broken steps and robust queries111. Project: the monthly sales fileJob 5: Operations Analyst
112. Shipping performanceJob 6: FP&A Analyst
113. Budget vs actual packJob 7: Pricing Analyst
114. Discount scenarioJob 8: Monthly business review
115. Monthly business reviewJob 9: Senior Analyst
116. Executive KPI scorecardJob 10: Analytics Engineer
117. Fix a slow, wrong reportJob 11: Lead BI Developer
118. Secure and ship the sales modelJob 12: Senior interview
119. Senior technical interviewHint
Thank you
We read every report and fix confirmed problems. You can skip this step meanwhile; your progress is kept.
Full solution