New: itmX offers a predefined Power BI template for visualizing your marketing automation data in the Evalanche App area.

In our last blog post, we looked at the topic of Customer Intelligence and how the topic of data management and data orchestration plays into that.

Today we would like to deepen this topic and our Power BI Template for Evalanche. Because with Evalanche version v7.256 from 09.06.2023, the new app area in the App Switch and Marketing Cockpit is now available to users. This app area makes it possible to integrate partner apps or third-party applications. We have taken this as an opportunity to integrate our existing Power BI Evalanche template. For you as an Evalanche user, this means that you can now visualize your Evalanche data with our predefined Power BI template.

Your benefits: itmX & Power BI – “the Preferred BI Solution” for Evalanche

In addition to the existing Evalanche data, it is also possible to visualize further data from other applications. This allows you to summarize all customer-relevant data from the initial contact to the successful conclusion and follow-up in one evaluation. This creates a completely new transparency for your lead management.

“In order to achieve the best possible customer journey, it is important in marketing and sales to analyze the past in order to obtain insights and derive measures. With Power BI, itmX is our preferred BI provider. The itmX Power BI template for Evalanche provides a predefined and parameterized template to start quickly and easily with the data analysis of Evalanche. The template also offers the flexibility to integrate other data sources, such as the CRM system or Google Analytics, into the analyses.”

Martin Philipp, Managing Director SC-Networks

The Power BI template for Evalanche powered by itmX includes the following

The itmX Power BI template for Evalanche is intended to enable the rapid use of analytical evaluations using Power BI. In the process, some work steps have already been prepared and parameterized to the extent that the customer-specific data is visible in Power BI with minimal adaptation.
After setting up the template and linking your data, you can already work with the evaluations.

The template contains:

  • The predefined and parameterized connection of the Evalanche Reporting API for the services (including first small transformations):

  • Profiles (standard version)

  • Mailings

  • Tracking Type

  • Resource Type

  • Forms

  • Trackinghistory

  • The data modeling and the relationship setup between the different data tables

  • A predefined visual Power BI report with the following pages:

  • Profiles (Evalanche standard version)

  • Mailings/ Newsletter

  • Mailings Details (for a detailed analysis)

  • Forms

  • Trackinghistory

  • Bi-Dahboard Evalanche_Formular Analyse
  • Bi-Dahboard Evalanche_Mailing Analyse
  • Bi-Dahboard Evalanche_Profil Analyse

Quick success for the visualization of your lead management

With our pragmatic and customer-oriented approach, you will be able to evaluate your data within a few days. Our approach is as follows:

Project approach with the Power BI Template

Microsoft Power BI & Evalanche

The following package has proven effective for deploying the Power BI template:

  • 1-day requirements workshop incl. mini-concept creation

  • Ready-to-Use Power BI Template with

  • Power BI Report

  • predefined Power Bi Connector to Evalanche Reporting API

  • predefined transformation steps in Power Query

  • predefined Power BI Measures in DAX

  • Power BI Data Model

  • Service

  • nitial setup of the Power BI template in the Power BI tenant in a separate workspace

  • Connection of the customer tenant

  • Adaptation of the template to the customer CI (colors, font & logo)

  • Integration into the partner app area in the Evalanche customer tenan

About the author

Robin Hartmann
Robin HartmannHead of Modern Work and Business Intelligence itmX GmbH
As Head of Modern Work and Business Intelligence, Robin is responsible for optimising our customers’ processes and helping them to position themselves for future challenges. As a creative mind, he is primarily driven by innovation topics. Due to his proximity to the customer, he experiences the real business requirements first-hand and enjoys driving them forward together with our customers.