QlikView Training 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, 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
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 7+ Years of Experience.
- Strong Theoretical & Practical Knowledge.
- Certified Professionals with High Grade.
- Well connected with Hiring HRs in multinational companies.
- 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
