[lien]

[nom] Data [nom]

Introduction

• Course Approach

[nom]

• [nom]
• [nom] Tour

[nom]

• [nom] Desktop Installation
• Course Folder Structure

Introduction to [nom] Scripting

• Data Load Editor
• Connect, Extract, Load
• Load Fact Tables
• Challenge – Load Fact Table
• Solution – Load Fact Table
• Basic Transformations
• Challenge – Basic Transformations
• Solution – Basic Transformations
• Script Debugging

Synthetic Keys

• Synthetic Keys Basic
• Loading Dimension Tables
• Challenge – Synthetic Key
• Solution – Synthetic Key
• Data Modeling Viewer

Adding Flat Files

• Load Excel Files
• Challenge – Load Suppliers Table
• Solution – Load Suppliers Table
• Challenge – Qualify Statement

Page | 1

[lien]

• Solution – Qualify Statement
• Variables
• Challenge – Variables
• Solution – Variables
• Include Files
• Challenge – Include Files
• Solution – Include Files

Dealing with Data Model Challenges – Part 1

• Using Record Counters
• Challenge – Record Counters
• Solution – Record Counters
• WHERE Clause
• Resident Load
• WHERE EXIST Clause
• Challenge – WHERE EXIST
• Solution – WHERE EXIST

Master Calendar

• Master Calendar Fundamentals
• FieldValue Function and Flags
• Create a Master Calendar

Mapping Tables

• Mapping Load Fundamentals
• Add Mapping Tables
• Challenge – Mapping Tables
• Solution – Mapping Tables
• Challenge – Preceding Load
• Solution – Preceding Load

Data Model Optimization

• Joins Deep Dive
• Challenge – Join Tables
• Solution – Join Tables
• Concatenation
• Implicit and Forced Concatenation
• Challenge – Concatenate
• Solution – Concatenate

Page | 2

[lien]

• Consolidate Fact Tables

Dealing with Data Model Challenges – Part II

• Circular Reference
• Cross Table
• Add Cross Table
• Link Table
• Create a Link Table
• Challenge - Class Function
• Solution – Class Function
• Interval Match

All About QVD Files

• QVD Fundamentals
• Creating QVD Files
• Optimized QVD Load

SET Analysis

• Set Analysis Fundamentals
• Create a Chart with Set Expression
• Challenge - Set Modifier
• Solution - Set Modifier
• Aggr()
• Challenge - Set Analysis with Aggr()
• Solution - Set Analysis with Aggr()
• FirstSortedValue Function
• Challenge – FirstSortedValue
• Solution – FirstSortedValue

Section Access

• Introduction
• Chapter Goals
• Layers of Security
• ABAC vs RBAC
• Authentication vs Authorization
• Why Section Access?
• Section Access Basics
• Section Access - App Authorization
• Troubleshooting App Lockdown

Page | 3

[lien]

• Section Access - Data Authorization

Qualification Project for certification

Page | 4