Visualizing User Journey On Website With Parameters

[Bsal26]

I need to display the user journey on our website in a dashboard. The table is from big query has associated events within each session and their parameters which are in array format. This can be parsed out but each event type has its own parameters. I want to display this in an intuitive way where any analyst or user can filter by a certain event and see the user journey. Currently, we have a lot of data and have not been able to achieve this either due to limitations in PowerBI exceeding maximum resources, or having to pivot the data so each event is in its own column. Any solution would be greatly appreciated. 

[v-kpoloju-msft]

Hi @Bsal26,

May i know has your issue been resolved? If the response provided by the Super user @rohit1991, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-kpoloju-msft]

Hi @Bsal26,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[rohit1991 · Accepted solution]

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.