Book Overview & Buying
Table Of Contents
Feedback & Rating

Hands-On Business Intelligence with Qlik Sense

By : Labbe, Clever Anjos , Solanki, DiMaso

3.3 (4)

Buy this Book

Hands-On Business Intelligence with Qlik Sense

3.3 (4)

By: Labbe, Clever Anjos , Solanki, DiMaso

Buy this Book

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

Get in touch

Free Chapter

Section 1: Qlik Sense and Business Intelligence

Getting Started with Qlik Sense

An overview of the Qlik Sense product

Summary

Section 2: Data Loading and Modeling

Loading Data in Qlik Sense

Technical requirements

Data loading process

Table associations

Data profiling

Summary

Further reading

Implementing Data Modeling Techniques

Technical requirements

An overview of data modeling

Joining

Concatenation

Filtering

QVDs

Link table

Canonical dates

As-Of Table

Script optimization

Summary

Sample questions

Further reading

Section 3: Building an Analytical Application

Working with Application Structure

Technical requirements

Application overview

Understanding the DAR methodology

Creating visualization objects

Creating Master items

Calculation expressions

Summary

Questions

Further reading

Creating a Sales Analysis App Using Qlik Sense

Technical requirements

Creating the dashboard sheet

Creating the analysis sheets

Creating a reporting sheet

Summary

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

Summary

Further reading

Creating Data Stories

An overview of stories

Creating snapshots

Planning and organizing your presentation

Creating stories

Editing your story

Sharing stories

Summary

Further reading

Section 4: Additional Features

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

Summary

Further reading

Creating a Native Map Using GeoAnalytics

Technical requirements

Concepts of GeoAnalytics

Creating a map

Adding more information to the map

Summary

Further reading

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

Summary

Further reading

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

Summary

Questions

Further reading

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

Summary

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

3.3 (4)

5 star

25%

4 star

25%

3 star

25%

2 star

1 star

25%

Technical requirements

In this chapter, we will use the Sales Analysis app that we created in Chapter 5, Creating a Sales Analysis App Using Qlik Sense, as a starting point, with a loaded data model and visualizations; this will eliminate the process of creating the application again.

You can also download the initial version of the .qvf file for this application, called CH10_start.qvd, from the book repository on GitHub, at https://github.com/PacktPublishing/Hands-On-Business-Intelligence-with-Qlik-Sense/tree/master/Chapter10.

You will also need access to one of the following two environments to import the application:

For Qlik Sense Enterprise, you will need an account with a root admin or a content admin role to access the Qlik Management Console (QMC) with the URL https://<servername>/qmc
For Qlik Sense Cloud Business, you will need an account with a subscription and...