Learn Qlik Sense Dashboard Development

Name: Learn Qlik Sense Dashboard Development
Rating: 4.1 (67 reviews)

Learn Qlik Sense data visualization via a discovery tool that lets you analyze data easily and make business decisions f

Created byPackt Publishing

Last updated 1/2019

English

What you'll learn

Develop an intuitive and informative dashboard with the appropriate depth of interactivity using Qlik Sense
Read data from popular spreadsheet applications MS Excel, websites and data from databases
Create a fully featured data model without circular references,
Display data in maps, charts, and text across multiple sheets.
Apply set analysis to your data in Qlik Sense expressions
Add security in your Qlik Sense applications for better data protection

Course content

7 sections • 33 lectures • 2h 11m total length

The Course Overview3:36
This video will give you an overview about the course.
Cloud or offline Qlik Sense3:09
In this video, we will understand which option to choose: Cloud or Offline Qlik Sense software.
• Website/Location to get both options
• Create accounts for both options
• Log in to the cloud environment
Overview of Qlik Sense Desktop2:09
What to expect from different desktop sections?
• Understand the main window
• Understand demo app and video section
• Get help related to Qlik Sense
App Demo5:21
How to open and explore a Qlik Sense app?
• Open a sheet to start exploring an app
• Make selections in the app
• Explore charts and view background info
Qlik Sense Architecture1:21
What are the important terminologies a developer must know related to Qlik Sense?
• Explore the architecture of Qlikview
• Understand the layers of Qlik Sense
• Understand the functioning of each layer to better understand the architecture

Creating an App4:15
How to create an app in Qlik Sense?
• Log in to Qlik Sense
• Click on the "Create new App button"
Importing Data from Excel6:29
How to import Excel data in Qlik Sense?
• Select the Add data from files option
• Go to the desired location by selecting My Computer
• Select the sales file and click on Load data
Understanding Fact and Dimensions5:05
What are fact and dimensions and how to identify them?
• Understand the difference between fact and dimensions
• Learn how to use special character to identify fact/dim
• Edit data in Qlik Sense to prefix fact/dim
Creating and Understanding Filters4:25
What are filters in Qlik Sense and how do we create them?
• Create a filter pane from the charts section
• Add dimensions
• Make selections and understanding selection terminology
Creating new Sheets1:58
How to create new sheets in Qlik Sense?
• Go to the Sheets drop-down option
• Click on the Create new sheet thumbnail

Types of Data Models3:05
What are the different types of data models that we can create in Qlik Sense?
• Understand single table model
• Understand star schema model
• Understand snowflake schema
Creating a Star Schema Model4:09
How to create a star schema in Qlik Sense?
• Go to Data Manager
• Import Fact and Dim tables from spreadsheet
• Join the tables based on suggested joins
Viewing and Analyzing the Resulting Data Model3:27
How to view and analyze the resulting data model?
• Go to the data model viewer to view the model
• Click on any of the key fields
• Using density and subset ratio to understand the model
Creating QVD Files4:47
How to create QVD files in Qlik Sense?
• Go to Script Editor and unlock the script
• Write the store command to get the table out
• View the QVD file location used in the store command

Filter Properties3:11
What are the different properties of Qlik Sense filters?
• Click on data section to change field and field name
• Click on sort section to change sorting settings
• Click on appearance to change the appearance settings
Date Filters2:34
What are date filters and how to use them?
• Use the most low-level date field in dataset
• Create multiple date fields to use as filters
• Select a year quarter field to use as filter on the frontend
Qlik Sense Charts4:43
How to create charts in Qlik Sense?
• Got to charts and select a chart of interest
• Provide a dimension of interest
• Provide a measure of interest
Master Items5:19
What are Master Items and how to create them?
• Master Items importance
• Go to Master Items
• Select dimension and measure of interest, and provide values
Bookmarks1:59
What are bookmarks and how to create them?
• Bookmarks to save analysis
• Make some selections from filters
• Go to Bookmark and click on Create Bookmark to save analysis

