Skip to content

Latest commit

 

History

History
28 lines (19 loc) · 1.3 KB

README.md

File metadata and controls

28 lines (19 loc) · 1.3 KB

Northwind Sales

Introduction

This project is looking at the Northwind company's data and utilizing hypothesis tests to give the company some recommendations. The Northwind database is a free, open-source dataset created by Microsoft containing data from a fictional company.

Questions that I investigated

  • Do discounts have a statistically significant effect on the number of products customers order? If so, at what level of discount?
  • Do discounts have a statistically significant impact on the revenue produced for a given order? If so, what level(s) of discount increase revenue?
  • Do different regions generate more revenue? Are discounts a factor of that?
  • Do different offices generate more revenue for the company?

Data Used

The data from this project is provided by Microsoft. The mapping of the database is pictured below: Northwind database map

Files included in the Repo

  • Jupyter Notebook
  • Presentation with recommendations for Northwind
  • The original database in sqlite format

Blog

Here is the link to the blog I wrote while completing this project: https://roweyerboat.github.io/fun_with_multicomparisons

Contact Info

LinkedIn