1.☕ Coffee Sales Dashboard (Excel) 📄 Overview This project features an Excel dashboard designed to analyze coffee sales data. It provides visual insights into sales trends, top customers, and country-wise distribution, aiding in better understanding and decision-making.
📊 Dashboard Highlights:
Monthly Sales Trend: Line chart showcasing monthly coffee sales over the years. Top 5 Customers: Bar chart highlighting the top five customers based on sales. Country-wise Sales: Bar chart representing sales distribution across different countries.
2.🚴♂️ Bike Sales Excel Dashboard 📊 Project Overview This project involves analyzing bike sales data to uncover insights into customer purchasing behavior. The dashboard provides visual representations of key metrics, enabling stakeholders to make informed decisions.
🛠️ Tools Used: Microsoft Excel: For data cleaning, analysis, and visualization. Pivot Tables: To summarize and analyze data. Charts: Bar and line charts for visual representation. Slicers: For interactive data filtering.
🧹 Data Cleaning: Removed duplicates and irrelevant columns. ->Standardized categorical data (e.g., marital status, gender). ->Converted income data to currency format. ->Created age groups for analysis.
📈 Data Analysis & Visualization: ->Bar Chart: Showcasing income and gender distribution based on purchase status across Europe, North America, and the Pacific regions. ->Line Chart: Depicting purchase trends across different age groups. ->Line Chart: Illustrating the relationship between commute distance and bike purchases.
- 📊 Vrinda Store Annual Sales Analysis (Excel Dashboard) Analyzed Vrinda Store's 2022 sales data using Excel, employing pivot tables and charts for insights. Findings reveal women constitute ~65% of purchases, with the 30–49 age group contributing ~50%. Top- performing states are Maharashtra, Karnataka, and Uttar Pradesh. Major sales channels include Amazon, Flipkart, and Myntra, accounting for ~80% of sales. Recommendations suggest targeting women aged 30–49 in these states through promotions on these platforms to enhance sales.