QLIKVIEW COURSE

Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed molestie, velit ut eleifend sollicitudin, neque orci tempor nulla, id sagittis nisi ante nec arcu.

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

CONTACT US

Free Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Premium Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.