Skip to content
KadmoonINC.
Business Intelligence

QlikView to Power BI migration

A full legacy BI estate moved to Power BI with inventory, dependency mapping, and a rebuild on a governed model, with no information blackout.

Power BIAzure SynapseDAXPower Query
Reports migrated
1,247
of 1,312 after rationalization
Parity validated
98.6%
checked number by number
Current wave
6 of 8
phased cutover, no blackout
Cumulative effort
4,180 h
Our team + client squad

Illustrative figures · fictitious client · under NDA

The challenge

A large report estate on legacy BI was expensive to license and hard to trust, and the business needed to move to Power BI without losing years of logic or leaving users without reports mid-migration.

What we built

We inventoried every report, mapped dependencies, and rebuilt the estate in Power BI over a governed semantic model, migrating in waves so each business unit kept working the whole way through.

  • A full inventory and dependency map of the legacy estate before moving a single report.
  • A governed Power BI semantic model so KPIs carry one definition.
  • A phased, wave-by-wave cutover with parity validation at each step.

Outcomes

  • Reports rebuilt on a governed model instead of copied one for one.
  • Migration in waves with no information blackout.
  • Lower licensing cost on the Microsoft stack.

The dashboard we delivered

Migration Cockpit · QlikView → Power BIctl_migracao · ImportRefreshed 07/08 06:12Illustrative data
Report pages
Filters
Wave
Waves 1 to 8
Status
All
Criticality
High and medium
Hierarchy
Business unit
Area
Report
Business unit · consolidated
Reports migrated+96 this wave
1,247
of 1,312 after rationalization
Parity validated+1.4 p.p.
98.6%
checked number by number
Current waveon track
6 of 8
phased cutover, no blackout
Cumulative effort-12% vs plan
4,180 h
Our team + client squad
Reports retired
65
DAX measures created
3,412
Active users/month
1,860
Average load time
4.2 min

Reports migrated per month

Cumulative by wave, against contracted target

MigratedPlan
34124414955
JanFebMarAprMayJunJulAugSepOctNovDec

Reports by business unit

Click to drill down the hierarchy

Rationalization retired 65 reports unused over the last 12 months.

Reports in scope

One row per report rebuilt in Power BI

8 of 160 rows
Report
Area
Wave
DAX measures
Parity
Effort
Status
RPT-1241 · Cash flowAccounting
Finance
8
58
99.2%
88 h
In validation
RPT-1235 · Management P&LAccounting
Finance
6
21
99.9%
76 h
Approved
RPT-1151 · Taxes assessedSales
Sales
5
45
99.6%
68 h
Approved
RPT-1282 · Service levelSales
Sales
5
21
99.8%
55 h
Approved
RPT-1111 · Productivity by shiftProduction
Operations
8
20
98.4%
26 h
In validation
RPT-1442 · Maintenance backlogProduction
Operations
7
18
97.8%
16 h
In progress
RPT-1752 · Discount grantedPurchasing
Procurement
6
25
98.1%
79 h
In validation
RPT-1457 · Service levelPurchasing
Procurement
8
44
98.8%
22 h
In validation

Illustrative dashboard with the structure delivered on the project. Client names and figures are fictitious and under NDA.

Want a dashboard like this on your data?

Tell us your scenario and get a diagnosis and a proposal with an investment range within a few business days.

Start a project

More case studies