Course: Recommended Learning Plan for Qlik Sense Data Architects, Topic: Intermediate

Topic outline

Recommended Learning Plan for Qlik Sense Data Architects
Start with the Basic pathway, then proceed through the Intermediate and Advanced pathways to learn more.

Expand your knowledge to learn even more scripting capabilities within Qlik Sense, including how to troubleshoot.

Estimated total duration: 14.75 hours
including activities and quizzes

Part 3: Loading Data

In this part you will learn more about how to load data into Qlik Sense, including various data sources including databases, Excel, QVD files, and Qlik DataMarket.

Total Estimated Duration: 4.3 hours

Objectives

Learn how to load data from databases
Learn how to load data from the Qlik DataMarket
Learn how to load data from excel

Loading Data from a Database	Considerations when Loading Data from Excel
(60 minutes)	(60 minutes)

Incorporating Data from Qlik DataMarket	Working with QVD Files
(50 minutes)	(90 minutes)

Part 4: Model Architecting

In this part you will learn more about how to architect your data model.

Total Estimated Duration: 7.5 hours

Objectives

Understand how to association Tables
Understand how to perform various data transformations
Understand how to reload data

Associating Tables and Transforming Data	Reload Data for Analysis
(50 minutes)	(60 minutes)

Creating Data During Reload	Generating a Master Calendar
(55 minutes)	(55 minutes)

Combining Tables	Create Master Items
(95 minutes)	(85 minutes)

Creating Master Items from the Data Model Viewer
(55 minutes)

Part 5: Validating and Troubleshooting

In this part you will gain an understanding of how to validate and troubleshoot your data model.

Total Estimated Duration: 3.0 hours

Objectives

Learn how to validate the data model
Learn how to debug the data model

Resolving Data Model Issues	Debugging the Script
(60 minutes)	(55 minutes)

Validating the Model
(55 minutes)