Data Modeling with google analytics data

[Anonymous]

I am trying to build a google analytics report using Power BI.

I couldn't find any unique IDs to connect all the data points from google analytics, and I am new to Power BI. The data modeling are not as organized as I want. Can someone please let me know the best way to build relationships among all these data from GA? Thank you in advance.

[spinto]

Hi @Anonymous ! Can you share me how your model looks?

Tks

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

Hi @Anonymous 

I think you need keyvalues just like IDs or other unique values in your tables to build efficient data model in your report. In Power BI, Snow Scheme and Star Scheme are the most used. I find some offical blogs for data model in Power BI.

For reference: Understand star schema and the importance for Power BI

Google Analytics in Power BI – data modeling

For more details about how to build relationships in Power BI, you may refer to this blog:

Create and manage relationships in Power BI Desktop

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.