Profile Picture

Manthan Jadav

Blinkit Power BI Dashboard

Home Overview

+

The Home Overview provides a centralized summary of Blinkit's business performance metrics, covering sales, impressions, clicks, and revenue. This dashboard acts as a snapshot for executives to quickly assess growth trends, customer engagement, and marketing effectiveness across recent periods.

Sales Overview

+

The Sales Overview breaks down sales quantity over fiscal years, highlights monthly trends, and identifies regional and customer-level performance variations. This view is valuable for tracking volume fluctuations, evaluating market penetration in different locations, and identifying top-performing customer segments.

Customer Report

+

    This report focuses on customer behavior patterns, including repeat purchase trends, new vs. lost customer counts, and customer segmentation (e.g., regular, premium, inactive). It also highlights top customers by quantity and order frequency. This data is essential for retention strategy, loyalty program design, and understanding customer lifetime value.

Feedback Report

+

The Feedback report consolidates customer sentiments across various categories like delivery, app experience, and product quality. It includes star ratings and feedback segmented by sentiment (positive, neutral, negative) and customer type. Businesses use this to enhance service quality, identify pain points, and improve customer satisfaction.

Inventory Report

+

The Inventory report details stock movement, damaged stock, and available inventory over time. It tracks stock received, sold, and remaining across months. This is critical for managing supply chain efficiency, minimizing losses due to damaged goods, and optimizing stock levels to meet demand.

Marketing Report

+

The Marketing report tracks the performance of ad campaigns using metrics like impressions, clicks, conversions, revenue, and spend over time. It helps identify successful campaigns, evaluate ROI, and allocate budgets more effectively to increase customer acquisition and maximize marketing impact.

Download Project PDF

Skill Used

SQL

Data querying and database management

Power BI

Data visualization and dashboards

Figma

Design Theme and elements