Microsoft · Dashboarding & Reporting

TOS-201 · Power BI - Data Analysis and Visualization

Connect, clean and model data, write DAX, and design and secure Power BI reports in enhanced hands-on lab guides. Exam prep with practice questions organised by lab, each answer checked against Microsoft Learn and explained option by option, with memory hooks and common exam traps.

  • 🧪 13 enhanced hands-on lab guides
  • 📘 Exam prep (487 practice questions)

Access is by invitation: ask your instructor or administrator.

What the course includes

Two parts that work together

You learn the concepts, build them in the product and check what you know, with each part pointing to the others.

Enhanced hands-on lab guides

Each lab is a step-by-step guide with a screenshot of every screen and the reason behind each step. The guides are replayed against the live product, so the steps match what you will see.

13 labs, in course order

Exam prep with explained answers

487 practice questions organised by lab, each answer checked against Microsoft Learn and explained option by option. Learn mode gives a hint first and the explanation after; timed practice exams show where you stand.

50 questions in 100 minutes, 700 of 1000 to pass

Course outline

The labs, in order

Each lab has its guide and the practice questions that belong to it.

  1. Lab 00Set up your own environment
  2. Lab 01Get data in Power BI
  3. Lab 02Clean, transform, and load data in Power BI
  4. Lab 03Configure a semantic model in Power BI
  5. Lab 04Create DAX calculations in semantic models
  6. Lab 05Modify DAX filter context in Power BI
  7. Lab 06Use DAX time intelligence functions in Power BI
  8. Lab 07Create visual calculations in Power BI Desktop
  9. Lab 08Design Power BI reports
  10. Lab 09Enhance Power BI report designs
  11. Lab 10Perform analytics in Power BI
  12. Lab 11Secure data access in Power BI
  13. Lab 12(Optional) Create dashboards in Power BI
How you study

Learn, build, practise, review

  1. LearnRead the lab guide's overview of the concepts.
  2. BuildWork through the lab guide in the product itself, step by step.
  3. PractiseAnswer that lab's questions in Learn mode: a hint first, then the explained answer.
  4. ReviewTake a timed practice exam; what you got wrong becomes your review list.