Power BI + Google Analytics = Power AnalyticsJul 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
- What Google Analytics and Power BI can do together
- Connecting Power BI with Google Analytics
- Embed report Power BI web part in SharePoint Online
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.
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.
- From the list of online services, select Google Analytics, and then click Connect.
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.
- Sign in to your Google Analytics account and pass your credentials in the next group of prompts.
- Google Analytics approaches Power BI Desktop for permission to connect to your data. Hit Allow.
- Power BI Desktop shows that you’re signed into Google Analytics. Click Connect to 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.
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.
- Publish Power BI report to your Power BI account on the web.
- Choose a destination and then click Select.
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.
Provide File Name as PowerBI+GA. The extension for files being exported using Power BI Desktop is .pbix.
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.
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.
- 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 in the Files box.
- Select Local File and open PowerBI+GA.pbix file created earlier.
- Choose the Embed in SharePoint Online from the File dropdown menu.
- From the dialog, 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.
- Click the + icon button and then select the Power BI web part.
- Click the Add report.
- Paste the copied report URL into the Power BI report link pane. The report loads automatically.
- Select Publish to roll out the change noticeable to your SharePoint Online users.
- 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.
- 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.
- The Power BI (preview) web part for SharePoint Online does not yet supplement screen readers or keyboard navigation.
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.
|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:
- You do not have access to the report in Power BI.
- The report was removed/deleted.
You should contact the SharePoint Online page owner to assist in resolving the issue.
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.
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.