Using the Webtrends SharePoint Analytics Dashboard via PBIX

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.

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

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.

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.

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.

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.

Search

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.

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.

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

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.

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

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