28. End-to-End Project: Blinkit Quick-Commerce Dashboard
28.1 Business Requirements
The (fictional) operations head wants to answer:
- How many orders did we receive, what were sales (₹) and AOV, and how do they compare with last year and last month?
- How fast are we delivering? What is the average delivery time and the % of orders delivered under 10 minutes, by city, dark store and hour of day?
- Where and when do cancellations happen (city, dark store, hour of day in IST)? Which payment modes are used?
- Which categories and products drive sales? How many customers come back (repeat customer %)?
- How does Blinkit compare with Amazon Now on orders, AOV and delivery speed?
- City managers must see only their own city. The report must update automatically every morning.
Ravindra Bagale's Tip
Friends, many students start building before the requirements are clear, then rebuild pages when the manager asks for something else. Write the KPI definitions and the page list first and get them agreed, even informally, before opening Power BI Desktop. Practise, and it will feel very easy.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students requirements स्पष्ट होण्याआधीच बनवायला सुरुवात करतात, आणि manager ने दुसरंच काही मागितलं की pages पुन्हा बनवतात. Power BI Desktop उघडण्याआधी KPI च्या व्याख्या आणि pages ची list लिहून काढा आणि अनौपचारिकपणे का होईना, त्यावर सहमती घ्या. Practice करा, मग एकदम सोपं वाटेल.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students requirements साफ़ होने से पहले ही बनाना शुरू कर देते हैं, फिर manager के कुछ और माँगने पर pages दोबारा बनाते हैं. Power BI Desktop खोलने से पहले KPI की परिभाषाएँ और pages की list लिखो और उस पर सहमति ले लो, भले ही अनौपचारिक रूप से. Practice करो, फिर बहुत आसान लगेगा.