28. End-to-End Project: Blinkit Quick-Commerce Dashboard
28.2 Step 1 – Prepare the Raw Data
Source files (in a SharePoint/OneDrive folder or a local folder):
| File | Content |
|---|---|
Blinkit_Orders_2025_01.csv … Blinkit_Orders_2025_12.csv |
Monthly Blinkit order lines (columns as in Module 1.7) |
AmazonNow_Orders.csv |
Amazon Now order lines; a few columns have different names (e.g. Order_No, Order_Value) |
Products.xlsx |
Product master: Category, Sub Category, Brand, Unit Price, Unit Cost |
Customers.xlsx |
Customer master |
DarkStores.xlsx |
Store ID, Store Name, Platform, Area, City, State, Country, City Manager, Manager Email (15 dark stores across 6 Maharashtra cities) |
DeliveryPartners.xlsx |
Delivery Partner ID, Partner Name, Vehicle Type, Home Store ID |
Ravindra Bagale's Tip
A common mistake is editing the raw files by hand to fix problems. Keep the raw exports untouched in a folder, and do all fixes in Power Query so the steps repeat on every refresh. Never forget this.
Ravindra Bagale's Tip – मराठी
एक common चूक म्हणजे problems दुरुस्त करण्यासाठी raw files हाताने edit करणं. Raw exports एका folder मध्ये जसेच्या तसे ठेवा, आणि सगळ्या दुरुस्त्या Power Query मध्ये करा म्हणजे प्रत्येक refresh ला steps पुन्हा चालतील. हे अजिबात विसरू नका.
Ravindra Bagale's Tip – हिंदी
एक common गलती है problems ठीक करने के लिए raw files को हाथ से edit करना. Raw exports को एक folder में जैसे के तैसे रखो, और सारे सुधार Power Query में करो ताकि हर refresh पर steps दोबारा चलें. यह बिल्कुल मत भूलना.