H6 – Data Modules and Data Upload

Training in modeling with data modules, data upload, metadata management, joins, navigation paths, calculations, filters, table views, relative time and security concepts.

Chapters and lessons

H6-01 Metadata

• H6-01-1 Uploading the initial demo data
• H6-01-2 Creating a simple data module
• H6-01-3 Simple JOIN: checking column usage
• H6-01-4 Additional column properties
• H6-01-5 Aggregation and sorting

H6-02 Joins

• H6-02-1 Joins and cardinalities (general)
• H6-02-2 Connecting additional data sources
• H6-02-3 Example of incorrect cardinalities
• H6-02-4 Outer-join example
• H6-02-5 Optimizing joins across multiple data sources

H6-03 Navigation paths and presorting

• H6-03-1 Creating navigation paths
• H6-03-2 Sorting members
• H6-03-3 Special navigation paths

H6-04 Calculations

• H6-04-1 Custom data groups
• H6-04-2 Cleaning and splitting data
• H6-04-3 Simple calculations with measures
• H6-04-4 Measure calculations in the expression editor
• H6-04-5 Advanced IF-THEN-ELSE calculations in the expression editor

H6-05 Filters

• H6-05-1 Built-in table-level filters
• H6-05-2 Standalone filters
• H6-05-3 Filters with macro functions

H6-06 Table views

• H6-06-1 Creating user views (JOIN)
• H6-06-2 Creating UNION views
• H6-06-3 Table aliases

H6-07 Relative time

• H6-07-1 Working with calendar functions

H6-08 Data security

• H6-08-1 Data source security (databases)
• H6-08-2 Example of data source security using the expression editor
• H6-08-3 Macro security

H6-09 Tips and tricks

• H6-09-1 Reconnecting data sources
• H6-09-2 Retrieving and copying data module XML

H6-10 Advanced topics

• H6-10-1 Defining column dependencies
• H6-10-2 Advanced configuration of column dependencies
• H6-10-3 Multilingual metadata