This course aims to provide the QlikView developer with the necessary knowledge and skills. Participants, through a combination of theory and practice, will learn how to: • Extract, transform and load data • Create and optimize a data model The course requires prior basic knowledge of QlikView graphic interface.
QlikView architecture
• Creation and distribution of a QlikView document
• Distribution methods
Creation of a data model
• Star schema / Snowflake schema
Loading data from different sources
• Database
• Excel file
• Web pages
Data loading instructions
• SQL Select … From /Preceding Load
• Load … From
• Load … Resident
• Load … Autogenerate
• Load Inline
Debugger
Table viewer
Synthetic keys
Circular references
Variables and dollar-sign expansion
Creating values classes
• Class function
• IntervalMatch
Creating a calendar
Optimizing data model and table functions
• Mapping
• Join
• Concatenate
Set Analysis
Alternate states
Handling multiple fact tables
• Link Table
• Concatenate
QVD and incremental load
Section Access
Ad hoc
Contatti
