SQL Training

Qlik sense

Xtream Tech offers comprehensive instructor-led Live Online or On-demand video-based Training or Classroom Training on Qlik Sense. This 22-hour Qlik Sense training program is designed to incorporate the latest features of Qliksense. Upon successfully completing this training, you will be well-prepared for both the Qlik Sense Business Analyst certification and the Qlik Sense Data Architect certification. Our learning approach is hands-on, featuring practical labs, exercises, multiple use-cases/projects, and includes job-search assistance and Mock Interviews to position you as the ideal candidate for roles as a Qlik Sense data analyst or Data Visualization and Analytics expert.

Course Includes

22 Hours of Sessions

Flexible Schedules

24/7 Lifetime Support

FREE Demo on Request

One-on-One Doubt Clearing

Real-time Project Use cases

Contact Us for Qlik Sense Demo

Instructor- Qlik Sense live online Training Schedule

Flexible batches for you

SEP 16 WeekEnd SAT & SUN (5.5 Weeks) 07:00 AM to 10:00 AM (IST)
ORIENTATION CLASS
SEP 18 iuwegu MON – FRI (15 Days) 07:00 AM to 09:00 AM (IST)
CLASS 1
OCT 07th WeekEnd SAT & SUN (5 Weeks) 08:30 PM to 11:30 PM (IST)
CLASS 1
OCT 09th iuwegu MON – FRI (15 Days) 08:30 PM to 10:30 PM (IST)
CLASS 1

Price 17,795 16,015

SEP 16 WeekEnd SAT & SUN (5.5 Weeks)
07:00 AM to 10:00 AM (IST) ORIENTATION CLASS
SEP 18 MON – FRI (15 Days)
07:00 AM to 09:00 AM (IST) CLASS 1
OCT 07th WeekEnd SAT & SUN (5 Weeks)
08:30 PM to 11:30 PM (IST) CLASS 1
OCT 09th MON – FRI (15 Days)
08:30 PM to 10:30 PM (IST) CLASS 1

Price 17,795 16,015

Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You’ll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.

Starts at 16,015

Talk to our training advisor

Qlik Sense Online Training Content

At Xtream Tech, our Qlik Sense course provides in-depth, hands-on instruction in data management, transformation, modeling, and visualizations. Our Qlik Sense Online Training covers optimization techniques, advanced script functions, and the latest advanced features and visualizations. We are committed to delivering the most industry-relevant training to ensure that learners acquire the in-demand job skills essential in today’s competitive Data Science job market.

QlikView Course Syllabus

Curriculum Designed by Experts

DOWNLOAD CURRICULUM

Learning Objectives: In this module, you will get an overview of BI Tools and you will be introduced to QlikView. Further you will learn about its features and architecture.

Topics:

  • What is BI?
  • Introduction to Visualization
  • Different BI Tools
  • What is QlikView?
  • Features and components of QlikView
  • Architecture
  • Installation & Navigation
  • Data Ingestion
  • Report Interface
  • QVS, QVW and .log files
  • Sheet Objects
  • Dimensions and Expressions
  • Presentation/ Layout / Sort tabs

Hands-on/Demo:

  • Downloading and Installing QlikView
  • Creating a List Box
 
Learning Objectives: In this module, you will learn the need and different features of scripting. You will learn about script toolbar, adding/editing tabs, variables, fields, joins and keep.

Topics:

  • Need of Scripting
  • What is Scripting?
  • Script Toolbar
  • Script Menu Commands
  • QlikView Variables (Set,Let) and Fields
  • Creating tabs in the script
  • Adding Sheet Objects
  • Inline table
  • Function in QlikView (Sum, Avg, Count, Date, etc)
  • Joins: Inner, Left, Right and Outer
  • Understanding Keep command

Hands-on/Demo:

  • Edit Script
  • QlikView Operations: Concatenate, If statement
  • Create variables, Inline load, Functions and Joins
 
Learning Objectives: In this module, you will learn about different QV data file types and ways to resolve the synthetic keys and circular reference.

Topics:

  • QlikView Data File Types: QVD, QVX
  • System fields
  • Star schema
  • Synthetic Key Tables
  • Circular References & its causes
  • Ways to Resolve Synthetic Keys and Circular Reference
  • Using Qualify & unqualify
  • Link Table
  • Concatenation: Forced, Auto, No
  • Data Model optimization
  • Master Calendar

Hands-on:

  • Star Schema, Synthetic key, Circular reference
  • Concatenation, Qualify & Unqualify
 
