MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

February 28, 2019 | ISBN: 9781789534528 | English

Duration: 39 Lessons (3h 43m) | Size: 810 MB

Debug common issues and optimize your data model to achieve the best performance for your Qlik Sense app

Learn

Dive into schemas in data modeling and Qlik Sense preferences when creating dashboards with accelerated performance

Load data from different data sources and know about the various connectors available within Qlik Sense

Fix real-world issues you face, such as synthetic keys while loading your data

Modify data in existing tables to obtain values required for your dashboard design as per business requirements

Transform data to generate new columns and achieve desired outcomes on the dashboard

Understand the use and benefits of including Preceding Load and Mapping Load in your data model

Take a look at the different types of join and use them to optimize data models

Realize the significance of Link Tables and how to create them so you can get better insights

Master the Calendar script and modifications that we can make to obtain fields for timeline analysis

About

ou'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.

The scripts for this course are available on Github at -

Style and Approach

This course is packed full of hands-on examples. You'll go through and understand concepts in a step-by-step manner, and explore their explanation to understand why and how things work while looking at the hands-on examples to try to understand the concepts further. This course has various in-depth sections that provide you with the skills needed to create a data model for a great app in Qlik Sense.

Features

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