Documentation Customer Journey Analytics Customer Journey Analytics Guide

Visualizations

Last update: Thu Jan 29 2026 00:00:00 GMT+0000 (Coordinated Universal Time)

Topics:
Data Views

CREATED FOR:

User

You want to understand how the visualizations, available in Customer Journey Analytics, can be similarly created using the available visualizations in the BI tools.

Customer Journey Analytics

Customer Journey Analytics has a number of visualizations. See Visualizations for an introduction and an overview of all possible visualizations.

BI tools

tabs

Power BI Desktop

Comparison

For most Customer Journey Analytics visualizations, Power BI Desktop offers equivalent experiences. See the table below.

table 0-row-3 1-row-3 2-row-3 3-row-3 4-row-3 5-row-3 6-row-3 7-row-3 8-row-3 9-row-3 10-row-3 11-row-3 12-row-3 13-row-3 14-row-3 15-row-3 16-row-3 17-row-3 18-row-3 19-row-3 20-row-3 21-row-3 22-row-3 23-row-3 1-align-center 5-align-center 9-align-center 13-align-center 17-align-center 21-align-center 25-align-center 29-align-center 33-align-center 37-align-center 41-align-center 45-align-center 49-align-center 53-align-center 57-align-center 61-align-center 65-align-center 69-align-center 73-align-center 77-align-center 81-align-center 85-align-center 89-align-center 93-align-center
Icon	Customer Journey Analytics visualization	Power BI Desktop visualization
	Area	Area chart, stacked area chart and 100% area chart
	Bar	Clustered column chart
	Bar stacked	Stacked column chart and 100% stacked column chart
	Bullet
	Cohort table
	Combo	Line and stacked column chart and Line and clustered column chart
	Donut	Donut chart
	Fallout	Funnel.
	Flow	Decomposition tree?
	Freeform table	Table and Matrix
	Histogram
	Horizontal bar	Clustered bar chart
	Horizontal bar stacked	Stacked bar chart and 100% stacked bar chart
	Journey canvas	Decomposition tree
	Key metric summary
	Line	Line chart
	Scatter	Scatter chart
	Section header	Text box
	Summary change	Card
	Summary number	Card
	Text	Text box
	Treemap	Treemap
	Venn

Drill down

Power BI supports a drill mode to explore in-depth details on certain visualizations. In the example below, you analyze purchase revenue for product categories. From the context menu of a bar representing a product category, you can select Drill down.

Power BI drill down

Drill down updates the visualization with purchase revenue for products within the selected product category.

Power BI drill up

The drill down results in the following SQL query that uses a WHERE clause:

code language-sql

select "_"."product_category" as "c25",
    "_"."product_name" as "c26",
    "_"."a0" as "a0"
from
(
    select "_"."product_category",
        "_"."product_name",
        "_"."a0"
    from
    (
        select "_"."product_category",
            "_"."product_name",
            "_"."a0"
        from
        (
            select "rows"."product_category" as "product_category",
                "rows"."product_name" as "product_name",
                sum("rows"."purchase_revenue") as "a0"
            from
            (
                select "_"."product_category",
                    "_"."product_name",
                    "_"."purchase_revenue"
                from "public"."cc_data_view" "_"
                where ("_"."daterange" >= date '2023-01-01' and "_"."product_category" = 'Fishing') and "_"."daterange" < date '2024-01-01'
            ) "rows"
            group by "product_category",
                "product_name"
        ) "_"
        where not "_"."a0" is null
    ) "_"
) "_"
order by "_"."product_category",
        "_"."product_name"
limit 1001

Tableau Desktop

Comparison

For most Customer Journey Analytics visualizations, Tableau Desktop offers equivalent experiences. See the table below.

