EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

The Ultimate Qlik Sense Course

Course outline

2 days
Discuss this programme →

Duration

The Ultimate Qlik Sense Course

2 days

What you'll learn

  • How to become a Qlik Sense designer
  • How to load data in Qlik Sense
  • How to create and upload apps in Qlik Sense
  • All about the different charts and graphs available in Qlik Sense
  • How to create your analysis in the Story Telling tab
  • About numeric and string functions in Qlik Sense
  • How to use Conditional Functions
  • How to use the Qlik Sense Geo Analytics tools (maps)
  • Use system and user-defined variables effectively
  • Use a variable’s input to create dynamic dimensions and measures
  • Maximize the dynamic loading feature to import data from diverse sources in numerous ways
  • Write powerful and elegant scripts and subroutines
  • Make the most of Qlik Sense’s conditional functions, including Match and Pick and to work with the values the functions return
  • Use the Alternate States feature to create and compare visualizations
  • Use Cascading Style Sheets (CSS) to design highly customized visualizations and dashboards
  • Use geo-analytics and spatial functions to work with location-based data
  • Layer components with functions such as the Bubble, Line, Area, Heatmap, and Geodata Layers
  • Transform data with Qlik’s toolbox of analytical functions to perform geometric, aggregating, route-based, and look-up operations.

Course Content

Introduction and ETL

  • Introduction to Connecting Data from Web Sources
  • Connecting data using Web Connectors - Google Drive
  • Qlik Sense Workflow
  • ETL Layer - Extract
  • ETL Layer - Transform
  • ETL Layer - Model
  • Application Layer - Dashboard
  • Concatenate Clause
  • Concatenate and Noconcatenate
  • Join Clause
  • Left Joins
  • Right Joins
  • Outer Join
  • Fiscal Calendar
  • Dashboard Design
  • Set Analysis
  • Color Code
  • Master Items
  • Master Items - Dimension
  • Master Items - Measure
  • Master Items - Visualization
  • MTD and YTD Buttons
  • Introduction to Variables
  • Uses of Variables
  • Dynamic Loading
  • Script Files & Sub-routines

Advanced Functions and Tables

  • Advanced Script Functions
  • Cross Table
  • Group By
  • Order By
  • YTD Fact Table
  • Master Calendar
  • Fiscal Calendar
  • Link Table
  • Star Schema
  • 100% Chart
  • Aggr
  • Rank
  • Toggle
  • Pagination

Step Up Your Visualization

  • Alternate States
  • Customizing Dashboards with CSS
  • Using Geoanalytics for Spatial Data

Programme scope, delivery arrangements and suitability are confirmed during enquiry.