QlikView Training in Dallas

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    
    • User identification    
      • Section access

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

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

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

Actions and Triggers

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

Project Explanation

  • Demostration 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