Data Analysis Portfolio Project In Excel Using Pivot Table

In this Project, we demonstrated the importance of Pivot table in Excel. Furthermore, we used the Pivot table to answer some of the sales analysis questions as stated below:-
PROBLEM STATEMENT
1. Ratio of Revenue per Unit Sold: This will help us understand the revenue generated per unit sold.
2. Regional Performance Analysis: We will use the pivot table to compare the performance of different regions in terms of total units sold and total revenue generated.
3. Product Performance Analysis: Here, we will analyze which product is generating the highest revenue and how it varies across different regions.
4. Salesperson Efficiency/Performance: We will determine which salesperson has the highest revenue per unit sold and explore factors contributing to their efficiency.

Download the Dataset: https://docs.google.com/spreadsheets/...