BETA

Believe in yourself and you can do unbelievable things.

  • OVERVIEW:

     

    This Qlikview Training Course lets you master the Qlikview software in order to derive business intelligence and for discovering visual insights. . In this QlikView online training, you will learn the skills needed for data interpretation, modeling, designing, and deploying. Get hands-on experience in Qlikview applications.

     

    DURATION:

     

    20 hours

     

    OBJECTIVES:

     

    1. Implement Qlikview data modeling , visualization and Qlikview reporting
    2. Learn how to create qvd file in Qlikview Desktop
    3. Learn basic steps of transformation
    4. Learn about data and BI visualization
    5. Create different types of charts and integrate them in dash board for analysis
    6. Learn how Qlik reads data from various tables
    7. Understand Qlikview set analysis and how to implement it in Qlikview
    8. Understand chart level functions and script level Qlik functions
    9. Know Qlikview Security and Qlikview access points
    10. Develop a real-time project using Qlikview and prepare yourself for Qlikview Certification
    11. Prepare yourself for QlikView Developer Certification

     

    TARGET AUDIENCE:

     

    • Designers, Business Intelligence analysts and reporting professionals
    • Software developers , IT architects and Testing professionals
    • Those eager to build career in data visualization and discovery

     

     

    ELIGIBILITY:

     

    • Must have Computer Science Background - BE/ B-Tech / MCA / BCA / Bsc

    •  
    PRE-REQUISITES:

     

    • Understand basics of SQL
    • Download Free QlikView desktop from Qlik.com

     

     

     

  • COURSE STRUCTURE:

     

    LESSON 1: Introduction to QlikView                                                                                                                                                           3.5 hours

     

    • QlikView: Course Introduction                                                                                                                   
    • QlikView Overview                                                                                                                                      
    • Introduction to Relational Database (RDBMS)                                                                                               
    • SQL Basics                                                                                                                                              
    • Dimensions and Measures                                                                                                                          
    • Quiz 1

     

    LESSON 2: Introduction to Scripting                                                                                                                                                 2 hours 25 min

     

    • Install QlikView Desktop                                                                                                                                 
    • Lecture 7 Introduction to Scripting                                                                                                              
    • Connect to the Database, ODBC, OLEDB                                                                                                     
    • Script Syntax and Data Load                                                                                                                          
    • Load Fact Tables                                                                                                                                           
    • Quiz 2

     

    LESSON 3: Data Modeling Basics and Charts                                                                                                                          5 hours 50 minutes

     

    • Understanding data model                                                                                                                             
    • Synthetic Keys                                                                                                                                            
    • Remove Synthetic Key from the Data Model                                                                                                
    • Data load from an Excel file                                                                                                                           
    • How to resolve circular loops and synthetic keys                                                                                             
    • Editing in Script, Use of If Conditions                                                                                                              
    • Different types of Charts & Its Properties– Scatter Chart, Bubble Chart, Gauge Chart, Line Chart, Bar Chart, Pie etc.                                                                                                                                                          
    • Data Modeling Basics

     

     

    Section 4: Generating Data in the Script                                                                                                                                   5 hours 40 minutes

     

    • How to generate data in the script                                                                                                               
    • Generating data in the script using Resident load                                                                                         
    • Master Calendar                                                                                                                                        
    • Add Master calendar to the script                                                                                                                 
    • Mapping tables                                                                                                                                            
    • Add Mapping tables and Preceding load to the script                                                                                    
    • Quiz 4

     

     Section 5: Data Model Optimization                                                                                                                                                              2 hours

     

    • Joins vs Concatenate, Join Vs Keep                                                                                                           
    • Lecture 25 Join or Concatenate tables                                                                                                           
    • Optimize data model                                                                                                                                    
    • Create star schema                                                                                                                                     
    • Quiz 5

     

    Section 6: Data Model Challenges                                                                                                                                                1 hour 15 minutes

     

    • Cross tables                                                                                                                                                
    • Load data from Cross table                                                                                                                            
    • Link tables                                                                                                                                                  
    • Create a Link table                                                                                                                                        
    • Quiz 6

     

    Section 7: Scripting Considerations                                                                                                                                            6 hour 50 minutes

     

    • Slowly Changing Dimensions                                                                                                                      
    • Interval Match/ Class function                                                                                                                     
    • Introduction to Set Analysis                                                                                                                          
    • Set Analysis Basics                                                                                                                                  
    • Power of Set Analysis Part I                                                                                                                       
    • Power of Set Analysis Part II                                                                                                                       
    • AGGR function                                                                                                                                             
    • Functions- DATE(), DATE#(), PEEK(), MonthStart(), AutoGenerate(),  Quarter(), ceil()                                     
    • Adhoc Reporting                                                                                                                                       
    • Variable overview-Add variable                                                                                                                     
    • Quiz 7

     

    Section 8: Security & QMC                                                                                                                                                            1 hour 30 minutes

     

    • Introduction to document security                                                                                                               
    • Add Section Access                                                                                                                                

     

     

    Section 9: Qlikview Server Basics                                                                                                                                                1 hour 30 minutes

     

    • QMC-Qlikview Management Console                                                                                                              
    • Document Distribution                                                                                                                                   

     

     

  • Below mentioned training methodologies will be adopted while training:

     

    • Aim to provide contextually relevant, skill oriented and emotionally positive experiences via training
    • Continuous encouragement to the trainees to complete course
    • Elements:
      • Pre & Post Assessment
        • Objective and fair assessment of trainees post training
      • Demarcation between Theory and In class Practicals
      • Be as much interactive as possible
      • Encourage participants to share their ”burning questions” about the topic
      • Launching a poll question for participants to answer
      • Try to explain using famous models and studies
      • Incorporate Case based learning (case videos/ movies) and storytelling, if applicable
      • Integrate soft skills in the training, if applicable
      • Motivate learners to apply concepts from domain subjects in a real world situation
      • Practical Home work
      • Provision of skill Certification information to trainees, wherever applied and required
      • Encourage regular trainee interaction during , in-between and after the course
      • Aim to design a module that engages participants every 4 minutes
      • Encourage participants to use platform tools like Poll, Chat, Raise Hand, Screen Sharing etc.
      • Provision of learning/ reference material to the trainees
      • Regular post session response to the trainees
      • Record of participation and Certificate of achievement issued by EduSmart Skills
  • Frequently Asked Questions about QlikView

    All those who have computer science background

    We can customize the course in your desired time frame. Please contact our customer service team for details

    We would be happy to develop a course to meet your requirements.

    If you are aware of the classes or dates you may be missing, please inform the trainer in advance and we will be happy to reschedule it for you or provide you alternate options.

    Edusmart Skills is an online education platform and has no engagement in the job placement. However, our trainers will be glad to guide you in the right direction.

  • EDUSMART SKILLS CERTIFICATION

     

    The entire training course content is in line with respective certification program and helps you clear the requisite exams with ease and get the best jobs in the top MNCs.

    As part of this training you will be working on the assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.

    During the program there will be assessments that perfectly reflect the type of questions asked in the exams and helps you score better.

    EduSmart Skills Course Completion certificate will be awarded on the completion of course.

  • Students Reviews for QlikView