Ravindra BagaleCourses & study guides

15. Final Project: Blinkit Maharashtra Monthly Report

15.4 Stage 3 – PivotTable Analysis

By Last updated:

Steps in Excel

  1. On a Calc sheet build pivots from tblOrders (Module 13.3): pvtCity (City × Sum of Amount, Status = Delivered), pvtTrend (Order Date by day), pvtCategory (Category × City), pvtOnTime (City × On Time, Show Values As % of Row Total), pvtKPI.
  2. City vs target: next to pvtCity, =GETPIVOTDATA("Sum of Amount",$A$3,"City","Pune")/XLOOKUP("Pune",tblTargets[City],tblTargets[Monthly Target]).
  3. Top categories per city: in pvtCategory use Row Labels filter › Value Filters › Top 10… › Top 3 Items by Sum of Amount.
  4. Write each answer to the five questions in one sentence on the Notes sheet.

Worked example – answer format (your numbers will differ).

Question Answer (example)
Q2 City Pune gave the highest sales (about 37%); Solapur is at 92% of target.
Q3 Trend Daily sales rose sharply from 14-09-2026 with the Ganeshotsav start, with modaks and pooja items leading.
Q5 Delivery All cities except Nagpur delivered ≥ 90% of orders within 12 minutes.

Ravindra Bagale's Tip

Khup students pivot banavtat pan tyatun "answer" lihit nahit – fakt aakde dakhavtat. Manager la aakde nako, nishkarsh (conclusion) hava: "Solapur is at 92% of target". Pratyek prashnasathi ek vakya liha; hech vakya dashboard chya chart title madhe vapra.

Practice task

Build the five pivots, calculate achievement vs target for all six cities, and write one-sentence answers to all five brief questions on the Notes sheet.