Welcome to ExcelToBI! Whether you're moving from Excel or already building Power BI reports, this page gives you a clear order to learn in. Follow the tracks below, or jump straight to the one that matches your goal.

Which track is right for me?

  • Coming from Excel? Start with Track 1.
  • Already using Power BI but your numbers look wrong? Go to Track 2 (DAX).
  • Reports are slow or hard to maintain? Try Track 3 (Data Modeling).
  • Working with enterprise models? Jump to Track 4 (SSAS Tabular).

Track 1: Power BI foundations

  1. Power BI for Excel users: what changes and what doesn't
  2. Getting and cleaning data with Power Query
  3. Building your first report

Track 2: DAX, from beginner to advanced

Beginner

  1. What is DAX? A beginner's guide
  2. Calculated columns vs. measures
  3. Row context vs. filter context

Intermediate

Advanced

Track 3: Data modeling

Track 4: SSAS Tabular

Still stuck?

Tell me what you'd like covered next via the Contact page, or browse everything by topic using the menu above.

Subscribe to: Posts (Atom)