Building Power BI Connections to Google Analytics

I’m currently connecting Power BI with the Google Analytics and Salesforce.  It’s much simpler than extracting SQL tables via GA API, but there are some data pitfalls to be mindful of.

I’ll document extracting and cleaning data in Google Analytics and bringing tables into Power BI.  I’ll show some simple relationships created between web data and external sources, such as a CRM objects.

Stay tuned for a post update.

Author: Peter

Peter holds a Google Analytics Individual Qualification (GAIQ) and Google Tag Manager certification. He has 10+ years of experience with Marketing analytics in organizations and websites of all sizes. When he isn't building BI dashboards he chases his daughters around Portland Oregon. View all posts by Peter