Adding KPIs6:50
In this video, we will learn what KPIs are and how to create them in Qlik Sense.
• Understand charts and KPI
• Drag KPI object to canvas
• Provide measure to create KPI
Adding Charts2:38
In this video, we will learn to create Charts in Qlik Sense.
• Understand different charts
• Drag the chart object to canvas
• Provide dimension and measure to chart
Simple and Pivot Table3:17
How to Create Simple and Pivot Table?
• Select a simple or pivot table in chart
• Drag the table object to canvas
• Provide dimension and measure to table
Drill Down Dimension3:59
What is drill down dimension and how to create it?
• Select the dimension on which drill down is required
• Create the drill down dimension
Text and Images3:30
In this video, we will learn how to add text and images in Qlik Sense.
• Drag on to canvas at the desired position
• Enter the relevant text or select image to display
Maps3:36
In this video, we will learn how to create and configure maps in Qlik Sense.
• Drag the map object to desired location
• Provide geo-tagged field and measure to populate chart

Basics of Set Analysis Expression8:27
In this video, we will learn what set analysis is and how to use it in Qlik Sense.
• Set Analysis Requirements overview
• Set Analysis Syntax overview
Assignment Operators5:16
Learn what assignment operators in Qlik Sense are and how to use them.
• Understand various types of operators and situation and when you need it
• Use the required assignment operator in set analysis expression
Set Operators3:50
In this video, we will learn what set operators in Qlik Sense are and how to use them.
• Use the required set operator in set analysis expression
Element Functions5:18
In this video, we will learn what element functions are and their use.
• Understand what element functions are and situations when you need it
• Use the required element function in set analysis expression

Qlik Sense Security Overview3:01
How does security get configured and used in Qlik Sense?
• Security section overview
• Learn best practices for security script
• Security effectiveness
Understanding Various Types of Security2:08
What are the different levels on which security can be applied?
• Security types overview
• Understand when to use a particular type of security
• Understand when security comes in to effect
Configuring Security6:13
How to write security script in Qlik Sense?
• Drag the tab prior to every other tab
• Write the security script and load the data
Next Steps2:48
How to take help on any Qlik Sense topics or custom needs?
• Overview of community.qlik.com
• Enter the question as per your problem
• Select the best possible populated question based on your requirements

Requirements

A basic understanding of BI concepts is all you need to get started with this course.

Description

Qlik Sense enables you to create interactive reports and dashboards with stunning charts and graphs. This course will show how you can use Qlik Sense to build your own dashboard.

You will start by connecting your Data with Qlik Sense and will create your own Qlik Sense app. You will see how to add data from popular spreadsheet applications MS Excel and work with Qlik Sense components such as charts, list boxes, input boxes, and Text objects. You'll build your own dashboard by adding different functionalities, perform analyses, and secure your data in Qlik Sense.

By the end of the course, you will able to analyze data and make business decisions faster.

About the Author

Abhishek Agarwal has 12+ years experience in developing analytical solutions. He is a seasoned BI professional with expertise in multiple technologies. He has been teaching BI technologies for the past 5+ years and has worked in a similar domain. He uses QlikView, Power BI, Tableau, and a couple of other technologies for end-to-end analytical solution development in his current work.

Who this course is for:

Business analysts, managers, or anyone who just wants to get started with Qlik Sense will find this tutorial useful.

Learn Qlik Sense Dashboard Development

What you'll learn

Explore related topics

Course content

Getting Started with Qlik Sense5 lectures • 16min

Getting Data into Qlik Sense and Creating Your First Qlik Sense App5 lectures • 22min

Creating Data Models4 lectures • 15min

Qlik Sense Components5 lectures • 18min

Let's Build a Dashboard6 lectures • 24min

Adding Set Analysis4 lectures • 23min

Securing Your Data4 lectures • 14min

Requirements

Description

Who this course is for: