Welcome to ONLC Training Centers


Qlik Sense Advanced Course Outline

 (2 days)
Version 3

Special Note to New Hampshire Residents
This course has not yet been approved by the State's Department of Education. Please contact us to get an update as to when the class should be available in New Hampshire.

Overview
This class is an excellent course for all aspiring Qlik Sense® developers. It will take you through the basics, right through to the use of more advanced functions.

Starting with a quick refresher on obtaining data from data files and databases, this class moves on to the more refined features of Qlik Sense®, including visualization, scripting, and set analysis. The tips and tricks provided will help you to overcome challenging situations while developing your applications in Qlik Sense®. This and more will help you to deliver engaging dashboards and reports efficiently.

Prerequisites
Before attending this course, students should have attending the Qlik Sense Introdution class or have equivalent experience.

Course Outline

Unit 1: Getting Started with the Data
Extracting data from databases and data files
Extracting data from Web Files
Invoking help while in the data load editor or the expression editor
Previewing data in the Data model viewer
Creating a Master Library from the Data model viewer
Using a Master Library in the Edit mode

Unit 2: Visualizations
Highlighting the performance measure in a bar chart
Associating persistent colors to field values
Using the ColorMix1 function
Composition
Relationships
Comparison
Distribution
Structuring visualizations

Unit 3: Scripting
Structuring the script
Efficiently debugging the script
Packaging the code in script files
Optimizing the UI calculation speed
Using a For Each loop to load data from multiple files
Using the Concat() function to store multiple field values in a single cell

Unit 4: Managing Apps and User Interface
Publishing a Qlik Sense® application created in Qlik Sense® desktop
Creating geo maps in Qlik Sense®
Reference lines in Sales versus Target gauge chart
Effectively using the KPI object in Qlik Sense®
Adding Reference Lines to trendline charts
Creating text and images

Unit 5: Useful Functions
Using the Previous() function to identify the latest record for a dimensional value
Using the NetworkDays() function to calculate the working days in a calendar month
Using the Concat() function to display a string of field values as a dimension
Using the Rangesum() function to plot cumulative figures in trendline charts
Using the Declare and Derive functions to generate Calendar fields
Using the For Each loop to extract files from a folder

Unit 6: Set Analysis
Cracking the syntax for Set Analysis
Using flags in Set Analysis
Using the = sign with variables in Set Analysis
Using comparison sets in Set Analysis
Using search strings inside a set modifier

Unit 7: Extensions in Qlik Sense®
Creating an HTML visualization extension for Qlik Sense®
Defining a Properties panel in Qlik Sense® visualizations
Creating custom components within Qlik Sense® visualizations

Unit 8: What's New
Defining variables in Qlik Sense®
Exporting stories to MS PowerPoint
Using Qlik Dev Hub to generate mashups
Embedding Qlik Sense® application on a website using a single configurator
Creating dynamic charts in Qlik Sense®

View outline in Word

XQSM30

Attend hands-on, instructor-led Qlik Sense Advanced training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $995

Savings options:

 15 Day Pass
 CEA Tech Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com