After completion of the course, you will be able to:

  • Understand Business Intelligence concepts and analyse data using QlikView.
  • Connect to database through scripts and fetch data for analysis.
  • Understand and use many in-built functions to increase your productivity.
  • Loading data into QlikView using different available approaches for analysis.
  • Basic and advance level data visualization using multiple visualization controls such as multi dimensional charts and pivot tables.

Target Audience

  • Business Intelligence professionals
  • Sales and Marketing professionals
  • Data scientist
  • Project Managers
  • Solution Architects
  • Functional Consultants
  • In general: anyone who wants to make career in QlikView!

Trainer Profile

Trainer has 8+ years of experience in QlikView consulting, development and training.

He works with a major IT company and delivers training on demand.

He is well versed on QlikView, SQL Server and other related technologies.

Trainer has delivered training to many major IT companies in different countries including USA, UK, Canada, Australia and India.


Course Content

Module 1: Introduction to BI Concepts

  • Data Warehouse Architecture
  • Operational Data Source(ODS)
  • Datamart
  • Differences between OLTP and OLAP
  • Dimensional Model
  • Dimension and Fact Tables
  • Types of Dimension Tables
  • Types of Fact Tables
  • Star and SnowFlake Schemas
  • Approaches to build DWH

Module 2: QlikView Architecture

  • Source Systems
  • Qlikview Desktop
  • Qlikview Server
  • Qlikview Publisher
  • Qlikview Accesspoint
  • Qlikiview Clients

Module 3: QlikView Folder Structure

  • Scripts
  • Resources
  • QVD_Extract
  • QVDGeneratorExtract
  • QVW_Extract

Module 4: Edit Script

  • Script editing
  • Edit Script Toolbar
  • Edit Script Menu Commands
  • Statements Area
  • Edit Script Tool Pane
  • Syntax
  • Renaming a Field

Module 5: Creating the Script

  • Script generation
  • Creating a connection to the database(ODBC/OLEDB)
  • Reading tables or views or stored procedures into QlikView

Module 6: Structure the Script

  • Creating tabs in the script

Module 7: Data Structure of the Loaded Data

  • The Table Viewer
  • System fields
  • The system table

Module 8: QlikView Functions

  • Pick
  • Match
  • Applymap
  • Previous
  • Peek
  • Ceil
  • Floor
  • Valueloop
  • Valuelist
  • FirstSortedValue
  • Round
  • Abs
  • Date
  • Time
  • Reload
  • IntervalMatch
  • Aggregate Functions
  • Subfield
  • Purgechar
  • Keepchar
  • Replace
  • Evaluate
  • Autonumber
  • Rowno
  • Recno

Module 9: Data Relationships

  • Join
  • Inner join
  • Left join
  • Right Join
  • Outer join
  • Keep
  • Concatenation
  • Types of Join, Keep and Concatenation

Module 10: Scripting Considerations

  • Synthetic key tables
  • Circular references
  • Causes of circular references
  • Ways to Resolve Synthetic Keys and Circular Reference

Module 11: Adding Data From Other Sources

  • Text Files
  • Excel Files
  • CSV Files
  • Others

Module 12: Generating data in the QlikView Script

  • Resident Load
  • Creating data using Load Inline and Autogenerate
  • Inline tables
  • Autogenerate tables

Module 13: Cross Tables

  • Manual Process
  • Automated Process

Module 14: Mapping Tables

  • Mapping Quarters to the Orders table
  • MonthYear

Module 15: Different Types of Loads

  • Preceding Load
  • Resident Load
  • Generic Load
  • Info Load
  • Bundle info Load
  • Semantic Load
  • Intervalmatch
  • Partial Reload
  • Loading Data from Web Pages
  • Binary Load
  • Mapping

Module 16: QlikView Data (QVD) Files

  • QVD file format
  • Use of QVD files
  • Creating QVD files
  • Structure of QVD
  • QVD Modes
  • Optimized and Unoptimized Load

Module 17: Incremental Load

  • Initial Load
  • Calculating Modification Date
  • Incremental Load Process
  • Types of Incremental Load

