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.
Table of Contents (18 chapters)
Free Chapter
1
Section 1: Qlik Sense and Business Intelligence
3
Section 2: Data Loading and Modeling
6
Section 3: Building an Analytical Application
11
Section 4: Additional Features

Table associations

The power of Qlik Sense Associative resides in how your tables are associated. Unlike SQL tools, you don't have to worry about Many-To-One and One-To-Many relationships and predefine the exploration path between your data. You can load your data, set which fields (usually called key fields) are the links between the tables, and Qlik Sense Associative takes care of the rest.

Now, let's see how we can create the associations between the two tables we have loaded:

On the right-hand side of the screen, you can see a section called Recommended associations. While loading your data, Qlik Sense analyzed your tables and proposed how to associate your tables based on a complex algorithm that considers distinct values of each field, column names, and the frequency of each value for each table.

Press the Preview all button to check how Qlik Sense is proposing...