Qlikview Online Training

Qlikview Online Training

  • ABOUT THE COURSE
    • Course Duration

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

      Training Materials

      1. Well designed study materials, lab manuals and practice sessions
      2. Online demos
      3. High quality video lectures
      4. Live webinars from expert instructors
      5. Case studies and project oriented examples

      What’s Needed to Join This Course?

      1. Basic knowledge of programming concepts
      2. 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

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

      Why NORTH TECH SYSTEMS?

      1. Training by experienced professionals and industry experts
      2. Live examples and case studies discussed in depth to impart greater knowledge on the subject
      3. Cost effective fee structure
      4. 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

      1. Import/Export Sheet and Document Layouts as XML
      2. Qlik Wholesale Trade (QWT) Project Plan
      3. Project Plan Review
      4. SAFE Methodology

      DEPLOYMENTS

      1. QlikView Standalone
      2. QlikView Server
      3. QlikView Publisher

      INTRODUCTIONS TO DATA AND SCRIPTING

      1. Relational Databases
      2. Other Data Structures
      3. Comparing Database Structures to QlikView Data Structures
      4. Data Structures in QlikView
      5. Data Source Files
      6. The QWT Primary Data Source
      7. The QWT Secondary Data Files
      8. Introduction to Scripting

      BASIC SCRIPT SYNTAX

      Syntax

      LOADING DATA FROM THE DATABASE

      1. Script Generation
      2. Comments in the Script
      3. Script Debugging

      STRUCTURING THE SCRIPT

      Creating Tabs in the Script

      BASIC DATA MODEL AND TABLE VIEWER

      1. The Table Viewer
      2. The System Table
      Document Properties:

      BASIC DATA TRANSFORMATION

      1. Load Statement
      2. Renaming a Field
      3. Script Expressions
      4. Loading an XML File
      5. Renaming Fields Using the Qualify Statement
      6. Key Fields
      7. Example Predicament
      8. How Does this Affect You?
      9. Loading a Field into a Table Multiple Times
      10. Using a Record Counter on Key Fields
      11. Is it Correct?

      ADDING TEXT DATA

      1. Employees
      2. Offices
      3. Script generation using the File Wizard

      GENERATING DATA IN THE QLIKVIEW SCRIPT

      1. Resident Load
      2. Using Orders to determine Sales Person.
      3. Include
      4. Time Functions: Creating a Calendar
      5. Getting the Highest and Lowest Date from the Orders Table
      6. Autogenerate tables
      7. Creating Variables in the Script
      8. The Master Calendar

      SCRIPTING CONSIDERATIONS

      1. Synthetic Key Tables
      2. Circular References
      3. Causes of Circular References
      4. Check the Numbers
      5. QLIKVIEW DATA (QVD) FILES

      6. QVD File Format
      7. Use of QVD Files
      8. Creating QVD Files
      9. Manual Creation of a QVD File in the Script
      10. Automatic Creation of a QVD File in the Script
      11. QVD File Script Functions

      REPORTING BUGS IN QLIKVIEW

      ADDITIONAL INFORMATION

      1. Reference Materials
      2. Data types in QlikView

      APPENDIX: LAYOUT BASICS FOR DEVELOPERS

      1. User Friendly Design
      2. Natural Human Behavior
      3. Chart and Object Choices in QlikView
      4. Import/Export Sheet and Document Layouts

      APPENDIX: The Completed Script

  • ROADMAP
  • REVIEWS
    • “I have completed my Qlikview training here and I am completely satisfied with the quality of training and support given.” – Mohita
      “Great faculty delivering excellent lectures. I am now very confident to implement Qlikview skills learnt.” - Vasudevan
  • FAQ's
    • Content will be coming soon

Copyrights @2018-All rights reserved