About this project
Project revolves around the analysis of following KPIs:
- Sales
- Quantity
- Profit
- Order Count
- YOY Growth Trend
This project presents the holistic picture of the company’s performance regarding sales and profit over the years.
This dashboard enables the filtering based on the different Years, Segments and Regions which helps visualize the answers for many questions that can be answered by the aforementioned KPIs.
I was able to get the answers for the following questions:
Which segments of good had more Sales and Profit?
Home Office leading with Sales of $1867547 and Profit of $226098
Top 5 subcategories with highest overall sales?
Phone, Chairs, Storage, Tables and Binders
Year with highest YOY Growth in terms of Profit and Sales?
2014
Category having the highest share in sales?
Category "Technology" has the highest contribution in overall sales i.e. 36.40%
Which category contributes the least to the overall sales?
All categories have same contribution to overall sales.
Which Region had highest overall Sales & Profit?
Southern Region leading with Sales of $19055478 and Profit $ 239647
Monthly overall trend of Sales?
Overall sales increase towards the end of year. Holiday season might be one of the factor affecting this trend.
Important learning out comes of this project:
Excel Formulas: Manipulating data with help of formulas e.g. calculation of YOY Growth or extracting data out of Pivot Table to create the Waterfall and Map chart.
Pivot Tables: Creating Pivot Tables to extract meaningful insights that can be presented.
Charts understanding: Working on this project has helped in understanding different charts, how they can be used to display different types of insights.
