QlikView Training

BY
Mindmajix Technologies

Mode

Online

Duration

25 Hours

Fees

₹ 9600 12000

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based
Frequency of Classes Weekdays, Weekends

Course and certificate fees

Fees information
₹ 9,600  ₹12,000
certificate availability

Yes

certificate providing authority

Mindmajix Technologies

The syllabus

Module 1 - Introduction Qlikview

  • QlikView
  • Data Warehousing
  • Business Intelligence Tool
  • What makes Qlikview  Special, on need to know basis?
  • Products Overview
  • Architecture Overview
  • QlikView Platform Overview
  • Charts: Common Types
  • Collaboration of tables through SQL
  • Qlikview data Visualization tool explained

Module 2 - Data Extraction from SQL Server & Excel and Creating QVD

  • Practical session of Qlikview
  • Creating a new Dashboard
  • QVD maker, OLE DB, 
  • Data Extraction from SQL Server
  • ODBC plug-in, Datasource to SQL Server, Example of Survey DB

Module 3 - Data Modeling in QlikView

  • How to create a data Transformation Layout
  • Data Modeling, Directory, Qualify

Module 4 - QlikView Tables

  • Data Model/Internal Table view, 
  • Inline Table

Module 5 - Qlikview Loads

  • Resident Load
  • Incremental Load, Transform Layer
  • Buffer Load
  • Partial reload

Module 6 - QlikView Visualization

  • Visualization mode    
  • Months functions for example  
  • V - Layer
  • Design of themes    
  • Background image for ppt    
  • Default Theme
  • DashBoard    
  • Employee Expense and report 

Module 7 - Introduction to QlikView Boxes

  • Listbox    
  • Horizontal and vertical Listbox    
  • Statistics box    
  • MultiBox    
  • Current selection properties  
  • Button properties
  • Input box    
  • Tablebox    
  • TableBox properties

Module 8 - Introduction to Viz and other Controls

  • Cashflow Dashboard    
  • Line/Arrow    
  • Slider/calinder object properties

Module 9 - Objects

  • Book mark object
  • Container object

Module 10 - QlikView Charts

  • Chart properties
  • Dimensions
  • Radar Chart
  • Mekko chart
  • Block chart
  • Funnel chart
  • Pie chart
  • Scatter and grid chart
  • Mini chart
  • Gauge chart
  • Straight and Pivot table
  • Straight and Pivot table

Module 11 - Guage

  • Linear Guage in stud table  
  • Circular Guage
  • Chart with multiple variations   

Module 12 - QlikView PEF Report

  • Creating a report in QlikView  
  • Button properties

Module 13 -If else Condition

  • Scenario-based conditional calculations  
  • If condition, wild match
  • Optimized load

Module 14 -Nested IF else Condition

  • Nested If else condition  
  • Conditional colouring    
  • Set analysis

Module 15 - Mapping Load

  • Apply Map        
  • Mapping load    
  • User identification    
  • Section access

Module 16 - Objects

  • Object visible or invisible    
  • Section Access    
  • Different actions and triggers
  • Select Excluded    
  • Set variables   

Module 17 - Functions in Qlikview

  • Review of Data Model Preparation
    Discussion on Functions
  • Exists
  • ApplyMap
  • WildMatch         
  • Other important functions with examples
  • Examples On Accumulation
  • Concept Of Accumulation
  • Practice on charts
  • Pivot Table
  • Straight Table
  • Difference

Module 18 - Scenarios in Qlikview

Set Analysis
  • Writing Set Analysis expressions in the chart
  • Syntax structure
Task
  • Top 5 and Bottom 5 Records.
  • Alternate state

Module 19 - Section Access

Section Access
  • Concept of Section Access
  • Why Section Access is necessary in Qlik View (QV)
  • Type of Section Access
    • NT NAME
    • USER ID
  • Demonstration of Section Access
  • Document Level SA
  • Sheet Level
  • Data Level

Module 20 - Actions and Triggers

  • Button Object
  • Text Object

Module 21 - Project Explanation

  • Demostration on Past Application
  • Project Explanation

Module 22 - Practice Test & Interview Questions

Instructors

Mr Rasool
Instructor
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses