Ravindra BagaleCourses & study guides

29. Practice Exercises and Final Assignment

By Last updated:

Mitrano, vachun Power BI yet nahi – karun yeta. Ya module madhe pratyek module sathi exercises aani shevti ek final assignment aahe. Pratyek exercise Power BI Desktop madhe swatah kara, answer hint lagech baghu naka.

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.