QlikSense Data Architect Masterclass

Understand the three-layer Qlik Sense architecture—data access, application, and presentation—with data sources from Excel to big data and in-memory calculations handled by the proxy, engine, scheduler, repository, and Qmk.

Unlock Qlik Sense Desktop via two methods: register with Click Branch for a PSD file, or use a cloud business subscription. The lecture guides installation, unlocking steps, and trial expiration.

Learn how to unlock Qlik Sense Desktop using Click Business Cloud authentication, including registering for a 30-day free trial, authenticating via the profile, and launching the browser-based desktop for training.

Set up the basic Qlik Sense bootcamp folder on your local machine, download the data and include folders from GitHub, and prepare the northwind database for building the data model.

Apply basic transformation to create line sales amount in the order detail table by multiplying unit price, quantity, and (1 - discount), then reload and review data model for accuracy.

Resolve a synthetic key by renaming the customers table fields: address, city, country, postal code, and region, to avoid conflicts with employees; reload and confirm no synthetic keys remain.

Set up an XML data connection, load the suppliers table from suppliers.xml, and use a qualify statement to handle synthetic keys like company name, contact name, title, fax, and phone.

Learn how the qualify statement prefixes each field with its table name to resolve synthetic keys between suppliers, employees, and customers, and avoid island tables by unqualifying at the end.

Qualify all fields with a qualify statement on the suppliers table, unqualify the supplier ID field, and use star unqualified to prevent synthetic keys, shaping the data model.

Create an xml file path variable, add it to variables.txt in the include folder, apply dollar sign expansion, and reload the document to validate the data model.

explore include files that store path variables and connection strings, using must_include with dollar expansion to load a single shared text file across developers.

Create a variables.tf include file in the include folder, save it as variables.txt, and load it to verify the include file connection.

Use a dedicated record counter in the orders table to ensure frequency on the order ID key field comes from the correct table, avoiding cross-table miscounts.

Learn to create a customer ID counter in the orders table to count active customers accurately, then build a straight table showing active customers by year alongside the total orders.

Explore how the Qlik Sense where clause filters records during load statements, using variables and dollar sign expansion to cap data to last three years, e.g., year greater than 1996.

Create a mapping table from the products table in the Northwind database, loading product ID and unit price. Apply mapping to the orders detail table, computing cost of goods sold.

Explore how joins work in Qlik Sense, including associative and natural joins, and how left, right, inner, and full outer joins shape data models.

Learn how to optimize a QlikSense data model by using left joins and lap joins to consolidate categories into products, avoid cartesian joins, and boost performance.

Use the data load editor to perform a lap join between orders detail and the order detail extended table from Northwind, adding the extended price field to orders detail.

Master concatenation in Qlik Sense by learning how to add rows from multiple tables, distinguish implicit versus force concatenation, and handle matching or differing field names.

Explore implicit and forced concatenation in Qlik Sense through a practical employees example, showing when implicit concatenation occurs and how to force concatenation to avoid synthetic keys.

Consolidate the orders and order details into a single fact table by lap joining order details to orders, rename tables to facts, and optimize the data model with auto layout.