Skip to content

A Data Warehouse project based on Microsoft Northwind Database.

Notifications You must be signed in to change notification settings

Bernardbyy/MicrosoftNorthwindDatawarehouse

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Microsoft Northwind Data Warehouse 🚄🗎

A Data Warehouse project based on Microsoft Northwind Database.

Data Warehouse Star Schema:
image

Business Reports:

Report 1: Market Basket Analysis

  • Uses Common Table Expressions, "with" clause to simplify query and "CUBE" function to aggregated sumamry statistics.
  • Allows users to actually state the specific timeframe (or all), geographical setting (or all) and product categories (or all) for analysis.
  • Applications: (1) Cross-Selling Opportunities and (2) Inventory Management image

Report 2: Market Penetration Analysis

  • Uses Common Table Expressions and "ROLL UP" Function for illustrate both detailed and high-level view of specific market performance.
  • Allows users to state specific timeframe (or all), geographical location (or all) and product line (or all) to analyse.
  • Applications: (1) Strategic Marketing Planning and (2) Resource Allocation Decision Making image

Report 3: Customer Satisfaction Analysis

  • Uses Common Table Expressions and "ROLL UP" Function for illustrate both detailed and high-level view of specific customer segment satisfaction levels.
  • Allows users to specify year and specific country for analysis
  • Applications: (1) Customer Retention / Prevent Customer Churn and (2) Targeted Marketing image

About

A Data Warehouse project based on Microsoft Northwind Database.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published