You will need to access our MySQL database for this challenge. The database credentials will be sent to you by e-mail.
- DATA_PRODUCT: PRODUCT INFO
| COLUMN NAME | COLUMN DESCRIPTION |
|---|---|
| PRODUCT_COD | PRODUCT CODE |
| PRODUCT_NAME | PRODUCT FULL NAME |
| PRODUCT_VAL | PRODUCT SALES VALUE |
| DEP_NAME | NAME OF THE DEPARTMENT RESPONSIBLE FOR THE PRODUCT |
| DEP_COD | CODE OF THE DEPARTMENT RESPONSIBLE FOR THE PRODUCT |
| SECTION_NAME | NAME OF THE SECTION WHERE THE PRODUCT IS |
| SECTION_COD | CODE OF THE SECTION WHERE THE PRODUCT IS |
- DATA_PRODUCT_SALES: PRODUCT SALES
| COLUMN NAME | COLUMN DESCRIPTION |
|---|---|
| STORE_CODE | STORE CODE |
| PRODUCT_CODE | PRODUCT CODE |
| DATE | SALES DATE |
| SALES_VALUE | SALES VALUES |
| SALES_QTY | SALES QUANTITY |
- DATA_STORE_CAD: STORE INFO
| COLUMN NAME | COLUMN DESCRIPTION |
|---|---|
| STORE_CODE | STORE CODE |
| STORE_NAME | STORE NAME |
| START_DATE | SHOP OPENING DATE |
| END_DATA | SHOP CLOSING DATE |
| BUSINESS_NAME | NAMES OF BUSINESS AREA RESPONSIBLE FOR THE SHOP |
| BUSINESS_CODE | CODE OF BUSINESS AREA RESPONSIBLE FOR THE SHOP |
- DATA_STORE_SALES: SALES PER STORE
| COLUMN NAME | COLUMN DESCRIPTION |
|---|---|
| STORE_CODE | STORE CODE |
| DATE | COMMERCIAL DATE |
| SALES_VALUE | TOTAL VALUE OF SALES IN THAT DATE |
| SALES_QTY | TOTAL QUANTITY OF SALES IN THAT DATE |
After accessing our database, create queries using the schema looqbox_challenge to answer the following questions:
- How many products does the company have?
- What are the 10 most expensive products in the company?
- What sections do the 'BEBIDAS' and 'PADARIA' departments have?
- Which store sold the most products in one day? Which day?
- Bonus!! What was the total sale of products (in $) of each business area in the first quarter of 2019?
- Create at least one chart using the table IMDB_movies. The code must be in R or Python, and you are free to use any libraries, data in the table and graphic format.
- MySQL database
- R/Python
- Send an e-mail to the person that you are in contact within Looqbox!
- Your answer must have the queries and the visualization (you can use notebooks or regular code)
- Question 5 is a bonus question!
- Explain why you chose the visualization you are submitting.