.png){kind=link}
Created & Analyzed by Saddam Ansari @Aspiring Data Analyst Linkedin
Live Dashboard at Novypro Live_link_Novypro
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.
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.
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.
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.
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.
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.
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!
Saddam Ansari @Aspiring Data Analyst LinkedIn
Location: India
THE END