Course curriculum
-
1
Overview
04:14- Introduction
-
2
Course Resources
00:00- Course Resources
-
3
Introduction to Data Manager
14:01- Introduction
- Components of Data Manager
- Navigating to Data Manager : Qlik Sense Desktop
- Navigating to Data Manager : Qlik Sense Enterprise
- Navigating to Data Manager : Qlik Sense Business Cloud
- Quiz : Data Manager Introduction
-
4
Connection and Loading Data with Data Manager
34:42- Introduction
- Attaching files and loading data to app
- Creating a folder data connections
- Loading data from Excel file
- Loading data from CSV file
- Loading data from text file
- Loading data from QVDs
- Connecting and Loading Data from Database
- Manual data entry
- Quiz : Loading Data with Data Manager
-
5
Managing Association in Data Manager
31:36- Introduction
- What is Association?
- Associating Tables using Recomonded Associations Panel
- Associating Tables Manually
- Associating Tables in Tables Editor View
- Summary
- Associations Quiz
-
6
Transforming Data in Data Manager
31:56- Introduction
- Unpivoting Cross Tab Data
- Adding Calculated Field
- Challenge
- Concatenating Data in Data Manager
- Basics of SQL Joins
- Joining tables in data manager
- Challange
- Data Transformation Quiz (Joins and Concatenation)
-
7
Transforming Data using Data Profiling Cards
32:14- Introduction
- Examine Data Using Summary Card
- Cards for Dimension Fields : Order and Set Null Card
- Cards for Dimension Fields : Split and Replace Card
- Card for Measure Fields : Bucket Card
- Synchronizing Data Load Editor Script
- Changing Field Type and Hiding Field from Analysis
-
8
Loading and Associating Qlik Data Market Data with Corporate Data
10:31- Loading and Associating Qlik Data Market Data with Corporate Data