You will need to access our MySQL database for this challenge. The database credentials will be sent to you by e-mail.
Challenge
Tables descriptions
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
SQL test
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?
When were the most products sold? In which store?
Bonus!! What was the total sale of products of each business area in the first quarter of 2019?
Building your own visualization
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.
Stack
MySQL database
R/Python
Submitting
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)
Bonus points!
Question 5 is a bonus question!
Explain why you chose the visualization you are submitting.
