0
Views
Building analytical reports based on the BI platform Qlik Sense - course RUB 40,490. from Specialist, training, Date: March 17, 2024.
Miscellaneous / / December 03, 2023
Qlik Sense is a data visualization and exploration tool. The ability to process data directly in RAM allows you to flexibly explore large amounts of information.
During the course, you will gain complete knowledge of advanced techniques for loading and converting various types data, building BI applications on the Qlik Sense platform and the capabilities of visual data analysis in this system. You'll learn to create a fully functional ETL process and Qlik Sense application interface using the full range of available visualization objects. At the end of the course, you will be able to create a full-fledged Qlik Sense application from scratch yourself.
Course audience:
Qlik Sense training is provided on the Qlik Sense Business Cloud version. All students are given access to Qlik Sense Business Cloud for the duration of their cloud-based training.
Design data models.
Create an application interface from scratch using all existing Qlik Sense visualization objects.
Create and customize applications in Qlik Sense.
Perform complex calculations in interface objects.
Use triggers and variables to perform calculations.
Design a printed form of the report and upload it to PDF.
During the course, you will gain complete knowledge of advanced techniques for loading and converting various types data, building BI applications on the Qlik Sense platform and the capabilities of visual data analysis in this system. You'll learn to create a fully functional ETL process and Qlik Sense application interface using the full range of available visualization objects. At the end of the course, you will be able to create a full-fledged Qlik Sense application from scratch yourself.
Course audience:
Qlik Sense training is provided on the Qlik Sense Business Cloud version. All students are given access to Qlik Sense Business Cloud for the duration of their cloud-based training.
You will learn:
Ability to load data from various sources into Qlik Sense.
Ability to transform data when loading.
Knowledge of the principles of layered data storage in qvd files.
Design data models.
Create an application interface from scratch using all existing Qlik Sense visualization objects.
Create and customize applications in Qlik Sense.
Perform complex calculations in interface objects.
Use triggers and variables to perform calculations.
Design a printed form of the report and upload it to PDF.
Module 1. Getting started with Qlik Sense (3 ac. h.)
A quick overview of the Qlik Sense architecture. Differences from QlikView.
Principles for building Qlik Sense analytical applications. Examples.
Qlik Sense interface.
Visual data analysis capabilities in Qlik Sense. Brief overview of diagrams. Examples.
Qlik Sense app and its properties. Creating a Qlik Sense application.
Application tabs. Preparation. Analysis. Commenting.
Review of possible data sources.
Easier loading of data into the Qlik Sense app. Narration.
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 (3 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 (3 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 (3 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. Measures. Measurements. Set Analysis (3 ac. h.)
Fields. Field options. Drag and Drop. Automatic selection of visualization.
Measurements. Single and detailed. Introduction to Drilldown.
Measurements. Value colors.
Measures. Basic aggregation.
Measures. Segment colors.
Introduction to Set Analysis.
Set Analysis in measures.
Module 7. Visualizations. Diagrams. Detailed customization of visualizations (3 ac. h.)
Working with various types of visualizations.
Controls. Button. Filter.
Simple visualizations. KPI. Barchart. PieChart. Treemap, etc.
Complex visualizations. Bullet Chart. BubbleChart. Map. Heatmap, etc.
Container element. Usage scenarios.
Types of dashboards by use case.
Module 8. Security Settings. Separation of access rights. Self Service. QMC. API (3 ac. h.)
Security in Qlik Sense. Introduction to Section Access.
Principles of Self Service.
Task Scheduler (QMC) overview.
Overview of API interaction.
Subscribe