Learning Qlik Sense?: The Official Guide - Second Edition电子书

Learning Qlik Sense® The Official Guide Second Edition

Table of Contents

Learning Qlik Sense® The Official Guide Second Edition

Credits

About the Authors

Acknowledgments

About the Reviewer

www.packtpub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

Instant updates on new Packt books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Reviewing the example applications

Errata

Piracy

Questions

1. Qlik Sense® and Data Discovery

Continuing disruption

Qlik Sense® and the QlikView.Next project

Making sense of modern business

What is data discovery?

The empowered user

Interaction with data

Traditional business intelligence architecture

The Qlik® way

Color coding

Freedom of data navigation

Calculation on demand

Data discovery—the evolution of BI

Summary

2. Overview of a Qlik Sense® Application's Life Cycle

Overview of an application's life cycle

Starting application authoring

What makes up a Qlik Sense® application?

Sharing an application

Continuing the application's life cycle

Summary

3. Empowering Next Generation Data Discovery Consumers

Data discovery consumption requirements

Introducing the hub

Introducing streams

Exploring the components of the application

Sheets

Bookmarks

Data storytelling

Navigating and leveraging the associative experience

Navigation

Smart visualizations

Global search

Global filtering

Extending with Library

Summary

4. Contributing to Data Discovery

Realities of the data discovery contributor

Creating private bookmarks

Creating and sharing private sheets

Creating a private sheet

Publishing a private sheet

Creating a new sheet

Adding a predefined visualization to a new sheet

Creating a Combo chart object

Publishing a private sheet

Creating and sharing stories

Defining a story

Creating snapshots

Adding text

Adding shapes

Media library

Publishing your story

Summary

5. Authoring Engaging Applications

Preparations and requirements

The requirement specifications

The communication problem

A step-wise implementation

The process

Getting started with the app creation

Creating a new app

Loading your data

Loading additional tables

Using the Data load editor

Creating a database connection

Data connectors

The analysis interface—sheets and visualizations

Creating a sheet

Adding visualizations

Adding dimensions and measures

Defining bar charts

Storytelling

The application library

Which fields should be exposed?

Defining KPIs

Creating library entries

Best practices in data visualization

Dashboard

Analysis

Reporting

Structuring a sheet

Graphs and other visualizations

Dimensions and measures

The bar chart

The pie chart

The line chart

The KPI object

The gauge

The scatter chart

The tree map

The geographical map

Tables

Sorting and colors

Migrating applications from QlikView® to Qlik Sense®

Changes to the script

Changes to the user interface

Publishing your apps

Summary

6. Building Qlik Sense® Data Models

The QIX engine

The Qlik Sense® data model

Creating a multitable data model

Linking tables

Structuring your data

Normalization

Star schema and snowflake schema

Pitfalls in the data model

The data model viewer

Using preview mode

Summary

7. Qlik Sense® Apps in the Cloud

Why use the cloud?

Cloud sharing

Cloud content

Using Qlik Sense® apps in the cloud

Uploading an app from the desktop

Creating an app in Qlik Sense® Cloud

Sharing an app in Qlik Sense® Cloud

Maintaining Qlik Sense® Cloud apps

Using the Qlik DataMarket® content

Adding the QlikMarket® data

Summary

8. Extending the Qlik® Analytic Platform

Qlik® Dev Hub

Web mashups

Extending the Qlik Sense® client

Engine API Explorer

Developer community – Qlik Branch

Summary

9. Administering Qlik Sense®

The Qlik Sense® architecture

Services

Clients

Applications

Nodes

Streams

Deployment and licensing

Single node or multinode

License and access passes

Tokens

Access rules

Management and monitoring

Importing and managing apps

Importing extensions

Users and user directories

Defining streams

Connectivity management

Tasks

System management

Security rules

Monitoring

Security

Authentication and authorization

Content security

Summary

10. Sales Discovery

The business problem

Application features

Who are our top customers?

The 360-degree customer view

Filtering customers

Reviewing shipments for top customers

Reviewing the bottom five customers

Who are our most productive sales representatives?

Analyzing products

Analyzing customer sales

Building the application

The SalesDetails table

The Customers table

The AggSales table

US States ISO CODE 2 polygons

Analyzing the Sales Discovery Library

Dimensions

Measures

Visualizations

Summary

11. Human Resource Discovery

The business problem

Application features

Sheets

Training costs

Using the global selector

How the application was developed

Dimensions

Summary

12. Travel Expense Discovery

The business problem

Application features

Tracking expenses

Analyzing expenses overspent

Digging deeper into the data

Creating an analysis story for travel expenses

Creating an overview

Sharing our analysis

Finishing the story

Developing the application

Examining the key tables

Expenses

PerDiemRates

Airfare

Department

Budget

LinkTable

Dimensions

Measures

Visualizations

Summary

13. Demographic Data Discovery

Problem analysis

Application features

Analysis

Using the lasso selector to make selections

Using the global selector to make selections

How the application was developed

Dimensions

Measures

Summary

Index