Qlikview Developer

Overview

This training course on Qlikview allows participants to quickly build and position analytic apps without any need for professional development skills, routing faster response to changing business requirements, and less time to value, with more insight throughout the organization. In this training course, participants will learn about system management with data visualization and design best practices for building better experiences with guided analytics.
Duration
6 Days

Pre-Requisites
  • Participants must have basic knowledge of DWH and BI Concepts
  • Participants must have dimensional Modelling and ER Modelling basics
  • Participants must have basic of T-SQL Query programming

    • Course Outline

    • Qlik Business Discovery
    • Qlik Project Methodology Framework
    • Qlik Project Plan
    • QlikSense Server Tokens
    • Getting started with the data
    • The Relational Database Management Systems (RDBMS)
    • The Snowflake Schema
    • The Star Schema
    • Extracting data from databases, data files and Web Files
    • Extracting the data from Sharepoint sites and lists
    • The Data Model Viewer
    • Script Editor
    • Loading Data to Script Editor
    • Connecting to Databases
    • Basic Script Syntax
    • Basic Data Manipulation
    • Arranging Script: Comments and Tabs
    • Script Debugger
    • The Table Viewer
    • System Tables and System Fields
    • The File Wizard and Script Generation
    • The Qualify Statement
    • Key Fields
    • Count and Sum
    • Resident Load
    • Include Files
    • The Data Market
    • Managing Data Table Associations – Data Profiling
    • More About Synthetic keys
    • Composite Keys
    • Identifying and Eliminating Circular Reference
    • Loosely Coupled Tables
    • Date and Time Functions
    • Building the Master Calendar
    • Using Flags
    • Data and Date Islands
    • The Mapping Syntax
    • Cleaning up Structure
    • Link Tables and Concatenated Tables
    • Interval Match
    • Class
    • If Statement
    • Cross Tables
    • Set Analysis
    • Variables
    • Dollar-Sign Expansion
    • Aggr Function
    • Master Items
    • Tags
    • Comments
    • Rename
    • Null Functions
    • HidePrefix, HideSuffix
    • QVD File Format
    • Use in QVD Files
    • Store QVD
    • QVD File Script Functions
    • Building the Data Layer
    • Performance Tuning
    • Best Practises for File Optimization
    • Discussing Qlik Framework and Solution
    • Installing Qlik Framework
    • Building Folder Structure
    • Best Practices

    Stay updated about us!