E-commerce dataset
This data warehouse is inspired by an E-commerce website like Amazon. 
Our E-commerce website allows vendors to sell items in multiple categories. Users can add as many items as they want to a cart and then purchase a cart with/without a discount code. Users also can return items and leave reviews.
Practice exercises
-
1. Counting subcategories in an online storeStart
-
2. Percentage of purchases with discount codesStart
-
3. Most popular items in E-commerce storeStart
-
4. Categories’ items distributionStart
-
5. Percentage of users who leave reviewsStart
-
6. Average number of items per cartStart
-
7. Top grossing month of the yearStart
-
8. Measuring feature adoptionStart
-
9. Average price per cartStart
-
10. Time between purchasesStart
-
11. Product ratings distributionStart
-
12. Count users with identical namesStart
-
13. E-commerce power usersStart
-
14. Top rated productsStart
-
15. Items per cart year-over-year dynamicsStart
-
16. Naive sentiment analysisStart
-
17. The biggest categoryStart
-
18. Vendor with the highest refund rateStart
-
19. Distribution of users by countryStart
“well worth the money”
Fluent in SQL in a month
Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.