Qlikview - Developer 2 Day

Qlikview Developer 2 Day training Course in Belfast Northern Ireland

Course Outcomes

Delegates will learn:

• Data model
• Creation of the proper data connections
• Scripting fundamentals 

Course Outline

Working with Data Sources

• Using ODBC and OLE DB drivers
• Accessing custom data sources
• Extracting data-two hands-on examples
• Extracting data from Excel, CSV
• The resulting data model
• Loading a table file
• QVD and QVX files
• Loading an Inline table

Data Modelling

• Dimensional data modelling
• Relational databases and ER modelling
• Dimensional Modelling Schemas
• Dimensional models in QlikView
• How associations are created
• Avoiding data model conflicts
• The Table Viewer window
• Hands on sessions 

Qlikview Scripting Features

• The Script Editor
• Menu and toolbar
• Script pane
• Tool pane
• Script statements
• Synthetic keys
• Synthetic Key tables
• Composite keys
• Manipulating tables
• The Lookup Function
• Concatenate Function
• Joins
• Conditional functions
• Debugging script
• organizing script
• Re-using scripts

Data Transformation Basics

• Changing the source table structure
• Cleansing a dirty table
• File contents
• Working with the Transformation Step wizard
• The final result
• Expanding a hierarchy
• Working with the Hierarchy Wizard
• The tree-view list-box
• Generic load
• Loading a generic table into QlikView
• Comparative analysis
• A comparative analysis example 

Advanced Data Transformations

• Data architecture
• Two-stage architecture
• Loading data already stored in QlikView
• Cloning a QlikView data model
• Loading from RAM
• IntervalMatch Function
• Peek Function
• Hands on sessions
• 7: Securing Workbooks
• Access Control
• Access Levels
• Access Control Database
• Inherited Access Restrictions
• Hidden script
• Adding Section access
• Section access fields
• Reduction fields
• Initial data reduction
• Omitting fields
• Document-level security
• Sheet-level security

Macros and Automation

• Using Automation Macros
• Internal Macro Interpreter
• Getting hold of a QlikView Document
• VB Script Functions
• Using macros in QV document