Learning Objectives: In this module, you will learn how to modify the existing data to a new data format. You will learn about different types of loads and tables.

Topics:

  • Generating data in the QlikView Script
  • Different Type of Loads
  • Incremental load with QVD file
  • Column manipulation
  • Tables: Rotating, Straight and Pivot, Cross
  • Mapping Table
  • Security – Section Access and Control

Hands-on/Demo:

  • Preceding load, Resident load & Incremental Load
  • Rotating, Pivot, Cross & Mapping Tables
  • Security with Section Access
    Learning Objectives: In this module, you will learn to visualize the data in QlikView. You will also be able to add various advanced functions in the report.

    Topics:

    • Sheet Objects: Slider Text Box, Calendar Box, Current Selections Box
    • QlikView Advance Functions: Apply map, match, Peek, pick, lookup,exist, not exist, AGGR , rank, rangesum, class, date and date#, Valuelist
    • Chart object menu
    • Visualization Charts: Bar chart, line, combo, radar, scatter, grid, pie, funnel, block, gauge, mekko
    • Chart Formatting
    • Information density Subset Ratio and Perfect Key
    • Triggers
    • Alternate State
    • QlikView Management console: Server, Publisher

    Hands-on/Demo:

    • Advanced QV functions
    • QlikView visualization charts: Bar, line, Combo, Radar, Scatter, Pie, Grid, Funnel & Mekko
    • Chart Functions
      Learning Objectives: In this module, you will learn to analyze the data using set, indirect, and what-if analysis. You will also be learning about some advanced QV operations.

      Topics:

      • Set Analysis (Indirect Set Analysis, Identifiers, Modifiers & Operators)
      • What-if Analysis
      • Comparative Analysis
      • Dynamic Reporting or Ad-hoc Reporting.
      • Document Channing
      • How to select range of Dates
      • Information density Subset Ratio and Perfect Key
      • AND Mode
      • Document Analyzer
      • Exception Handling
      • Buffer load
      • Qlikview cals
      • Qlikview sap connector
      • Qlikview sales force connector
      • Macro
      • Geolocation
      • Web Connectors
      • Conditionally Enabling Dimensions

      Hands-on:

      • What-If Analysis, Comparative & Set Analysis

      Course Description

      QlikView Training and Certification is specifically designed for professionals who wants to learn QlikView for Business Intelligence and to bring visual insights to the data. This training covers all the concepts of QlikView such as Data Interpretation, Designing, Modelling and then dives into advance features such as analyzing the data, discovering the hidden data and generating interactive graphs and charts
      After completing this course, you should be able to:
      • Understand what is QlikView. How does it work? What makes it a useful tool in analytics domain?
      • Learn to edit scripts
      • Gain rich experience on generating data using QlikView scripts, working with sheet objects and creating dashboards
      • Use multiple charts, tables, synthetic Key tables and resolve the synthetic keys and circular reference
      • Understand data file types and incremental load
      • Perform object field formatting
      • Perform set, indirect and what if analysis
      QlikView is a Self-Service Business Intelligence, Data Visualization and Data Analytics tool.
      With this humongous amount of data and real business implications, business organizations across the world have the need for an easy to use tool to analyze the data and derive actionable insights from it.
      QlikView helps organizations to extract meaningful information and perform visualizations on the data. Many companies worldwide have truly transformed the way they uncover insights from data by using QlikView.
      This Qlikview Certification Training will help you become a Business Analyst with Qlikview. It will hone your skills by offering you comprehensive knowledge on Qlikview. It will also acquaint you with the required hands-on experience for solving real-time industry-based Qlikview projects. During this course you will be trained by our expert instructors on:
      • Visualization and modelling techniques
      • Performing chart and script expressions
      • Performing data analysis & transformation
      • Accessing multiple charts, tables, sheet objects in dashboard
      • Work on a real-life project
      The Qlikview Certification Training is for all the professionals who are passionate about Business Intelligence and want to go ahead and make their career as a Qlikview Business Analyst. It is best suited for individuals who are:
      • Business Analysts
      • Business Intelligence Manager
      • Data Scientist
      • BI /ETL/DW Professionals
      • Statisticians and Analysts
      • Graduates aiming to build a career in Visualization & Analysis
      There are no such pre-requisites for this course, but if you have some knowledge of file type, SQL, DWH, RDBMS then it will be beneficial.

      Free Career Counselling

      We are happy to help you 24/7

      Enroll Now
      close slider

      Please Fill your details

      Please Fill your details

      Note: Few seats left, Your batch starts in 5 days