29. Practice Exercises and Final Assignment

29.8 Modules 14–15: Visuals, Formatting and Maps

By Ravindra Bagale · Last updated: 25 September 2026

1. Build one example of every chart in the Module 14.3 table using our data, and write one sentence per chart on why it fits the question.
2. Format a bar chart with the 10-click routine (Module 14.2) and copy the format to three visuals with Format painter.
3. Build a line and column chart of Orders and Avg Delivery Time by Order Hour (IST). Which hours look busiest in your sample data? Compare a normal week with the Diwali week.
4. Build a waterfall of Orders from September to October broken down by City.
5. Build a scatter chart of stores (Orders vs Avg Delivery Time) with a play axis by month and constant lines for quadrants.
6. Build a KPI visual for Avg Delivery Time with direction Low is good.
7. Add a forecast (30 days) and an average line to a daily orders line chart.
8. Use the decomposition tree to explain Total Orders by City › Area › Category.
9. Enable map visuals, set data categories, and build a dark store bubble map with latitude/longitude, bubble size = Orders and conditional colours.
10. Explain why a Map Location column like "Solapur, Maharashtra, India" reduces geocoding errors.