Data & Analytics / Project
Czech banking analytics platform
An ETL and Power BI analytics platform for customer segmentation and risk analysis on a public banking dataset.
- My role
- Data engineering & business intelligence
- Period
- Jan 2026
- Transactions
- 1M+
- Visualizations
- 50+
- DAX measures
- 20+
Project scope. Analysis uses the historical 1999 Czech Financial Dataset.
01 / The context
What the project addresses
Explore customer and transaction data from the 1999 Czech Financial Dataset through a structured database and reporting workflow.
02 / My contribution
What I worked on
Built the ETL pipeline and PostgreSQL data layer, and developed Power BI dashboards and DAX measures.
The challenge
Turn a large transaction dataset into understandable customer and risk-analysis views.
03 / The approach
How the pieces fit together
- Ingest and transform data with Python, Pandas and SQLAlchemy.
- Store and query the data in PostgreSQL.
- Build Power BI views for customer segmentation and risk scoring, backed by DAX measures.
04 / The outcome
What the work delivered
- An integrated workflow from transaction data to customer and risk-analysis dashboards.
Next case study