29. Practice Exercises and Final Assignment
29.13 Final Assignment: "Blinkit vs Amazon Now – City Performance Report"
Scenario. The (fictional) leadership team wants to review quick-commerce performance for the Indian financial year (April–March) across Pune, Nashik, Nagpur, Kolhapur, Solapur and Sambhaji Nagar, and compare Blinkit with Amazon Now. Use only the fictional sample data.
Requirements:
- Data preparation: use parameters for the folder path and start date; combine monthly Blinkit files with the Folder connector; standardise city spellings with a mapping table; flag invalid values; clean and rename the Amazon Now file and append it; add Order Date, Order Hour and Delivery Band; remove errors and duplicates; document every applied step with meaningful names.
- Model: star schema with Orders, Product, Customer, DarkStore, DeliveryPartner and a DAX Date table with Fiscal Year and Fiscal Quarter; inactive Delivered Date relationship; all keys hidden; Location, Date and Product hierarchies; a Region group; a
_Measurestable with display folders. - Measures (minimum 18): base measures, AOV, Cancellation Rate, Avg Delivery Time, % Orders Delivered Under 10 Mins, Orders per Dark Store, Repeat Customer %, FYTD sales (
TOTALYTDwith"3/31"), sales last FY YTD, YoY %, 7-day moving average of orders, store speed rank, top 5 product share, platform share %, dynamic title. - Report (minimum 4 pages + 1 drill-through + 1 tooltip page): executive overview, delivery operations, customers & products, and a Blinkit vs Amazon Now comparison page – with synced slicers, a page navigator menu, a show/hide filter panel, bookmarks, drill down on the Location hierarchy, dynamic titles, conditional colours (delivery time > 15 min red), a dark store map, a dynamic Top N chart and at least one field parameter.
- Security: dynamic RLS for city managers (Ravindra Bagale – Pune, Shraddha Bagale – Nashik, Shahrukh – Nagpur, Zoya – Kolhapur, Amir – Solapur, Raja – Sambhaji Nagar; Ravina sees Pune and Solapur).
- Service: publish, create a dashboard with 4 pinned tiles, one alert, one subscription and an app (if your licence allows).
- Presentation: a 5-minute walkthrough explaining 3 insights from your sample data and 3 design decisions.
Evaluation guide for trainers:
| Area | Weight |
|---|---|
| Data preparation and documentation | 15% |
| Data model design | 20% |
| DAX correctness and readability | 25% |
| Report design, storytelling and accessibility | 25% |
| Security, Service configuration and presentation | 15% |
Final assignment ghaai ne karu naka. Ek ek step purna kara, check kara, mag pudhe jaa. All the best!
Ravindra Bagale's Tip
Mitrano, khup students try to build the final assignment in one sitting and get stuck. Split it into the steps of Module 28, finish and check each step, and keep a short log of decisions (KPI definitions, assumptions) that you can explain in an interview. Bilkul visru naka.
Thodkyaat sangaycha tar (quick recap)
Pratyek exercise swatah kara, results source shi jodun bagha, aani final assignment Module 28 chya steps ne kara. Aata pudhe jaauya interview preparation kade.