Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Data Modeling with google analytics data

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.

 

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

  • spinto's avatar
    spinto
    Frequent Visitor
    4 years ago

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

    Tks