Sign In Start Free Trial

Hands-On Business Intelligence with Qlik Sense

By : Labbe, Clever Anjos , Solanki, DiMaso

3.3 (4)

Hands-On Business Intelligence with Qlik Sense

3.3 (4)

By: Labbe, Clever Anjos , Solanki, 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

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

Section 1: Qlik Sense and Business Intelligence

Getting Started with Qlik Sense

Getting Started with Qlik Sense

An overview of the Qlik Sense product

Summary

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

Data profiling

Summary

Further reading

Implementing Data Modeling Techniques

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

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

Summary

Questions

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

Summary

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

Summary

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

Summary

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

Summary

Further reading

Creating a Native Map Using GeoAnalytics

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

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

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

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

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

0

1 star

25%

Setting up a Google BigQuery account

Google's BigQuery (https://cloud.google.com/bigquery/) is a service provided by Google as part of Google Cloud Platform as a serverless enterprise data warehouse. This can be deployed in minutes and tested using a free tier. They have a data sample that we can use. Perform the following steps to set up an account:

Set up the data lake access using https://cloud.google.com/bigquery/ and click on TRY BIGQUERY FREE. From here, you will be redirected to your Google account login form:

If you don't have a Google account, please create a new one for the purpose of this chapter. You're going to receive a $300.00 credit, which is valid for 12 months.

Once you are redirected to Google Cloud Platform (https://console.cloud.google.com), which is the Google Software as a Service (SaaS) ecosystem home, we can see where the BigQuery console...

Search

Your notes and bookmarks