Want to create a pdf of this page content to print or email? Click on icon.
Problem Statement
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
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.
Category:
Category: