Course Content
Structuring Data
- are written in a standardised and highly structured way
- can be easily understood by anyone familiar with The QlickiT Methodology
- can be easily amended or added to; and
- provide a structure which makes incremental load and consolidation of different data sets simpler
Load data from database sources
Convert data into a standard QVD format
Understand the difference between Dimension and Transaction tables
Join tables using a link table
Create a common calendar
Use the standardised approach and templates defined in The Methodology
Manipulating Data
- Create a new QlikView document from a Script file
- Load data from database and other data sources
- Specify selection criteria to Extract only the data required for your application
- Format and Transform the data into the format required by your application
- Concatenate and Join tables
- Add data using Mapping tables and the ApplyMap function
- Create Map Tables with an Inline Load
- Add Calculated fields and create Flags
- Use the standardised approach and templates defined in The Methodology
