Modern data warehousing

Modern data warehousing

Dr. Hicham Zmarrou:  Head of Trefoil Academy

Dr. Jeroen Sijl

The data landscape has changed drastically in the past couple of years, and what it means to build data platforms has evolved alongside it. The organization, tools, languages and architectural patterns have all shifted to take advantage of emerging technologies, cloud scalability and advancements in analytics… but how to you evolve alongside it? 

Trefoil Academy has a broad experience with respect of designing and creating  unsuccessful and successful data modern platform. Our mission is to share our expertise with our client and spare them   

Why should you join the modern data warehousing workshop?

Do you want to learn more about moderne datawarenhouses, the current enterprise data platform architecture, their architectural failure modes, the next enterprise data platform architecture, the core principles and logical architecture of a successful data platform   

  • “I’m new to data platform engineer role or have got a new data platform related project”
  • “With our data warehouse cloud migration I find myself fighting against the windmills”
  • “I have been working in the data warehousing for years, but would like to explore the state-of-the-art trends and practices”
  • “My company has only started to establish data strategy and building a modern data platform is a part of this strategy” 
  • “My company started building a moderne data platform years ago but we are not to deliver yet. I don’t know where is the problem”  

With the help of the Trefoil Academy courses, you get an efficient entry and deep insights into moderne data warehouses concepts and best practices. You will receive answers to many common questions, like:

  • Data Strategy: How do I argument the business value of data management improvements?
  •  Data Quality: How do I measure data quality or which KPIs are relevant?
  • Data management roadmap: What are the state-of-the-art developments and trends?
  • Data Governance: How other companies have structured data governance roles?

During the three seminar modules experts from Trefoil and CDQ AG and representatives from various industries will share their experience, practical solutions and real-life use cases. In addition, in small working groups you will try out the new concepts in practice. By joining Trefoil and CDQ Academy data management course, you stay tuned to the state-of-the-art data management know-how and grow your network of data-oriented peers.

The Trefoil Academy

  • 2 days data management course 
  • The three modules of the training can be completed in any order
  • Time for networking
  • Insights from industry experts
  • Certificate of participation from CDQ Academy
  • Discounts for groups, CC CDQ and Data Sharing Community members
  • Your investment: CHF 2’150 per 2 (3) days data management training

Structure of the Data management training courses

Our data management training program is based upon the practice-proven CDQ Data Excellence Model (DXM) framework, that is a structured reference model addressing all aspects of developing and maintaining effective data quality in digital and data-driven companies. This model has been developed in a joint effort by the Competence Center Corporate Data Quality (CC CDQ), from which the CDQ Academy emerged. The program consists of three training modules:

  • Module 1: Data Excellence for Business Value
  • Module 2: Governance and Data Quality Management
  • Module 3: Data Architecture, Life-Cycle and Applications

Data Excellence for Business Value

Business and data management capabilities

Data Strategy

Data excellence

Continuous improvement 

Governance and Data Quality Management

People, roles and responsibilities 

Processes and methods 

Performance management

Data Architecture, Life-Cycle& Applications

Data models

Data Lifecycle 

Data applications

Information architecture 

The data management training modules at a glance

Excellence drivers in data management, corresponding strategy development and continual improvements

Module 1 of the data management course addresses principal business outcome drivers and capability requirements for effective data management that delivers measurable business value. Participants will explore frameworks for contribution of data excellence and its implications for data strategy and roadmap development. This session will also cover an approach to ensuring effective and sustainable improvements in key data capabilities across people, process and technology areas. The conceptual foundation is validated by numerous good practice examples across variety of industry types.

Data-oriented governance setup, data quality management and performance assessments

This data management course provides fundamentals for two key data management enabler areas – data governance and performance measurement system. You will learn about typical data management roles and responsibilities, how they become operational in various organizational models, how to design a purposeful data quality monitoring framework and use it for continual corrective and optimization measures. The presented concepts and models are complemented with practical insights into deployment approaches, with reflections on lessons-learned from implementation experience, again with a number of good practice examples.

Enabling aspects for data management in context of business processes and IS environment

