Challenge
A major Hungarian state-owned energy utility, operating across the full electricity value chain from generation to retail, faced a fragmented and ungovernered data landscape. Business-critical information was locked in disconnected source systems — primarily SAP for operational and financial data, and Salesforce for customer-facing processes — with no central repository to consolidate, historise, or govern it. Reporting was largely ad hoc, relying on manual exports, spreadsheets, and one-off queries executed directly on transactional systems. This placed significant strain on IT teams, introduced inconsistencies across reports, and made it impossible for business users to access reliable data independently. The organisation recognised the need for a proper data warehouse foundation as a prerequisite for any meaningful self-service BI capability, but lacked the architectural expertise to design and deliver it internally.
Solution
Squery joined the project as a data architecture and engineering partner, working alongside the client’s internal team to co-design and implement a central Data Warehouse on MS SQL Server. The architectural approach adopted Data Vault 2.0 as the core modelling methodology, chosen for its auditability, flexibility to accommodate schema changes, and ability to track the full history of data changes — critical requirements for a regulated utility environment. SSIS was used to build the integration layer, with dedicated pipelines extracting, transforming, and loading data from both SAP and Salesforce into the central DWH. Hub, Link, and Satellite structures were carefully designed to reflect the client’s core business entities, and a Business Vault layer was introduced to support derived metrics and business rules. Throughout the engagement, Squery contributed to technical decision-making, pipeline development, data modelling, and knowledge transfer to the internal team.
Benefits
The delivered Data Warehouse gave the organisation its first single source of truth — a consistent, historised, and auditable data foundation that business units could rely on. By integrating SAP and Salesforce into a unified model, cross-functional reporting became possible for the first time, eliminating the contradictions that had previously arisen from siloed systems. The Data Vault 2.0 structure ensured the architecture could absorb future source system changes without requiring fundamental redesign. Most visibly, the DWH layer enabled the rollout of self-service BI reporting, allowing business analysts and managers to access governed, up-to-date data directly — reducing dependency on IT and significantly shortening the time from question to insight.
