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