Building analytical reports based on the QlikView BI platform - course RUB 40,490. from Specialist, training, Date: March 17, 2024.

You will learn:
Create and customize QlikView documents.
Load and convert data in various formats: database, Excel and XML.
Create and use QVD files for loading.
Aggregate data in different sections.
Manipulate data tables (attach tables to the left, right, bottom).
Optimize and debug the download script.
Design an optimal data model by resolving structural problems.
Design data storage layers.
Perform complex calculations in interface objects.

Module 1. Getting started with the Script Editor (3 ac. h.)
A brief overview of the QlikView architecture.
Load script editor. Key settings.
Table browser and its capabilities. Service information fields.
Introduction to variables in the load script. LET and SET operators.
Overview of options for connecting to data sources.
Dynamic script substitution. INCLUDE operator.
Comments in the script. Load log. Debugging. Service variables.
Module 2. Loading and converting data part 1. Simple transformations (3 ak. h.)
Connecting to the database. CONNECT operator and its properties.
Wizard for creating a script for loading tables from a database. LOAD and SQL statements.
Loading data from an XML file.
Loading data from multiple tabs in an Excel file. Peculiarities.
Loading pivot tables from Excel. CrossTable operator.
Renaming tables and fields. Operators AS, RENAME, ALIAS and QUALIFY.
Loading an arbitrary data set. LOAD INLINE construction.
Basic functions for working with dates. Creating a calendar.
Removing tables. DROP FIELDS and DROP TABLE constructs.
Adding artificial fields.
Simple calculations in the loading script.
Module 3. Optimization of the script structure and data model part 1 (4 ac. h.)
Optimization of script structure, tabs.
Data model optimization. Key fields. Measures and measurements.
Selection of data for loading. WHERE clause. The LIKE, MATCH, WILDEMATCH and EXISTS operators.
Using an already loaded dataset. LOAD RESIDENT design.
Data generation. LOAD AUTOGENERATE construction.
Module 4. Optimization of the script structure and data model part 2 (4 ac. h.)
The theory of layered data storage.
Data model optimization. Synthetic keys and circular references. Functions for converting composite keys.
STORE operator. BUFFER LOAD design.
Using loops in the loading script. The Do..loop and For..next constructions.
Lookup tables. MAPPING LOAD construct, Applymap function.
Module 5. Loading and converting data part 2. Complex transformations (4 ac. h.)
Loading script optimization. QVD files, their properties and practical applications.
Conditional statements in the loading script.
Data aggregation. GROUP BY operator.
Inter-record functions Previous and Peek.
Joining and truncating tables. JOIN, CONCATENATE and KEEP operators.
Using downloaded data in calculations. Previous loading.
Incremental loading. Design principles.
Launching external programs. Execute statement.
Module 6. Complex calculations in the interface (3 ac. h.)
Set analysis and its practical application.
On-the-fly data aggregation. Function Aggr.
Create complex calculated dimensions. Function Class.
Introduction to Macros.
Triggers.
Introduction to optimizing QlikView application performance. Basic recommendations.
Module 7. Security Settings. Self Service. QMC (3 ac. h.)
Security in QlikView. Introduction to Section Access.
Principles of Self Service.
Task Scheduler (QMC) overview.
Overview of API interaction.