How zellyirigon/sql-data-warehouse-powerbi works
This repository describes a SQL Server warehouse and Power BI reporting workflow: source CSVs are loaded into bronze, cleaned in silver, shaped into gold views, then consumed by a semantic model and reports. The README also describes database setup and the major reporting capabilities. Source excerpts were unavailable, and several documented directories and assets are absent from the supplied tree, so those components use only supported paths where possible; edges reflect README statements, not inspected implementations.
Main entry points: scripts Bronze load · init_database.sql Initialize schemas · ddl_bronze.sql Bronze tables · dataset CRM and ERP CSVs
Components 12
SQL Warehouse
- Bronze load
scripts - Bronze tables
scripts/ddl_bronze.sql - Silver load
scripts - Gold dimensions
scripts - Gold sales fact
scripts
Power BI Reporting
- Semantic model
- DAX measures
- Report pages
Database Setup
- Initialize schemas
scripts/init_database.sql
Other components
- Analyst
- CRM and ERP CSVs
dataset - SQL Server
Connections 14
- Analyst → Initialize schemas: runs setup
README.md - Initialize schemas → SQL Server: creates schemas
README.md - CRM and ERP CSVs → Bronze load: bulk loads
README.md - Bronze tables → SQL Server: defines tables
README.md - Bronze load → SQL Server: loads raw data
README.md - Bronze load → Silver load: loads next
README.md - Silver load → SQL Server: writes cleaned data
README.md - Gold dimensions → SQL Server: defines views
README.md - Gold sales fact → SQL Server: defines view
README.md - Semantic model → Gold dimensions: connects to
README.md - Semantic model → Gold sales fact: connects to
README.md - Semantic model → DAX measures: includes
README.md - DAX measures → Report pages: supports
README.md - Analyst → Report pages: views
README.md