CLIENT SUCCESS STORY
Company Highlights
Company Type: Energy
Industry: Energy
Client Function: Finance, Operations
Introduction
One of our clients is a firm that used QlikView for reporting, and wanted to migrate to Power BI and Azure, the strategic data platforms that offer market leading data tools. Pomerol supported the migration by rebuilding the ETL, replacing nPrinting with Power BI Paginated Reports, and using Power Automate workflows to create buttons in the reports.
Business Problem
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.
Challenges
Some of the QlikView apps had additional complexities, this prompted Axpo to ask for Pomerol’s support with the migration:
- Complex ETL processes with multiple stages of transformations apps and QVD storage.
- nPrinting used extensively to generate PDF reports to email to stakeholders.
- Buttons embedded in the QlikView apps allow users to manually trigger the nPrinting emails and refresh of the data.
Solution and Results
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.
About Pomerol
Pomerol Partners creates and delivers meaningful, business-focused data solutions. We are not general technologists; we specialize in data and data-driven projects. Our team of consultants and data engineers have a depth of experience across the full analytics supply chain – from initial data extract, through transformation and modelling, to dashboarding and operational alerting, and, onward to machine learning and predictive analytics. We also integrate data into customer facing portals. We work in a wide range of industries across a wide range of business functions including sales, operations, finance, manufacturing, marketing, and, more. Our clients include the Fortune 100 to 100 employee companies.
Our consultants are in the United States, United Kingdom, Australia, and Portugal.
More Insights
-
Qlik to Power BI Migration
-
Client Product Reporting in FX Sales & Trading
-
Consolidating Financials for Multiple Acquisitions
-
How Machine Learning Can Transform the Financial Sector in 2024
-
Tracking Key Business Metrics using Power BI
-
Update on the future of Talend Open Studio
-
Multinational Bank’s Need of Fluid Understanding for their FX Pricing
-
Building a Single View of a Customer’s Portfolio to Support Regulatory Compliance
-
Exploring Change Data Capture (CDC)
-
🔍 Excel vs. BI Tools: Why It's Time to Evolve Your Data Strategy
