Sales DB is a Data Warehouse Project

This project aims to create a full data warehouse architecture using MS SQL Server

---

Phases:

• Phase #1
  • Collect the data, Understand and Cleaning.
• Phase #2
  • Star Schema.
• Phase #3
  • Cube - MDX - Reporting.

---

Sample SQL Scripts from the project

SELECT sales.TransactionNumber AS [Transaction Number],
employees.EmployeeID AS [Employee ID],
products.ProductID AS [Product ID],
customers.CustomerID AS [Customer ID],
sales.SalesDate AS [Transaction Date],
SUM(sales.Quantity) AS Quantity,
SUM(sales.TotalPrice * (1 - sales.Discount) * sales.Quantity) AS [Total Price]
FROM sales INNER JOIN products ON sales.ProductID = products.ProductID
INNER JOIN employees ON sales.SalesPersonID = employees.EmployeeID
INNER JOIN customers ON sales.CustomerID = customers.CustomerID
GROUP BY sales.TransactionNumber, employees.EmployeeID,
products.ProductID, customers.CustomerID, sales.SalesDate

Sample MDX Query

---

SELECT
{[Measures].[Quantity Sold],[Measures].[Total Price]} ON COLUMNS,
[Transaction Date].[Transaction Date].&[2018-01-04T00:00:00] ON ROWS
FROM [DW Project 313]
WHERE [Product].[Product Name].&[Bananas]

---

Sample Excel Report & Chart

Sample Power Bi Report & Chart

---

dw-sales GiHub