Book Image

Learning Qlik Sense??: The Official Guide Second Edition - Second Edition

By : Christopher Ilacqua, QlikTech International AB, Henric Cronström, James Richardson
Book Image

Learning Qlik Sense??: The Official Guide Second Edition - Second Edition

By: Christopher Ilacqua, QlikTech International AB, Henric Cronström, James Richardson

Overview of this book

The intuitive and powerful Qlik Sense visual analytics software allows anyone to engage in data discovery, to explore your data, and find meaningful insights to empower your business. Qlik Sense lets you easily create personalized reports and visualizations and reveal essential connections to show new opportunities from every angle. Written by members of the Qlik Sense team, this book is the official guide from Qlik to understanding and using their powerful new product with fully updated coverage to the latest features of the most modern edition of Qlik Sense. Benefit from the vision behind the development of Qlik Sense and get to grips with how Qlik Sense can empower you as a data discovery consumer. Learn how to create your own applications for Qlik Sense to customize it to meet your personal needs for business intelligence, and how to oversee and administer the Qlik Sense data architecture. Finally, explore utilizing Qlik Sense to uncover essential data, with practical examples on finding and visualizing intelligence for sales figures, human resources information, travel expense tracking, and demographic data discovery.

Related Content you might be interested in

Current Title:

Small book image
Learning Qlik Sense??: The Official Guide Second Edition - Second Edition
Christopher Ilacqua | QlikTech International AB | Henric Cronström | James Richardson
Dec, 2015 | 282 pages
No titles found
Table of Contents (21 chapters)
Learning Qlik Sense® The Official Guide Second Edition
Learning Qlik Sense® The Official Guide Second Edition
Credits
Credits
About the Authors
About the Authors
Acknowledgments
Acknowledgments
About the Reviewer
About the Reviewer
www.packtpub.com
www.packtpub.com
Preface
Preface
Free Chapter
1
Qlik Sense® and Data Discovery
Qlik Sense® and Data Discovery
Continuing disruption
Qlik Sense® and the QlikView.Next project
What is data discovery?
The Qlik way
Data discovery—the evolution of BI
Summary
2
Overview of a Qlik Sense® Application's Life Cycle
Overview of a Qlik Sense® Application's Life Cycle
Overview of an application's life cycle
Summary
3
Empowering Next Generation Data Discovery Consumers
Empowering Next Generation Data Discovery Consumers
Data discovery consumption requirements
Summary
4
Contributing to Data Discovery
Contributing to Data Discovery
Realities of the data discovery contributor
Creating and sharing stories
Summary
5
Authoring Engaging Applications
Authoring Engaging Applications
Preparations and requirements
Getting started with the app creation
Loading your data
The analysis interface—sheets and visualizations
The application library
Best practices in data visualization
Migrating applications from QlikView® to Qlik Sense®
Publishing your apps
Summary
6
Building Qlik Sense® Data Models
Building Qlik Sense® Data Models
The QIX engine
The Qlik Sense® data model
Structuring your data
The data model viewer
Summary
7
Qlik Sense® Apps in the Cloud
Qlik Sense® Apps in the Cloud
Why use the cloud?
Using Qlik Sense® apps in the cloud
Using the Qlik DataMarket® content
Adding the QlikMarket® data
Summary
8
Extending the Qlik Analytic Platform
Extending the Qlik Analytic Platform
Qlik Dev Hub
Developer community – Qlik Branch
Summary
9
Administering Qlik Sense®
Administering Qlik Sense®
The Qlik Sense® architecture
Deployment and licensing
Management and monitoring
Security
Summary
10
Sales Discovery
Sales Discovery
The business problem
Application features
Summary
11
Human Resource Discovery
Human Resource Discovery
The business problem
Application features
How the application was developed
Summary
12
Travel Expense Discovery
Travel Expense Discovery
The business problem
Application features
Developing the application
Summary
13
Demographic Data Discovery
Demographic Data Discovery
Problem analysis
Application features
How the application was developed
Summary
Index
Index

How the application was developed

The data model for the Human Capital Management application looks similar to what is shown in the following diagram:

There are six tables in this application:

  • Employees: This is the main table, which has one record per employee and month. It contains all the relevant information about the employee such as country, position, salary, and so on. It would probably be a cleaner data model if this table were split into one table containing employee information that doesn't change over time and another table with the time-dependent information.

    However, since the QIX engine analyzes the data just as efficiently either way, we don't see any great benefit in spending time structuring the data more.

    Preview of the Employees table

  • Hierarchy: This table contains information about the hierarchy of the employee, such as who the manager of the employee is, and who the VP of the employee is.

  • Survey: This table contains the results from an external survey made on employee satisfaction...

Previous Section
End of Section 4
Next Section