Customer Insight and Marketing Effectiveness

Insights that Drive Impact

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

Customer Insight and Marketing Effectiveness

The client wished to migrate an existing Qlik Sense dashboard into Power BI as part of a larger firmwide move into Azure Cloud Services. The Qlik Sense dashboard had functionality native to the Qlik Sense tool that needed to be replicated in Power BI. Additionally, the data modeling had to be recreated using Power BI’s Query Editor as the two tools handled the data differently. The client was migrating their infrastructure to Azure and this project allowed the dashboard to fall inline with that larger strategy. It also enables them to leverage the capabilities of the Microsoft Power Platform to improve data quality and process efficiency. The Qlik Sense dashboard was created to track the performance of the main marketing KPI’s based on the market insight data and group scorecard data from each business unit. This allowed them to review and analyze their final results versus predicted results for campaigns. The dashboard enabled them to drill into the data of individual campaigns to perform in-depth performance analysis.

Problem Statement

Bridging the Gap

The principal challenges were to replicate visualizations’ and analytics built using native Qlik Sense functionality, and to recreate the Qlik data model in Power Query M. These included:

• Loading data from multiple data sources in one data model so business users could access and do analysis on data in one place

• Maintaining the Self-Service functionality that Pomerol had built into the Qlik Sense report

• Restricting user’s access to only data from their business unit

• Distributing the report to over 100 business users across different business units

• Alternate dimensions and measures (user ability to configure dimensions and measures in a chart)

• Comparing results across different time periods

• The ability to view the data in different currencies

Solution Overview

Maximizing Marketing Success

Pomerol created a new report in Power BI tracking marketing spend and ROI against internal targets.

A new data model was designed to align with Power BI’s functionality and best practices.

Using the new data model Pomerol were able to replicate the dimension switching functionality of Qlik Sense.

A series of nested measures were created that allowed the business users to view the data by their chosen currency as well as other business defined metrics based on slicer selection in data islands.

Another series of nested measures allowed the user to select which measure was reflected in charts based on filter selections in data islands. Rules were built into the report to restrict data access by username so that the business could distribute the report to over 100 users with the correct security access applied.

Results and Impact

Through the implementation of enhanced marketing KPIs accessibility, up to 100 users now benefit from real-time insights and data-driven decision-making capabilities.

This increased access has empowered users to report on key performance figures more efficiently and make informed decisions at a faster pace. As a result, there has been a significant improvement in KPI tracking accuracy and a reduction in report delivery times, leading to more agile and responsive marketing strategies.

Overall, this has contributed to a streamlined decision-making process and a noticeable boost in marketing effectiveness.

Discover how enhanced access to marketing KPIs enables 100 users to make faster, data-driven decisions, significantly improving KPI tracking and report delivery

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: