29. Practice Exercises and Final Assignment
29.13 Final Assignment: "Blinkit vs Amazon Now – City Performance Report"
Plan the final assignment before you build — example — in 30 seconds
What: Before you build the final assignment, turn each requirement into a measure, a visual and a page, on paper.
Why: Students start dragging charts and miss half the brief. A plan table keeps every requirement covered.
Tiny example: Requirement "Compare platforms by city", then measure Total Sales, then clustered column chart with Legend = Platform.
Plan the final assignment before you build — example — 30 सेकंदात
काय: Final assignment बनवण्याआधी, प्रत्येक requirement चं measure, visual आणि page मध्ये रूपांतर कागदावर करा.
का: Students सरळ charts ओढायला लागतात आणि अर्धा brief विसरतात. Plan table मुळे प्रत्येक requirement cover होते.
छोटं उदाहरण: Requirement "शहरानुसार platforms ची तुलना", then measure Total Sales, then Legend = Platform असलेला clustered column chart.
Plan the final assignment before you build — example — 30 सेकंड में
क्या: Final assignment बनाने से पहले, हर requirement को measure, visual और page में काग़ज़ पर बदलिए.
क्यों: Students सीधे charts खींचने लगते हैं और आधा brief भूल जाते हैं. Plan table से हर requirement cover होती है.
छोटा उदाहरण: Requirement "शहर के हिसाब से platforms की तुलना", then measure Total Sales, then Legend = Platform वाला clustered column chart.
First look at the data (before, then after):
Same before / after tables as text
Before — Brief lines (Blinkit vs Amazon Now – City Performance Report)
| # | Requirement |
|---|---|
| 1 | Total sales and orders for each platform |
| 2 | Compare platforms by city |
| 3 | Show the % of orders delivered under 10 minutes |
| 4 | City managers see only their city |
About this data: This table uses columns: Measure, Visual, Page. This table uses columns: Area, Weight. Values shown are the lesson examples already on this page (not a new dataset).
Formula / click path
For each requirement: measure, then visual, then page, then check one number by hand
After — Plan table
| # | Measure | Visual | Page |
|---|---|---|---|
| 1 | Total Sales, Total Orders | Cards + Platform slicer | Overview |
| 2 | Total Sales | Clustered column: City, Legend = Platform | Overview |
| 3 | % Orders Delivered Under 10 Mins | Bar by city, sorted | Delivery |
| 4 | — | RLS role on DarkStore[City] | Modeling › Manage roles |
Do it step by step:
- Copy every line of the brief into column 1 of a plan table.
- For each line, write the measure you need.
- Write the visual next to it.
- Write the page it lives on.
- Build page by page. Tick a line only after you check one number by hand.
- Finish with an RLS test (View as) and a Performance Analyzer run.
एक-एक step करून बघा:
- Brief ची प्रत्येक line plan table च्या column 1 मध्ये copy करा.
- प्रत्येक line साठी लागणारा measure लिहा.
- त्याच्या शेजारी visual लिहा.
- तो कोणत्या page वर राहतो ते लिहा.
- Page by page बनवा. एक number हाताने तपासल्यावरच line वर tick करा.
- शेवटी RLS test (View as) आणि Performance Analyzer run करा.
एक-एक step करके देखिए:
- Brief की हर line plan table के column 1 में copy कीजिए.
- हर line के लिए ज़रूरी measure लिखिए.
- उसके बगल में visual लिखिए.
- वह किस page पर रहेगा, लिखिए.
- Page by page बनाइए. एक number हाथ से जाँचने के बाद ही line पर tick कीजिए.
- आख़िर में RLS test (View as) और Performance Analyzer run कीजिए.
Scenario. The (fictional) leadership team wants to review quick-commerce performance for the Indian financial year (April–March) across Pune, Nashik, Nagpur, Kolhapur, Mumbai 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 – Mumbai, Raja – Sambhaji Nagar; Ravina sees Pune and Mumbai).
- 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% |
Do not rush the final assignment. Finish one step, check it, then move on. All the best!
Final assignment घाईने करू नका. एक-एक step पूर्ण करा, check करा, मग पुढे जा. All the best!
Final assignment जल्दबाज़ी में मत कीजिए. एक-एक step पूरा कीजिए, check कीजिए, फिर आगे बढ़िए. All the best!
Ravindra Bagale's Tip
Friends, many 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. Never forget this.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students final assignment एकाच बैठकीत बनवायचा प्रयत्न करतात आणि अडकतात. Module 28 च्या steps मध्ये तो विभागा, प्रत्येक step पूर्ण करून चेक करा, आणि interview मध्ये समजावून सांगता येतील अशा निर्णयांची (KPI definitions, assumptions) छोटी नोंद ठेवा. हे अजिबात विसरू नका.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students final assignment एक ही बार में बनाने की कोशिश करते हैं और अटक जाते हैं. उसे Module 28 के steps में बाँटो, हर step पूरा करके check करो, और फ़ैसलों (KPI definitions, assumptions) का छोटा log रखो जिसे interview में समझा सको. यह बिल्कुल मत भूलना.
Thodkyaat sangaycha tar (quick recap)
Do every exercise yourself, compare your results with the source, and do the final assignment with the steps of Module 28. Now let us move on to interview preparation.
प्रत्येक exercise स्वतः करा, results source शी जुळवून बघा, आणि final assignment Module 28 च्या steps ने करा. आता पुढे जाऊया interview preparation कडे.
हर exercise ख़ुद कीजिए, results को source से मिलाकर देखिए, और final assignment Module 28 के steps से कीजिए. अब आगे बढ़ते हैं interview preparation की ओर.
Revision card