Renovating an analytics platform of an electricity distributor

Infopulse Helps a Nordic Electricity Network Company Rebuild Their Business Analytics Platform

Electricity Network Company

Location:

Nordics

Industry:

Energy, Oil & Gas

Employees:

3,000+

About the Customer:

One of the leading energy companies in the Nordics with over 900,000 customers that provides electricity distribution, grid connection, and other network-related services, also contributing to charging stations infrastructure and development of energy solutions.

Business Challenge

After separation and restructuring, the company required its own well-documented data warehouse, a reporting system (including building ad-hoc reports of different complexity), and the possibility for business users to connect to the data via self-service analytical tools.

energy-company-rebuilds-business-analytics-platform-picture-in-content

Solution

  • Infopulse developed a new data warehouse and ETL flow using WhereScape RED. The system enables the collection, transformation, preparation, and visualization of business data from 7 different data sources. 
  • More than 70 SSRS-based analytical reports in multiple functional areas for different business users.
  • SSAS-based cubes and views on the presentation layer to enable connection via self-service analytical tools.
  • Redesigned and re-implemented the revenue assurance solution.
  • Implemented multi-temperature data management (the data rarely used by users is transferred to the archives).

Technologies

microsoft-sql-server-analysis-services logo
Microsoft SQL Server Analysis Services (SSAS)
sql-server-reporting-services logo
Microsoft SQL Server Reporting Services (SSRS)
microsoft-sql-server-integration-services logo
Microsoft SQL Server Integration Services (SSIS)
WhereScape RED logo
WhereScape RED
Oracle 12c logo
Oracle 12c
PowerShell logo
PowerShell

Business Value

Infopulse helped the electricity network company make better decisions by having easy access to accurate and relevant data, creating official reports to the authorities, and ensuring high data quality and correctly invoiced customers, at the same time reducing the internal personnel workload:

  • Created a new fully documented corporate DWH from scratch, including data partitioning. 
  • Empowered business users with a flexible analytical platform to create ad-hoc reports of different complexity.
  • Provided different tool sets (Excel, Power Pivot, Power BI) for accessing data.
  • Established data quality control process, including sending out alerts on any data inconsistency.
  • Helped data stewards adjust data in the data warehouse excluding direct access to the database.
  • A number of mandatory reports were built, which now go directly to the authorities without additional manual work.

Related Services

We have a solution to your needs. Just send us a message, and our experts will follow up with you asap.

Please specify your request

Thank you!

We have received your request and will contact you back soon.