Blog Power BI + Google Analytics = Power Analytics RSS Feed

Power BI + Google Analytics = Power Analytics

Jul 15, 2019

One of the best online marketing tools to track website performance used by organizations worldwide is Google Analytics. It helps achieving online marketing goals seamlessly. It facilitates digital marketing teams to determine audience’s navigation behavior and the ways audience interact with the website content. It also help the firms to discover which search terms were used to visit their site, which pages and artifacts attracted the most audience, and what percentage responds to call-to-action.

Table of content

  1. What Google Analytics and Power BI can do together
  2. Connecting Power BI with Google Analytics
  3. Embed report Power BI web part in SharePoint Online
  4. Conclusion

What Google Analytics and Power BI can do together

It is highly critical to analyze and track your site’s traffic in this marketing age. Knowledge of your audience’s location, day and time of their visit, frequency of their visits and time spent on your site are some of the parameters which may help you improve your site and bring you closer to your marketing objectives.

Most organizations use Google Analytics to track marketing goals and obtain insights into ways of improving website performance. Using Google Analytics data in Power BI, it has become a driving force to unpack hidden ways that focus on completely new opportunities and suggest innovation in marketing world in a way to attract new customers.

Google Analytics does a fabulous job of tracking site visitor behavior, such as the number of unique page visits, time spent on a site, and geographic location of users. But Google Analytics fails to offer a lot of analytic tools for connecting marketing data to data from other sections of an organization, or to external data trends that are luring a considerable marketplace.

That missing value is added by Power BI. With Power BI you can – 

  • Draw a comparison between Google Analytics data and data from other sources of organization, internal and external.
  • Import data from SharePoint, HDInsight, Azure Marketplace, Exchange – or even Facebook, Wikipedia, and Data.gov.
  • Determine web performance data against data you import from various sources such as Salesforce, Marketo, SharePoint or more.
  • Enable team members to achieve a more specific view of your organization’s performance.

Many users utilize Power BI for its dynamic visualization tools and insights, which are quite exciting. Anyway, it’s a great place to measure your site performance but one thing that catches people’s eye is its real-time data visualization, uncovering multiple trends and patterns of usage.

Consider, for instance, using Power BI map visualizations. They are helpful in tracking the following actions:

  • Enable you to track site visitors’ location worldwide over time. You can drill down a location to track more detail regarding a user’s region.
  • Analyze website traffic at a specific place over time. Zoom in / zoom out and pinpoint a location where traffic exists.
  • Cross check the day and time of visits in different regions against contemporaneous events.
  • Is the increase in website traffic proportional to a local conference or sales announcement? Based on this insight, you can better expect when people will browse through your site, enabling you to add relevancy in terms of data to generate interest in your products or services.

track site usage

If you are using Google Analytics to track site usage and events occurring in your site and digital measurement, there is some great news for you.

Connecting Power BI with Google Analytics

Using Power BI Desktop, you can explore and visualize the Google Analytics content pack. By using Google Analytics along with Power BI, you can immediately connect and gain insights into your data and site usage in the last 6 months, allowing you to build custom reports.

  • In the top navigation pane, click Get Data.

Get Data

  • From the list of online services, select Google Analytics, and then click Connect.

Select Google Analytics

This connector uses the Google Analytics API, allowing you to access Google Analytics data after enabling Google Analytics for your site. On selecting it from the menu of sources, it will ask for your credentials and allow Power BI to access your account.

  • Read the information for connecting to a third-party service, and then click Continue.

connecting to a third-party service

  • Sign in to your Google Analytics account and pass your credentials in the next group of prompts.

 

Sign in Google analytics

  • Google Analytics approaches Power BI Desktop for permission to connect to your data. Hit Allow.

Power BI Desktop

  • Power BI Desktop shows that you’re signed into Google Analytics. Click Connect to load your Google Analytics data.

Load your Google Analytics data

  • Once you connect, you'll see a list of the accounts you have accessed to. Drill through the account, properties, and views to see a selection of values, categorized in display folders. Select the property and view inside the navigator that you want to connect to and click Load.

List of the accounts

As you select different values, Power BI will send a query back to the source to get results. The output will be a single flat table will all the values selected. Google Analytics has a limit on the number of items you can select together, so select the initial set and build as needed.

Additional operations, such as filtering on the data you selected, will also be sent to a query in Google Analytics. After loading the tables or switching to the Report view, you’ll be able to visualize and explore your data.

  • Power BI Desktop loads Google Analytics data. Now you can start creating your astounding dynamic reports.

Power BI Desktop loads Google Analytics data

 

  • Publish Power BI report to your Power BI account on the web.

Publish Power BI report

  • Choose a destination and then click Select.

Choose a destination

