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
Ek common chuk mhanje 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. Bilkul visru naka.