Description

In this course, you would learn how to use QlikView for Business Intelligence and to bring visual insights to the data. This training covers all the concepts of QlikView such as Data Interpretation, Designing, Modelling and then dives into advance features such as analyzing the data, discovering the hidden data and generating interactive graphs and charts

Course Content

Module 1 – Qlik Sense Introduction & Installation

  • Comparing Qlik Sense Desktop with Qlik Sense
  • Installing Qlik Sense Desktop
  • How Qlik Sense varies from QlikView?
  • Starting with QlikSense Desktop
  • Opening an app with QlikSense
  • QlikSense Architecture

Module 2 – Starting QlikSense

  • Navigating in the user interface
  • Data Manager
  • Data Load Editor
  • Data Model Viewer
  • Interacting with the user interface
  • Creating apps and Visualizations
  • Structuring an app with Sheets

Module 3 – Designing Visualizations

  • Different type of Visualizations
  • Dimensions and Measures in a CHART
  • When to use and What Chart to Use
  • Selections in a Visualization
  • Settings and Properties of each Visualization

Module 4 – Using Expressions in Visualization

  • Expressions, Functions and Variables
  • Working with Expression Editor
  • Using Functions in Charts
  • Using Variables in Expressions
  • Set Analysis and Set Expressions
  • Working with Master Items

Module 5 – Manage Data

  • Adding data from files and databases
  • Loading data with the data load script
  • Data Connections
  • Various types of Data loads
  • Profile Data with QlikSense
  • Troubleshooting

Module 6 – Creating a Data Model

  • Qlik Sense Data Architecture
  • Creating Star and Snowflake schemas
  • Use of Joins, Keeps, Concatenate etc..
  • Understanding QVD layer
  • Working on synthetic keys and circular references

Module 7 – Advanced Data Modelling

  • Qlik Sense Star Schema
  • Link Table
  • Dimensions Table
  • Master Calendar
  • Optimizing data models
  • Best Practices of Data Modelling

Module 8 – Collaborate in QlikSense

  • Data Storytelling
  • Publishing
  • Exporting and Printing
  • Advanced Scripting and Chart Functions
  • Qlik Tips and Techniques

Module 9 – Qlik Sense Security

  • Learning about Qlik Sense App and its security features
  • Providing Qlik Sense access to user sets
  • Qlik Sense Security rule code

Duration: 2 – 4 weeks

Hi, How Can We Help You?