SysTrack Dashboard Designer

This course is an advanced course, intended for those who will be designing custom SysTrack Dashboards.

Sign in  as a SysTrack customer to start this course.

Prerequisite

You must register for and complete the SQL Knowledge prerequisite quiz before you can begin this course.

Course Objectives

This course covers:

  • The most commonly used Dashboard objects and concepts.
  • Basic SQL concepts; these units are not required and can be skipped if you are already familiar with SQL.
  • Using SQL to access the mostcommonly used data tables.

To complete this course, you will need access to your SysTrack environment and have the required permissions to use SysTrack Dashboard Builder. Please contact your SysTrack Administrator if you do not have this access.

Course Content

The "Introduction to SQL for SysTrack Dashboards" unit introduces some basic SQL. If you have experience writing SQL queries, feel free to skip it by moving the slider to the end of the video. The "SQL Examples for SysTrack Dashboards" unit is also optional if you have SQL experience, but it does cover some SysTrack-specific information.

The "QUIZ: SQL for SysTrack Dashboards" is a short, 5-question quiz on basic SQL concepts. It is required for everyone, but those with SQL experience should be able to complete it quickly.

The "Accessing Commonly Used SysTrack Data" unit is not required for those with SQL experience, but is highly recommended as it highlights the SysTrack tables that contain the most commonly used information.

There are two required Show Your Work assignments in which you will be given specifications for a SysTrack Dashboard to create on your own, using your SysTrack installation. You will then export the dashboard and submit it for review. Please note that only the Dashboard layout and properties will be exported; none of your data will be included. There is also an optional Extra Credit assignment available to challenge you.

Upon completion of the course, you will receive a certificate of completion which you can download. You will also receive an email with a link to an e-badge which you can display in your email signature, professional profile, or other ways of recognition.

If you have any questions, please contact education@lakesidesoftware.com.

Tags: Dashboard Builder, Reporting