Public sector — North AmericaIA Data & Automatisation

A public organization modernized its decision system by migrating from Pentaho to Power BI.

Migration of decision reports from an aging Pentaho platform to Power BI. Data model enrichment, refresh industrialization, access governance. Integration into the existing Microsoft ecosystem.

Delivery model

Development center (CDR)

Via Vivantro

Typical duration

Dedicated multi-month program

Team

BI architect, Power BI Expert developers, data engineers, integration experts

01Context

Aging Pentaho decision platform, costly maintenance
Need to harmonize decision system with the Microsoft ecosystem in place
Critical business reports to migrate without disruption
Opportunity to enrich the data model for new analytical needs

02Intervention

Mapping of existing Pentaho reports (frequency, criticality, users)
Data model redesign for Power BI (keys, granularity, performance)
Progressive migration by functional domain with parity tests
Industrialization of refresh pipelines
Access governance (workspaces, RLS, Premium capacities)
User training and documentation capitalization

03Deliverables

Power BI reports iso-functional to migrated Pentaho reports
Enriched and documented data model
Industrialized refresh pipelines
Access and workspace governance in place
User documentation and team training

04Outcomes

Decision ecosystem unified on the Microsoft stack
Simplified maintenance with operational cost reduction
Capability to address new analytical needs thanks to the enriched model
Increased autonomy of business teams on Power BI

Technologies used

Click a technology to explore our dedicated practice.

Pentaho↗Power BI ExpertSQLPower QueryDAXMicrosoft Fabric↗

Related modernization paths

Path

Cognos to Power BI →

Path

Power BI data audit →

Related expertise

IA Data & Automatisation →

Methodology

ATLAS methodology →

Does this context match yours?

We frame your program at Intake, with transparent budgeting. A short POC can be delivered in a few weeks before committing to a full program.

02Intervention

Mapping of existing Pentaho reports (frequency, criticality, users)

Data model redesign for Power BI (keys, granularity, performance)

Progressive migration by functional domain with parity tests

Industrialization of refresh pipelines

Access governance (workspaces, RLS, Premium capacities)

User training and documentation capitalization