Sunday, October 23, 2016

Power BI Desktop – Google Analytics Integration

PowerBIDesktop

Download Power BI Desktop or from the Power BI Portal. Power BI provides out of the box integration with Google Analytics through the Google Analytics Core Reporting API. Google Analytics Core Reporting API change log to track any changes released by Google.

I tried to get some analytics on my blog through Power BI Desktop – Google Analytics Integration.

Note: The Google Analytics content pack and the connector in Power BI Desktop rely on the Google Analytics Core Reporting API. As such, features and availability may vary over time.

a) Open Power BI Desktop – Free tool provided by Microsoft to install on desktops and immediately start pulling data from disparate sources and start building Visualisations over that.

b) Click on “Get Data” from the tool bar and select “Online Services” and choose “Google Analytics”.

PowerBI-GA-1

c) You will then displayed with the message advising that Power BI connects to a third party service which in this case is the Google Analytics Core Reporting API. You can check the Don’t warn me again for this connector checkbox and click “Continue”

PowerBI-GA-2

d) If you haven’t already connected your Google Analytics account with Power BI Desktop then you will be provided with the below screen to connect to your Google Analytics account.

PowerBI-GA-2a

PowerBI-GA-2b

PowerBI-GA-2bb

PowerBI-GA-2c

e) Once provided the credentials and access to Power BI you can then connect to your Google Analytics account from Power BI Desktop.’

PowerBI-GA-2d

f) Select the Google Analytics account and start choosing your dimensions and measures you would like to analyse and Power BI Desktop will import them for you.

PowerBI-GA-3

PowerBI-GA-4

g) Now you can start building your visualisations on your Google Analytics data using Power BI Desktop similar to the below one.

FinalOutput

No comments:

Post a Comment