Data Modeling with google analytics data

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.