All lessons

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 started

Visuals

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: Visuals

Data 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 model

Power 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 Query

DAX 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 basics

CALCULATE 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: CALCULATE

Iterators 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: iterators

Time 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 intelligence

Ranking, 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 formatting

Share and secure

81. Publish and share82. Refresh and gateways83. Row-level security84. Row-level security, hands-on85. Skill check: share and secure

Job 1: Sales Analyst

86. Monthly sales report

Job 2: Financial Analyst

87. Profitability review

Job 3: BI Developer

88. Fix the data model

Job 4: Take-home test

89. Analyst take-home test

Advanced 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 average

Performance and enterprise

103. Make slow reports fast104. Write faster DAX105. Calculation groups and field parameters106. Incremental refresh and deployment107. Semi-additive measures: balances and stock

Power Query in practice

108. Custom and conditional columns110. Group, sort and rank116. Broken steps and robust queries130. Project: the monthly sales file

Report design

109. One page, one story111. Titles that say something112. Color that means something113. The right chart for the question114. Numbers people can read

Fix 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 dashboard

DAX interview prep

123. Row context vs filter context124. CALCULATE replaces, KEEPFILTERS keeps125. Ranking with ties: Skip, Dense and tie-breakers126. Fiscal years and moving averages

Dashboard challenges

127. Challenge 1: Retail performance dashboard128. Challenge 2: CFO target tracker129. Challenge 3: The CEO one-pager

Job 5: Operations Analyst

131. Shipping performance

Job 6: FP&A Analyst

132. Budget vs actual pack

Job 7: Pricing Analyst

133. Discount scenario

Job 8: Monthly business review

134. Monthly business review

Job 9: Senior Analyst

135. Executive KPI scorecard

Job 10: Analytics Engineer

136. Fix a slow, wrong report

Job 11: Lead BI Developer

137. Secure and ship the sales model

Job 12: Senior interview

138. Senior technical interview

Job 13: Capstone

139. Capstone 1: the model140. Capstone 2: the measures141. Capstone 3: the report142. Capstone 4: the answer
0 XP