Using the Webtrends SharePoint Analytics Dashboard via PBIX
  • 08 Jul 2021
  • 2 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Using the Webtrends SharePoint Analytics Dashboard via PBIX

  • Dark
    Light
  • PDF

What is a PBIX?

A PBIX file is the default file storage format used by Power BI Desktop. In essence, it's a compressed file containing layout information, data, and connection information.

Using the File

Sample Data

When downloaded, the PBIX is populated with sample data. To replace the sample data, you will need to edit the parameters.

Parameters

Parameters can be edited by clicking on Transform Data > Edit Parameters in the ribbon menu at the top of the screen.

image.png

A new modal will be presented that allows you to edit the Profile ID, Start Date, and End Date.

image.png

Once the parameters are edited, refresh the data.

Refreshing Data

Every time a parameter is changed, a refresh of the data is necessisary. To refresh the data, click on the Refresh option in the ribbon menu at the top of the screen.

image.png

If you have not accessed the data before, you'll be prompted to authenticate your access. Enter in your account name\username in the username field and your password in the password field.

image.png

As the data is being refreshed, you'll see the following screen. When completed, it will go away and the data will update based on the parameter settings.

image.png

Usage

The Usage tab gives Session, Page View, Avg Session Duration, and Bounce rate key metrics. Clicking on the metric names at the top will filter the visuals below to show that metric. Also, the visual on the left can be filtered by Department, Job Title, and Office Location.

image.png

The Search tab gives information on On-Site Searches. Clicking on the metric names at the top will filter the visuals below to show that metric.

image.png

Technology

The Technology tab gives information on the device types and browsers used to access your site, as well as the frequency and time of use.

image.png

Clicking on one of the browser values, and then selecting drilldown will give you information on the version of the browser being used.

image.png

image.png

Sites/Content

The Sites/Content tab gives information on Page Views, Sessions, and Views Per Session by Site Name. It also gives information on Document Interactions, based on Downloads, Opens, Shares, etc. Web parts, measured by clicks round out the visuals.

image.png

Right clicking on a Site Name allows you to drill down into the pages viewed within that site.

image.png

The Site Pages tab shows the pages for the selected Site Name. It's not intended to be used outside this function.

image.png


Was this article helpful?