SysTrack collects over 10,000 pieces of data every 15 seconds. However, that much data can be overwhelming when you need to produce a report. Learn how to download and configure the SysTrack Power BI Connector so you can then use Microsoft Power BI to showcase SysTrack data in the best way possible.
NOTE: This course assumes that you know how to use Power BI and have access to your SysTrack cloud tenant. If you have an on-premises SysTrack installation, you do not need the SysTrack Power BI Connector as you will use the SQL database connector.
This course does not provide instruction on using Power BI Desktop or for connecting Power BI to a SQL database.
There is no certification exam for this course. You will receive a Certificate of Completion at the conclusion.
Sign in as a SysTrack customer to start this course.
Prerequisite
Power BI knowledge
SysTrack Administrator course (for information on using Configure)
Recommended (to practice the topics covered in this course):
Power BI Desktop
Access to your SysTrack cloud tenant
Course Objective
Learn how to download and configure the SysTrack Power BI Connector so you can then create Power BI reports that include SysTrack data.
Course Outline
Introduction
Course Overview
Microsoft Power BI
Setting It Up
Configuring the Power BI Connector
Importing the Kit
Using an automation to install the certificate
Download and copy PQX file
Testing the connection
SysTrack tools used:
Kits
Configure: Automations and Collection Extensions
Configure: Administration > Read Configuration
Resolve: Tools > Run Automations
Admin Panel: Tenant Information
Templates and Reports
Power BI Connector Datasets
Adding Lakeside datasets
Creating Templates and Reports
Tags: Configure, Power BI, Reporting