AI and Data in Business
dbt Analytics Engineering
This in-depth course develops directly applicable capability in dbt Analytics Engineering. It connects Analytics Engineering Project Design, SQL Transformation and Modularity, and Testing and Documentation to the decisions, controls, and activities participants need to perform in their workplace.
Overview
Practical learning for workplace transfer.
This in-depth course develops directly applicable capability in dbt Analytics Engineering. It connects Analytics Engineering Project Design, SQL Transformation and Modularity, and Testing and Documentation to the decisions, controls, and activities participants need to perform in their workplace. The five-module curriculum progresses toward Analytics Product Workshop, using evidence, scenarios, and work products appropriate to the subject.
Objectives
- Analyze analytics engineering project design, including dbt projects, profiles, adapters, models, and materializations.
- Configure or structure sql transformation and modularity, including ref and source dependency resolution.
- Evaluate testing and documentation, including generic and singular tests for business rules.
- Manage deployment and data reliability, including slim ci, state comparison, selectors, and deferred builds.
- Apply analytics product workshop, including model a source-to-mart transformation chain.
Target audience
- Professionals responsible for this subject area
- Managers, supervisors, and team leaders
- Analysts, specialists, engineers, or coordinators working with the relevant processes
- Project, implementation, assurance, or improvement team members
- Professionals preparing for broader responsibilities in this field
Program outline
A clear structure for the learning journey.
Program outline
Outline points are grouped in one designed block instead of being treated as separate module cards.
Module 1: Analytics Engineering Project Design
dbt projects, profiles, adapters, models, and materializations
Source declarations, staging conventions, and model contracts
Development, test, and production target separation
Module 2: SQL Transformation and Modularity
ref and source dependency resolution
Macros, Jinja control structures, and reusable packages
Incremental models, snapshots, and slowly changing dimensions
Module 3: Testing and Documentation
Generic and singular tests for business rules
Freshness checks, exposures, descriptions, and ownership
Generated documentation, lineage graphs, and catalog review
Module 4: Deployment and Data Reliability
Slim CI, state comparison, selectors, and deferred builds
Job scheduling, environment variables, and secret handling
Failed model diagnosis, backfills, and rollback decisions
Module 5: Analytics Product Workshop
Model a source-to-mart transformation chain
Add contracts, tests, metrics, and documentation
Review pull-request evidence and release readiness
Materials provided
- ○ Course-specific presentation slides
- ○ Guided exercises, scenarios, or configured-environment activities appropriate to the subject
- ○ Course-specific worksheets, checklists, or calculation templates
- ○ Applied workplace case materials
- ○ 4D Certificate of Completion issued by 4D Training & Consultancy
- ○ Post-course support for implementation questions
Training Options
Programs can be delivered in-house, online, or in a blended format depending on your team's schedule, location, and learning objectives. When an external certificate or exam is included, certification rules and fees remain under the relevant awarding body's policies, while 4D provides the training and preparation support.
Why choose 4D
4D Training & Consultancy adapts the program to the client’s operating environment. Delivery combines structured explanation with subject-specific analysis, exercises, and implementation decisions so participants can transfer the learning to real responsibilities without implying vendor authorization.
Related courses
AI Agents and Workflow Automation for Business Operations
This course helps business and operations teams understand how AI agents and workflow automation can reduce repetitive work, improve handoffs, and support faster execution. Participants learn how to map processes, identify automation candidates, design human-in-the-loop controls, and manage risks before scaling AI-enabled workflows.
View courseAI Change Management and Adoption for Managers
This course helps managers lead teams through AI adoption with clarity, confidence, and responsible use. Participants learn how to address resistance, redesign work, set expectations, coach employees, define safe-use rules, and measure adoption without creating fear or unrealistic expectations.
View courseAI for Business Leaders and Department Managers
This course helps business leaders and department managers understand how artificial intelligence can be used responsibly across departments. Participants explore practical AI use cases, productivity opportunities, governance requirements, implementation risks, and decision-making considerations without needing a technical background.
View course