How to Analyze CDP Data in Power BI

What is Power BI?

Power BI is a business analytics platform by Microsoft that enables users to visualize data, share insights and build interactive dashboards and reports. It connects to various data sources to help organizations make data-driven decisions.

How does the Power BI connector facilitate integration with Sitefinity Insight?

The Power BI connector for Sitefinity Insight uses an access key to connect to Insight’s API server and retrieve all required data. It is configured to pull data from all datacenters associated with the access key.

Can we build interactive reports in Power BI using customer data?

Yes, the connector exposes tables with data about contacts and their interactions reported to Sitefinity Insight. Note that contact and interaction data export must be enabled before the connector can consume it.

How does the connector handle large data sets to maintain report performance?

Power BI is designed to work efficiently with large datasets using features like caching. The connector also minimizes API requests, making them only when necessary to maintain optimal report performance.