Visualizing Google Analytics Data via Microsoft Power BI

Power BI is a data visualization and modelling tool from Microsoft.

It is free to use (for up to 1 GB data storage per user) and can be connected to various data sources including ‘Google Analytics’.

Through this tool you can visualize your website data to gain insight.

The pro version of this tool is the paid version and can be used, if you need more data storage, want hourly data refresh (instead of daily) and more BI (Business Intelligence) tools.

The Importance of Data Visualisation in Web Analytics

Data visualization is the presentation of data in graphical format.

Data visualisation is not just about creating pretty reports and dashboards.

It is about making sense of the data.

When you got have lot of data to analyze, you can’t spend days or weeks, analyzing thousands/millions of rows of data in excel spreadsheets.

You need a system through which you can quickly make sense of data, determine patterns and anomalies, which are otherwise extremely hard to detect in a timely manner.

Here data visualization comes handy.

Data visualization not only helps in data interpretation but also help in data retention and telling meaningful, emotional and engaging stories to key decision makers.

If you wish to make your reports more meaningful and persuasive, then you need to learn the art of story telling by visualising your data.

Get the E-Book (37 Pages)

Get the E-Book (40 Pages)

Power BI vs. Google Data Studio vs. Tableau

Power BI, Google Data Studio and Tableau, all are well known data visualization tools.

Following are the various pros and cons of using these tools:

#1 Free Version

Both Power BI and Tableau provide free version of their products.

On the other hand, Google data studio is free to use.

Tableau’s  free version is called ‘Tableau Public’ but it won’t let you produce and save any private content, so pretty much useless for commercial purpose.

Tableau provides only 2 weeks free trial, unless you are a student or instructor at an accredited academic institution, who can use Tableau for free.

#2 Cost

Google data studio is free to use.

The paid version of Power BI will cost you just $9.99 per user per month.

The cheapest tableau product is ‘Tableau Desktop Personal edition’ which will cost you $420 per user per year.

But this edition is pretty much useless, as it does not directly connect with Google Analytics and provide just 7 connectors (data sources).

Tableau Desktop Professional edition’ directly connects to: Google Analytics, Google BigQuery, Google Sheets.

But this edition will cost you $840 per user per year and it still does not directly connect with Google Adwords.

Use Power BI for basic data visualization.

If you have very specialized data visualization needs, then consider using ‘Tableau’.

#3 Data Connectors

Google Data studio primarily integrates and visualize data across all GA products.

It primarily focus on connecting data from other Google data sources (like Google Analytics, Google Adwords, DBM, Google sheets, Youtube etc).

So if you are mainly using Google products then it is all well and good.

But if you are using non-google products then in many cases there is no direct integration.

However bear in mind that Google will introduce more data connectors in the near future.

So this limitation won’t be there for long. 

Power BI, primarily focus on connecting data from other Microsoft products (Microsoft Azure Enterprise, Dynamics AX cost management etc).

But unlike data studio, it provides many more data connectors for both non-microsoft and non-google data sources (Adobe Analytics, comScore Digital Analytics, Github, MailChimp, Marketo, Salesforce, Stripe etc)

However the biggest downside of Power BI is that, it provide only two connectors for Google products and i.e. for Google Analytics and Google BigQuery (still in beta).

So for example, Power BI does not provide any connector for: Google Adwords or Google sheets.

What that means, you can’t download the Google Adwords data directly into Power BI.

But there is a workaround.

You can still indirectly, download Adwords data via your Google Analytics or via Excel or CSV file.

But then really what more can you ask, from one of the cheapest data visualization tool in the market.

Following is a short video which compares Power BI and Tableau on four important factors:

Integrating Power BI with Google Analytics

To integrate Power BI with Google Analytics, follow the steps below:

Step-1: Sign up for Power BI (free) using your work email. Use the online (cloud based) version instead of the desktop version for now. Power BI desktop is more powerful but more suitable for advanced users.

Step-2: After you have signed up, click on the ‘Get’ button under the ‘Services’ box:

welcome

Step-3: Search for Google Analytics app and then click on the ‘Get it now’ link:

