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

29. Practice Exercises and Final Assignment

29.11 Modules 23–24: Design, Reports and Dashboards

By Last updated:

  1. Redesign one of your pages using the layout in Figure 23.1 and apply a custom theme JSON.
  2. Set a custom canvas background image designed in PowerPoint.
  3. Add alt text to every visual on one page and set the tab order.
  4. Publish and create a dashboard with pinned visuals, a live page tile, a Q&A tile and a text tile.
  5. Set an alert on a card tile and edit tile details with a custom link.
  6. Create a mobile layout for the Executive page and for the dashboard.
  7. Explain to a colleague the difference between a report and a dashboard in 5 points.

Practice files (fictional): visuals_orders_apr_may_2026.csv

Hints
  • Sketch first; test the 10-second rule with a classmate.
Solutions (checked on the practice files)
  1. Layout: KPI row, two main visuals, slicer panel; theme JSON applied.
  2. Canvas background › Image › Fit.
  3. Alt text on each visual; tab order in the Selection pane.
  4. Dashboard tiles open the report when clicked.
  5. Alerts only on card, KPI and gauge tiles.
  6. View › Mobile layout; dashboard › Edit › Mobile view.
  7. Report: many pages, interactive, one model, built in Desktop. Dashboard: one page, Service only, pinned tiles from many reports, alerts.

Ravindra Bagale's Tip

Friends, many students skip the design exercises because they "aren't technical". Design is what users see first. Sketch the layout on paper before building, and ask someone else whether they can find the key number in ten seconds. Don't make this mistake!