Agenda


✔ ETL Structure: Loading facts and dimensions, setting up staging tables, executing multiple ETL packages, and using templates 

✔ Debugging & Troubleshooting: Examples of common problems and solutions  

✔ ETL Scripts: Script samples, including the use of macros  

✔ Schemas: Snowflake schema vs. Star schema  

✔ Date & Time: Best practices and advanced settings  

✔ Export Formats: CSV and Excel best practices  

✔ Special Features: Currency, translations, and closing balance 

✔ Data Uploads: Incremental load in near real-time

 

Audience: Users interested in making data models for report designers

Prerequisites: Access to TARGIT Management is required to use these tips

You'll Hear From

Niels Thomsen

Niels Thomsen

Solution Architect

Jesper da Silva Endelt

Jesper da Silva Endelt

Senior Solution Architect