You will now see a dialog box which ask you to select ‘authentication method’:.authentication

However you don’t have the option to select any other authentication method.

Step-4So leave this selection the way it is and click on the ‘Sign in’ button.

Step-5: Choose your Google account by clicking on it.

Step-6: Allow Power BI to access your Google Analytics data by clicking on the ‘Allow’ button:request-for-permission

Note: It may take up to a minute or more for Power BI to connect with your Google Analytics. So you need to be patient and do not automatically assume that something has gone wrong. If the integration does not work the first time then try it again. Remember after all, it is a Microsoft product.

Step-7: Select your Google Analytics account, property and view whose data you want to visualize and then click on the ‘import’ button:

connect-to-ga

Note: Importing data from your GA property could take some time.

Introduction to Workspace in Power BI

Workspace is the navigation area used for interacting with Power BI:

The workspace contains following four main areas:

  1. Dashboards
  2. Reports
  3. Workbooks
  4. Datasets

A dataset is simply a data source like: ‘Google Analytics’, ‘Excel file’, ‘Salesforce’ etc.

The more data source you integrate with Power BI, the more datasets you can use and more powerful your marketing and analytics reports become.

You need to have at least one dataset available, before you can create reports and/or dashboards in Power BI.

You can create visualizations by adding data points to your dataset and then save the visualization as a new report.

From your reports, you can create a new dashboard.

Creating Reports in Power BI

In the context of Power BI, a report is one or more visualization tiles.

These visualization tiles can be on one page or multiple pages.

Here is how a visualization tile looks like in Power BI:

visualization-tile

Note: A single visualization title is also known as single visualization.

There are two methods through which you can create one or more visualization tiles.

One is through ‘Datasets’ area and the other is through ‘Reports’ area.

To create a visualization tile via ‘Datasets’ follow the steps below:

Step-1: Click on the ‘Dataset’ which you want to use, for creating your visualization. For example, you can select ‘Google Analytics’:

Step-2: Select the metric you want to use for creating a data visualization tile. For example, I selected ‘sessions’ by typing ‘sessions’ in the ‘search’ box:

type-sessions

Step-3: Drag and drop the ‘sessions’ metric into the empty drawing area on the left hand side:

drag-drop-metric

After the drag and drop, you will see a new data visualization tile based on the ‘sessions’ metric:

visualization-tile2

Step-4: Click on the ‘Reading View’ button at the top:

reading-view2

Step-5: Click on the ‘save’ button:unsaved-changes

Step-6: Give your new report a name and click on the ‘save’ button:

save-report

You will now be automatically redirected to the ‘Reports’ section of your workspace.

Step-7: Click on the ‘Edit report’ link to add more data visualization tiles to your report:

edit-report2

Step-8: Select the metric you want to use for creating new data visualization tile by typing that metric in the ‘search’ box (as explained earlier)

Step-9:Drag and drop the selected metric into the drawing area on the left hand side.

Step-10: Select the type of visualization you want to apply to your visualization tile from the visualization tool box:

visualization-toolbox

Step-11: Format the text in your data visualization tile by clicking on the ‘Format’ button:

format-button

Step-12: If you want to add rows and columns to your visualization tile, then drag and drop data fields to ‘rows’ and ‘columns’:

drag-data-fields

Step-13: If you want to apply filters to your visualization title, then Power BI provides three types of filters: ‘Visual level filters’, ‘Page level filters’ and ‘Report level filters’:pwer-bi-filters

In order to get the desired data in your visualization title, you need to use these filters.

However do not change the ‘visual level filter’, unless you want to use a different metric for your visualization.

For example, if you want to get visualization data for the date say ‘Sept 25, 2016’ then drag and drop the ‘Date’ field under the ‘Report level filters’ column and then select the date:

drag-date-field

Step-14: Click on the ‘Reading view’ button once you have done editing your report and then save it.

Creating Dashboard in Power BI

In the context of Power BI, a dashboard is a collection of data visualization tiles from one or more reports and/or datasets.

When you first create a Power BI account, one dashboard is automatically set up for you.

