QlikView Course 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

Corporate Training

Software Testing (QTP / Selinium)

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make.

SWIFT / IOS

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make.

Informatic, ETL, Hadoop

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make.

WebSphere, PHP, Angular JS

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make.

Java, Adv Java, .NET, LINUX Admin

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make.

Tableau / Qlikview

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make.

AutoCAD, REVIT

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make.

SQL /PL SQL / DB2

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make.

Website Development

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make.

Contact us to Take FREE Demo Class

bigrock reviews