Qlikview Course Syllabus

Introduction

• What Is Qlikview?
• Why Qlikview?
• Unique Features Compared To Traditional BI Tools
• Complete Dataware Housing Basics

qlikview products

• Desktop
• Server
• Publisher
• AccessPoint

Roles involved

• Developer
• Designer
• Administrator

Deployment process

• Standalone
• Server
• Publisher

Introduction to data and scripting

• Relational Databases
• Dimensional Data Structures
• Comparing Data Models To QlikView Data Model
• Data Structures In QlikView
• Data Source Files
• The QWT Primary Data Source
• The QWT Secondary Data Files
• Edit Script Explanation

Loading data from the database

• Script Generation
• Comments In The Script
• Script Debugging

Structuring the script

• Creating Tabs In The Script

Basic data model and table viewer

• The Table Viewer
• The System Table
• Explanation Of Document Properties

Basic data transformation

• Load Data From Multiple Data Sources
• Renaming A Field
• Script Expressions
• Loading An XML File
• Renaming Fields Using The Qualify Statement
• Key Fields
• Loading Generic Tables
• Including Images And Media Content
• Loading A Field Into A Table Multiple Times
• Using A Record Counter On Key Fields
• Loading Cross Tables And Info Tables
• Handling Null Values
• Changing Date Formats
• Changing Metadata
• Complete Discussion About Concatenation
• Resolving Synthetic Keys
• Resolving Loops
• Preparing QVD Files
• Performing Incremental Loads
• Optimization Techniques At Script Level