All projects

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

  1. Ingest and transform data with Python, Pandas and SQLAlchemy.
  2. Store and query the data in PostgreSQL.
  3. 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

Anticipating energy demand