pbix.plRadosław Sobczak
v1.3.8
PLEN
HomeTrainingsProjectsFAQContact
Case studies

Power BI Projects

Data on its own doesn't create value — reports and dashboards do, by helping people make better decisions.

Discuss your project
FMCG / Retail

Real-time Sales Performance Dashboard

Problem

Management received 30+ Excel reports every week — each department sent its own file with its own KPI definitions. No one knew which numbers were current.

Solution

A single Power BI dashboard fed directly from the ERP and SQL Server. A central data model with unified KPI definitions, automatic nightly refresh, accessible from any device via Power BI Service.

Result

80% less time spent on reporting. One view for the entire board — updated every morning.

Power BISQL ServerDAXPower BI Service
Revenue
+18%
Margin
22.4%
Close time
−86%
Errors
0
Manufacturing

Month-End Close Automation

Problem

Closing the month took two weeks of manually gathering data from SAP, spreadsheets and databases. Copy-paste errors and delayed decisions were the norm.

Solution

A Power Query pipeline connecting SAP, SQL Server and Excel files into a single data model. Automatic nightly refresh eliminates manual consolidation — analysts work with ready-made reports.

Result

Monthly report preparation cut from 14 days to 2. Zero errors from manual copy-pasting.

Power BIPower QuerySAP ConnectorSQL Server
Retail — 200+ stores

HR Analytics Platform

Problem

No single source of truth for headcount, turnover and absence data across a network of 200+ stores. Each regional manager kept their own Excel. Workforce decisions were made without data.

Solution

An automated HR data model in Power BI with weekly refresh. Row Level Security limits each manager's view to their own region. One report replaced dozens of spreadsheets.

Result

Workforce decisions backed by data. Identified turnover patterns reduced annual recruitment costs.

Power BIPower QueryRow Level SecurityDAX
Turnover
−15%
Regions
12
On-time SLA
+12pp
Systems
3
Logistics

Supply Chain KPI Monitoring

Problem

Delivery data scattered across three systems: WMS, TMS and ERP. No real-time SLA visibility — breaches were discovered only after the fact.

Solution

Power BI Gateway connecting all three operational systems without migrating data. A unified delivery dashboard with SLA-at-risk alerts and on-time performance analysis by carrier.

Result

On-time delivery improved by 12 percentage points in 6 months. Issues escalated before SLA breaches occur.

Power BIPower BI GatewayDAXPower Query

Let's build something together.

Tell me about your data and goals — I'll suggest how Power BI can solve a specific problem in your organisation.

Get in touchView trainings
pbix.pl
The best of Excel, Power BI and SQL in one place.
Trainings
Power BIExcelSQLData Visualization
Navigation
HomeTrainingsProjectsContact
Contact
kontakt@pbix.pl
Microsoft Certified Trainer (MCT)
© 2025 Radosław Sobczak | pbix.pl
Power BI, Excel, SQL trainings across Poland