QlikView Training in New York

BY
Mindmajix Technologies

Mode

Online

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

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

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

Data Modeling in QlikView

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

QlikView Tables

  • Data Model/Internal Table view
  • Inline Table

Qlikview Loads

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

QlikView Visualization

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

Introduction to QlikView Boxes

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

Introduction to Viz and other Controls

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

Objects

  • Book mark object
  • Container object
Object visible or invisible
  • Section Access    
  • Different actions and triggers
Select Excluded
  • Set variables    

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

Guage

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

QlikView PEF Report

Creating a report in QlikView
  • Button properties

If else Condition

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

Nested IF else Condition

Nested If else condition
  • Conditional colouring    
  • Set analysis

Mapping Load

  • Apply Map        
  • Mapping load  

Mapping load

User identification
  •   Section access

Functions in Qlikview

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

Scenarios in Qlikview

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

Section Access

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

Actions and Triggers

Actions on Objects
  • Button Object
  • Text Object
Triggers
  • Different Triggers

Project Explanation

  • Demonstration on Past Application
  • Project Explanation

Practice Test & Interview Questions

Instructors

Mr Rasool
Instructor
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books