Sales Analysis Dashboard Using Microsoft Excel
Sales Analysis Dashboard Using Microsoft Excel
Project overview
This project analyses sales data using Microsoft Excel to identify sales trends, compare performance across regions and products, and evaluate profitability. An interactive dashboard presents key insights through charts, PivotTables, and slicers to support better business decisions.
Dashboard Preview
Tools and Methodology: I cleaned and organised the sales dataset, checked data types, and used PivotTables to summarise sales and profit. I then created six charts and added interactive slicers to build a dashboard that allows users to explore sales performance by region, country, product, sales representative, and date.
My Role and Project Outcome: I completed this project independently, using my Microsoft Excel skills to clean data, analyse sales performance, and build an interactive dashboard. The final dashboard presents sales and profit information in a clear, visual format, making it easier to identify trends and compare performance across different categories.