How debajyotiparui26/sql-datawarehouse-superstore works
This repository documents a Superstore sales warehouse and Power BI reporting suite. The main workflow loads CSV data into Bronze, transforms it through Silver into a Gold star schema, then uses that analytics layer for interactive reporting. The README describes the layer sequence and dashboard capabilities; SQL source excerpts were unavailable, so links between individual transformations and tables are limited to those documented relationships.
Main entry points: superstore_sales_ power_bi - Copy.pbix Power BI Suite · 02_create_raw_data_table_in_bronze_layer.sql Create Raw Table · 03_load_raw_data_in_bronza.sql Load Raw Data · 04_silver_customer.sql Transform Customers
Components 22
Bronze Ingestion
- Create Schemas
Scripts/01_create_databases_and schemas.sql - Create Raw Table
Scripts/02_create_raw_data_table_in_bronze_layer.sql - Load Raw Data
Scripts/03_load_raw_data_in_bronza.sql - bronze.raw_superstore
Silver Transformations
- Transform Customers
Scripts/04_silver_customer.sql - Transform Products
Scripts/05_silver_products.sql - Transform Orders
Scripts/06_silver_orders.sql - Transform Regions
Scripts/07_silver_region.sql - Transform Dates
Scripts/08_silver.dates.sql - Silver Tables
Gold Warehouse
- Customer Dimension
Scripts/09_gold_dim_customer.sql - Product Dimension
Scripts/10_gold_dim_product.sql - Date Dimension
Scripts/11_gold_dim_date.sql - Region Dimension
Scripts/12_gold_dim_region.sql - Sales Fact
Scripts/13_gold_fact_sales.sql - Gold Star Schema
Power BI Reporting
- Power BI Suite
superstore_sales_ power_bi - Copy.pbix - Sales Overview
superstore_sales_ power_bi - Copy.pbix - Product Insights
superstore_sales_ power_bi - Copy.pbix - Regional Logistics
superstore_sales_ power_bi - Copy.pbix
Other components
- Superstore CSV
Datasets/Sample - Superstore.csv - Report User
Connections 29
- Create Schemas → Create Raw Table: enables schemas
- Create Raw Table → bronze.raw_superstore: creates table
- Superstore CSV → Load Raw Data: provides rows
- Load Raw Data → bronze.raw_superstore: loads raw data
- bronze.raw_superstore → Transform Customers: raw source
- bronze.raw_superstore → Transform Products: raw source
- bronze.raw_superstore → Transform Orders: raw source
- bronze.raw_superstore → Transform Regions: raw source
- bronze.raw_superstore → Transform Dates: raw source
- Transform Customers → Silver Tables: cleans customers
- Transform Products → Silver Tables: cleans products
- Transform Orders → Silver Tables: cleans orders
- Transform Regions → Silver Tables: cleans regions
- Transform Dates → Silver Tables: cleans dates
- Silver Tables → Customer Dimension: builds dimension
- Silver Tables → Product Dimension: builds dimension
- Silver Tables → Date Dimension: builds dimension
- Silver Tables → Region Dimension: builds dimension
- Silver Tables → Sales Fact: builds fact
- Customer Dimension → Gold Star Schema: dimension table
- Product Dimension → Gold Star Schema: dimension table
- Date Dimension → Gold Star Schema: dimension table
- Region Dimension → Gold Star Schema: dimension table
- Sales Fact → Gold Star Schema: fact table
- Gold Star Schema → Power BI Suite: feeds reporting
- Power BI Suite → Sales Overview: includes page
- Power BI Suite → Product Insights: includes page
- Power BI Suite → Regional Logistics: includes page
- Report User → Power BI Suite: explores