-The OLAP dimensional Star schema has a fact table with composite primary key consist of (orderId, ItemId)
This repo contains:
- Generated dimension date table by TSQL
- TSQL queries that define the star schema.
- ER diagram for Star and Snowflake models.
- Ad-hoc queries for data discovery.
- Stored Procedure and Views for advanced insights.
- UAT Quality for data Validity, accuracy and integrity.
- Copy pipeline to copy tables from SQL server to Parquet in ADLS.
- Power BI report for revenue by region, Year and month for each Product-category.