Business Insight 360 is a comprehensive project aimed at analyzing Blinkit's sales performance, customer satisfaction, and inventory distribution. Using Power BI and Excel, this project provides actionable insights through tailored KPIs and advanced visualizations, enabling strategic decision-making.
To deliver a holistic analysis of Blinkit’s:
- Sales trends and performance.
- Customer satisfaction metrics.
- Inventory distribution and optimization opportunities.
The project leverages data cleaning, modeling, and visualization to create an interactive and insightful dashboard.
-
Data Preparation:
- Used Excel for data cleaning, handling inconsistencies, and preparing datasets for analysis.
- Ensured data accuracy and quality through validation.
- Modeled data effectively for seamless integration into Power BI.
-
KPIs:
- Total Sales: Overall revenue generated.
- Average Sales: Revenue per transaction.
- Number of Items Sold: Total items sold.
- Average Customer Rating: Feedback on sold items.
-
Visualizations:
- Donut Chart (Total Sales by Fat Content): Analyze the impact of fat content on sales.
- Bar Chart (Total Sales by Item Type): Evaluate the performance of different product categories.
- Stacked Column Chart (Fat Content by Outlet): Compare total sales across outlets segmented by fat content.
- Line Chart (Sales by Outlet Establishment): Assess how the age/type of outlet influences sales.
- Donut/Pie Chart (Sales by Outlet Size): Examine the correlation between outlet size and sales.
- Funnel Map (Sales by Outlet Location): Visualize geographic sales distribution.
- Matrix Card (All Metrics by Outlet Type): Provide a comprehensive view of all KPIs by outlet type.
-
Dashboard Development:
- Designed an interactive and intuitive layout in Power BI.
- Incorporated slicers and dynamic visuals for enhanced user experience.
- Focused on readability and deriving actionable insights.
- Identified top-performing product categories and outlets.
- Showed the influence of outlet size, location, and establishment type on sales trends.
- Highlighted patterns in customer satisfaction through average ratings.
- Excel: For data cleaning and initial exploration.
- Power BI: For data modeling, visualization, and dashboard development.
- DAX: For creating advanced metrics and calculations.
- Download the Power BI file from the repository.
- Open it using Power BI Desktop.
- Interact with the dashboard to explore insights and trends.
Business Insight 360 provides a robust analytical framework for understanding Blinkit's operations, delivering key insights to enhance sales strategies and customer satisfaction.