You can create additional dashboard(s) by navigating to your workspace and then clicking on ‘+ Create button’ followed by ‘Dashboard’ link:

Once you have created the dashboard, then you need add contents to it.

For example, Let us suppose I created a dashboard named ‘Marketing Dashboard’.

Now I want to add content to it.

So what I can do, is navigate to one of my existing report and then click on the ‘Pin Live page’ button:

pin-live-page

Then select my dashboard from the drop down menu and then click on the ‘Pin live’ button:

pin-live-button

Now when I navigate to my dashboard, I can see this report there.

You can also pin an individual data visualization tile (instead of the entire report) to your dashboard from one or more connected datasets.

That’s how you can create dashboards in Power BI.

You can also share your dashboards with others.

Following is an example of a dashboard in Power BI:

dashboard

Source: https://powerbi.microsoft.com/en-us/features/

You can click on one of these reports to see detailed report.

For example following is the data visualization for system usage report in the last 180 days:

system-usage

If you wish to see say ‘system usage’ data for the last 30 days, then click on the ‘Edit report’ button at the top of the report:

edit-report

Type 30 days in the box as shown below:

30-days

Click on the ‘Reading View’ button:

reading-view

Click on the ‘Save’ button:unsaved-changes

You will now see the ‘system usage’ data report for the last 30 days:

system-usage2

If you want to ‘zoom in’ a particular report, then click on the ‘Focus mode‘ button:

focus-mode

If you want to see the data for a particular chart, then right click on the chart and select ‘See Records’ or ‘See Data’:

see-records

The data that is reported is quite easy to understand:

see-records2

see-records3

Ask Questions About Your Data

This is a very cool feature of Power BI.

You can literally ask questions in plain english about your data from a dashboard and this tool with try to answer it.

I used the word ‘try’ because it does not always answer all of the questions, you may ask.

But it does a very decent job of answering questions.

Google Analytics provide similar functionality via Analytics Intelligence.

Just like in GA, in the case of Power BI, you don’t need to know, how to drill down data.

Just type your question like ‘total sessions by mobile browser’ in the ‘Ask a question about your data’ text box on your dashboard:

type-your-question

As soon as you type your question, you will see the report for ‘total sessions by mobile browser’ (provided there is data available to answer your question):

corresponding-report

 

Check out this cool feature on your own and see how many answers you can get from this powerful ‘Q & A’ feature of the Power BI tool.

There are ton more things you can do with Power BI.

But it is impossible to cover them all in one just one article.

However I hope, you got a basic understanding of what Power BI is and how it can be used.

To learn more about Power BI, checkout the documentation here: Get started with Power BI.

There is a big Power BI users community out there and tons of tutorials are available online for further reading and support.

Learn about the Google Analytics Usage Trends Tool

The Google Analytics usage trend is a new tool which is used to visualise trends in your Google Analytics data and to perform trend analysis.


Do you want to Learn Web Analytics in 4 Weeks?

  • Learn and Master Web Analytics, Conversion Optimization & Google Analytics from Industry Expert in 4 weeks.
  • Lifetime access to the course + Lifelong FREE course updates.
  • New study material added every few months (lifelong learning).
  • Up to date training material.
  • Most exhaustive course on Google Analytics on the internet.
  • Hundreds of Assessments to test your learning.
  • Your 24/7, 365 days a year reference source.
  • Learn at your own pace and from any place.
  • Risk Free with 30 days 100% Money Back Guarantee.

Take your Analytics knowledge to the next level. Checkout my Best Selling Books on Amazon

Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.

Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.

Attribution Modelling in Google Analytics and Beyond
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.

Himanshu Sharma

Certified web analyst and founder of OptimizeSmart.com

My name is Himanshu Sharma and I help businesses find and fix their Google Analytics and conversion issues. If you have any questions or comments please contact me.

  • Over eleven years' experience in SEO, PPC and web analytics
  • Google Analytics certified
  • Google AdWords certified
  • Nominated for Digital Analytics Association Award for Excellence
  • Bachelors degree in Internet Science
  • Founder of OptimizeSmart.com and EventEducation.com

I am also the author of three books:

error: Alert: Content is protected !!