Ravindra BagaleCourses & study guides मराठी Track your progress

29. Practice Exercises and Final Assignment

Friends, you do not learn Power BI by reading – you learn it by doing. This module has exercises for every module and a final assignment at the end. Do every exercise yourself in Power BI Desktop, and do not look at the answer hint straight away.

Live story: Practice like the job

Suppose your first manager gives you a messy file and says, "Show me sales by city by tomorrow." Practice exercises are that tomorrow, done safely today. This chapter gives exercises chapter by chapter and a final assignment.

All numbers in this story are fictional practice data.

Use the fictional Blinkit and Amazon Now sample datasets (Module 1.7) for all exercises. Try each exercise on your own before looking at the hints.

Concepts in this chapter

  1. 29.1Modules 1–2: Introduction and Interface
  2. 29.2Modules 3–5: Getting Data, Databases, Web and Google Sheets
  3. 29.3Modules 6–7: Power Query Essentials and Data Cleaning
  4. 29.4Module 8: Add Column, Calculated Columns and Measures
  5. 29.5Modules 9–10: Folder Combine and Parameters
  6. 29.6Modules 11–12: Data Modelling, Hierarchies and Groups
  7. 29.7Module 13: DAX (with answer hints)
  8. 29.8Modules 14–15: Visuals, Formatting and Maps
  9. 29.9Modules 16–19: Drill, Drill Through, Tooltips and Bookmarks
  10. 29.10Modules 20–22: Dynamic Text and Colour, Dynamic Charts, Filters and Slicers
  11. 29.11Modules 23–24: Design, Reports and Dashboards
  12. 29.12Modules 25–27: Service, RLS and Performance
  13. 29.13Final Assignment: "Blinkit vs Amazon Now – City Performance Report"

The chapter recap is at the end of the last concept page.

Ravi Sir's Cards: 1 revision, interview and comparison cards for this chapter · मराठी cards