Ravindra BagaleCourses & study guides

15. Final Project: Blinkit Maharashtra Monthly Report

By Last updated:

Mitrano, aata khari pariksha! Ya project madhe tumhi ek messy raw export gheun, to clean karun, Tables aani formulas lavun, PivotTables, dashboard aani ek chhota macro banavnar aahat – agdi job madhe jasa karava lagta tasa. Ha project tumchya resume aani interview sathi "Explain your project" cha uttar banu shakto. Swatah kara, ghai karu naka – ek ek stage.

What you will deliver

  • A cleaned tblOrders built from a messy raw export (Module 5)
  • Lookup and calculated columns with Tables and formulas (Modules 3, 4, 6, 9)
  • PivotTable analysis answering five business questions (Module 7)
  • A one-screen interactive dashboard (Modules 8 and 13)
  • A small macro that refreshes and exports the dashboard (Module 12)
  • A protected, print-ready workbook Blinkit_Final_Project_<YourName>.xlsm (Module 14)

Concepts in this chapter

  1. 15.1Project Brief and Data
  2. 15.2Stage 1 – Clean the Raw Export
  3. 15.3Stage 2 – Tables and Lookup Formulas
  4. 15.4Stage 3 – PivotTable Analysis
  5. 15.5Stage 4 – Build the Dashboard
  6. 15.6Stage 5 – A Small Macro
  7. 15.7Submission Checklist and Marking Guide

The chapter recap is at the end of the last concept page.