Course Syllabus:

About the course: This 5 day intensive hands on course is ideal for beginners to QlikView. This course will provide a thorough introduction to QlikView through to more advanced topics such as advanced expressions, data transformations and data visualisation.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the QlikView.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Day 1

What is Qlikview?

• Brief history and technical overview of Business Intelligence and Qlikview
• The Qlikview Ecosystem
• Qlikview Server
• Qlikview Publisher
• Qlikview Desktop

Getting Started with Qlikview

• Download, install and open Qlikview
• Getting Familiar with Qlikview Desktop Client
• Features and components of Qlikview
• Architecture
• Report Interface
• QVS, QVW and .log files
• Sheet Objectst
• Dimensions and Expressions
• Presentation, Layout

Qlikview Basics

• Download, install and open Qlikview
• Start Qlikview 12
• The Qlikview Start Page
• Opening & Saving a document
• Selections Stepping back or forward in list of selection
• Locking and unlocking selections

Day 2

Overview of scripting

• Introduction to scripting
• Introduction to datasources
• Text files, Excel, Access datasources
• Connecting to your database

Data Modelling

• Overview of the data model
• Load and manipulate new data sources
• Data load from Excel
• Relationships in your data
• Creating Inner Joins
• Synthetic keys
• Circular References
• Qlikview Expressions
• Qlikview Functions

Qlikview Data Files (QVD)

• What is a QVD File?
• Modes of QVD Files – Optimised and Unoptimised loads
• Role of QVD File in Qlikview Architecture
• How to create a QVD file
• QVD File Loader script
• Using QVD Files
• Advantages of using QVD files

Master Data Calendar

• What is a master data calendar?
• How to create a master data calendar

Day 3

Qlikview Security

• Understanding Qlikview security
• Authentication and Authorization
• Security Architecture
• Security using Qlikview Publisher
• Access Levels
• Row Level Security

Qlikview Sheets and Object

• What is a Qlikview Sheet
• Navigating in a Qlikview Sheet
• Qlikview Sheet and Object Association

Boxes

• The List Box
• Statistics Box
• Multi Box
• Table Box

Charts

• Overview of Qlikview Charts
• Bar Chart
• Pie Chart
• Combo Chart
• Line Chart
• Other Chart Types