Qlikview Training in Electronic City
Let eMexo Technologies Best QlikView Training in Electronic City Bangalore take you from the fundamentals of QlikView to Advance QlikView and make you an expert in developing real time QlikView applications. Here are the major topics we cover under this QlikView course Syllabus Data Warehouse Concepts, QlikView data structures, Advanced scripting. Each topic will be covered in practical way with examples.
All the topics will be covered with Practical and hands on training. Our trainers have industry experience with live project experience in cutting edge technologies which they teach. We hire only Best QlikView industry specialists as trainer for our QlikView trainings.
Come over to our training institute for a free demo class. Let our trainer give you a demo on QlikView and only then you take the decision to enroll into the training program.
Qlikview Training Features
FAQs
Book your free demo class today
-
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
- SNOWFLAKE SCHEMA
- Difference between STAR and SNOWFLAKE 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 data sources
- 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 Big Data 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