QlikView Online Training Real Time Projects and Scenarios
QlikView Online Training Real Time Projects and Scenarios
QlikView Course Content
OnlineTrainerAnand@gmail.com
BuddhaiSoft@gmail.com
+91-7799895236 +91-7207401404
Data warehouse Concepts:
- Basics of Data Warehousing.
- What is ETL
- 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:
- List Box.
- Statistic Box.
- Multi Box.
- Table Box.
- Charts.
- Input Box.
- Current Selections Box.
- Buttons.
- Text Object.
- 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.
Comments
Post a Comment