Step into the world of intelligent data architecture with our course on Data Warehouse Manager in SimCorp Dimension. This course introduces the Data Warehouse Manager functionality, including the Data Model Designer, Load Monitor, and configuration tools for operating the data warehouse. You’ll gain a solid foundation in data modeling concepts and learn how to apply them using SimCorp’s Investment Management Warehouse (IMW). Through practical exercises and expert guidance, you’ll learn how to design, extend, and maintain efficient data warehouses that support business insights and reporting. 

Key Learning Objectives:

- Data Integration: Seamlessly connect functional applications in SimCorp Dimension with the Data Warehouse Manager.   
- Complex Data Modeling: Apply the standard data model SimCorp IMW, including star schemas, to support advanced reporting.   
- Scalability & Performance: Address challenges in handling large data volumes while maintaining system efficiency.   
- Data Quality & Accuracy: Ensure reliable analytics through high-quality data management strategies.   
- Incremental Data Loading: Implement efficient update mechanisms to keep data current with minimal downtime.   
- Customization & Extension: Adapt and extend the IMW data model to meet specific business and analytical needs. 

Target Audience:  
This course is designed for professionals responsible for operations and automating workflows that involve processing data for external stakeholders, such as report recipients, business analysts, and upper management. Additionally, data warehouse specialists will benefit from understanding the automated data flows within SimCorp Dimension, particularly how investment analytics are produced and how measures behave when data is recalculated or arrives late in the process.  

Pre-requisites:  
We recommend prior experience with export or transport of data between software components for reporting or migration purposes, especially Data Extractor (DEX) is valuable, as this tool reflects the basic ETL process. It is also important to have basic skills in SimCorp Dimension, equivalent to one of the courses of SimCorp Dimension Academy or SimCorp Dimension Technical Foundation. Otherwise, ask for an introductory day, where topics such as navigation, transaction lifecycle, and extractions in general will be covered.  

Course Details:  
Dates: 18-22 May, 2026 
Location: Virtual Classroom  
Language: English  
Duration: 5 days sessions of 4 hours 
Daily sessions from 9:00 - 1:00 PM CET // 4:00 - 8:00 PM SGT

Course Fee: 3100 EUR / 3720 USD / 4650 SGD excl. VAT