• logo
  • 9861600203
  • info@mentorit.com.np
header-logo.png

Overview

Welcome to the world of data visualisation

Data Visualization is one of the fastest evolving areas in Analytics and Data Science. With data increasing by the second, we need people who can not only visualise huge amount of data but also communicate data based stories to their customers. This is the reason, we mentioned data visualisation as a key skill to learn in 2015.

QlikSense is one of the fastest evolving Business Intelligence (BI) and data visualisation tool. It is very fast to deploy, easy to learn and very intuitive to use for a customer. So, if you want to improve data visualisation practices, then QlikSense is the perfect tool to start with.

Here our aim is to provide a learning path to all those people who are new to QlikSense. This path will help you to learn QlikSense in a structured approach. If you already have some background, or don’t need all the components, feel free to adapt your own paths and let us know how have you made the changes in the path.

 

 

Course Content

  • What is QlikSense?
  • Qlik Sense Desktop vs Qlik Sense
  • Installing Qlik Sense Desktop
  • How Qlik Sense varies from QlikView?
  • Starting with QlikSense Desktop
  • Opening an app with QlikSense
  • QlikSense Architecture
  • Getting Started with Qlik Sense
  • My First Qlik Sense App
  • Read Data into QIik Sense Data Sources
  • Table Files
  • Excel
  • Drag and drop
  • Select data button
  • Text files
  • Inner Join
  • Extracting data from databases and data files
  • Extracting data from Web Files
  • Previewing data in the Data model viewer
  • Creating a Master Library from the Data model viewer
  • Using a Master Library in the Edit mode
  • Star schema
  • Synthetic Key Tables
  • Circular References & its causes
  • Ways to Resolve Synthetic Keys and Circular Reference
  • Using Qualify & unqualify
  • Link Table
  • Concatenation: Forced, Auto, No
  • Data Model optimization
  • Master Calendar
  • Different Type of Loads
  • Incremental load with QVD file
  • Column manipulation
  • Tables: Rotating, Straight and Pivot, Cross
  • Mapping Table
  • Security – Section Access and Control
  • Structuring the script
  • Efficiently debugging the script
  • Packaging the code in script files
  • Optimizing the UI calculation speed
  • Using a For Each loop to load data from multiple files
  • Using the Concat() function to store multiple field values in a single cell
  • QlikView Advance Functions
  • String Functions
  • Logical Functions
  • Range Functions
  • Date Functions
  • Overview of visualization
  • Explore Tables, Bar chart, Line Chart, Pie Chart
  • Highlighting the performance measure in a bar chart
  • Associating persistent colors to field values
  • Reference lines in Sales versus Target gauge chart
  • Effectively using the KPI object in Qlik Sense
  • Adding Reference Lines to trendline charts
  • Customizing the visual parameters
  • Publishing a Qlik Sense application created in Qlik Sense desktop
  • Data Storytelling
  • Publishing
  • Exporting and Printing
  • Qlik Sense App and its security features
  • Providing Qlik Sense access to user sets
  • Introduction to Qlik Sense Enterprise
  • Qlik Sense Security rule codes
  • Introduction to Mashups and Extensions

About the instructor

DIPU MAHARJAN

BI Solution Architect

Hi I am Dipu Maharjan. I am working as BI Solution Architect. I have experience more than 13 years as Data Analyst, Database Programmer, BI Developer and Trainer.

No reviews for this course


Write a Message

Security Check
2 + 2 =

    Course Features

  • Total Credit Hours30 hrs
  • Course CostUSD 226.20