QLIKVIEW

  • 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

QUICK ENQUIRY