Qlikview

Qlikview Training In Bangalore Marathahalli & BTM Layout

We are Best Qlikview Training In Bangalore Marathahalli. Providing Advanced level Qlikview Training In Bangalore Marathahalli with most talented Trainers with 8 Years Experience. Get Real Time Experience on the Qlikview Training. We are the leading Software training Institute among Qlikview Training Institutes in Bangalore providing real-time Training Courses in Bangalore

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