table 0-row-3 1-row-3 2-row-3 3-row-3 4-row-3 5-row-3 6-row-3 7-row-3 8-row-3 9-row-3 10-row-3 11-row-3 12-row-3 13-row-3 14-row-3 15-row-3 16-row-3 17-row-3 18-row-3 19-row-3 20-row-3 21-row-3 22-row-3 23-row-3 1-align-center 5-align-center 9-align-center 13-align-center 17-align-center 21-align-center 25-align-center 29-align-center 33-align-center 37-align-center 41-align-center 45-align-center 49-align-center 53-align-center 57-align-center 61-align-center 65-align-center 69-align-center 73-align-center 77-align-center 81-align-center 85-align-center 89-align-center 93-align-center
Icon	Customer Journey Analytics visualization	Power BI Desktop visualization
	Area	Area Chart
	Bar	Bar Chart
	Bar stacked
	Bullet	Bullet Graph
	Cohort table
	Combo	Combination Charts
	Donut
	Fallout
	Flow
	Freeform table	Text Table
	Histogram	Histogram
	Horizontal bar	Bar Chart
	Horizontal bar stacked	Bar Chart
	Journey canvas
	Key metric summary
	Line	Line Chart
	Scatter	Scatter Plot
	Section header
	Summary change
	Summary number
	Text
	Treemap	Treemap
	Venn

Drill down

Tableau supports drill mode through hierarchies. In the example below, you create a hierarchy when you select the Product Name field within Tables and drag it on top of Product Category. Then, from the context menu of a bar representing a product category, you can select + Drill down.

Tableau drill down

Drill down updates the visualization with purchase revenue for products within the selected product category.

Tableau drill up

The drill down results in the following SQL query that is using a GROUP BY clause:

code language-sql

SELECT CAST("cc_data_view"."product_category" AS TEXT) AS "product_category",
  CAST("cc_data_view"."product_name" AS TEXT) AS "product_name",
  SUM("cc_data_view"."purchase_revenue") AS "sum:purchase_revenue:ok"
FROM "public"."cc_data_view" "cc_data_view"
WHERE (("cc_data_view"."daterange" >= (TIMESTAMP '2023-01-01 00:00:00.000')) AND ("cc_data_view"."daterange" < (TIMESTAMP '2024-01-01 00:00:00.000')))
GROUP BY 1,
  2

The query does not limit the results to the selected product category; only the visualization shows the selected product category.

Tableau drill up

Alternatively, you can create a drill down dashboard where one visual is the result of the selection in another visual. In the example below, the Product Categories visualization is used as a filter to update the Product Names table. This visualization filter is client-only and does not result in an additional SQL query.

Tableau visualization filter

Looker

Comparison

For most Customer Journey Analytics visualizations, Looker offers equivalent experiences. See the table below.

table 0-row-3 1-row-3 2-row-3 3-row-3 4-row-3 5-row-3 6-row-3 7-row-3 8-row-3 9-row-3 10-row-3 11-row-3 12-row-3 13-row-3 14-row-3 15-row-3 16-row-3 17-row-3 18-row-3 19-row-3 20-row-3 21-row-3 22-row-3 23-row-3 1-align-center 5-align-center 9-align-center 13-align-center 17-align-center 21-align-center 25-align-center 29-align-center 33-align-center 37-align-center 41-align-center 45-align-center 49-align-center 53-align-center 57-align-center 61-align-center 65-align-center 69-align-center 73-align-center 77-align-center 81-align-center 85-align-center 89-align-center 93-align-center
Icon	Customer Journey Analytics visualization	Power BI Desktop visualization
	Area	Area Chart
	Bar	Bar Chart
	Bar stacked	Bar Chart
	Bullet	Bullet Graph
	Cohort table
	Combo	Customizing visualizations
	Donut	Donut
	Fallout	Funnel
	Flow	Sankey
	Freeform table	Table
	Histogram
	Horizontal bar	Bar Chart
	Horizontal bar stacked	Bar Chart
	Journey canvas
	Key metric summary
	Line	Line Chart
	Scatter	Scatterplot
	Section header
	Summary change	Single Value
	Summary number	Single Value
	Text	Single Value
	Treemap	Treemap
	Venn Diagram	Venn Diagram

Jupyter Notebook Comparing the visualization capabilities of matplotlib.pyplot, the state-based interface to matplotlib, is beyond the purpose of this article. See examples above for inspiration and the matplotlib.pyplot documentation.

RStudio Comparing the visualization capabilities of ggplot2, the data visualization package in R, is beyond the purpose of this article. See examples above for inspiration and the ggplot2 documentation.

recommendation-more-help

080e5213-7aa2-40d6-9dba-18945e892f79