Forum Discussion
Visualizing User Journey On Website With Parameters
Hi Bsal26
Visualizing a dynamic user journey in Power BI with event data from BigQuery especially when dealing with nested arrays and large volumes can be hard, but it's achievable with the right data modeling approach.
Here are some steps:
-
Flatten the structure in Power Query first. Basically, turn each event into its own row with a common session/user ID. That way, every action is easier to slice, sort, and filter.
-
Then, if you’re using parameters (like source, campaign, or entry page), create a separate lookup table for those and build relationships. Makes it easier to control filters across visuals.
-
For the actual journey path, you could use a matrix or custom visuals like a Sankey chart or even a line chart if you’re tracking by timestamp.
-
If your dataset is big, try doing some grouping or summarizing in Power Query before bringing it into Power BI. It’ll perform much better.
-
Hi Bsal26
Visualizing a dynamic user journey in Power BI with event data from BigQuery especially when dealing with nested arrays and large volumes can be hard, but it's achievable with the right data modeling approach.
Here are some steps:
-
Flatten the structure in Power Query first. Basically, turn each event into its own row with a common session/user ID. That way, every action is easier to slice, sort, and filter.
-
Then, if you’re using parameters (like source, campaign, or entry page), create a separate lookup table for those and build relationships. Makes it easier to control filters across visuals.
-
For the actual journey path, you could use a matrix or custom visuals like a Sankey chart or even a line chart if you’re tracking by timestamp.
-
If your dataset is big, try doing some grouping or summarizing in Power Query before bringing it into Power BI. It’ll perform much better.