Qlik Sense Recipes: Tips, Tricks, and Techniques: Perform efficient data analysis and visualizations by implementing proven recipes using Qlik Sense

Qlik Sense Recipes: Tips, Tricks, and Techniques: Perform efficient data analysis and visualizations by implementing proven recipes using Qlik Sense

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 2h 59m | 2.55 GB

Recipes for efficient visualization with Qlik Sense

Qlik Sense is a great tool for exploring data and empowering analysts to generate reports. It truly puts the user in control with self-serve business intelligence. This video course is your guide to getting the most out of Qlik Sense and will help you solve common problems you might come across while using it. This course contains practical recipes covering the various key tasks you can accomplish with Qlik Sense, from visualizing your data to analyzing it. The course also contains some handy recipes for troubleshooting various possible issues in Qlik SenseBI. We’ll ensure that you have the tricks of the trade to mastering Qlik Sense for effective visual analytics. By the end of the course, you will have upgraded your skills and knowledge to be able to efficiently and become confident in implementing Qlik Sense for your real-world projects. Some prior knowledge of Qlik Sense (and familiarity with Excel and SQL) is assumed for this course.

Learn

  • Dive straight into the most common issues and resolution of visualization, expressions, and data loading
  • Create advanced visualizations to present complex scenarios more effectively
  • Dive into the advance expression function to calculate custom business logic
  • Load and manipulate data for faster and more efficient data import into the Qlik Sense engine
  • Take your expressions to the next level with the set analysis functions and operators
  • Learn about the common data issues related to formatting, expression, and presentation
  • Tips and tricks for efficient and compelling visualization development
Table of Contents

Creating Innovative Charts with Qlik Sense
1 The Course Overview
2 Summarizing Data Points with Box Plot Chart
3 Understanding the Data Movement with Waterfall
4 Understanding the Competition with Butterfly Chart
5 Visualizing Project Activities with Gantt Chart
6 Understanding the Performance with Traffic Light KPIs

Expressions to Create Visualizations
7 Sorting Stack Bar Chart
8 Virtual Table Expressions with AGGR
9 Calculations Using Above and Below Values
10 Calculations Based on Forward and Backward Values
11 Aggregating Ranges

Set Analysis Recipes
12 Important Set Analysis Terms
13 Including or Excluding Selections
14 Removing the Effect of a Particular Value
15 Taking Effect of Possible or Excluded Values
16 Conditional Searching
17 Functions Inside Set Analysis

Data Loading Scripting Recipes for Efficient Dashboard
18 Loading Multiple Files
19 How to Add Only New Data
20 Loading Data at the Speed of Light
21 Random Sampling of Data
22 Looking Up Data from a Different Table

Common Tasks for Data Manipulation and Presentation
23 Number and Dates Formatting
24 Picking Up Selected Data for a Dynamic Display
25 Optimizing Expression (Using Variables)
26 Missing and Null Values
27 Formatting Output with Dual

Qlik Sense Important Functions
28 Creating Numeric Categories
29 Picking Up Previous Values
30 Ranking Data Points
31 Creating Correlations
32 Joining String Values

Qlik Sense Field Selections
33 Comparing Values of the Same Chart
34 Setting Default Selection Values
35 Dynamic Title from Field Selections
36 Possible Field Count Using Another Field Selection
37 Saving the Selections for Future Use
38 Next Steps