Qlik View Developer

Course details

QlikView is a business discovery platform that provides self-service BI for all business users in organizations. With QlikView you can analyze data and use your data discoveries to support decision making. QlikView lets you ask and answer your own questions and follow your own paths to insight. QlikView enables you and your colleagues to reach decisions collaboratively.
At the core of QlikView is our patented software engine, which generates new views of data on the fly. QlikView compresses data and holds it in memory, where it is available for immediate exploration by multiple users. For data sets too large to fit in memory, QlikView connects directly to the data source. QlikView delivers an associative experience across all the data used for analysis, regardless of where it is stored. You can start anywhere and go anywhere; and are not limited to pre-defined drill paths or pre-configured dashboards.

At E-Learnify, we have successful track record of providing quality education on Qlikview Online Training, Qlik View Certification and Qlik View Course to the students based in USA, UK, Australia, New Zealand, Qatar, Oman, Baharin,Saudi Arabia, UAE, Kuwait, Abu Dhabi

DATAWARE HOUSING  CONCEPTS
INTRODUCTION

• What is Qlikview?
• Why Qlikview?
• Unique Features compared to Traditional BI Tools
• Complete Dataware Housing Basics

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.

Updated on 01 August, 2018