ABOUT THE COURSE

Course Duration

40-45 hours (8 hours of content) interactive e-learning sessions providing real time experience

Training Materials

• Well designed study materials, lab manuals and practice sessions
• Online demos
• High quality video lectures
• Live webinars from expert instructors
• Case studies and project oriented examples

What’s Needed to Join This Course?

• Basic knowledge of programming concepts
• Database knowledge – TSQL, data modeling, data warehouse, etc.

Who Are Ideal Candidates?

This course provides comprehensive training on Qlikview Software. The topics include QlikView Overview, Qlikview Application, Deploying Qlikview applications, etc. The course allows analyzing data and making informed data driven decisions. The data modeling functions and data loading enables to integrate data from various sources on one platform.

The candidates looking for career in software, IT graduates and working professionals can enroll for this course.

Course Info

This course teaches all the concepts with practical tutorials to make you a professional QliKView developer. The course does not require prior programming skills. The basic understanding of SQL serves as an advantage. The course starts with basic introduction about the Qlikview and gradually explaining QlikView scripting concepts. Each section has a quiz to test the level of knowledge.

Highlights Of The Course

• Extensive learning through project work, case studies, assignments and quizzes
• Training by industry experts with the real-time experience
• 24*7 technical support during course hours
• Certificate oriented training program
• Well researched content/syllabus
• One-to-one, interactive, practical sessions

Why VRP CORP SOLUTIONS?

• Training by experienced professionals and industry experts
• Live examples and case studies discussed in depth to impart greater knowledge on the subject
• Cost effective fee structure
• Assistance in resume preparation and job placement after successful completion of course

CURRICULUM

Traditional BI tools vs Qlikview

• In-Memory technology
• Architecture of Qlikview

QLIKVIEW ENVIRONMENT

QlikView Desktop

QLIKVIEW DEVELOPMENT METHODOLOGIES

• Import/Export Sheet and Document Layouts as XML
• Qlik Wholesale Trade (QWT) Project Plan
• Project Plan Review
• SAFE Methodology

DEPLOYMENTS

• QlikView Standalone
• QlikView Server
• QlikView Publisher

INTRODUCTIONS TO DATA AND SCRIPTING

• Relational Databases
• Other Data Structures
• Comparing Database Structures to QlikView Data Structures
• Data Structures in QlikView
• Data Source Files
• The QWT Primary Data Source
• The QWT Secondary Data Files
• Introduction to Scripting

BASIC SCRIPT SYNTAX

Syntax

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

Document Properties:

BASIC DATA TRANSFORMATION

• Load Statement
• Renaming a Field
• Script Expressions
• Loading an XML File
• Renaming Fields Using the Qualify Statement
• Key Fields
• Example Predicament
• How Does this Affect You?
• Loading a Field into a Table Multiple Times
• Using a Record Counter on Key Fields
• Is it Correct?

ADDING TEXT DATA

• Employees
• Offices
• Script generation using the File Wizard

GENERATING DATA IN THE QLIKVIEW SCRIPT

• Resident Load
• Using Orders to determine Sales Person.
• Include
• Time Functions: Creating a Calendar
• Getting the Highest and Lowest Date from the Orders Table
• Autogenerate tables
• Creating Variables in the Script
• The Master Calendar

SCRIPTING CONSIDERATIONS

• Synthetic Key Tables
• Circular References
• Causes of Circular References
• Check the Numbers

QLIKVIEW DATA (QVD) FILES

• QVD File Format
• Use of QVD Files
• Creating QVD Files
• Manual Creation of a QVD File in the Script
• Automatic Creation of a QVD File in the Script
• QVD File Script Functions

REPORTING BUGS IN QLIKVIEW

ADDITIONAL INFORMATION

• Reference Materials
• Data types in QlikView

APPENDIX: LAYOUT BASICS FOR DEVELOPERS

• User Friendly Design
• Natural Human Behavior
• Chart and Object Choices in QlikView
• Import/Export Sheet and Document Layouts

APPENDIX: The Completed Script