David Bocián
David BociánBusiness Intelligence Analyst

End-to-end BI solutions
from data to decisions.

A SQL data warehouse, Power BI semantic models and reports, automation and AI agents. The whole solution – from business requirements to a report management can rely on.

NewPower BI as code with GitHub and Claude Code
I work with
// from data to decisions

One solution, every layer

What an end-to-end BI solution involves – from the nightly data load to the report and safe AI access. The components are live, the data illustrative.

  1. SourcesERP · CRM · billingnightly load
  2. Data warehouseSQL Server · T-SQLdata tests
  3. Semantic modelPower BI · DAXone version of truth
  4. ReportsPower BI ServiceGit and checks
  5. Decisionsmanagement and businessnumbers people trust
01 · data

Data sources

Nightly load into the data warehouse

  • Accounting06:02Done
  • CRM · customers06:06Done
  • Billing06:10Done
  • Contact centre06:14Done
  • Plan and budgetRunning
Loaded 4 of 5
02 · quality

Data tests

Before data reaches the model

  • Unique keys
  • Referential integrity
  • Yesterday complete
  • Reconciled to source
All tests passed
03 · model

EBITDA

Actual vs. budget, m

ActualBudget
EBITDA: Actual vs. budget, m
MonthActualBudget
Nov9.59.8
Dec10.310.1
Jan10.110.4
Feb10.610.2
Mar10.410.6
Apr11.310.9
May11.011.2
Jun11.111.3
Jul11.911.4
Aug12.011.5
Sep12.111.6
Oct12.611.8
04 · report

Churn by region

12-month churn rate

  • Capital6.8%
  • North6.1%
  • East5.4%
  • Central4.9%
  • West4.6%
  • South3.9%
05 · build

Report change

Nothing reaches production unchecked

feat/retentionNew Retention page
  • Design standard
  • Relationships and measures
  • Sensitive data
  • Numbers = warehouse
A human publishes.
06 · AI

Ask the data

AI on the data warehouse, safely

Which customers left in October because of price?

I found 214 supply points. Here are the first three, personal data is masked.

CustomerRegionCommodity
J*** N***SouthGas
P*** K***NorthElectricity
M*** S***CentralElectricity
read-onlyPII maskedaudited
// selected work

Case studies

All projects
pbip-github

Power BI as code: from .pbix to production

Moving reports from .pbix to PBIP, versioning them on GitHub and developing with Claude Code – with a controlled path into production in Power BI Service.

.pbix→PBIP→GitHub→Claude Code→Service
Read the case study
// report demos

Demo reports

All demos

Interactive replicas of Power BI reports on fictional data.

finance

EBITDA – actual vs. budget

A finance overview for management: where the group makes money, how it compares to budget and what exactly drove the gap.

What it shows

  • An EBITDA bridge from budget to actual split into volume, price & mix, cost and other effects.
  • Variance to budget by division with cross-filtering – clicking a division filters the whole report.
  • Monthly trend against budget and a detail table by month and division.
Open demo
David Bocián
// who is behind it

Hi, I'm David.

A BI analyst based in Brno. For over three years I've been building reporting at an international company – from warehouse data to the reports management decides on.

I enjoy the whole cycle: understanding the problem, designing the solution and taking it into production. Lately I build BI with AI agents – faster, with the same quality checks.

Brno, CzechiaBusiness Intelligence AnalystMasaryk University
More about me
// contact

Let's talk about data.

Happy to discuss BI, reporting or AI in analytics. Drop me a line.

Actions
LinkedInGitHubČeská verze
↑↓ move↵ openEsc close
Česká verze