Module 18: Creating a Calendar

  • Getting the Highest and Lowest date from the Orders table
  • Creating variables in the script
  • Creating the Master Calendar

Module 19: Handling Null Values, Changing Date and Number Format

  • Date#
  • Date()
  • Num#
  • Num()

Module 20: QlikView Security

  • Access control
  • Access levels
  • Access control database
  • Hidden script
  • Adding Section Access

QlikView Visualizations

Module 21: Sheets and Sheet Objects

  • Sheet Basics
  • Sheet Objects

Module 22: The List Box

  • Introduction
  • Creating a List Box
  • List Box in Action
  • Properties of the List Box
  • Exercise – List Boxes

Module 23: The Table Box

  • Introduction
  • Creating a Table Box
  • Selections in Table Boxes
  • Sorting in Table Boxes
  • More Table Box formatting options
  • Printing data from a table box
  • Exporting data from a table box to a text file
  • Exercises

Module 24: The Multi Box

  • Introduction
  • Selections in Multi Boxes
  • Creating a Multi Box
  • Resizing Multi Boxes
  • Formatting Multi Boxes
  • Exercises

Module 25: The Text Object

  • Introduction
  • Creating Text Objects
  • Formatting, Resizing, Copying and Moving Text Objects

Module 26: Charts

  • Chart Basics
  • Creating a Chart (Bar, Pie, Line etc…)
  • Selections in Charts
  • Changing the Chart Properties for Existing Charts
  • Common Chart Types
  • A Note About Mathematical Expressions
  • Exporting charts
  • References in charts
  • Excercises

Module 27: Multidimensional Charts and Pivot Tables

  • Straight Table with Multiple Expressions
  • Pivot Tables with Multiple Dimensions
  • Grouped bar charts
  • More about Pivot Tables and Straight Tables
  • Using a Dropdown Selection List
  • Using Visual Cues
  • Summary – Comparing Tables
  • Exercises

Module 28: Gauges

  • Why Use a Gauge Chart?
  • Types of Gauges
  • Building Gauges
  • Exercises

Module 29: Buttons

  • Buttons in QlikView
  • Creating and Formatting a Button
  • Shortcut Buttons
  • Launch/Export-Buttons

Module 30: The Other Sheet Objects

  • The Statistics Box
  • The Current Selections Box
  • The Slider/Calendar Object
  • The Input Box
  • The Bookmark Object

Module 31: Additional Editing in the Layout

  • Title Settings
  • Fast Change Chart Type
  • Legend Settings
  • Reference Lines / Text in Chart
  • Advanced Caption Settings

Module 32: Other Use of Expressions

  • Calculated Labels and Dynamic Text in Text Objects
  • Conditional Functions
  • Chart Attribute Expressions
  • Color Expressions
  • Calculated Fields in List Boxes
  • Calculated Dimensions in Charts

Module 33: The Settings Menu

  • User Preferences
  • Document Properties
  • Sheet Properties

Module 34: The QlikView Script: Desktop Data

  • Loading Data into QlikView
  • What data can QlikView read?
  • Structure of the Data Repository
  • The Edit Script Dialog
  • Executing the script
  • Loading files with the Table File Wizard
  • Renaming Fields while Loading

Module 35: Reports and Bookmarks

  • Introduction – Reports
  • QlikView Report Types
  • Managing Reports
  • Creating and editing reports
  • Introduction – Bookmarks
  • Bookmark Types
  • Managing Bookmarks
  • Creating Bookmarks

Module 36: Other Sheet Objects Set Analysis

  • Purpose of Set Analysis
  • Identifiers, Operators, Modifiers
  • Example Expressions
  • YTD and MTD
  • Indirect Set Analysis

Module 37: What-If Analysis

  • Creating Variable
  • Creating Slider Object
  • Assigning variable to Sheet Object and Slider Object

Module 38: Server Installation and Deployment

  • Installation
  • Types of Licenses
  • Types of CALS
  • Deploying the application in server
  • NTFS Mode file access
  • DMS mode file access
  • Session Collaboration

For more information email to info@msdynamicsconsulting.com