This project aimed to utilize Excel functions, pivot tables, and charts to provide a succinct overview of sales performance at AdventureWorks Company from 2001 to 2004.
The sales insights overview was created to answer the following questions :
- Which type of order generated more revenue?
- How were the monthly sales YOY?
- Which Salesperson generated the highest revenue for the company?
- What is the revenue distribution by country?
- How is the delivery performance?
Microsoft Excel 2021
[Data source](Sales overview Excel.xlsx)
The already cleaned dataset was modified to add new columns using the Index & Match function before transformation using pivot tables and visualization using charts.
[Overview dashboard]
After finding answers to the questions posed by the initial task list, I further analyzed the data to answer the question of
What are the sales trends and patterns for Adventure Works over 3 years across 6 countries, and based on this data, would it be advisable for the company to shift all its sales to an online platform?
- What type of order/sale (Offline or online) generated more revenue for the company in each country? What % of the total sales were made online?
- Which reason type was highly grossing and occurred most frequently in sales? How was the sale made for this reason type?
- In which country did average online sales dominate and in which year?
Insights can be viewed in the below visualization.
[My Analysis dashboard]