Welcome to Wings Academy

QLIKVIEW TRAINING

QLIKVIEW TRAINING

QlikView With SAS Training

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, factless, 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,multi-box
  • Calculation and expressions
  • Reporting formats
  • Server setup
  • Publisher
  • Alerts
  • Bookmark

Trainer Profile of QlikView Training

Our Trainers provide complete freedom to the students, to explore the subject and learn based on real-time examples. Our trainers help the candidates in completing their projects and even prepare them for interview questions and answers. Candidates are free to ask any questions at any time.

  •  More than 10+ Years of Experience.
  •  Strong Theoretical Practical Knowledge.
  •  QlikView Certified Professionals with High Grade.
  •  Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
  •  Trainers have Experienced on multiple real-time projects in their Industries.
  •  Our Trainers are working in multinational companies such as CTS, TCS, HCL Technologies, ZOHO, Birlasoft, IBM, Microsoft, HP, Scope, Philips Technologies etc
  •  Strong Theoretical & Practical Knowledge.
  •  Certified Professionals with High Grade.
  •  Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
  •  Trainers have Experienced on multiple real-time projects in their Industries.