By using this web site you accept our use of cookies. More information about cookies
Accept
Infopulse - Expert Software Engineering, Infrastructure Management Services
By using this web site you accept our use of cookies. More information about cookies
Accept
Infopulse - Expert Software Engineering, Infrastructure Management Services
Infopulse - Expert Software Engineering, Infrastructure Management Services
Send message
Send message Please fill in this quick form and we will send you a free quote shortly.
* Required fields
Your privacy is important to us. We will never share your data.
Subscribe to our updates Be among the first to get exclusive content on IT insights, innovations, and best practices.
* Required fields
Your privacy is important to us. We will never share your data.
Subscribe to our Vacancies Please fill in this quick form to be among the first to receive our updates.
* Required fields
Your privacy is important to us. We will never share your data.
Photo of Dmitry Kotelva Send an email to Dmitry Kotelva Please fill in this quick form to contact our expert directly.
* Required fields
Your privacy is important to us. We will never share your data.
Infopulse - Expert Software Engineering, Infrastructure Management Services
Read the Full Case Study Don't miss the most interesting part of the story!
Submit this quick form to see the rest and to freely access all case studies on our website.
* Required fields
Your privacy is important to us. We will never share your data.

Ellevio Streamlines Decision-Making with a New Business Analytics Platform

70+ analytical reports available in Excel, Power Pivot, and Power BI

Business Challenge

Ellevio is one of the leading electricity distribution operators in Sweden with nearly 915,000 customers. For more than 10 years, the company was owned by the city of Stockholm and Fortum, until it was bought out by new owners in 2015.

After separation and restructuring, Ellevio was in need of its own well-documented Data Warehouse, a reporting system and the possibility for business-users to connect to the data via self-service analytical tools and build ad-hoc reports of different complexity.

Solution

  • Developed a new Data Warehouse and ETL flow using WhereScape RED. The system enables collecting, transforming, preparing and visualizing 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 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).

Business Value

Infopulse helped Ellevio make better decisions by having easy access to accurate and relevant data, create official reports to the authorities and ensure 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.

Technologies

  • MS SQL Server 2016
  • MS SQL SSRS
  • MS SQL SSIS
  • MS SQL SSAS
  • WhereScape RED
  • Oracle 12c
  • PowerShell

Customer Quote

Infopulse

EVRY and Infopulse operate with integrity and respect, always performing above expectations. Ellevio can recommend EVRY and Infopulse as professional, responsible, reliable and trustworthy solution partners with a deep experience in Data Warehouse, Business Intelligence, and Business Analytics services.

Subscribe to our Newsletter