更新时间：2021-07-02 13:06:12
coverpage
Title Page
Copyright and Credits
Hands-On Business Intelligence with Qlik Sense
About Packt
Why subscribe?
Packt.com
Contributors
About the authors
About the reviewer
Packt is searching for authors like you
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Download the color images
Conventions used
Get in touch
Reviews
Section 1: Qlik Sense and Business Intelligence
Getting Started with Qlik Sense
An overview of the Qlik Sense product
The components of Qlik Sense
In-memory associative database
ETL engine
Data manager
Script
Data model
Visualization platform
The hub
Application overview
Sheets
Objects
API and extensibility capabilities
The Associative Engine
Setting up Qlik Sense Desktop
Setting up Qlik Sense Cloud
Self-service with Qlik Sense
Summary
Section 2: Data Loading and Modeling
Loading Data in Qlik Sense
Technical requirements
Data loading process
Loading data from data sources
Data connections
Dragging a data file into your application
Loading a data file from a folder (Qlik Sense Desktop)
Loading a data file from data files (QlikCloud)
Creating calculated fields
Data load editor
Table associations
Data profiling
Profiling using the Data manager
Profiling using the Data model viewer
Further reading
Implementing Data Modeling Techniques
An overview of data modeling
Data modeling techniques
Entity relationship modeling
Dimensional modeling
Joining
Types of joins
Join/outer join
Left join
Right join
Inner join
Pitfalls of using joins
Concatenation
Automatic concatenation
Forced concatenation
The NoConcatenate
Filtering
Filtering data using the Data manager
Filtering data in the script editor
QVDs
Why use QVDs?
Link table
Canonical dates
As-Of Table
Script optimization
Using Applymap instead of joins
Applymap()
Reducing the size of data as much as possible
Optimized QVD load
Non-optimized load
Optimized load
Dropping unwanted tables immediately after use
Sample questions
Section 3: Building an Analytical Application
Working with Application Structure
Toolbars
Understanding the DAR methodology
