1. Problem understanding
Duration1h15 AI Banned
Sales of a high-tech and multimedia shop
Context
We are in the context of a high-tech and multimedia shop located in the US with stores in several cities. The manager of this shop would like to prepare the promotional period and to well target advertisements for the products. He is interested in boosting sales by targeting the best moments to launch promotions. He contacted you as a data engineer to help him achieve this objective.
Data Description
You have been given a dataset: The manager asked a student employee to collect some data about sales of the shop during two years related to 9 different cities in the US. The student employee provided a .csv file containing thousands of records, described by some variables, as follows:
| Variable | Meaning |
|---|---|
| Order ID | unique number for the order. One order can be related to several sold products |
| Product | the product being sold |
| Quantity Ordered | the quantity of the sold product |
| Price Each | the price of one unit of the sold product |
| Order Date | the sale date |
| Purchase Address | the address of the client who purchased the product |
Activity
Understanding the problem and associated data is crucial before diving into machine learning algorithms. Let’s start by exploring this problem.
Details
Question 1 What do you know from the text above and what information is missing?
Details
Question 2 Do you have some idea about the objectives of the study and the knowledge you could extract from the data? What is the main variable of interest? Could you suggest a list of questions of interest?
Details
Question 3 Describe the data, in particular the variables (their expected scale of measurement, expected format and role).
| Variable | Meaning | Scale | Role |
|---|---|---|---|
| Order ID | unique number for the order. One order can be related to several sold products | ||
| Product | the product being sold | ||
| Quantity Ordered | the quantity of the sold product | ||
| Price Each | the price of one unit of the sold product | ||
| Order Date | the sale date | ||
| Purchase Address | the address of the client who purchased the product |
Details
Question 3 In addition, from your experience, do you think that you have all the variables you need?