Qlikview

1. QlikView Overview

• What is QlikView?
• Business Intelligence (BI) & Business Intelligence Tools
• Types of Business Intelligence Tools
• Difference between QlikView and other Tools.

2. Data Base Drivers

•  ODBC (Open Database Connectivity)
•  OLEDB (Object Linking and Embedding, Database)

3. QlikView script statements

• Joins
• Keep
• Concatenation
• Mapping
• Apply map
• Inline table
• Resident table
• Binary load
• As or alias
• Generic load
• Interval match
• Cross table
• Bundle info load
• Hierarchy table
• Unqualified & qualify
• Input field…etc

4.  Commenting Types

• Single line comment
• Multiline comment
• Rem

5. Synthetic Keys and Synthetic Keys Removing Methods
6. Circular loop or Circular references and Removing Methods
7. QVD Creation Methods
8. QVD Architecture
9. Variable Types and Variable Creation Methods
10. Set analysis
11. Section Access
12. Sheet Objects

• List Box
• Statistics Box
• Multi Box
• Table Box
• Input Box
• Current Selection Box
• Button
• Text Object
• Line/Arrow Object
• Slider/Calendar Object
• Bookmark Object
• Search Object
• Container
• Custom object

• Charts

• Bar Chart
• Line Chart
• Combo Chart
• Radar Chart
• Gauge Chart
• Makko Chart
• Scatter Chart
• Grid Chart
• Pie Chart
• Funnel Chart
• Block Chart
• Pivot Table
• Straight Table

13. Mini Chart & Trellis Chart
14. Incremental load
15. Groups
16. Relative Path and Associate Path
17. Inter Record Functions
18. Conditional Functions
19. Link Table
20. Alternate Sates
21. Folder Structure
22. QlikView Publisher/Server
23. Data Warehouse Concepts
24. Master Calendar
25. End to End Implementation