Book Image

Hands-On Business Intelligence with Qlik Sense

By : Pablo Labbe, Clever Anjos, Kaushik Solanki, Jerry DiMaso

Book Image

Hands-On Business Intelligence with Qlik Sense

By: Pablo Labbe, Clever Anjos, Kaushik Solanki, Jerry DiMaso

Overview of this book

Qlik Sense allows you to explore simple-to-complex data to reveal hidden insights and data relationships to make business-driven decisions. Hands-On Business Intelligence with Qlik Sense begins by helping you get to grips with underlying Qlik concepts and gives you an overview of all Qlik Sense’s features. You will learn advanced modeling techniques and learn how to analyze the data loaded using a variety of visualization objects. You’ll also be trained on how to share apps through Qlik Sense Enterprise and Qlik Sense Cloud and how to perform aggregation with AGGR. As you progress through the chapters, you’ll explore the stories feature to create data-driven presentations and update an existing story. This book will guide you through the GeoAnalytics feature with the geo-mapping object and GeoAnalytics connector. Furthermore, you’ll learn about the self-service analytics features and perform data forecasting using advanced analytics. Lastly, you’ll deploy Qlik Sense apps for mobile and tablet. By the end of this book, you will be well-equipped to run successful business intelligence applications using Qlik Sense's functionality, data modeling techniques, and visualization best practices.

Preface

Who this book is for

What this book covers

To get the most out of this book

Free Chapter

Section 1: Qlik Sense and Business Intelligence

Section 1: Qlik Sense and Business Intelligence

Getting Started with Qlik Sense

Getting Started with Qlik Sense

An overview of the Qlik Sense product

Section 2: Data Loading and Modeling

Section 2: Data Loading and Modeling

Loading Data in Qlik Sense

Loading Data in Qlik Sense

Technical requirements

Data loading process

Table associations

Further reading

Implementing Data Modeling Techniques

Implementing Data Modeling Techniques

Technical requirements

An overview of data modeling

Canonical dates

Script optimization

Sample questions

Further reading

Section 3: Building an Analytical Application

Section 3: Building an Analytical Application

Working with Application Structure

Working with Application Structure

Technical requirements

Application overview

Understanding the DAR methodology

Creating visualization objects

Creating Master items

Calculation expressions

Further reading

Creating a Sales Analysis App Using Qlik Sense

Creating a Sales Analysis App Using Qlik Sense

Technical requirements

Creating the dashboard sheet

Creating the analysis sheets

Creating a reporting sheet

Interacting with Advanced Expressions

Interacting with Advanced Expressions

Technical requirements

Creating calculations with conditions

Using TOTAL for aggregation scope

Using some useful inter-record functions

Using AGGR for advanced aggregation

Leveraging Set Analysis for in-calculation selection

Further reading

Creating Data Stories

Creating Data Stories

An overview of stories

Creating snapshots

Planning and organizing your presentation

Creating stories

Editing your story

Sharing stories

Further reading

Section 4: Additional Features

Section 4: Additional Features

Engaging On-Demand App Generation

Engaging On-Demand App Generation

Technical requirements

How Qlik Sense handles large volumes of data

Setting up a Google BigQuery account

Configuring Qlik Sense for ODAG applications

Building a summarized application

Building the detailed application

Integrating the summarized and detailed applications

Further reading

Creating a Native Map Using GeoAnalytics

Creating a Native Map Using GeoAnalytics

Technical requirements

Concepts of GeoAnalytics

Adding more information to the map

Further reading

Working with Self-Service Analytics

Working with Self-Service Analytics

Technical requirements

Creating self-service analytics

Sharing insights with community sheets

Approving sheets to add them to a baseline

Co-creating applications in Qlik Sense Cloud Business

Further reading

Data Forecasting Using Advanced Analytics

Data Forecasting Using Advanced Analytics

Technical requirements

Qlik Sense Engine and Server Side Extensions

Preparing your R environment

Using the R extension in a Qlik Sense application

Preparing your Python environment

Using a Python extension

Using the Python SSE in your apps

Further reading

Deploying Qlik Sense Apps for Mobile/Tablets

Deploying Qlik Sense Apps for Mobile/Tablets

Technical requirements

Setting up the Sales Analysis app for mobile usage

Choosing the right client

Preparing the Sales Analysis app for offline usage

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Preparing the Sales Analysis app for offline usage

When developing or adjusting an application for offline usage, consider the following points:

The complexity and size of the application: Create simple and small applications of a few megabytes in size and fewer sheets and objects. The Qlik Sense Mobile application runs on an iOS device with much lower CPU performance and available memory compared to a computer that uses a web browser to connect to a Qlik Sense Enterprise server. You can perform tests on an iOS device with system specifications that match those of your application consumer. Download the application, open and make selections in the data, and observe the behavior. The apps need to be small. The download is aborted if the app is not ready for download in 90 seconds when requested from the server.
Extensions: Extensions are allowed in the Qlik Sense app. They are...