The third data management module focuses on very operational aspects of data management – data models, life-cycle processes and lineage, including perspectives on information architecture requirements and solutions. Participants will also familiarize themselves with essential software components supporting data management activities.

Benefits of joining the training

  • Build up the case for state-of the-art data management through conceptual foundations, templates and practical insights packed into each 2-day training course (3 days in case of online training due to COVID-19)
  • Experts from large international companies will share practical insights and report on challenges and solutions from their daily practice
  • Experienced consultants share their methods and tools in data management
  • In small groups you directly apply the newly learned concepts in a creative atmosphere
  • Get inspired by questions from other participants and by confronting your ideas with practices from the others – coming from various industries and markets
  • Strengthen your motivation and nurture your thinking forward – cross-check your data management roadmap with other practitioners
  • Extend your network! You will enjoy plenty of time for personal exchange during coffee and lunch breaks as well as at the dinner

Training dates

Participation Fees

  • The participation fee is 2,150 Swiss Francs (exclusive of VAT) for each training module. If more than one participant from the same company attend the same module, each additional participant receives a 15% discount.
  • Members of the CC CDQ and the Data Sharing Community (former Corporate Data League, CDL) pay reduced fee of 1,490 Swiss Francs (exclusive of VAT). No discounts are applicable.
  • Included in the fee are lunches, catering during breaks, the dinner on the first evening, and all necessary course documents. Travel expenses and accommodation are not included in the fee.

Reimbursement Policy

  • In the event of cancellation of participation no later than twenty-eight days prior to the beginning of the course, the fee will be fully refunded. If participation is cancelled at a later date or registered participants do not attend, CDQ invoices a cancellation fee of 500 CHF.
  • Please note that the program is subject to change without prior notice.

Governance and Data Quality Management (M2)

Content 

Module 2 provides fundamentals for two key data management enabler areas – data governance and performance measurement system. You will learn about typical data management roles and responsibilities, how they become operational in various organizational models, how to design a purposeful data quality monitoring framework and use it for continual corrective and optimization measures. The presented concepts and models are complemented with practical insights into deployment approaches, with reflections on lessons-learned from implementation experience, again  with a number of good practice examples.

Target group
The course addresses line and project managers in the area of data management, data stewards, data managers and data architects.

Participants who attend all three training modules will receive a ‘Certificate of Participation’ from the CDQ Academy. Participants who wish to attend only one or two of the modules may do so.

 

Trainers

Dr. Zib Korendo CDQ AG

Tobias Pentek CDQ AG

Dr. Hicham Zmarrou Trefoil Analytics

Data Architecture, Life-Cycle and Applications (M3)

Content 

Module 3 focuses on very operational aspects of data management – data models, life-cycle processes and lineage, including perspectives on information architecture requirements and solutions. Participants will also familiarize themselves with essential software components supporting data management activities.

Target group

The course addresses line and project managers in the area of data management, data stewards, data managers and data architects.

Participants who attend all three training modules will receive a ‘Certificate of Participation’ from the CDQ Academy. Participants who wish to attend only one or two of the modules may do so.

Trainers

Dr. Zib Korendo CDQ AG

Tobias Pentek CDQ AG

Dr. Hicham Zmarrou Trefoil Analytics

Data Excellence for Business Value (M1)

Content 

The focus of Module 1 of the data management course is on principal business demand drivers and capability requirements for effective data management in the digital and data-driven enterprises. Participants will explore the business value contribution of data excellence and its implications for data strategy and roadmap development. This session will also cover an approach to ensuring sustainable performance and systematic improvements in key data capability areas. The conceptual foundation is backed-up with numerous good practice examples across variety of industry types.

Target group

The course addresses line and project managers in the area of data management, data stewards, data managers and data architects.

Participants who attend all three training modules will receive a ‘Certificate of Participation’ from the CDQ Academy. Participants who wish to attend only one or two of the modules may do so.

Trainers

Dr. Zib Korendo CDQ AG

Tobias Pentek CDQ AG

Dr. Hicham Zmarrou Trefoil Analytics