End-to-end Banking Data Engineering and Analytics project focused on data cleaning, ETL pipelines, SQL Server Data Warehousing, Star Schema modeling, and interactive Power BI dashboards for financial and risk analysis.
Raw Banking Data
↓
Python Data Cleaning
↓
SQL Server
↓
SSIS ETL Pipelines
↓
Star Schema Data Warehouse
↓
Power BI Dashboards
| Layer | Technologies |
|---|---|
| Data Processing | Python, Pandas |
| Data Warehouse | SQL Server |
| ETL | SSIS |
| Data Modeling | Star Schema |
| Visualization | Power BI |
- Fact_Client_Financials
- Dim_Client
- Dim_Income_Band
- Dim_Risk
- Dim_Banking_Profile
- Dim_Date
Banking-Data-Engineering-Project/
│
├── data/
├── notebooks/
├── powerbi/
├── project_screenshots/
├── README.md
└── LICENSE
- Reham Mohammed
- Sara Abuzied