Chapter
Chapter 1: Qlik Sense® and
Data Discovery
Qlik Sense® and the QlikView.Next project
Data discovery—the evolution of BI
Chapter 2: Overview of a Qlik Sense® Application's Life Cycle
Overview of an application's life cycle
Chapter 3: Empowering Next Generation Data Discovery Consumers
Data discovery consumption requirements
Chapter 4: Contributing to Data Discovery
Realities of the data discovery contributor
Creating and sharing stories
Chapter 5: Authoring Engaging Applications
Preparations and requirements
Getting started with the app creation
The analysis interface—sheets and visualizations
Best practices in data visualization
Migrating applications from QlikView® to Qlik Sense®
Chapter 6: Building Qlik Sense® Data Models
The Qlik Sense® data model
Chapter 7: Qlik Sense® Apps in the Cloud
Using Qlik Sense® apps in the cloud
Using the Qlik DataMarket® content
Adding the QlikMarket® data
Chapter 8: Extending the Qlik® Analytic Platform
Developer community – Qlik Branch
Chapter 9: Administering Qlik Sense®
The Qlik Sense® architecture
Management and monitoring
Chapter 10: Sales Discovery
Chapter 11: Human Resource Discovery
How the application was developed
Chapter 12: Travel Expense Discovery
Developing the application
Chapter 13: Demographic Data Discovery
How the application was developed
Module 2: Qlik Sense Cookbook
Chapter 1: Getting Started
with the Data
Extracting data from databases and
data files
Extracting data from Web Files
Activating the Legacy Mode in Qlik Sense® desktop
Extracting data from custom databases
Invoking help while in the data load editor or the expression editor
Previewing data in the Data model viewer
Creating a Master Library from the Data model viewer
Using a Master Library in the Edit mode
Chapter 2: Visualizations
Creating and adding content to a story
Adding embedded sheets to the story
Highlighting the performance measure in a bar chart
Associating persistent colors to field values
Using the ColorMix1 function
Structuring visualizations
Efficiently debugging the script
Packaging the code in script files
How to use sub routines in Qlik Sense®
Optimizing the UI calculation speed
Optimizing the reload time of the application
Using a For Each loop to load data from multiple files
Using the Concat function to store multiple field values in a single cell
Chapter 4: Managing Apps and User Interface
Publishing a Qlik Sense® application created in Qlik Sense® desktop
Creating private, approved, and community sheets
Publishing a Qlik Sense® application to Qlik Sense® cloud
Creating geo maps in Qlik Sense®
Reference lines in Sales versus Target gauge chart
Effectively using the KPI object in Qlik Sense®
Creating dimensionless bar charts in Qlik Sense®
Adding Reference Lines to trendline charts
Applying limitations to charts
Adding thumbnails – a clear environment
Navigating many data points in a scatter chart
Chapter 5: Useful Functions
Using an extended interval match to handle Slowly Changing Dimensions
Using the Previous() function to identify the latest record for a dimensional value
Using the NetworkDays() function to calculate the working days in a calendar month
Using the Concat() function to display a string of field values as a dimension
Using the Minstring() function to calculate the age of the oldest case in a queue
Using the Rangesum() function to plot cumulative figures in trendline charts
Using the Fractile() function to generate quartiles
Using the FirstSortedValue() function to identify the median in a quartile range
Using the Declare and Derive functions to generate Calendar fields
Setting up a moving annual total figure
Using the For Each loop to extract files from a folder
Using the Peek() function to create a currency Exchange Rate Calendar
Using the Peek() function to create a Trial Balance sheet
Cracking the syntax for Set Analysis
Using flags in Set Analysis
Using the = sign with variables in Set Analysis
Point in time using Set Analysis
Using comparison sets in Set Analysis
Using embedded functions in Set Analysis
Creating a multi-measure expression in Set Analysis
Using search strings inside a set modifier
Capturing a list of field values using a concat() function in Set Analysis
Using the element functions P() and E() in Set Analysis
Chapter 7: Extensions in
Qlik Sense®
Creating an HTML visualization extension for Qlik Sense®
Defining a Properties panel in Qlik Sense® visualizations
Creating custom components within Qlik Sense® visualizations
Using data with extensions
Chapter 8: What's New in
Version 2.1.1?
Using the visual exploration capability in Qlik Sense® 2.1.1
Defining variables in Qlik Sense®
Exporting stories to MS PowerPoint
Using the Qlik Dev Hub in Qlik Sense® 2.1.1
Using Extension editor in Qlik Dev Hub
Using Qlik Dev Hub to generate mashups
Embedding Qlik Sense® application on a website using a single configurator
Using the Qlik DataMarket
Creating dynamic charts in Qlik Sense®
Using smart data load profiling
Keyboard shortcuts in Qlik Sense® Desktop
Module 3: Predictive Analytics Using Rattle and Qlik Sense
Chapter 1: Getting Ready with Predictive Analytics
Analytics, predictive analytics, and data visualization
Introducing R, Rattle, and Qlik Sense Desktop
Installing the environment
Downloading and installing Rattle
Installing Qlik Sense Desktop
Exploring Qlik Sense Desktop
Chapter 2: Preparing Your Data
Datasets, observations, and variables
Chapter 3: Exploring and Understanding Your Data
Visualizing distributions
Correlations among input variables
Chapter 4: Creating Your First Qlik Sense Application
Customer segmentation and customer buying behavior
Loading data and creating a data model
Creating a simple data app
Chapter 5: Clustering and Other Unsupervised Learning Methods
Machine learning – unsupervised and supervised learning
Chapter 6: Decision Trees and Other Supervised Learning Methods
Partitioning datasets and model optimization
Entropy and information gain
Underfitting and overfitting
Using a Decision Tree to classify credit risks
Chapter 7: Model Evaluation
Measuring the performance of classifiers
Chapter 8: Visualizations, Data Applications, Dashboards, and Data Storytelling
Data visualization in Qlik Sense
Data analysis, data applications, and dashboards
Data storytelling with Qlik Sense
Chapter 9: Developing a Complete Application
Understanding the bike rental problem
Exploring the data with Qlik Sense
Creating a Qlik Sense App to control the activity
Using Rattle to forecast the demand