Skip to content

Latest commit

 

History

History
43 lines (24 loc) · 1.75 KB

README.md

File metadata and controls

43 lines (24 loc) · 1.75 KB

Wide World Importers Data Warehouse

Introduction

About The Source Database

Wide World Importers (WWI) is a wholesale novelty goods importer and distributor operating from the San Francisco bay area. It is a premade database which was made by Microsoft and it is good for practicing queries and making data warehouse based on it. for more information click the link below : Wide World Importers sample databases for Microsoft SQL

About Our Work

In This Project , Me (Mohammad Mahdi Mohajer) and my Colleague (Mohammad Derakhshan) decided to implement a Data Warehouse based on Wide World Importers database. We implemented 2 Data Marts from this database for Bachelor's Course of Software Engineering Major in Isfahan University of Technology : Database II.

Implemented Data Marts

  1. Warehouse Mart : Details of stock items, their holdings and transactions.

  2. Sales Mart : Details of customers, salespeople, and of stock item sales.

Technologies Required

  1. Microsoft SQL Server (2012 and Higher >>)
  2. Microsoft SSMS (SQL Server Management Studio)

Other Optional Technologies

  1. Microsoft SSAS
  2. Microsfot SSRS

Project Guide

For testing and running the data ware house that we created , go to Source directory and read the README.md and follow the instructions.

Project Status

This Project Is Completed ✅

Credit

  1. Mohammad Mahdi Mohajer
  2. Mohammad Derakhshan