Introduction
  • Introduction
  • 20 Minute Dashboard - No Formula Required
  • Structure Like a Software Developer
  • Tidy Data
  • Tables - Essential Step
Get & Transform
  • Automate Refresh with Power Query
  • Merging Data an Alternative to VLookups or DB Joins
  • Merge a Folder of Files
  • Transforming Pivot Data
Modelling
  • Input Driver Sheet with Named Ranges
  • Compensation Cost Modelling Intro
  • Power Query vs Worksheet Calculations
  • Driver Based Model
  • What If Analysis - Goal Seek, Solver, Scenario Manager
New Visualisations
  • Excel Treemaps and Sunbursts vs Power BI
  • 3D Maps
Conclusion and Extra Resources
  • How to Reach the Next Level
  • Bonus: Move to the Next Level with a 95% OFF Discount
  • Vlookup vs Power Query vs DB Joins vs OLAP vs R