Super market analysis (Excel)

-
Supermarket Sales Dashboard – Excel Interactive Visualization

Supermarket Sales Dashboard – Excel Interactive Visualization

I developed an interactive Supermarket Sales Dashboard using Microsoft Excel, incorporating key business metrics and visual analytics to provide actionable insights.

Key Features:

  • 📊 Total Revenue & Sales Overview: Displays key performance indicators (KPIs) such as total revenue, total quantity sold, gross income, and average rating.
  • 📦 Product & Category Insights: Showcases revenue distribution across different product lines and branches.
  • 👥 Customer Segmentation: Includes slicers for filtering data by branch, product category, customer type, city, and payment method for in-depth analysis.
  • 📈 Trend Analysis: A dynamic line chart visualizing sales performance over time.
  • 💳 Payment Method Analysis: A pie chart illustrating the distribution of payment methods like cash, credit card, and e-wallets.
  • 🏙️ City-Based Sales Performance: A bar chart highlighting revenue by city.

This dashboard enhances decision-making for supermarket managers by providing a comprehensive, data-driven view of sales trends and customer behavior.

Tools Used:

📊 Microsoft Excel (Pivot Tables, Charts, Slicers, Conditional Formatting)

link= https://github.com/Anandmalviya20/excel_dashboard/blob/main/supermarket.xlsx

Comments

Post a Comment

Popular posts from this blog

Employee Management System - SQL Database with Triggers & Stored Procedures

-
Image
SQL-Based Employee Management System SQL-Based Employee Management System I designed and implemented an SQL-based Employee Management System that automates employee record handling using triggers and stored procedures . This project ensures that every new employee entry is logged in an audit table, maintaining data integrity and historical tracking. Key Features: ✅ Employee Table – Stores essential details like name, position, salary, and hire date. ✅ Audit Table – Automatically records employee changes with timestamps for tracking modifications. ✅ Trigger for Data Auditing – A SQL trigger (AFTER INSERT) ensures that all new employee records are mirrored in the audit table. ✅ Stored Procedure for Employee Addition – Simplifies employee insertion while enforcing consistency. Technologies Used: SQL (MySQL / PostgreSQL) Triggers & ...
Read more

Excel: Mother of Business Intelligence - Certified by Codebasics

-
Image
Excel: Mother of Business Intelligence Certification Excel: Mother of Business Intelligence Certification I have successfully completed the Excel: Mother of Business Intelligence course from Codebasics , gaining expertise from beginner to advanced levels. This course focused on real-world business applications , working with datasets exceeding 1 million records , and mastering essential Excel functionalities for data analysis and business intelligence . Key Skills Acquired: Data Cleaning and Transformation Advanced Excel Formulas & Functions Pivot Tables & Data Visualization Business Case Studies & Real-World Applications Handling Large Datasets Efficiently Successfully passed the final exam with 70%+ marks , demonstrating proficiency in Excel for data-driven decision-making. Certificate: ...
Read more