Practice E-commerce power users

E-commerce power users

About the exercise

This exercise is an example of a power users analysis. You can guess who power users of a product are – the most active users, your product is part of their life and they use most of its features. For an E-commerce store power users are the ones with most purchases per month.

💾  About the dataset

This data warehouse is inspired by an E-commerce website like Amazon. :shopping_cart:

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.

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit is also a collection of Practice exercises (you’re looking at one atm) based on various datasets (E-commerce, Finance, etc). They’re meant to deepen your SQL and Data Analysis knowledge 💪, prepare you for any challenge at work or a job interview.

“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.