Business Intelligence Solutions With Qlik Sense

Learn Qlik Sense data visualization and analyze data easily and make faster business decisions

What you'll learn

Develop an intuitive and informative dashboard with the appropriate depth of interactivity using Qlik Sense.

Display data in maps, charts, and text across multiple sheets.

Apply set analysis to your data in Qlik Sense expressions.

Add security in your Qlik Sense applications for better data protection.

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.

Requirements

A basic understanding of BI concepts is all you need to get started with this course.

Description

Qlik Sense is business intelligence (BI) and visual analytics platform that supports a range of use cases all within a scalable, governed framework. It not only allows you to create interactive reports and dashboards with stunning charts and graphs but also prepares you to be an expert in your organization when it comes to designing BI solutions using Qlik Sense.This course takes a practical and incremental approach. It helps you master all the advanced Business Intelligence capabilities of Qlik Sense to debug common issues and optimize your data model. It will first teach you how to connect your Data with Qlik Sense & create your own Qlik Sense app. Then you'll learn to build your own dashboard by adding different functionalities, perform analyses, and secure your data in Qlik Sense. Moving further you be learning to create a data model to achieve optimized performance, including how to load data from different data sources & much more. Finally, you will be mastering 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.Contents and OverviewThis training program includes 2 complete courses, carefully chosen to give you the most comprehensive training possible.The first course, Learn Qlik Sense Dashboard Development starts by connecting your Data with Qlik Sense and will create your own Qlik Sense app. You will see how to add data from popular spreadsheet applications MS Excel and work with Qlik Sense components such as charts, list boxes, input boxes, and Text objects. You'll build your own dashboard by adding different functionalities, perform analyses, and secure your data in Qlik Sense. By the end of the course, you will able to analyze data and make business decisions faster.The second course, Mastering Qlik Sense 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.About the Authors:Abhishek Agarwal has 12+ years of experience in developing analytical solutions. He is a seasoned BI professional with expertise in multiple technologies. He has been teaching BI technologies for the past 5+ years and has worked in a similar domain. He uses QlikView, Power BI, Tableau, and a couple of other technologies for end-to-end analytical solution development in his current work.Colibri is a technology consultancy company founded in 2015 by James Cross and Ingrid Funie. The company works to help its clients navigate the rapidly changing and complex world of emerging technologies, with deep expertise in areas such as Big Data, Data Science, Machine Learning, and Cloud Computing. Over the past few years, they have worked with some of the world's largest and most prestigious companies, including a tier 1 investment bank, a leading management consultancy group, and one of the World's most popular soft drinks companies, helping each of them to better make sense of its data, and process it in more intelligent ways. The company lives by its motto: Data -> Intelligence -> Action.Diksha Bhosle is a versatile trainer from Colibri Digital. She has over 12 years' experience and has trained in a number of different technologies including Microsoft, CRM, Marketing Applications and of course Qlik Sense and Qlik View. Having worked with Qlik Technologies for a few years she has in-depth knowledge and understanding of both Qlik View and Qlik Sense. After a number of interactions with Various Qlik Sense customers, she has gained a deeper understanding of common issues faced by customers.

Overview

Section 1: Learn Qlik Sense Dashboard Development

Lecture 1 The Course Overview

Lecture 2 Cloud or offline Qlik Sense

Lecture 3 Overview of Qlik Sense Desktop

Lecture 4 App Demo

Lecture 5 Qlik Sense Architecture

Lecture 6 Creating an App

Lecture 7 Importing Data from Excel

Lecture 8 Understanding Fact and Dimensions

Lecture 9 Creating and Understanding Filters

Lecture 10 Creating new Sheets

Lecture 11 Types of Data Models

Lecture 12 Creating a Star Schema Model

Lecture 13 Viewing and Analyzing the Resulting Data Model

Lecture 14 Creating QVD Files

Lecture 15 Filter Properties

Lecture 16 Date Filters

Lecture 17 Qlik Sense Charts

Lecture 18 Master Items

Lecture 19 Bookmarks

Lecture 20 Adding KPIs

Lecture 21 Adding Charts

Lecture 22 Simple and Pivot Table

Lecture 23 Drill Down Dimension

Lecture 24 Text and Images

Lecture 25 Maps

Lecture 26 Basics of Set Analysis Expression

Lecture 27 Assignment Operators

Lecture 28 Set Operators

Lecture 29 Element Functions

Lecture 30 Qlik Sense Security Overview

Lecture 31 Understanding Various Types of Security

Lecture 32 Configuring Security

Lecture 33 Next Steps

Section 2: Mastering Qlik Sense

Lecture 34 The Course Overview

Lecture 35 What’s New in Qlik Sense?

Lecture 36 Understanding the Schemas

Lecture 37 Our Objective: The Data Model

Lecture 38 Introduction to Data Load Editor

Lecture 39 Loading Data in Qlik Sense

Lecture 40 What is Data Transformation?

Lecture 41 Loading Dimension Tables

Lecture 42 Synthetic Keys: Problems Arising from Them

Lecture 43 Synthetic Keys: Choosing a Solution That Works for You

Lecture 44 Synthetic Keys: Impact on Your Dashboard

Lecture 45 Loading Data: Database Example

Lecture 46 Loading Data from Other Data Files

Lecture 47 What Impact Does Circular Reference Have?

Lecture 48 Resolving Circular References

Lecture 49 Impact of the Circular References on the Dashboard

Lecture 50 Using the Where Clause to Filter Data

Lecture 51 Using Resident Load to Manipulate Data

Lecture 52 Using Where Exists for comparisons

Lecture 53 Adding Counters When Needed

Lecture 54 Mapping Load

Lecture 55 Preceding Load

Lecture 56 Introduction of Joins

Lecture 57 Using Joins

Lecture 58 Concatenation in Qlik Sense

Lecture 59 Auto- Concatenation in Qlik Sense

Lecture 60 Forced Concatenation in Qlik Sense

Lecture 61 Grouping Data Using Class Function

Lecture 62 How To Use the Class Function

Lecture 63 Link Tables in Qlik Sense

Lecture 64 Master Calendar

Lecture 65 Master Calendar MinMaxDate

Lecture 66 Master Calendar – Final Script

Lecture 67 Master Calendar – Dashboard Example

Lecture 68 Introduction To Set Analysis

Lecture 69 How Does Set Analysis Work

Lecture 70 Section Access

Lecture 71 Section Access Script

Lecture 72 Moving on From Here…

This course is for Business analysts, Business Intelligence professionals and Data Analysts or anyone who just wants to get started with Qlik Sense become experts in using Qlik Sense.