Pomerol Partners Logo
let's talk

Qlik to Power BI Migration: An Energy Company’s Story

Empowering Data Transformation: From QlikView to Power BI

Want to create a pdf of this page content to print or email? Click on icon.

image_pdfDownload page as pdf

Qlik to Power BI Migration: An Energy Company's Story

In the evolving world of data analytics, one of our clients, a forward-thinking firm, used QlikView for reporting. They aimed to enhance their data capabilities by migrating to Power BI and Azure, known for their advanced tools. Pomerol facilitated this transformation by overhauling the ETL processes, ensuring seamless data integration. We replaced nPrinting with Power BI Paginated Reports to meet their complex reporting needs and used Power Automate to create interactive buttons, streamlining workflows. Through strategic planning and expert execution, Pomerol guided the firm to a modern data environment, empowering them to harness their data like never before. This story underscores the impact of advanced data platforms and the value of a skilled partner in navigating migration complexities.

Problem Statement

Seamless Migration Needed

Our client used QlikView for reporting across the firm including uses cases as diverse as operational reporting on their reservoirs and credit risk reporting for finance. They wished to migrate all their QlikView apps to Power BI. QlikView has gone end-of-life and is no longer supported by Qlik. The Power Platform and Azure are the strategic data platforms for this company. They provide market leading data tools and the capability to cater for any future use case that our client may face.

Some of the QlikView apps had additional complexities, this prompted them to ask for Pomerol’s support with the migration:

  1. Complex ETL processes with multiple stages of transformations apps and QVD storage.
  2. NPrinting used extensively to generate PDF reports to email to stakeholders.
  3. Buttons embedded in the QlikView apps allow users to manually trigger the NPrinting emails and refresh of the data

 

Solution Overview

Creating Efficiency

Pomerol successfully completed the migration enabling our client to decommission their QlikView servers, substantially reducing their reporting license costs.

The ETL was rebuilt using Power BI dataflows and SQL stored procedures. The dataflows provide modular multi-stage ETL and the SQL database replaces the QVD storage.

Power BI Paginated Reports replaced nPrinting recreating all PDF reports. Paginated Reports ability to independently create visuals and charts means this company has a more flexible solution going forward that is simpler to maintain.

Power Automate workflows were used to create buttons in the Power BI reports to trigger data refreshes and Paginated Reports. The Power Platform suite of tools enables adding other capabilities to Power BI reports.

The solutions Pomerol delivered set our client up to apply best practice throughout their Power BI and Power Platform environments.

 

 

Results and Impact

Pomerol’s migration solution delivered significant business value by enabling the client to retire their outdated QlikView servers, leading to substantial cost savings on reporting licenses. The transition to Power BI and Azure provided the client with a more flexible and scalable reporting infrastructure, enhancing their ability to generate insights and make data-driven decisions. The new system’s ease of maintenance and adaptability to future needs ensured long-term operational efficiency. Additionally, the integration of automated workflows streamlined reporting processes, saving time and reducing manual effort. Overall, Pomerol’s solutions empowered the client to optimize their data strategy and maintain a competitive edge in their industry

 

Interested in migrating from Qlik to Power BI?

Contact us for a free assessment. 

Qlik to Power BI: 4 Week Implementation
Discover how Pomerol’s migration from QlikView to Power BI and Azure reduced costs, enhanced flexibility, and streamlined reporting for long-term efficiency.

Related Case Studies

Transforming Pharmaceutical Sales with Data Visualization

Pomerol transformed the sales management of a global bio-pharmaceutical giant by implementing a data visualization platform with QlikView.

Category:

Data Analytics in Hospitality

Pomerol Partners transformed the hospitality industry by implementing advanced data analytics solutions for high-end game reserves and lodge industries. By integrating cleansed legacy data with accounting and hospitality management packages, they provided clients with actionable insights and automated reporting. This enabled clients to make informed marketing decisions, optimize their booking and revenue cycles, and significantly improve operational efficiency.

Category:

How Pomerol is Driving Agile Wins in Manufacturing

Pomerol Partners transformed a North American manufacturing client’s operations by implementing an agile BI reporting solution using SAP data. The comprehensive Procurement and Spend application, encompassing 14 million records over five years, enabled detailed analysis and proactive problem-solving. The introduction of the Plan for Every Part (PFEP) had an immediate impact, optimizing inventory management and improving supplier relationships.

Category:

Share the Post: