In this project, we employ formulas and pivot tables in Excel to conduct an analysis based on specific questions.
Our exploratory data analysis includes using conditional formatting. We also identify if there are any anomalies in the data.
Additionally, we generate dynamic sales reports of each country.
Best SALESPERSON By Country
Gigi Bohling achieved the highest sales in three countries (Australia, Canada, and India), which is an outstanding performance she was.
While some salespersons excelled, others encountered difficulties. It’s essential to address anomalies and explore strategies to improve sales across all countries.
Anomalies Found in The Data
Upon analyzing the charts, we discovered intriguing patterns in the sales data. Some products achieve substantial revenue despite selling fewer than 50 units, while others require sales of over 100 units to generate significant revenue.
Dynamic Sales Report
We use data validation and SUMIFS formula to design this kind of dynamic report for each country.
