Dataset Comprehensive Analysis
Budget: $30 – $250 AUD
Project overview
A detailed analysis and visualization of a dataset to uncover insights on sales performance, customer value, and product trends.
Data needs
- Load, explore, and clean the dataset to address missing values and inconsistencies.
- Conduct analysis using SQL to extract insights on top-selling products, average order value per country, customer lifetime value (total revenue per customer), monthly trend of revenue over time, and any seasonal patterns in the data.
- Design a star schema data model to efficiently organize the dataset into fact and dimension tables. (at least 1 fact and two dimension tables)
- Create informative visualizations to clearly communicate the analysis findings.
Analysis type
Descriptive analysis
A detailed analysis and visualization of a dataset to uncover insights on sales performance, customer value, and product trends.
Data needs
- Load, explore, and clean the dataset to address missing values and inconsistencies.
- Conduct analysis using SQL to extract insights on top-selling products, average order value per country, customer lifetime value (total revenue per customer), monthly trend of revenue over time, and any seasonal patterns in the data.
- Design a star schema data model to efficiently organize the dataset into fact and dimension tables. (at least 1 fact and two dimension tables)
- Create informative visualizations to clearly communicate the analysis findings.
Analysis type
Descriptive analysis