Business Intelligence Solutions with Qlik Sense

This video gives a glimpse of the entire course.

Take a look at what’s new in Qlik Sense’s latest release and the Architecture and understand the role of all of the services on the Qlik Sense Server.

   •  Take a look at the new features in the latest release of Qlik Sense

   •  Go through it’s architecture

Quick glance of the 2 schemas – Snowflake and Star.

   •  Understand what Schema is

   •  Understand Star and Snowflake Schemas

Have a look at our objective

   •  Go through the topics we will be covering in the course

   •  Explore the data model we will create

Understand what the different components of the Data Load Editor in Qlik Sense are. While there may be a number of ways to load data into Qlik Sense, yet Data Load Editor is most preferred.

   •  Take a look at all different options on the Data Load Editor Window

   •  Look at where you find connectors to different data sources and how you might want to better organize your script

How to load a basic table into Qlik Sense?

   •  Connect to the Data folder that contains the excel file

   •  Generate the script and load data from excel

   •  Understand how to name tables in Qlik Sense

In this video, we will perform basic transformations in Qlik Sense, and see how can we rename columns or perform simple calculations.

   •  Make a change in the column name using the select data window or

   •  Change the name of a column in the script

   •  Perform a simple calculation in the script

What are the rules while loading data into Qlik Sense?

   •  Only one key column between 2 tables the name of the columns to be exactly the same?

   •  Connect to a data source is the first step towards loading data, a simple example of this is covered here, another in section 4

   •  Load the data available with your connection, in this example we see loading excel and csv, more data file types in section 4

What is the problem with the synthetic keys and possible solutions?

   •  Learn how is a synthetic key formed

   •  Understand why do we want to fix synthetic keys, so issues around them

   •  Fix these

Which one can we use to fix the synthetic key in our data model?

   •  Rename and transform 2 columns into one in one of the tables to eradicate the synthetic key

What is the impact of the synthetic key on our dashboard?

   •  Check the results of a formula that uses the columns from the synthetic table

   •  Look at both scenarios with and without the Synthetic table in our data model

We will see what could be the prerequisites to load data into Qlik Sense.

   •  Set up data sources on your machine

   •  Connect to the database using the right connector

   •  Load data

Just as we load different data types let’s try one example of the XML data.

   •  Connect to my XML data folder

   •  Load the XML  table

What problems arise with circular references?

   •  Have a look at the impact of the circular references on our data model

Fixing our messed up data model.

   •  Try to use a simple solution to fix our data model

We will see what could be the reasons and impact of Circular References

   •  Understand Circular References

   •  Understand its impact on the dashboard

We don’t always need to load a complete table, in some cases partial data is good enough.

   •  Learn how do we load data based on criteria

   •  Understand Where clause

Loading data from a table that's already present in our data model can be challenging in databases, however in Qlik Sense , Resident Load makes it a piece of cake.

   •  Use resident load

Resident load works find with Where however if we need to load data by comparing values in 2 table Where exists is what we need.

   •  Understand where exists

   •  Learn how to use it in our script

In our data model, calculations can be done by designers on the dashboard, but as a developer there are some changes that you can make to be able to help calculate certain values.

   •  Learn how to add a counter /variable that can be used by the designer

   •  Go through a simple example on the dashboard on using the counters

Understanding how Mapping load can make life so much easier when loading tables and there isn’t a need for joins here.

   •  Go through the rules for using mapping loads

Preceding load: What is it?

   •  Understand the concept of the preceding load

   •  Use preceding load in our example

Understand what are all different types of Joins?

   •  Understand Joins and diagrams

   •  Learn how the joins work

Make sure to choose the right tables to join. Joining very large tables will have an adverse impact.

   •  Go through the joins syntax and example in the script

What is Concatenation? Types of Concatenation and understanding how they work.

   •  Go through the details of auto and forced concatenation

While you have seen the definition of the auto-concatenate, here we look at how this actually works.

   •  Go through the definition

   •  Go through an example

Look at how to force tables to concatenate and see that there are null values in the data model.

   •  Go through the definition

   •  Go through an example

We will see what is Class Function

   •  Take a look at the use and syntax of class function

As we try to understand Class Function , this quick example gives us a glimpse of what we can get in terms of output

   •  to create a quick example of the Class function output and a way to fix the result to look more presentable

Understand  link tables

   •  Take a look at the very tough concept of Link tables with a very easy example, this is just a scenario based example every user may face different situations and this cannot be generalized

Introduction and understanding the need of the master calendar.

   •  Understand the Key concepts and requirements related to master calendar

We start with our dates and pull out the latest and oldest date from out data

   •  Then we need to generate a table starting with the oldest date and generating consecutive dates all the way through to the latest date.

   •  Go through the script used

Using the new table to generate additional fields for analysis.

   •  Take a look at the script being used to generate fields also take a look at the help page for all possible date and time functions

Here, we will again the use of the master calendar on the dashboard, for analysis.

• Go through a simple chart example for time analysis

This video is an introduction to Set Analysis

• Understand what Set Analysis is

This video will show you how Set Analysis works

• Understand Set Analysis through an example

Here, we will take a look at Section Access

• Understand what section Access is

This video will help you understand the script for Section Access

• Understand Section Access

• Go through an example

The journey ahead

• Go through the next steps

• Go through the reference links