Debug common issues and optimize your data model to achieve the best performance for your Qlik Sense app
About This Video
Get acquainted with the basic as well as advanced Business Intelligence capabilities of Qlik Sense
Develop Qlik Sense models (using data in various formats) that run on-premise as well as on the cloud
Administer your Qlik Sense applications for maximum performance and reliability
In Detail
You've probably done some beginner work on Qlik …
Mastering Qlik Sense
Video description
Debug common issues and optimize your data model to achieve the best performance for your Qlik Sense app
About This Video
Get acquainted with the basic as well as advanced Business Intelligence capabilities of Qlik Sense
Develop Qlik Sense models (using data in various formats) that run on-premise as well as on the cloud
Administer your Qlik Sense applications for maximum performance and reliability
In Detail
You've probably done some beginner work on Qlik Sense, so you know how easy it is to work with the interface. However, there is always more than what we see on the Qlik Sense dashboard. Work done by developers in the extremity plays a very important role while making an appealing and well-performing dashboard.
If your data model is not designed appropriately, you will face issues not only with the performance of the app but also with the quality of its output.
In this course, we look at everything that goes into creating a data model to give you the most optimized performance, including how to load data from different data sources, fix synthetic keys, and other issues. Also included are topics such as creating link tables, the master calendar script, and applying set analysis to your data. Thus, you will master the art of creating dashboards that are not only visually appealing and accurate but also very informative and a BIG bonus to your team while making those tough decisions.
Audience
This course is for Business Intelligence professionals and Data Analysts who want to become experts in using Qlik Sense. If you have extensively used QlikView in the past and are looking to transition to Qlik Sense, this course will also help you.
A fundamental idea of how Qlik Sense works, its architecture, and its features is all you need to get started with this course.
Chapter 3 : Synthetic Keys: Common Issues and Solutions
Loading Dimension Tables
Synthetic Keys: Problems Arising from Them
Synthetic Keys: Choosing a Solution That Works for You
Synthetic Keys: Impact on Your Dashboard
Chapter 4 : Debugging Common Issues around Circular References
Loading Data: Database Example
Loading Data from Other Data Files
What Impact Does Circular Reference Have?
Resolving Circular References
Impact of the Circular References on the Dashboard
Chapter 5 : Doing More with Your data
Using the Where Clause to Filter Data
Using Resident Load to Manipulate Data
Using Where Exists for comparisons
Adding Counters When Needed
Chapter 6 : Using Mapping Tables and Preceding Load
Mapping Load
Preceding Load
Chapter 7 : Optimizing Data Model with Joins
Introduction of Joins
Using Joins
Concatenation in Qlik Sense
Auto- Concatenation in Qlik Sense
Forced Concatenation in Qlik Sense
Chapter 8 : Class Function and Link Tables
Grouping Data Using Class Function
How To Use the Class Function
Link Tables in Qlik Sense
Chapter 9 : Making the Most of Master Calendar
Master Calendar
Master Calendar MinMaxDate
Master Calendar – Final Script
Master Calendar – Dashboard Example
Chapter 10 : Applying Set Analysis and Section Access
Introduction To Set Analysis
How Does Set Analysis Work
Section Access
Section Access Script
Moving on From Here…
Start your Free Trial Self paced Go to the Course We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.
This site uses cookies. By continuing to use this website, you agree to their use.I Accept