10BC0 GitHub - dmortalla/project11-bi-modeling: Dimensional data-modeling for a BI warehouse using SQL and Power BI ETL. · GitHub
[go: up one dir, main page]
Skip to content

dmortalla/project11-bi-modeling

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
data
data
 
 
docs
docs
 
 
scripts
scripts
 
 
sql
sql
 
 
README.md
README.md
 
 
requirements.txt
requirements.txt
 
 

Repository files navigation

🧱 Dimensional Data Modeling for BI Warehouse (Python + SQL + Power BI)

Build a dimensional star schema from flat retail data and load it into PostgreSQL for optimized BI analytics.

Workflow

  1. Load flat CSV data (orders, customers, products).
  2. Create dimension and fact tables.
  3. Load schema into PostgreSQL.
  4. Verify joins and KPIs in Power BI.
  5. Automate warehouse refresh via GitHub Actions.
  6. Optionally swap in real-world Kaggle or Maven datasets.

Tech Stack

  • Python (pandas, SQLAlchemy)
  • PostgreSQL
  • Power BI
  • GitHub Actions
  • Hostinger

About

Dimensional data-modeling for a BI warehouse using SQL and Power BI ETL.

darrellmortalla.com

Topics

sqlalchemy postgresql data-engineering business-intelligence python-pandas star-schema dimensional-modeling sql-warehouse bi-data-modeling powerbi-etl

Resources

Readme
Activity

Stars

0 stars

Watchers

0 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

 
 
 

Contributors

Languages
0