QlikView Course Content

Data warehouse Concepts:

  •  Basics of Data Warehousing.
  • What is ETL.(DaraMerging,DataAggrygation,Datascrubbing,Data cleansing)
  • Data warehouse Architecture
  • Data mart

Dimensional Modeling Concepts:

  •  Introduction to Dimensional Modeling.
  • Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling
  • Dimensional table
  • Fact table
  • Star schema
  • Snowflake schema
  • Star schema Vs. Snowflake schema
  • Fact Vs. Dimension table
  • Fact Vs. Aggregate Table
  • Types of Facts
  • Types of Fact tables
  • Types of Dimensions
  • Level of Granularity
  • Slowly Changing Dimensions( SCD )
  • Normalization De Normalization

QlikView Introduction:

  •  What is QlikView?
  • Why QlikView is most effective than other BI Tools.
  • QlikView Architecture.
  • QlikView Components.
  • Qlikview Desktop Developer.
  • How data flows in QlikView.

Scripting:

  • Creating Etractor
  • Concatenate.
  • NoConcatenate
  • Auto Concatenate
  • Joins Vs Keep
  • About Synthetic keys.
  • About Circular references
  • About Set & Let
  • Mapping Load
  • Look up
  • Link Table
  • Binary Load
  • Exist  & Not Exist
  • Set Analysis
  • Incremental load
  • Partial load
  • Inline Load
  • Security
  • Section access
  • Interval match
  • Master Calendar
  • About qualify and unqualified
  • Basic Aggregation Functions.
  • String Function.
  • Counter Functions.
  • Advanced Aggregation.

Modeling:

  • Table Viewer.
  • Modeling Techniques and Best Practices.
  • Creating Star Schema
  • Creating SnowFlake Schema.

QVD File:

  • How to create a QVD File.
  • Reading data from QVD Files.
  • Storing QVD By Variable.

Incremental Load:

  • Insert.
  • Insert and Updates.
  • Incremental Load through a QVD File.
  • Preceding Load.

Hierarchies:

  • Drill Down group.
  • Cyclic Group WithExpressions.

QlikView -Set Analysis and Alternate State:

Transformations in QlikView:

  • User Preferences.
  • Document Properties.
  • Sheet Properties.
  • Sheet Objects:
  1. List Box.
  2. Statistic Box.
  3. Multi Box.
  4. Table Box.
  5. Charts.
  6. Input Box.
  7. Current Selections Box.
  8. Buttons.
  9. Text Object.
  10. Bookmark Object.

Other Features we provide:

  • Real Time Scenarios
  • Resume Preparation
  • Provide Sample Resumes
  • Interview FAQ’S
  • Conduction Mock Interviews
  • Class notes which is useful for who is trying for job.