BlinkIT, India's last-minute grocery app Dashboard

Analyzed by- Saddam Ansari -Data & Reporting Analyst

---

About the Project

The BlinkIT grocery dashboard project is a comprehensive analysis and visualization endeavor focused on BlinkIT, India's last-minute grocery app. This project aims to provide insights into various aspects of the business, such as sales performance, item types, outlet locations, and customer preferences.

By leveraging advanced data visualization techniques, the project presents an interactive dashboard that stakeholders can use to make informed business decisions.

Stakeholders' Requests

The stakeholders requested a detailed and interactive dashboard that includes the following key metrics and insights:

• Total Sales: Overall sales performance across all outlets.
• Average Sales: The average sales per outlet or item type.
• Number of Items: The total number of items sold.
• Average Rating: The average customer rating for the items sold.
• Outlet Analysis: Performance comparison based on outlet size, location, and establishment year.
• Item Analysis: Breakdown of sales by item type, fat content, and other relevant categories.
• Visual Representation: Clear and interactive visualizations to facilitate easy understanding and analysis.

---

Project Objectives

The main objectives of this project were to:

1. Analyze Sales Performance: To understand the overall and average sales performance across different dimensions.
2. Identify Key Trends: To identify trends and patterns in sales based on item types, outlet locations, and establishment years.
3. Evaluate Customer Preferences: To evaluate customer preferences and ratings for different items.
4. Facilitate Informed Decision-Making: To provide stakeholders with actionable insights through interactive visualizations.

---

Tools Used

To achieve the project objectives, the following tools were used:

• Microsoft Excel: For data cleaning, transformation, and preliminary analysis.
• Power BI: For creating interactive and detailed visualizations.

---

Detailed Explanation of Each Component

1. Total Sales

The dashboard highlights the total sales amounting to $1.20 million. This metric provides an overall view of the business's revenue from all outlets combined.

2. Average Sales

The average sales per outlet are $141, providing an insight into the performance efficiency of individual outlets.

3. Number of Items Sold

A total of 8,523 items were sold, indicating the volume of transactions and customer engagement.

4. Average Rating

The average customer rating is 3.9, reflecting the overall satisfaction level of customers with the products offered.

5. Outlet Establishment Year

The sales trend over the years shows how the business has evolved. The graph indicates significant peaks in sales, with the highest being $205K in 2018.

6. Outlet Size Analysis

The dashboard categorizes outlets into small, medium, and large sizes. The sales distribution is shown, with medium-sized outlets generating $249.0K and large-sized outlets generating $507.9K.

7. Outlet Location Analysis

The analysis of outlet locations by tier shows that Tier 3 locations generate the highest sales ($472.13K), followed by Tier 2 ($393.15K) and Tier 1 ($336.40K).

8. Item Type Analysis

A detailed breakdown of sales by item type reveals that fruits and vegetables, snack foods, and household items are the top-selling categories. This helps in understanding which product lines are the most popular among customers.

9. Fat Content Analysis

Sales are further analyzed based on the fat content of items, distinguishing between low-fat and regular products. This insight can be useful for health-conscious customers and marketing strategies.

10. Outlet Type Analysis

Different types of outlets (Supermarket, Grocery Store, etc.) are compared based on total sales, number of items, average sales, average rating, and item visibility. This helps in understanding the performance of different store formats.

---

My Learnings from This Dashboard

Working on the BlinkIT grocery dashboard project provided several valuable insights and learning opportunities:

• Data Cleaning and Preparation: Emphasized the importance of clean and well-structured data for accurate analysis.

• Advanced Data Visualization: Enhanced my skills in creating interactive and informative dashboards using Power BI.

• Business Insights: Gained a deeper understanding of key business metrics and how to interpret them to drive decision-making.

• Customer Behavior Analysis: Learned how to analyze and visualize customer preferences and satisfaction levels.

• Communication: Improved my ability to present complex data in an easily understandable and visually appealing manner.

Overall, this project was an excellent opportunity to apply data analysis and visualization skills to real-world business problems, providing actionable insights for stakeholders.

---

How you can help me:

I've successfully completed over 80 Power BI projects, all showcased in my Novypro portfolio. You're all invited to visit my portfolio and explore these amazing projects!

Additionally, I'm currently seeking internship or entry-level opportunities. If you have any opportunities available or need a freelance Power BI project completed, please connect with me on LinkedIn.

Looking forward to connecting with you all!

---

Created and Presented by-

Saddam Ansari @Aspiring Data Analyst LinkedIn Location: India THE END