How to set up x-hoppers integration with Power BI
This guide provides step-by-step instructions for configuring x-hoppers integration with Power BI and importing call adoption and performance metrics.
Created: October 2024
Permalink: https://x-hoppers.atlassian.net/wiki/x/IwABB
- 1 Introduction
- 1.1 Requirements
- 2 Setup
Introduction
x-hoppers integration with Power BI (PBI) enables you to download x-hoppers analytical data and import it to Power BI for advanced reporting and visualization. The following data types are available for import:
Adoption: information about who joined a broadcast, when and for how long (import via a script)
Performance metrics: Agents and Stores stats, including wait and talk time, headsets battery status and more; Help points stats, such as QR code scans and tablet help points usage (import via CSV/ XLSX)
Requirements
x-hoppers system on WMS 6
Power BI
Node.js (required for specific scenarios)
x-hoppers SuperHopper+AI license to download performance metrics
Note: Steps describe in this Guide are also applicable to other platform for data analysis, such as Looker, Tableau, Excel and Google Sheets.
Setup
Adoption data
You can import adoption data into Power BI using one the following method.
Method 1. PowerBI direct import
This method involves uploading a DAX (Microsoft’s formula expression language) script to Power BI:
Open Power Query Editor in Power BI, select New Source and choose Blank Query
Open Advanced Editor for the blank query and paste the following script: