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

29. Practice Exercises and Final Assignment

29.9 Modules 16–19: Drill, Drill Through, Tooltips and Bookmarks

By Last updated:

  1. On a column chart with the Location hierarchy, use all four drill buttons and describe what each did.
  2. Show the difference between Go to next level and Expand all down on the Date hierarchy with two years of data.
  3. In a matrix, expand only Pune, then the entire City level; exclude a test store with right-click › Exclude.
  4. Create a drill-through page for Dark Store details (e.g. right-click Hinjewadi or CIDCO) with a Back button. Test Keep all filters on and off.
  5. Add a drill-through button that is disabled until one store is selected.
  6. Create a report-page tooltip that shows AOV and Cancellation Rate for a hovered city.
  7. Turn on modern visual tooltips and use a drill action from inside a tooltip.
  8. Add bookmarks to toggle between a chart view and a table view in the same space (Data unticked).
  9. Build a show/hide filter panel using a grouped rectangle + slicers and two bookmarks.
  10. Build a vertical page navigator side menu and a bookmark navigator for Blinkit / Amazon Now / Both.

Practice files (fictional): visuals_orders_apr_may_2026.csv, dark_stores_maharashtra.csv

Hints
  • Test every path as a user, including Back.
Solutions (checked on the practice files)
  1. Drill on Region › City › Store: West ₹850 → Pune ₹850 → Kothrud ₹650, Baner ₹200.
  2. Next level replaces the level; Expand all down keeps parent labels (e.g. Pune Kothrud).
  3. Expand only Pune shows Kothrud and Baner; Exclude removes the selected item from the visual.
  4. Drill through on Kothrud: 2 orders, ₹650 (301, 306).
  5. Button with a drill-through destination stays disabled until one store is selected.
  6. Tooltip values: AOV Pune ₹283.33, Nashik ₹266.67, Kolhapur ₹450; cancellation Pune 0%, Nashik 0%, Kolhapur 50%.
  7. Modern tooltips allow drill actions from the tooltip.
  8. Two bookmarks with Data off (Module 19.4).
  9. Group the panel and slicers; two bookmarks show/hide the group.
  10. Page navigator from Insert › Buttons › Navigator.

Ravindra Bagale's Tip

A common mistake is building drill through and bookmarks and never testing them as a user would. After each exercise, click through every path, including the Back button and the Reset button. It's very simple – just make it a habit.