What is this course about?
This Course addresses the fundamentals required to enable you for self-service visualization and discovery. The course combines demonstrations and hands-on exercises to teach the essential and advanced concepts for designing beautiful and effective Qlik Sense visualizations and guided stories. This course includes many case studies that provides you with the opportunity to configure a library, build Qlik Sense visualizations, and create a guided story. At the end of this course you will be an independent and Expert Reporting Data Modeler and Qlik Data Architect.
What are the course objectives?
At end of this Qlik training you will be able to,
- Learn to create apps and Visualization using Qlik.
- Learn to write data load scripts.
- Work on Customer Specific Requirements
- Will be able to design Complex Data Models and Advanced Data Visualizations
- Learn to work and collaborate with Various Data Sources
Who should do this course?
This training will be suitable for,
- Fresh Graduates
- Job Seekers
- Visualization authors
- Business users
- Data architects and QlikView developers who want to know more about the self-service capabilities of Qlik Sense
Course Outline
Module 1 – Qlik Sense Introduction & Installation
- What is Qlik Sense?
- Comparing Qlik Sense Desktop with Qlik Sense
- Installing Qlik Sense Desktop
- How Qlik Sense varies from QlikView?
- Starting with Qlik Sense Desktop
- Opening an app with Qlik Sense
- Qlik Sense Architecture
Module 2 – Starting Qlik Sense
- Navigating in the user interface
- Data Manager
- Data Load Editor
- Data Model Viewer
- Interacting with the user interface
- Creating apps and Visualizations
- Structuring an app with Sheets
Module 3 – Designing Visualizations
- Different type of Visualizations
- Dimensions and Measures in a CHART
- When to use and What Chart to Use
- Selections in a Visualization
- Settings and Properties of each Visualization
Module 4 – Using Expressions in Visualization
- Expressions, Functions and Variables
- Working with Expression Editor
- Using Functions in Charts
- Using Variables in Expressions
- Set Analysis and Set Expressions
- Working with Master Items
Module 5 – Manage Data
- Adding data from files and databases
- Loading data with the data load script
- Data Connections
- Various types of Data loads
- Profile Data with Qlik Sense
- Troubleshooting
Module 6 – Creating a Data Model
- Qlik Sense Data Architecture
- Creating Star and Snowflake schemas
- Use of Joins, Keeps, Concatenate etc..
- Understanding QVD layer
- Working on synthetic keys and circular references.
Module 7 – Advanced Data Modelling
- Qlik Sense Star Schema
- Link Table
- Dimensions Table
- Master Calendar
- Optimizing data models
- Best Practices of Data Modelling
Module 8 – Collaborate in Qlik Sense
- Data Storytelling
- Publishing
- Exporting and Printing
- Advanced Scripting and Chart Functions
- Qlik Tips and Techniques
Module 9 – Qlik Sense Security
- Learning about Qlik Sense App and its security features
- Providing Qlik Sense access to user sets
- Qlik Sense Security rule code