Gerard Hales | Power BI & Business Intelligence Developer in Kraków
Open to freelance BI projects · Kraków & remote

Dashboards your stakeholders actually read.

Gerard Hales — Business Intelligence Developer

Nine years across banking, engineering and people analytics — currently building Power BI and Databricks solutions at UBS. I model the data, optimise it, and design the reporting layer on top.

revenue_overview.pbix LIVE
Revenue YTD
€2.4M
↑ 12.3%
Net margin
34%
↑ 2.1pp
Refresh
0.8s
optimised
Revenue by month 2026
forecast · Q3
70+ KPIs · one dashboard
4 sources → 1 trusted model
Gerard Hales
{{ s.value }}
{{ s.label }}
9 years inside
UBS·Rolls-Royce·Publicis·Revolut·State Street
Core tooling
Power BI Databricks T-SQL Python DAX Azure
// 01 services

What I build for you

Fixed-price engagements with a clear scope upfront. Every project includes documentation and a handover session so your team stays independent.

Power BI Dashboard
From data source to published, interactive report. KPIs, drill-throughs, bookmarks, row-level security and an optimised DAX model.
Revenue YTD ↑ 12.3%
€2.4M
→ Semantic model included
→ Handover & documentation
→ One revision round
Fixed price 2–4 weeks
Data Modelling & SQL
Clean up messy source data. Build a single trusted analytical layer in SQL, Databricks or Power Query that feeds every report correctly.
Orders order_id PK user_id FK amount Users user_id PK name Products product_id PK 1:N 1:N
→ Multiple source merging
→ Performance tuning
→ Schema documentation
Fixed price 1–3 weeks
BI Audit & Training
Review existing dashboards for performance, accuracy and usability. Live training sessions for your team on Power BI and DAX.
BI Training
→ Written audit report
→ Live training session
→ Recorded for reuse
Day rate 1–5 days
// 02 the pipeline

From scattered data to real impact

Raw sources go in one side. Clean, organised intelligence comes out the other. I'm the part in the middle that makes it trustworthy.

Sources
Excel
CSV files
ERP systems
Databases
Web pages
ingest
▶
Gerard with laptop
Gerard
cleans · models · optimises
Merges, validates & transforms the data into one trusted layer.
SQL DAX AI
deliver
▶
Outcomes
Organised dashboards
Reports
Ready insights
// 03 process

From brief to delivered

A predictable four-step process. You always know where we are, what comes next, and what you own at the end.

{{ pr.no }}
{{ pr.time }}
{{ pr.title }}
{{ pr.desc }}
→{{ pr.deliverable }}
// 04 selected work

Flagship projects

Enterprise work delivered under NDA — screenshots are restricted, so here's what was built and the impact it had.

↑ 23% YTD
UBS · Banking

Power BI on Databricks

Building and optimising Power BI dashboards backed by Databricks for internal banking clients — gathering requirements, modeling the data and tuning models for performance at scale.

Live
since 2023
10+
stakeholder teams
Power BI Databricks DAX TMDL Claude
RETENTION 73% HEADCOUNT 4.2k PROMOTED ↑18 ATTRITION 8.1%
Rolls-Royce · HR

People Dashboard — 70+ KPIs

A flagship Power BI People Dashboard for the Chief People Officer: 70+ KPI tiles, moving trends, bookmarks, custom tooltips and drill-through across 24 months of data from 4 sources merged in SQL.

4→1
sources merged
~150
exec viewers
Power BI Oracle SQL Workday
68% response SURVEY SENT RESPONSES ACTIONABLE check-ins / q
Publicis · Experience

Employee Experience reporting

End-to-end Employee Experience dashboards built from survey data — cleaning, recoding, mapping and merging in Qualtrics, plus recruitment performance and check-in tracking in Power BI.

100%
survey lifecycle
Board
level reporting
Qualtrics Power BI Excel
Have a dashboard like this in mind?
Tell me what you're trying to measure — I'll scope it and quote it.
Start a project →

Showcase projects

things you can actually see

Live · you're on it

This portfolio site

Designed and built from scratch with AI assistance — a self-contained showcase of how I structure information and present data clearly.

HTML / CSS AI-assisted Claude
halesgerard.github.io/Webpage →
halesgerard.github.io/Webpage
Portfolio site preview
Sample

SME Finance Executive Dashboard

Power BI financial overview — revenue vs. costs, net profit, KPIs, client breakdown and monthly trends. DAX measures, AI-generated executive summary, multi-page navigation. Every item — visuals, labels, descriptions, text — can be translated into any language with AI.

Power BI DAX M / Power Query TMDL Claude AI Summary AI translation · any language
SME Finance Executive Dashboard
// 05 recommendations

What colleagues say

“

{{ r.quote }}

{{ r.initials }}
{{ r.name }}
{{ r.role }}
via LinkedIn · {{ r.year }}
// 06 track record

Experience

{{ e.period }}
{{ e.role }}
{{ e.company }}

{{ e.desc }}

{{ tc }}
Education & certifications
{{ ed.year }}
{{ ed.title }}
{{ ed.org }}
{{ ed.note }}
// languages
{{ lg.name }} {{ lg.level }}
// 07 toolbox

The full analytics stack

{{ g.name }}
{{ it }}
Gerard Hales — Business Intelligence Developer
// 08 about

From banking ops to BI development

I started out processing investor transactions at State Street, automating the tedious parts with Excel VBA — and never stopped chasing the cleaner, faster version of every report. That instinct took me through Revolut, Rolls-Royce and Publicis into full BI development, and today to UBS, where I build Power BI solutions on Databricks.

I'm a relentless self-learner — continually deepening my craft through specialisations on Coursera, Udemy and edX. I also build faster by pairing with AI models like Claude, including authoring Power BI semantic models directly in TMDL. I care about correctness first, clarity second, and I leave you with documentation you can actually maintain.

$ ./start-project.sh

Have data that should be doing more?

Tell me what you're trying to measure. I'll reply within two business days with a clear scope and a fixed quote.

↑