In this project you will experience doing an analysis using both Python and SQL to obtain the final result, by exploring each tool's behavior.
A data project lifecycle has many phases, rather than being just an isolated analysis in a single tool. In this project you will experience doing an analysis using both Python and SQL to obtain the final result, by exploring each tool's behavior.
We pickup an historical sales data from 45 stores from Kaggle.
The Retail Data provide an historical sales data for 45 stores located in different regions - each store contains a number of departments. The company also runs several promotional markdown events throughout the year. These markdowns precede prominent holidays, the four largest of which are the Super Bowl, Labor Day, Thanksgiving, and Christmas. The weeks including these holidays are weighted five times higher in the evaluation than non-holiday weeks.
- Python Code: Provide well-documented Python code that conducts the analysis and SQL upload.
- SQL text file (.sql) well commented document with all the queries answering the Business questions.
- Short Presentation: Structure the presentation in the following way:
- Intro Slides: introduce the problem and the datasets
- Data cleaning and assumptions
- Business questions and SQL query (1 slide per question with a print screen of the query and the answer is enough)
- PDF Document with data Business Report Analysis.
- Paola Rivera
- Ginosca Alejandro
- Natanael Santiago
- Javier Dastas