Lecture Notes: Blinket Analytics Dashboard

Introduction

• Blinket: An online grocery shopping application by Zomato.
• Focus of the video: Creating an interactive dashboard for Blinket’s sales analysis.
• Tools used: Excel for data storage, Power BI for dashboard creation.

Key Features of the Dashboard

• Dynamic and Interactive: Operable with interactive filters.
• Panels and Filters:
  • Left panel for filters and actions.
  • URL filters for site redirection and data view.
• KPI Metrics Displayed:
  • Total Sales
  • Average Sales
  • Number of Items
  • Average Ratings

Data Insights

• Product Analysis:
  • Total sales, number of items, average sales, and ratings presented dynamically.
  • Filters include item type and fat content.
• Outlet Analysis:
  • Visualizations based on outlet size (small, medium, high) and location (tier 1, 2, 3).
  • Outlets are the focal points of distribution.

Dashboard Development

• Data Preparation:
  • Data gathered from Excel, read and processed in Power BI.
• Visualization Techniques:
  • Donut charts for sales and fat content analysis.
  • Line charts for outlet establishment analysis.
  • Bar charts for item type sales.
  • Funnel charts for outlet location.
• UI and UX Considerations:
  • Incorporating color schemes relevant to Blinket.
  • Ensuring clarity and ease of navigation.

Power BI Certification Mention

• PL-300 Exam:
  • Offered opportunity by Odin School for certification in Power BI.
  • Importance: Recognized expertise in data modeling and Power BI features.
• Training Details:
  • Two paths: Classroom in Hyderabad and live online training.
  • 100% money-back guarantee if the exam is not cracked within 30 days of course completion.

Final Touches and Enhancements

• Interactive Features:
  • Dynamically filter and interact with data.
  • Reset buttons to clear filters for a full view.
• Additional Resources:
  • Links to download data and additional learning materials.
  • Encouragement to visit personal website for further data analyst resources.

Conclusion

• Recap of building the dashboard and its functionalities.
• Importance of understanding user requirements and data insights.
• Encouragement to practice and apply skills in real-world projects.