CardioLog Software as a Service (SaaS) allows you to gain all the benefits of CardioLog Analytics usage reports for your SharePoint website without having to own and maintain servers or extra equipment. With all of your usage report data in the cloud, you can also now use Microsoft Power BI to visualize and understand information about your website and your users.
Power BI allows users to visualize and analyze their data using customizable templates in their browser. In order to integrate your CardioLog usage report data with Power BI, first you will need to make sure you have the web app configured. Additionally, your company or organization will have to pre-configure integration with CardioLog. For more information, see MS Power BI support. If your company already uses Power BI for other uses, CardioLog data can easily integrate into your workflow.
While CardioLog SaaS collects all the same data as our standard on-premise edition, Power BI gives you a different set of tools to visualize that data. Some important differences include live filters directly accessible from within reports that allow you to quickly compare multiple time periods and Microsoft's intelligent question based filters. You can also combine datasets from different sources. For example, you can view site usage data collected by CardioLog alongside usage data from a mobile app, or company sales reports.
In order to use CardioLog Analytics SaaS, you will need at least one user account with Power BI Pro or Power BI Premium Per User (PPU) license.
A Power BI Pro or Power BI Premium Per User (PPU) license is required for any end user who would like to share reports and collaborate on reports.
End users who would like to consume reports, do not need a Power BI Pro or Power BI Premium Per User (PPU) license. You can export the data for them (to PDF, CSV, Excel, Power Point) or embed reports within SharePoint.
Configuring CardioLog SaaS
CardioLog has a simple configuration wizard for CardioLog SaaS that allows you to choose which of your sites you would like to track, which attributes to report on, the tracking code you'll need to add to your sites, and how to integrate with Power BI.
Once configured, there are three main components within Power BI: Datasets, Reports and Dashboards.
- Datasets - Imported or connected data from an external source. For our purposes, this is your CardioLog usage report data.
- Reports - A collection of different data visualizations all sourced from the same Dataset. Reports can be created manually or or automatically simply by selecting the data you would like to have presented. A single report may appear in multiple Dashboards.
- Dashboards - A manually created presentation of data that may be sourced from multiple Datasets.
View CardioLog SaaS Reports
CardioLog Analytics SaaS includes many helpful reports that are included in your imported organizational data.
To view reports, sign in to Power BI Web Interface with your Power BI Pro or Power BI Premium Per User (PPU) account credentials, go to Workspaces > CardioLog Analytics > Reports > click on CardioLog Analytics SaaS.
Create and Edit Reports
There are several different ways to create a new report in Power BI.
- The simplest way to begin is selecting the Dataset you would like to work with from the navigation menu on the left side of the page. This will present you with a blank report canvas.
- From the Visualizations menu on the right side of the page, you may begin by clicking the type of graph visualization you would like to add. You can change the type of graph at any time to best suit the data would like to present.
- From the Fields menu on the right side of the page, you can begin typing to quickly find the data and filters you would like to report. Use multiple filters to fine tune your presentation. For example you may select Average Page Views per Session, Month, and User Category to find out which departments have been using your portal in depth recently.
- From the File menu above your report canvas, click Save to save any changes or updates to your report. Attempting to move to another section of Power BI before saving will also prompt you with an option to save your changes.
You can find more information here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-create-a-new-report/
You can learn more about reports in general here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-reports/
Note: A user account with Power BI Pro or Power BI Premium Per User (PPU) license is required in order to create and edit reports.
Create and Edit Dashboards
Once you've accessed the CardioLog Analytics workspace in Power BI, you will be interacting with your report in Reading View. This mode provides a simple and powerful way to view all aspects of the data in your report. In most cases simply hovering or clicking on a graph or data point will isolate the information and automatically visually cross-highlight the rest of your report page. To learn more about Reading View, click here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-interact-with-a-report-in-reading-view/
CardioLog Saas comes with a wide array of Dashboard templates out of the box. If you'd like to customize these or create your own, without affecting your team's data, create a personal copy to work on - Workspaces > CardioLog Analytics > Reports > click on CardioLog Analytics SaaS > File > Save as.
To better understand how to use Power BI dashboards in general, you can learn more here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-dashboards/
Note: A Power BI Pro or Power BI Premium Per User (PPU) license is required in order to create and edit dashboards.
Filter, Highlight and Drill Down in Reports
All reports can be easily filtered, and Power BI contains several levels of filtering options.
- Page Filters - Apply to all visual graphs and meters on the current page
- Visual Filters - Apply to an individual visual data widget
- Report Filters - Apply to all pages of a single report
Similarly, there are three types of filters that can be applied to different aspects of your data.
- Text Fields - Apply to pre-defined fields such as campaigns, departments, usernames, etc.
- Numeric Fields - Apply to data values such as number of visitors, page views, posts, etc.
- Date and Time - Apply time based filters to your data from as specific as fractions of a second, to as broad as years, depending on the report and data available.
- Portal Tree Hierarchy - Apply page hierarchy filters to your data based on a page level within your portal, and its related child pages.
In addition to filters, you may also highlight information. This will not remove unrelated information but will focus on a specific set of data, and dim other data. While in Reading View, you may use multiple filters and highlights across your data sets. Selecting more than one filter will apply both filters to your data. For example, if you would like to filter a Portal Growth report by department and time range, and filter using fields labeled "Marketing" and " D2016," then you will see all Portal Growth and activity from the Marketing team during the year 2016.
You can easily drill down in a visualization in Power BI as detailed here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/#method-1-for-drill-down
Portal Tree Hierarchy
The easiest way to scope any report to a specific site collection (or a specific subsite , library, list, etc) is to add the Hierarchy Slicer visual to the report:
- Make sure you are working on a copy of the report (and not the original), then click on Edit report from the top menu:
- Open the Visualizations menu on the right, and select the Hierarchy Slicer visual:
- In the Fields menu, expand SharePoint Tree and drag SP Tree Hierarchy into the visual's Fields:
This will add a visual representation of the portal structure that you can use as slicer. To filter the report, expand the tree to find the part of the portal you are interested in, and mark the box next to it. That will automatically filter all the visuals in the report to reflect on that particular part of the portal.
The easiest way to scope any report to a specific tree item (URL) is to add the Slicer visual to the report:
- Make sure you are working on a copy of the report (and not the original), then click on Edit report from the top menu:
- Open the Visualizations menu on the right, and select the Slicer visual:
- Select the Tree Url column and then search for the URL:
Exclude Single Page Visits to the Homepage
In order to exclude single page visits to the homepage, add the Home Page Exclude Bounces filter to the report:
- Make sure you are working on a copy of the report (and not the original), then click on Edit from the top menu:
- In the Fields menu, search for the Home Page Exclude Bounces field and drag it into the Filters section:
- By default, the report includes data for all visits the homepage, including single page visits in which the user opens the homepage and then leaves to a different website or closes the browser.
In order to exclude this data, uncheck the homepage URL:
Ask Your Data Questions
Power BI integrates robust search features that allow you to ask natural language questions that it will interpret and use to actively filter and sort your data. Upon entering any text in the Question field at the top of your report, Power BI will immediately begin offering common suggestions. You may either select a sample question, or continue typing to complete your question phrase. If a dedicated widget does not already exist for the metric you are searching for, Power BI will automatically create a new report widget based on your question terms.
For more information about how Power BI interprets commonly used words, see: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-q-and-a-tips/
In order to help your team use the feature thoroughly, you can also add keywords to labels, headings and titles. For tips on optimizing your reports see: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-make-your-data-work-well-with-q-and-a/
How to Share Your Data
You can share your data, reports and dashboards, with users who have the Power BI Pro or Power BI Premium Per User (PPU) license by sharing the CardioLog Analytics app workspace with them.
Learn how to share your dashboards here: https://docs.microsoft.com/en-us/power-bi/service-share-dashboards
End users who need to consume reports data, do not need a Power BI Pro or Power BI Premium Per User (PPU) license. You can export the data for them (to PDF, CSV, Excel, Power Point, web link).
Embedding a report into SharePoint
Using this option allows you to embed the fully interactive reports into any page in SharePoint.
Site owners will go the SharePoint page and use the report to get information about the site (or sites) they are interested in.
Advantages: This option is best if you would like to allow users to stay in the context of SharePoint and not have to leave to a different application.
1. From the CardioLog report, click on File and choose Publish to Web or Embed in SharePoint Online
2. When choosing publish to web, copy to html code and embed it into a SharePoint page.
3. When choosing Embed in SharePoint Online, to go a modern SharePoint page, add a Power BI web part and choose your report.
Note: Only the user with Power BI Pro or Power BI Premium Per User (PPU) license who owns the CardioLog Analytics app workspace can embed the report.
View reports from SharePoint Site Actions menu
You can view usage reports from within your SharePoint website by using the SharePoint Site Actions menu.
- In the Site Actions menu gear on the desired SharePoint page, click Site Statistics to run a usage report for the site you are visiting.
- A Power BI report will be displayed in a new browser tab or window depending on your browser's preferences.
Note: In order to use this feature, contact your CardioLog system administrator.
How to Export your Data
- Use the export data option to export any visual (widget) to Excel
- Use the print option to print a dashboard, a report page, or a report visual, to export it to PDF (by setting a virtual printer such as the Microsoft Print to PDF).
- Use the share option to email a dashboard or a report page to your colleagues (they will get a link to the interactive report). You can also share filtered reports with your colleagues.
- Use the subscribe option to send a dashboard or a report page via Email (note that this option is currently not available for customers using SSAS).
- Use the embed to SharePoint Online option to embed interactive reports to SharePoint Online using office 365 single-sign-on.
- Use the publish to web option to embed interactive reports to any website or create a public link to the report (no need to sign-in to view the report)
- Use the export to Power Point to create a slide deck based on your report.
- Use the analyze in Excel option to export the full dataset to an .odc file and use it in other applications (an Excel file which works a pivot table and holds a connection to the data source - so whenever the data refreshes the Excel file will refresh as well).
- Use the download option to export the full report to a .pbix file and use it in Power BI Desktop.
Conceal Personal Identifiable Information (PII)
One of CardioLog's core capabilities is the ability to track authenticated users. Since some organizations and locations have strict privacy laws, CardioLog Analytics SaaS includes a feature that conceals personal data so you can benefit from rich report details and advanced filtering options while still abiding by local laws.
The Personal Identifiable Information (PII) Concealment feature is designed to protect user information and disable its appearance in the reports. The database will not store any personal user information. Instead, CardioLog Analytics SaaS generates unique IDs for each user using a hashing algorithm. Hashing algorithms are designed so that it's impossible to turn a hash back into its original value and correlate the concealed identity back to the user.
CardioLog Analytics SaaS reports with PII Concealment feature enabled
When PII concealment is enabled, the following data is concealed by default in CardioLog Analytics SaaS:
- User account name (UPN), display name and email address
- SharePoint group names
- SharePoint user profile attribute values (configurable, you can select which attributes to conceal and which ones not to conceal in the CardioLog Analytics SaaS configuration page).
Hence, it is not possible to filter reports by specific users, groups and/or concealed user profile attributes when PII concealment is enabled.