QlikView

QlikView

Qlikview online training course content
1. Data warehouse Concepts
• Basics of Data Warehousing
• OLTP and OLAP systems
• Data Warehousing Architecture
• Dimension and Fact Tables
• Star Schema and Snowflake Schema

2. Introduction to QlikView
• Traditional BI and QlikView
• QlikView In-memory Analysis
• Sample QlikView Demo Application
• What is Dashboard and Analysis?
• QlikView Flavors
• QlikView Architecture
• QlikView Components

QlikView Desktop Developer
QlikView Server
QlikView Publisher
QlikView Access Protocol
• Downloading and Installing of QlikView Software
• QlikView Data Sources

3. Scripting
• Script menu commands
• Edit script Toolbar/Editor
• System Variables
• Data Extraction(Various sources)
• Script Editing
• Renaming of fields
• Executing script
• Debugging, Tracing and trouble shooting
• Data Modeling
• Types of data modeling
• Storing data into QVD files.

4. Calendar
• Generation of calendar
• Date and Time functions

5. Functions and Expressions
• QlikView Functions
• Expressions
• Joins
• Keep (left and right)
• Aggregation of data at script
• Concatenation
• Variables
• SET and LET

6. Interacting with QlikView Objects
• List Box
• Multi Box
• Table Box
• Current selection Box
• Text Object
• Calendar/Slider Object
• Input Box
• Line/Arrow Object
• Button
• Statistics Box
• Bookmark Object
• Search Object
• System Table

7. Interacting with QlikView Objects with All Properties(Charts)
• Bar Chart
• Line Chart
• Combo Chart
• Radar Chart
• Mekko Chart
• Grid Chart
• Scatter Chart
• Pie Chart
• Funnel Chart
• Block Chart
• Straight Table
• Pivot Table
• Container Box

8. Interacting with QlikView Objects(Charts II)
• General – Calculation Condition
• Error Message
• Fast Change
• Trellis Chart
• Expression – Mini Chart
• Accumulation/No Accumulate
• Trend Lines

9. Interacting with QlikView Script
• Mapping Load
• Binary Load
• Exists
• Synthetic Key
• Loop/Circular Reference
• Cyclic and Drilldown Groups
• Expression Grouping
• Joins in QlikView

10. Set Analysis
• What is Set Analysis and Alternate States?
• Why and how do we use it?
• Identifiers, Operators and Modifiers
• Examples

11. Interacting with QlikView
• Sheet Properties
• Document Properties
• Conditional Display of Object and Sheet
• Triggers
• Hidden Script

• Preceding Load
• Load Inline Data
• Indicators
• Incremental Load
• Interval Match

12. Security
• What is security?
• Type of Implementation
• Security based on User ID
• Security based on NTNAME

13. Type of Licenses
• Names CALS
• Document CALS
• Session CALS
• Usage CALS

14. Creation of Demo Application
• What is BRD?
• Technical Specifications
• Creation of Dashboard and Reports
• Implementation of security

15. Access of Application
• Access by Access point
• Access by QlikView Developer

16. QlikView Best practise