In this lesson, we'll review all the guidelines and specifications for the final project for Module 3.

• Nick & Max
• Lindsey & Francois
• Harrison & Joe

• Understand all required aspects of the Final Project for Module 3
• Understand all required deliverables
• Understand what constitutes a successful project

Another module down--you're half way there!

For the culmination of Module 3, you just need to complete the final project!

For this project, you'll be working with the Northwind database--a free, open-source dataset created by Microsoft containing data from a fictional company. You probably remember the Northwind database from our section on Advanced SQL. Here's the schema for the Northwind database:

The goal of this project is to test your ability to gather information from a real-world database and use your knowledge of statistical analysis and hypothesis testing to generate analytical insights that can be of value to the company.

The goal of your project is to query the database to get the data needed to perform a statistical analysis. In this statistical analysis, you'll need to perform a hypothesis test (or perhaps several) to answer the following question:

Does discount amount have a statistically significant effect on the quantity of a product in an order? If so, at what level(s) of discount?

In addition to answering this question with a hypothesis test, you will also need to come up with at least 3 other hypotheses to test on your own. These can by anything that you think could be imporant information for the company.

For this hypothesis, be sure to specify both the null hypothesis and the alternative hypothesis for your question. You should also specify if this is one-tail or a two-tail test.

To complete this project, you will need to turn in the following 3 deliverables:

1. A Jupyter Notebook containing any code you've written for this project.
2. A Blog Post explaining your process, methodology, and findings.
3. An "Executive Summary" PowerPoint Presentation that explains the hypothesis tests you ran, your findings, and their relevance to company stakeholders.

For this project, your jupyter notebook should meet the following specifications:

Organization/Code Cleanliness

• The notebook should be well organized, easy to follow, and code is commented where appropriate.

Findings

• Your notebook should clearly show how you arrived at your results for each hypothesis test, including how you calculated your p-values.

Your blog post should include everything from how you identified what tables contained the information you need, to how you retrieved it using SQL (and any challenges you ran into while doing so), as well as your methodology and results for your hypothesis tests.

NOTE: This blog post is your way of showcasing the work you've done on this project--chances are it will soon be read by a recruiter or hiring manager! Take the time to make sure that you craft your story well, and clearly explain your process and findings in a way that clearly shows both your technical expertise and your ability to communicate your results!

Your presentation should:

• Contain between 5-10 professional quality slides detailing: