Overview
Welcome to my Portfolio! In this repository, you'll find a collection of Excel dashboards showcasing various visualizations of employee data. These dashboards were created using Microsoft Excel, demonstrating my skills in data visualization and analysis.
This dashboard provides an overview of sales performance.
Visualizations: Bar charts, line graphs, and pie charts showing sales by region, product, and salesperson/managers.
Overview of Sales Trend: The sales trend over the past year shows consistent growth, with a slight dip in Q3 followed by a significant increase in Q4, likely due to holiday season sales.
Product Category Sales Analysis: The Television category has the highest sales volume, with a noticeable peak during the holiday season in Q4. However, sales decreased in 2019 compared to 2018.
Regional Sales Performance: Sales in the Central region significantly outperform those in other regions, indicating a potential area for further expansion or focus.
Top-Selling Products: The top-selling products for the years 2018 and 2019 are Television, Home Theater, and Cellphone. However, in 2019, Home Theater sales surpassed those of Television.
Seasonal Sales Trends: Sales exhibit a clear seasonal pattern, with peaks during the holiday season and summer months, suggesting the need for seasonal marketing strategies.
Additional Metrics: Units Sold: Overall, 2,121 units were sold across all categories, with Television accounting for 66% of total sales. Top Performing Managers: Martha and Hermann emerged as the top-performing managers, consistently exceeding sales targets and driving growth in their respective regions.
Work in Progress
Usage
Feel free to explore each dashboard by downloading the corresponding Excel file. You can interact with the data and customize the visualizations to suit your needs. If you have any questions or feedback, don't hesitate to reach out!