Book Image

Qlik Sense: Advanced Data Visualization for Your Organization

By : Henric Cronström, Ferran Garcia Pagans, Neeraj Kharpate, James Richardson, Philip Hand
Book Image

Qlik Sense: Advanced Data Visualization for Your Organization

By: Henric Cronström, Ferran Garcia Pagans, Neeraj Kharpate, James Richardson, Philip Hand

Overview of this book

Qlik Sense is powerful and creative visual analytics software that allows users to discover data, explore it, and dig out meaningful insights in order to make a profit and make decisions for your business. This course begins by introducing you to the features and functions of the most modern edition of Qlik Sense so you get to grips with the application. The course will teach you how to administer the data architecture in Qlik Sense, enabling you to customize your own Qlik Sense application for your business intelligence needs. It also contains numerous recipes to help you overcome challenging situations while creating fully featured desktop applications in Qlik Sense. It explains how to combine Rattle and Qlik Sense Desktop to apply predictive analytics to your data to develop real-world interactive data applications. The course includes premium content from three of our most popular books: [*] Learning Qlik Sense: The Official Guide Second Edition [*] Qlik Sense Cookbook [*] Predictive Analytics using Rattle and Qlik Sense On completion of this course, you will be self-sufficient in improving your data analysis and will know how to apply predictive analytics to your datasets. Through this course, you will be able to create predictive models and data applications, allowing you to explore your data insights much deeper.

Related Content you might be interested in

Current Title:

Small book image
Qlik Sense: Advanced Data Visualization for Your Organization
Henric Cronström | Ferran Garcia Pagans | Neeraj Kharpate | James Richardson | Philip Hand
Dec, 2017 | 12 hours 44 minutes
No titles found
Table of Contents (5 chapters)
Preface
Preface
What this learning path covers
What you need for this learning path
Who this learning path is for
Reader feedback
Customer support
Free Chapter
1
1. Module 1
1. Module 1
1. Qlik Sense® and Data Discovery
2. Overview of a Qlik Sense® Application's Life Cycle
3. Empowering Next Generation Data Discovery Consumers
4. Contributing to Data Discovery
5. Authoring Engaging Applications
6. Building Qlik Sense® Data Models
7. Qlik Sense® Apps in the Cloud
8. Extending the Qlik® Analytic Platform
9. Administering Qlik Sense®
10. Sales Discovery
11. Human Resource Discovery
12. Travel Expense Discovery
13. Demographic Data Discovery
2
2. Module 2
2. Module 2
1. Getting Started with the Data
2. Visualizations
3. Scripting
4. Managing Apps and User Interface
5. Useful Functions
6. Set Analysis
7. Extensions in Qlik Sense®
8. What's New in Version 2.1.1?
A. Appendix
3
3. Module 3
3. Module 3
1. Getting Ready with Predictive Analytics
2. Preparing Your Data
3. Exploring and Understanding Your Data
4. Creating Your First Qlik Sense Application
5. Clustering and Other Unsupervised Learning Methods
6. Decision Trees and Other Supervised Learning Methods
7. Model Evaluation
8. Visualizations, Data Applications, Dashboards, and Data Storytelling
9. Developing a Complete Application
A. Bibliography
4
Index
Index

Chapter 5. Useful Functions

In this chapter, we will focus on some interesting and useful functions available in Qlik Sense:

  • 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 Derive and Declare 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...
Previous Section
End of Section 6
Next Section