A Strategic Decision Engine for Hyperlocal Grocery Operations

This repository houses a comprehensive Power BI dashboard ecosystem designed to transform raw operational data from Swiggy Instamart into actionable business intelligence. Moving beyond traditional sales tracking, this project delivers a multi-layered analytical framework that correlates store performance, product category dynamics, temporal trends, and customer satisfaction metrics across diverse urban and suburban geographies. The dashboard serves as a command center for operations managers, category leads, and strategic planners seeking to optimize inventory allocation, identify underperforming store clusters, and uncover growth opportunities within the 10-minute grocery delivery ecosystem.

Built on a foundation of clean data modeling and interactive visual storytelling, this solution enables stakeholders to drill down from macro-level revenue trends to granular store-level KPIs with seamless navigation. The design philosophy prioritizes both executive summary views for quick pulse checks and deep-dive analytical pages for root cause analysis.

The Store Intelligence Dashboard is not merely a visualization of numbers—it is a narrative engine that translates transactional data into strategic narratives. The dashboard answers critical operational questions:

• Which store sizes and city types generate the highest average order value?
• How does customer rating correlate with sales volume across different categories?
• What seasonal patterns emerge when analyzing orders by opening year of stores?
• Which product categories require immediate supply chain intervention based on sales-to-rating divergence?

The solution leverages Power BI’s native capabilities including bookmarks, drill-through pages, custom tooltips, and conditional formatting to create an intuitive analytical journey.

In the hypercompetitive quick-commerce landscape, decisions made on stale or aggregated data can lead to inventory wastage, missed revenue targets, and eroding customer trust. This dashboard provides near-real-time decision support with a refresh cycle that aligns with daily operational cadences.

The underlying data model follows a star schema pattern, optimized for both performance and analytical flexibility. The core fact table captures transactional order data, while dimension tables provide contextual richness across multiple business perspectives.

Key Data Tables:

Data Transformation Highlights:

• Custom DAX measures for dynamic time intelligence calculations (time-locked year-over-year growth, rolling 30-day averages)
• Power Query M scripts for automated data cleaning, outlier detection, and category standardization
• Calculated columns for store age, order velocity, and rating quartile classification

• Global KPI cards: Total Sales (₹), Order Volume, Average Order Value, Net Promoter Score (derived from ratings)
• Temporal trend combos: Dual-axis charts comparing sales and orders with forecast indicators
• Geographic heatmap: City-level revenue density with zoom capabilities

• Matrix table: Store ID × Size × City Type with embedded sparklines showing 7-day trend
• Bubble chart: Sales vs. Avg Rating, sized by number of orders
• Top/Bottom N slicer: Quickly identify the best and worst performing 10 or 20 stores

• Treemap: Hierarchical view of revenue contribution by category → subcategory
• Waterfall chart: Month-over-month category margin changes
• Scatter plot: Category price elasticity vs. order frequency

• Hourly order heatmap: Day of week × Time of day density matrix
• Delivery time analysis: Actual vs. promised delivery window compliance rate
• Inventory turnover ratio: By store size and city type (calculated using sales velocity)

• Parameterized measures: Adjustable growth targets, discount rates, and rating improvement goals
• Dynamic waterfall: Visual impact of simulated changes on final revenue
• Sensitivity analysis grid: Identify the most impactful levers for profitability

Large datasets demand efficient query execution. The following strategies were employed to maintain sub-second response times even on the aggregated pages:

• Aggregation tables: Pre-calculated summaries at city-month and store-week granularity
• Field parameters: Dynamic dimension switching without multiple visuals
• Bidirectional cross-filtering: Minimized only where absolutely necessary to prevent ambiguity
• Storage mode hybridization: Fact table in DirectQuery for real-time capability, dimensions in Import for speed
• Query reduction: Strategic use of KEEPFILTERS and CALCULATE modifiers to avoid context transition overhead

“A dashboard that takes longer to load than a cup of coffee defeats its purpose.” — Internal Design Principle

Recognizing that operations teams span across regions with diverse linguistic preferences, the dashboard includes:

• Dynamic label switching via disconnected parameter table (English, Hindi, Kannada, Marathi)
• Colorblind-friendly palette using Power BI’s accessible theme templates
• Keyboard-navigable slicers with screen reader-compatible tooltips
• 24/7 Chat Support Integration: A placeholder for embedding collaborative analytics—the concept of “always-on analytical assistance” where teams can annotate and discuss insights directly within the dashboard context

This project is shared under the MIT License — you are free to use, modify, and distribute this dashboard framework for both personal and commercial projects, provided you include the original copyright notice.

Data Disclaimer: The datasets used in this dashboard are simulated and do not represent real Swiggy Instamart operational data. Any resemblance to actual transaction records, store configurations, or customer behavior is purely coincidental. The analytical patterns and methodologies demonstrated are intended for educational and professional development purposes only.

Swiggy-Instamart-Store-Intelligence-Dashboard-Power-BI/
├── dashboard/
│   ├── Swiggy_Instamart_Store_Intelligence.pbix        # Main Power BI file
│   ├── Swiggy_Instamart_Store_Intelligence_Backup.pbix  # Production backup
│   └── report_schema_2026.xlsx                          # Data dictionary
├── data/
│   ├── sample_orders_2026_q1.csv                        # 50K row sample
│   ├── store_master_2026.csv                            # Full store dimension
│   └── product_catalog_subset.csv                       # Category hierarchy
├── documentation/
│   ├── DAX_Measure_Reference.md                         # Complete formula catalog
│   ├── Data_Model_Diagram.md                            # ER diagram description
│   └── User_Adoption_Guide_2026.pdf                     # End-user training manual
├── assets/
│   └── custom_themes/                                   # .json theme files
├── LICENSE
└── README.md

Contributions that enhance analytical depth, improve performance, or extend the multilingual support are warmly welcomed. Before submitting a pull request, please review the existing measure structure to ensure consistency with the established DAX patterns.

Planned for Q3 2026:

• Integration with real-time APIs for live order streaming
• Machine learning module for store-level revenue forecasting (built in Python, exported to Power BI)
• Enhanced mobile-responsive layout for field operations teams
• Natural language Q&A support using Power BI’s Q&A feature with custom synonyms

This dashboard is more than a collection of charts—it is a reflection of operational philosophy. The belief that every data point, from a missed delivery slot to a glowing customer review, carries a signal that can guide better decisions. Use it as a template for your own analytical challenges, adapt it to your domain, and most importantly, question the data relentlessly.

If you find this project valuable for your work or learning journey, consider exploring the Power BI community forums for additional patterns or extending the DAX measures to fit your unique business context.