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.
Prerequisites
Relevant workplace familiarity is recommended; exact technical prerequisites can be adapted to the participant group.
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.
Outline points are grouped in one designed block instead of being treated as separate module cards.
01Analytics Engineering Project Design3 topics
- dbt projects, profiles, adapters, models, and materializations
- Source declarations, staging conventions, and model contracts
- Development, test, and production target separation
02SQL Transformation and Modularity3 topics
- ref and source dependency resolution
- Macros, Jinja control structures, and reusable packages
- Incremental models, snapshots, and slowly changing dimensions
03Testing and Documentation3 topics
- Generic and singular tests for business rules
- Freshness checks, exposures, descriptions, and ownership
- Generated documentation, lineage graphs, and catalog review
04Deployment and Data Reliability3 topics
- Slim CI, state comparison, selectors, and deferred builds
- Job scheduling, environment variables, and secret handling
- Failed model diagnosis, backfills, and rollback decisions
05Analytics Product Workshop3 topics
- 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