Qlik Sense Certification – The Complete Practical Course

Develop Qlik Sense Apps , be ready to take QSDA/QSBA certification exams - all in one comprehensive hands on course.

Created by: Paul Scotchford
Data Analyst and Qlik Development Specialist @ awari

What Will I Learn?

• Begin with the Data Manager to load & shape data in our first app
• Understand associative model concepts
• Create sheets with charts, tables and KPIs
• Understand the 4 application tier types
• Alternate states for comparative analysis
• Star and Snowflake schema types
• How to build data models based on user requirements
• Load data from different data source types
• Understand Joins, IntervalMatch, Crosstable , FirstSortedOrder ,Rank
• Incremental loads with sub routines for flow control
• Slowly Changing Dimensions
• Validate the data using different techniques
• Create technical requirements and design sheet layout
• Using element (E) & (P) functions inside a set expression
• The power of canonical calendars and their use
• Geo Analytics with switchable metrics
• Master Items e.g. Measures, Dimensions & Visualisations
• Security e.g. Data Reduction
• Mashups and data story telling
• Migrate QlikView documents to Qlik Sense
• Code Set Expressions - Simple to complex including date range expressions
• Development using the D A R concept , common in enterprise solutions
• Explore the Qlik Sense visualisation bundle features
• Understand the theory behind the scenes to fully appreciate Qlik Sense , explained in vivid detail
• Code pre-aggregations and flags in your load script
• Write efficient data load scripts
• So much more is covered in this course beyond what is included in this list
• Practice with assignment exercises to refine your skills
• Answer the quizzes to be sure of your knowledge
• All recorded in HD 1080p with code zooming so you don't miss a thing

Requirements

• QlikSense is a Windows based architecture hence a Windows PC is required (or use a VM/Docker running windows on a Mac)
• Please note, some reading/information resources within the course use external links e.g. Qlik Sense Help content
• All software and data downloads are provided for this course
• Basic understanding of Excel and formula creation such as functions like Sum()
• Basic understanding of SQL concepts (Although you are guided through this in the data load scripts we code)
• Basic understanding of data (e.g. Data Types, Files, Database concepts)

Target audience

• If you want to learn Qlik Sense completely from scratch then you should take this course
• If you have some rudimentary Qlik Sense skills and want to develop them further then you should take this course
• Even if you are good with Qlik Sense and want to advance much further then you definitely should take this course
• If you are planning on sitting the QSDA/QSBA certification exams you should take this course to fill in the your knowledge gaps to pass the exams