Course Content

Demo Video  Course Content  Interview Questions 

 

DATAWARE HOUSING CONCEPTS

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