BI extension
This article outlines how the Customer Journey Analytics BI extension can be used to implement the following data export use case:
- Data Lake, Data Warehouse or BI tools
Introduction
Exporting data using the Customer Journey Analytics BI extension allows you to export data from your Customer Journey Analytics data views.
More information
The Customer Journey Analytics BI extension enables SQL access to the data views that you have defined in Customer Journey Analytics. Your data engineers and analysts are more familiar with Power BI, Tableau, or other business intelligence and visualization tools (further referred to as BI tools). They can now create reporting and dashboards based on the same data views that Customer Journey Analytics users are using when creating their Analysis Workspace projects.
The BI extension returns aggregated data, not raw event-level rows. By default, each query returns 50 rows for a 30-day date range, but you can override the row limit to a maximum of 50,000 rows and the date range to your own custom range. See Defaults and limitations for more information.
For more information, see the detailed documentation on the BI extension.