Customer experience | Sales, Customer Insights,...

CI-J REALTIME data in PowerBI

(1) Share

Report

Posted on by WV-20080858-0

Hi community, I'm looking for the easiest way to show Customer Insights - Journeys data in PowerBI. Without having to build reports for CI-J from scratch. In that scenario we're busy for 2 weeks, diving into the data-model and try out different options on a trail-and-error-basis.

We have been working with Outbound-reports in PowerBI for some years. We adjusted the templates (see url below) so they fitted to our business needs.

Does anybody know if there are ready-to-use templates for CI-J?

Or at least a screenshot of how the data-model of a CI-J report should look like in PowerBI? How the relationships between the different Tabels should look like.

Or maybe a step-by-step tutorial how to adjust the outbound-template datamodel to CI-J respons-data and entities in CRM like Journey, Email and Forms?

Any help would be very much appreciated. I geuss a lot of users would like to know this.

Thanks and regards, Wietse

This blog shows a simple example of how to build a custom report in CI-J: https://community.dynamics.com/blogs/post/?postid=011afcd5-bd19-ef11-989b-6045bdb116ca

This page contains the outbound-templates: https://learn.microsoft.com/en-us/dynamics365/customer-insights/journeys/marketing-analytics/analytics-gallery-start

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nitesh Raj 188 on at

Like (0)

Report
CI-J data in PowerBI

Hi Wietse,

Here are some resources and tips to help you get started:

Ready-to-Use Templates: You can find a variety of ready-to-use Power BI templates for CI-J on the Microsoft Learn Page. These templates are designed to help you quickly create reports without starting from scratch.

Data Model Example: For a visual representation of how the data model should look in Power BI, you can refer to the Analytics Reporting Framework. This framework provides a generic template with parameters, data sources, and query code that you can use to query marketing data from Microsoft Dataverse and the interaction store.

Step-by-Step Tutorial: To adjust the outbound-template data model to CI-J response data and entities like Journey, Email, and Forms, you can follow the Prepare for Analytic Reporting with Power BI guide. This guide provides detailed instructions on setting up Azure Blob storage, connecting it to CI-J, and using Power BI templates.

I hope these resources help you get started with your CI-J data in Power BI.

Best regards

Was this reply helpful? Yes No
WV-20080858-0 54 on at

Like (0)

Report

CI-J REALTIME data in PowerBI

Hi Nitesh Raj,

Thanks for reaching out. The documentation you shared all related to Outbound marketing. We need to collectively transition to Realtime. So, my question specifically pertains to Realtime marketing. I’d like the same type of information and templates, but (of course) focused on Realtime. That would be greatly appreciated.

Regards,Wietse

Was this reply helpful? Yes No

Join the conversation

Community site session details

CI-J REALTIME data in PowerBI

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

CI-J REALTIME data in PowerBI

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates