🔍Objective:
Conduct a comparison analysis of iPhone 15 sales and iPhone 14 sales.
Datasets:
- fact_sales_Iphone14.csv
- fact_sales_Iphone15.csv
- dim_stores.csv
📌Tasks:
Here is a brief overview of the workflow for the task:
- Review the data (fact_sales_Iphone14 and fact_sales_Iphone15).
- Metrics to compare - iPhone 14 sales and iPhone 15 sales.
- Calculate the variance (absolute difference value) between the iPhone 15 sales and iPhone 14 sales for the identified metrics.
- Calculate the variance (in percentage) between the iPhone 15 sales and iPhone 14 sales for the identified metrics.
- Provide a complete report of the difference in numbers between the iPhone 15 sales and iPhone 14 sales data across the top 10 countries.