QLIKVIEW TRAINING IN TRICHY

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
• Loading data from multiple datasources
• Script editing
• 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