• USA
  • Canada
  • Europe
  • Australia
  • :
  • +1-972 850 7774
  • India
  • 951 333 1341 / 42

Qlikview Training in Bangalore

Lorem ipsum dolor sit amet, consetetur sadipscing elitr

  • Date Posted

    January 30, 2017

Qlikview Training in Bangalore

Learn how to use QlikView® from beginner level to advanced techniques which is taught by experienced working professionals. With our QlikView Training in Bangalore you’ll learn concepts in expert level with practical manner.

QlikView Training Syllabus:

Data Warehouse Concepts:

• Introduction of Data Warehouse
• Need arise of DWH
• OLTP V/S DWH
• OLTP V/s OLAP
• Data Warehouse /Data Marts Architecture
• Staging/without Staging
• Dimensions (Simple and Confirm)
• Fact (Simple, fact less, coverage, confirm)
• Warehouse Implementation Methods
• STAR SCHEMA
• SNOW FLAKE SCHEMA
• Difference between STAR and SNOW FLAKE Schema.
• Other terminologies Cleansing, Purging etc.
• Database Modeling
• Designing Methods
• Logical Designing
• Physical Designing
• Introduction of Dimension Modeling
• Difference between ER-Modeling and Dimension Modeling
• Implementation of Dimension Model
• Forward Engineering and Reverse Engineering
• Introduction of various Database Components
• OLAP ?OLAP/MOLAP/HOLAP

QlikView data structures:

• Data structures in QlikView (AQL).
• Sample Application walkthrough of QlikView
• Architecture and components of QV
• In-memory BI /OLAP

• Menu Commands and Syntax
• Handling DATA SOURCE FILES
• The QWT (Access File example) primary data source
• The QWT (Access File example with QVD Conversion) secondary data files
• Script generation
• Creating a connection to the database
• Reading tables into QlikView
• Big data Analytics
• Connecting of Qlikview with Bigdata hadoop

ADVANCED SCRIPTING:

• Condition on a field in a table
• Aggregating Data in Script (Resident Load and Group Function, Order By etc)
• Joining tables (Left, Right, Inner, Outer Joins)
• Concatenation
• Sheet Basics:
• Sheet Objects
• Text,list,chart,graph
• Multidimensional,gauges,multibox
• Calculation and expressions
• Reporting formats
• Server setup
• Publisher
• Alerts
• Bookmark
• Loading data from multiple datasources:
• Script editing

Course Not Available For Subscribe.

For more information please contact system administrator.

Jobs in Bangalore
Best Training

Quick Enquiry

Best Online Training Courses