Hands-On Business Intelligence with Qlik Sense

coverpage

Title Page

Copyright and Credits

Hands-On Business Intelligence with Qlik Sense

About Packt

Why subscribe?

Packt.com

Contributors

About the authors

About the reviewer

Packt is searching for authors like you

Preface

Who this book is for

What this book covers

To get the most out of this book

Download the example code files

Download the color images

Conventions used

Get in touch

Reviews

Section 1: Qlik Sense and Business Intelligence

Getting Started with Qlik Sense

An overview of the Qlik Sense product

The components of Qlik Sense

In-memory associative database

ETL engine

Data manager

Script

Data model

Visualization platform

The hub

Application overview

Sheets

Objects

API and extensibility capabilities

The Associative Engine

Setting up Qlik Sense Desktop

Setting up Qlik Sense Cloud

Self-service with Qlik Sense

Summary

Section 2: Data Loading and Modeling

Loading Data in Qlik Sense

Technical requirements

Data loading process

Loading data from data sources

Data connections

Data manager

Dragging a data file into your application

Loading a data file from a folder (Qlik Sense Desktop)

Loading a data file from data files (QlikCloud)

Creating calculated fields

Data load editor

Table associations

Data profiling

Profiling using the Data manager

Profiling using the Data model viewer

Summary

Further reading

Implementing Data Modeling Techniques

Technical requirements

An overview of data modeling

Data modeling techniques

Entity relationship modeling

Dimensional modeling

Joining

Types of joins

Join/outer join

Left join

Right join

Inner join

Pitfalls of using joins

Concatenation

Automatic concatenation

Forced concatenation

The NoConcatenate

Filtering

Filtering data using the Data manager

Filtering data in the script editor

QVDs

Why use QVDs?

Link table

Canonical dates

As-Of Table

Script optimization

Using Applymap instead of joins

Applymap()

Reducing the size of data as much as possible

Optimized QVD load

Non-optimized load

Optimized load

Dropping unwanted tables immediately after use

Summary

Sample questions

Further reading

Section 3: Building an Analytical Application

Working with Application Structure

Technical requirements

Application overview

Toolbars

Understanding the DAR methodology