Data Modeling & Pipelines — Catalog
Choose a course or a pack to get started.
Data Engineering roles include Data Engineers, Analytics Engineers, Data Platform Engineers, Data developers and professionals responsible for supplying BI, Analytics and AI with reliable data. The training need appears when moving from a simple transformation script to a real data chain: ingestion, analytical modeling, quality, orchestration, historization, observability, governance and recovery must work together.
The 15 courses cover Data architectures, analytical modeling, storage and formats, multi-source ingestion, ETL/ELT, incremental loading, dbt, Airflow, data quality and contracts, catalog and lineage, batch and event-driven processing, performance and cost, governance, CI and the industrialization of a complete Analytics pipeline. By the end of the pathway, you will be able to build and operate a reliable, tested, traceable and governed data platform ready for BI and AI.
🎓 15 courses • 📘 120 interactive lessons • ⏱️ 45 to 75 hours of conversational training
Best offer
Complete Pack — Data Modeling & Pipelines
142,90 € excl. VAT
Savings : 104,60 €
29,70 €
22,90 excl. VAT
Savings : 6,80 €
Understand data architectures and pipelines
understand how data flows from source systems to BI, analytics and AI use cases
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
No advanced technical prerequisite. Everyday computer skills and the ability to follow technical instructions are sufficient to start.
- Understand the role of Data Engineering in an organization
- Distinguish ingestion, transformation, orchestration and consumption
- Distinguish data warehouse, data lake and lakehouse
- Workshop: map an end-to-end data chain
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: map an end-to-end data chain
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
9,90 € excl. VAT
Model data for analytics
design a coherent analytical model from a business need, indicators and source data
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
No advanced technical prerequisite. Everyday computer skills and the ability to follow technical instructions are sufficient to start.
- Start from business use cases and define the analytical grain
- Choose business keys and surrogate keys
- Manage historization with Slowly Changing Dimensions
- Workshop: model a company's sales for BI
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: model a company's sales for BI
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
9,90 € excl. VAT
Organize analytical storage and data formats
choose a storage organization and formats suited to volume, processing and analytical use cases
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
No advanced technical prerequisite. Everyday computer skills and the ability to follow technical instructions are sufficient to start.
- Compare data warehouse, data lake and lakehouse
- Choose between CSV, JSON and Parquet
- Manage schema, compatibility and structure evolution
- Workshop: design the physical organization of an analytical space
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: design the physical organization of an analytical space
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
9,90 € excl. VAT
38,70 €
28,90 excl. VAT
Savings : 9,80 €
Reliably ingest data from multiple sources
extract data from files, SQL databases, APIs and Cloud storage while controlling errors and replayability
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Ingest CSV and JSON files
- Consume a paginated API to feed a pipeline
- Protect credentials, keys and access secrets
- Workshop: consolidate three sources into a staging zone
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: consolidate three sources into a staging zone
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
12,90 € excl. VAT
Design ETL and ELT transformations
organize readable, testable and traceable transformations between raw data and analytical models
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Design the raw, staging, intermediate and marts layers
- Normalize types, dates and conventions
- Formalize business rules in transformations
- Workshop: transform raw data into a usable model
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: transform raw data into a usable model
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
12,90 € excl. VAT
Build incremental loads and reliable recovery
update data efficiently without duplicates or loss, and know how to replay processing after an incident
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Compare full load and incremental load
- Implement upsert and MERGE logic
- Design an idempotent process
- Workshop: make an incremental load replayable without duplicates
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: make an incremental load replayable without duplicates
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
12,90 € excl. VAT
47,70 €
35,90 excl. VAT
Savings : 11,80 €
Transform, test and document data with dbt
industrialize analytical transformations with explicit dependencies, tests, documentation and lineage
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
A working knowledge of the foundations introduced in the first courses, or equivalent practical experience, is recommended.
- Understand the role of dbt in an ELT architecture
- Build models with source() and ref()
- Add generic tests and business checks
- Workshop: build a tested and documented mini dbt project
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: build a tested and documented mini dbt project
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
15,90 € excl. VAT
Orchestrate pipelines with Apache Airflow
schedule, chain, replay and monitor data processing with explicit orchestration
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Understand DAG, Task and dependencies in Airflow 3.x
- Schedule runs and configure tasks
- Replay periods with a controlled backfill
- Workshop: orchestrate and monitor a multi-step pipeline
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: orchestrate and monitor a multi-step pipeline
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
15,90 € excl. VAT
Ensure data quality, contracts and evolution
detect incorrect data and protect consumers from uncontrolled structural changes
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Define data quality dimensions
- Monitor freshness, volumes and drift
- Manage schema evolution and breaking changes
- Workshop: block the publication of a non-compliant dataset
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: block the publication of a non-compliant dataset
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
15,90 € excl. VAT
56,70 €
42,90 excl. VAT
Savings : 13,80 €
Manage metadata, catalog, lineage and impact analysis
make data understandable, traceable and governable from source to use
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Understand technical and business metadata
- Understand the role of a data catalog
- Analyze the impact of a schema change
- Workshop: carry out the impact analysis of a critical change
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: carry out the impact analysis of a critical change
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
18,90 € excl. VAT
Design batch, micro-batch and event-driven pipelines
choose the right processing mode based on latency, volume, complexity, cost and business requirements
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Compare batch, micro-batch and streaming
- Understand queues, event logs and offsets
- Understand at-least-once delivery and the exactly-once goal
- Workshop: decide whether a need truly justifies real time
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: decide whether a need truly justifies real time
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
18,90 € excl. VAT
Optimize storage, processing, performance and costs
reduce processing time and resource consumption without degrading quality or maintainability
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Measure volumes, processing time and costs
- Use columnar formats and compression
- Leverage parallelism and pushdown where available
- Workshop: diagnose and optimize a slow pipeline
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: diagnose and optimize a slow pipeline
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
18,90 € excl. VAT
74,70 €
48,90 excl. VAT
Savings : 25,80 €
Design a reliable, governed data platform
bring together ingestion, storage, transformations, quality, orchestration, security and governance into an operable architecture
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Define the components of a data platform
- Organize identities, roles, secrets and data access
- Integrate catalog, lineage and observability
- Workshop: produce the architecture of a governed platform
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: produce the architecture of a governed platform
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
24,90 € excl. VAT
Industrialize an end-to-end Analytics pipeline
build and operate a multi-source pipeline through to a reliable BI dataset with Git, CI, tests and monitoring
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Scope the Analytics dataset and its commitments
- Build staging and dbt transformations
- Orchestrate, replay and monitor with Airflow
- Workshop: publish an industrialized, observable BI dataset
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: publish an industrialized, observable BI dataset
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
24,90 € excl. VAT
Full professional Data Engineering project
design, build, operate and defend a professional data chain end to end
Course information
Data Engineers, Analytics Engineers, Data developers and professionals responsible for supplying BI, Analytics or AI with reliable, industrialized data.
You should already master the pathway foundations or have equivalent experience. Advanced topics build directly on skills developed in earlier courses.
- Scope needs, sources, consumers and service levels
- Build the ingestions and the staging zone
- Orchestrate, monitor, manage lineage and recovery
- Final workshop: present and defend the Data Engineering platform
- Apply the course methods and tools to a representative workplace situation.
- Produce a usable outcome by combining the concepts covered: present and defend the Data Engineering platform
- Check the consistency, quality and risks of the result before validation.
- Transfer the course skills to a comparable professional context and justify the choices made.
3 to 5 h
24,90 € excl. VAT