Note: If you already have the same dataset in Power BI, replace it with the updated dataset.

  • Select File and click Save As to download report from Power BI Desktop to your preferred location.

Download report from Power BI Desktop

Provide File Name as PowerBI+GA. The extension for files being exported using Power BI Desktop is .pbix.

 

Provide File Name

 

Embed report Power BI web part in SharePoint Online

SharePoint Online is a crucial part of the company’s communication strategy and introduction of Power BI there is a need for an hour. Using Power BI's new report web part for SharePoint Online, you can easily embed interactive Power BI reports in SharePoint Online modern pages infrastructure with no code required.

When utilizing the new Embed in SharePoint Online option, the embedded reports are completely secure, so you can easily create secure internal portals.

Requirements

For Embed in SharePoint Online reports to work, the below is the pre-requisites:

  • A Power BI Pro license or a Power BI Premium capacity (EM or P SKU) along with a Power BI license.
  • The Power BI web part for SharePoint Online needs Modern Pages.

Embed your report

To embed your report into SharePoint Online, you have to get the report URL and utilize it with SharePoint Online’s Power BI web part.

Get a report URL

  • Log in to Office 365 portal and open Power BI under the list of available apps.

open Power BI

  • Within the Power BI app in Office 365, view the report by importing .pbix file. From the left navigation pane, click Get Data.

Click Get Data

  • Click Get in the Files box.

Click Get in the Files box

  • Select Local File and open PowerBI+GA.pbix file created earlier.

open PowerBI+GA.pbix file

  • Choose the Embed in SharePoint Online from the File dropdown menu.

Embed in SharePoint Online

  • From the dialog, copy the report URL.

Copy the report URL

Add the Power BI report to a SharePoint Online page

  • Open the target modern page in SharePoint Online and select Edit.

Open the target modern page

  • Click the + icon button and then select the Power BI web part.

Power BI web part

  • Click the Add report.

Add report

 

  • Paste the copied report URL into the Power BI report link pane. The report loads automatically.

Power BI report link pane

  • Select Publish to roll out the change noticeable to your SharePoint Online users.

Publish to roll out the change

Note: 

  1. A Power BI Pro license is must require for publishers of the Power BI report. On the off chance that the report is not deployed on a Power BI Premium Capacity, the report viewers need a Power BI Pro license. If they don’t have that license then they need to sign-up for Power BI or begin a 60-day free trial of Power BI.
  2. Embedding a report in SharePoint Online does not consequently give users permission to view the report, regardless of whether the users have permission to view the page. The authorizations to view the report are set within the Power BI service. So, the user must have access to both the SharePoint Online site as well as the Power BI report to view the report on the page.
  3. The Power BI (preview) web part for SharePoint Online does not yet supplement screen readers or keyboard navigation.

Multi-factor authentication

In the event that your Power BI environment expects you to sign in using multi-factor authentication, you might be asked to sign in with a security device to confirm your identity. This happens if you did not sign in to SharePoint Online utilizing multi-factor authentication, however your Power BI environment requires a security device to validate an account.

Note: Users will see an error message as Power BI does not yet support multi-factor authentication with Azure Active Directory 2.0. On the off chance that the user signs in again to SharePoint Online using their security device, they might almost certainly view the report.

Web part settings

Below are the properties you can adjust in Power BI web part for SharePoint Online.

Web part settings

Property Description
Power BI report link You can display reports from Power BI by adding the link here.
Page name This property sets the web part’s default page. From the drop-down, choose a value. If no page is displayed then either your report has one page or the URL you pasted contains a page name. Expel the report section from the URL to select a specific page.
Display This web part property tunes how the report fits within the SharePoint Online page.
Show Navigation Pane The page navigation pane is displayed or hidden through this web part property.
Show Filter Pane The filter pane is displayed or hidden through this web part property.

Report that do not load

There are two common reasons your report does not load in SharePoint Online Power BI web part:

  1. You do not have access to the report in Power BI.
  2. The report was removed/deleted.

You should contact the SharePoint Online page owner to assist in resolving the issue.

Conclusion

Power BI makes it easy for anyone to connect to huge amounts of structured and unstructured data from numerous sources. The Power BI tool manipulates the data, which is imported from Google Analytics, by representing it in visual and analytics manner with regards to multiple different factors. One can easily and effectively share the data in this format with his/her associates. If one has more sources of data and has a correct tool to analyze and envision them then one can extract the significant bits of knowledge.

Crunch the numbers!!! Add Google Analytics to Power BI and watch the insights in a more detail way with the Power Analytics.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

About Tatvasoft

TatvaSoft is a CMMi Level 3 and Microsoft Gold Certified Software Development Company offering custom software development services on diverse technology platforms, like Microsoft, SharePoint, Biztalk, Java, PHP, Open Source, BI, Big Data and Mobile.

Follow Us