🚀 #Project Overview This project presents a Power BI dashboard for Blinkit, an instant grocery delivery service, analyzing key business metrics such as total sales, average sales, outlet performance, and item categories. The dashboard provides interactive insights into outlet sizes, locations, product categories, and sales trends, helping stakeholders make data-driven decisions.
💰 Sales Performance: Total sales amounting to $1.20M, with an average sales value of $141 per transaction. ⭐ Customer Ratings: Outlets maintain an average rating of 3.9, helping assess service quality. 📦 Product Analysis: Popular categories include fruits, snacks, and household items, contributing significantly to revenue. 🏪 Outlet Comparisons: Tier 3 outlets generate the highest sales ($472K), while supermarkets drive major revenue streams. 📈 Trend Analysis: Outlet establishment trends indicate peak expansion in 2018, with a record high revenue of $205K.
✔ Interactive filters for outlet type, size, and item categories. ✔ Data visualization with bar charts, line graphs, and pie charts. ✔ Comparison of sales performance based on outlet size, location, and product categories. ✔ Item visibility analysis to identify high-performing products.
Power BI – Data visualization and dashboard creation SQL/Python (Optional) – Data preprocessing and transformation Excel/CSV – Data storage and integration
This dashboard helps business analysts, sales managers, and operations teams optimize outlet performance, improve inventory decisions, and enhance customer experience.
