DBT
dbt
Create effective data management workflows with dbt
✓ Formation officielle SFEIR InstituteNiveau Fundamentals⏱️ 2 jours (14h)
Ce que vous allez apprendre
- Understand the key concepts, advantages, and architecture of dbt as a data transformation and modeling tool.
- Create structured data models with dbt, and perform transformations to process and prepare data for analysis.
- Master advanced features such as macros, Jinja models, variables, and flow control.
- Use dbt snapshots to track changes over time and manage historical data, facilitating the analysis of historical trends and slowly changing dimensions.
- Implement tests to ensure data quality and integrity, allowing for the validation of transformation results and detection of anomalies.
Prérequis
- Practical SQL knowledge equivalent to the SQL fundamentals course
Public cible
- Data Analysts, Data Engineers, Anyone interested in data transformation
Programme de la Formation
13 modules pour maîtriser les fondamentaux
Sujets abordés
- →Evolution of the data stack
- →Understanding the differences between Extract-Transform-Load (ETL) and Extract-Load-Transform (ELT) data integration approaches
- →Introduction to the modern data stack
Quality Process
SFEIR Institute's commitment: an excellence approach to ensure the quality and success of all our training programs. Learn more about our quality approach
Teaching Methods Used
- Lectures / Theoretical Slides — Presentation of concepts using visual aids (PowerPoint, PDF).
- Technical Demonstration (Demos) — The instructor performs a task or procedure while students observe.
- Guided Labs — Guided practical exercises on software, hardware, or technical environments.
Evaluation and Monitoring System
The achievement of training objectives is evaluated at multiple levels to ensure quality:
- Continuous Knowledge Assessment : Verification of knowledge throughout the training via participatory methods (quizzes, practical exercises, case studies) under instructor supervision.
- Progress Measurement : Comparative self-assessment system including an initial diagnostic to determine the starting level, followed by a final evaluation to validate skills development.
- Quality Evaluation : End-of-session satisfaction questionnaire to measure the relevance and effectiveness of the training as perceived by participants.
Prochaines sessions
Aucune date ne vous convient ?
Nous organisons régulièrement de nouvelles sessions. Contactez-nous pour connaître les prochaines dates disponibles ou pour organiser une session à la date de votre choix.
S'inscrire à une date personnaliséeFormer plusieurs collaborateurs
- Tarifs dégressifs (plusieurs places)
- Session privée ou sur-mesure
- En présentiel ou à distance