icon icon

data architecture

icon

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

icon

A coherent data architecture view - You will connect data strategy, enterprise architecture and roadmap planning into one clear picture, making it easier to align technical decisions with measurable business goals.

icon

Stronger data modeling skills - You will learn how conceptual, logical and physical models differ and how to move from design to implementation, so you can build clearer and more implementation-ready solutions.

icon

Practical MDM and metadata use - You will understand how to organize master data, dictionaries and classifications, and how to use metadata catalogs and lineage to assess change impact across systems faster.

icon

Better technology choices - You will compare relational and NoSQL databases, replication patterns and storage approaches, so you can choose an architecture that fits data scale, structure and change dynamics.

icon

More effective data integration - You will work through ETL, ELT, Reverse ETL, CDC, batch and streaming integration, plus APIs and integration platforms, helping you design smoother data flows across systems.

icon

Confidence in analytics design - You will grasp the differences between Inmon, Kimball and Data Vault, and when to use star schemas, snowflakes and data marts to build a stronger BI-ready analytical layer.

icon

Clarity on modern platforms - You will assess the strengths and trade-offs of Data Lake, Lakehouse, Data Fabric and Data Mesh, so you can choose the right balance between centralized and decentralized data models.

icon

Stronger governance and security - You will learn how to combine data quality, governance roles, access policies, classification and privacy by design to support BI, ML and AI solutions in a compliant way.

Training programme

1. Introduction to data architecture

At the organizational level, data architecture links strategy, operating principles, and execution planning. This section establishes core concepts, the relationship to enterprise architecture, and the role of vision, goals, metrics, capabilities, frameworks, high-level architecture, and the data roadmap.

  • basic concepts,
  • data strategy. The role of data architecture in the organization's strategy,
  • connection with enterprise architecture,
  • vision, goals, metrics,
  • capabilities, principles, frameworks,
  • high-level data architecture,
  • data roadmap.

2. Data models

From enterprise-wide structure to implementation details, data models organize how information is described and built. The section covers the corporate data model, conceptual, logical, and physical levels, common modeling notations, and the transition from model design into implementation.

  • corporate data model,
  • modeling levels: conceptual, logical, physical. Roles of models,
  • most commonly encountered modeling notations,
  • transition from model to implementation.

3. Reference and master data (RDM/MDM)

Reference and master data create the shared vocabulary required for consistent processing across systems. The section defines RDM and MDM, covers dictionaries, codes, classifications, and common master data domains, then addresses the practical challenges of governing and maintaining them.

  • definitions,
  • dictionaries, codes, classifications,
  • typical master data domains,
  • challenges related to master data management.

4. Metadata and metadata management

Metadata management provides the context needed to understand data assets beyond their technical storage. This part distinguishes key metadata types, shows how catalogs and dictionaries serve as a central knowledge point, and explains lineage, impact analysis, and common management challenges.

  • types of metadata,
  • metadata catalog and dictionary as a central point of knowledge,
  • metadata lineage (data lineage) and change impact analysis,
  • typical challenges related to metadata management.

5. Data storage - technologies and patterns

Relational and NoSQL technologies are examined from the perspective of storage patterns and architectural fit. The discussion clarifies where each database approach works best, how data structures differ, and why replication matters for availability, consistency, and distributed data management.

  • relational databases,
  • non-relational databases (NoSQL),
  • data replication.

6. Data integration - patterns and approaches

Building dependable data flows involves selecting integration patterns that match latency, source behavior, and target use. The section examines ETL, ELT, Reverse ETL, batch and streaming, CDC, orchestration, API-based communication, and the role of IPaaS and API Gateway platforms.

  • ETL, ELT, Reverse ETL,
  • streaming and batch integration,
  • Change Data Capture (CDC),
  • orchestration of integration processes,
  • API as a communication interface,
  • integration platforms (IPaaS, API Gateway).

7. Data warehouse and analytical modeling

Designing analytical storage requires choosing the right modeling approach for reporting and access. Here the program contrasts Inmon and Kimball, introduces Data Vault, explains star and snowflake schemas, and positions the Data Mart as an access layer for analytical consumption.

  • Inmon vs Kimball,
  • Data Vault,
  • star schema and snowflake schema,
  • Data Mart as an access layer.

8. Modern data platform architectures

Modern platform design is discussed through the architectural patterns most often used in large-scale data environments. The section compares medallion architecture, Data Lake, Data Lakehouse, and Data Fabric, focusing on their structure, operating model, and typical architectural use cases.

  • medallion architecture,
  • Data Lake,
  • Data Lakehouse,
  • Data Fabric.

9. Data Mesh and decentralized architecture

When organizations distribute responsibility closer to business domains, architecture must balance autonomy with consistency. This section covers Data Mesh principles, Domain Ownership, data as a product, data contracts, self-service platforms, and federated governance, including key benefits and trade-offs.

  • Data Mesh principles,
  • Domain Ownership,
  • data as a product,
  • data contracts,
  • self-service platform,
  • federated governance,
  • advantages and disadvantages of data mesh.

10. Data Quality and Data Governance

Reliable analytics depends on clear quality criteria and effective governance mechanisms. Participants work through data quality dimensions, profiling, and both reactive and proactive quality management, then place these practices within governance roles, policies, and operational processes.

  • data quality dimensions,
  • reactive and proactive data quality management,
  • data profiling,
  • typical roles related to data governance,
  • data governance policies and processes.

11. Data security and privacy

Regulatory requirements shape how data architecture handles privacy, access, and control. This part addresses GDPR and related regulations, data classification, masking and anonymization, as well as RBAC, ABAC, and PBAC models in the context of IT Controls and privacy by design.

  • GDPR and other regulations in data architecture,
  • data classification,
  • masking, anonymization,
  • access control (RBAC, ABAC, PBAC) and impact on IT Controls,
  • Privacy by design / security by design.

12. Data architecture as the foundation of BI, ML, AI

Semantic layer becomes the bridge between raw data assets and business use in BI, ML, and AI scenarios. The section explains how data architecture supports generative AI, extends reporting into intelligent decision systems, and enables process automation and optimization with AI models.

  • semantic layer,
  • data architecture supporting generative AI,
  • from reporting to intelligent decision-making systems,
  • automation and optimization of data management processes thanks to AI models.

What are the prerequisites for participating in the training?

icon

Database fundamentals - You should be comfortable with tables, relationships, keys and basic data operations, so you can easily follow the parts focused on modeling and data storage.

icon

IT systems awareness - You should know the main building blocks of an IT landscape, such as applications, interfaces, databases and integrations, to relate the patterns to real solutions.

icon

Analytics basics - You should understand the purpose of reporting, data warehouses and data flows, so you can better compare analytical approaches and architectural options.

icon

Quality and security awareness - You should have a basic understanding of data quality, access rights and information protection, so governance, privacy and compliance topics are easier to grasp.