Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
As a new data analyst at Shopify, you are being asked by the category manager to find the most performing categories. Since at Shopify, there are so many, they want to exclude the ones that have less than 100 sold items.
For that, you will use the shopify_sales table that includes the following columns:
| Column Name | Description |
|---|---|
| sale_id | Unique identifier for each sale |
| product_id | Identifier for the product sold |
| category_name | Name of the product category |
| quantity_sold | Number of units sold in the sale |
| sale_amount | Total amount of the sale |
As a new data analyst at Shopify, you are being asked by the category manager to find the most performing categories. Since at Shopify, there are so many, they want to exclude the ones that have less than 100 sold items.
For that, you will use the shopify_sales table that includes the following columns:
| Column Name | Description |
|---|---|
| sale_id | Unique identifier for each sale |
| product_id | Identifier for the product sold |
| category_name | Name of the product category |
| quantity_sold | Number of units sold in the sale |
| sale_amount | Total amount of the sale |
| sale_date | Date of the sale |
| category_name | total_items_sold |
|---|---|
| Electronics | 137 |
| Sports | 154 |
| Home & Kitchen | 155 |
| Books | 132 |
| sale_date | Date of the sale |
| category_name | total_items_sold |
|---|---|
| Electronics | 137 |
| Sports | 154 |
| Home & Kitchen | 155 |
| Books | 132 |