QlikView Course Syllabus

Table of Content

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

Contact Us

We are always here to guide you...

Quick Enquiry

Please enter name.
Please enter name.
Please enter valid email adress.
Please enter Course name.
Please enter your comment.

sitcomputerairoli@gmail.com

+91 9619 3417 13

+91 7506 4114 34

Website : www.sitcomputer.in

We Are Social