Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- The Philosophy and Principles of dbt / What is dbt?
- dbt vs Traditional ETL Processes
- An Overview of dbt Features and Architecture
- Beyond dbt: An Introduction to dbt Cloud
Understanding dbt Cloud
- The Lifecycle of a dbt Project in dbt Cloud
- How dbt Cloud Integrates with Data Warehousing and Transformation Workflows for Government
Getting Started with dbt Cloud
- Setting Up the Development Environment on dbt Cloud for Government
- Connecting dbt Cloud to Your Data Warehouse for Government
- Creating a dbt Project in dbt Cloud for Government
- Running dbt Commands in dbt Cloud for Government
- Collaborating with Team Members on a dbt Project in dbt Cloud for Government
Working with dbt Models
- Understanding dbt Models for Government
- Building a dbt Model for Government
- Transforming Data Using dbt for Government
- Working with Incremental Models in dbt for Government
- Implementing Macros and Custom Functions in dbt for Government
Managing dbt Projects in dbt Cloud
- Using the dbt Cloud Interface to Manage and Deploy Projects for Government
- Creating Schedules and Triggering dbt Jobs for Government
- Creating and Managing Environments in dbt Cloud for Government
- Deploying dbt Projects to Production for Government
- Setting Up Notifications and Alerts for Government
Integrating dbt Cloud with Other Tools
- Using dbt Cloud with Git and Version Control for Government
- Integrating dbt Cloud with Other Cloud-Based Data Warehousing and Transformation Tools for Government
Troubleshooting and Debugging
- How to Debug and Troubleshoot dbt Projects in dbt Cloud for Government
- Using Logs to Diagnose Issues for Government
- Best Practices for Maintaining dbt Cloud Projects for Government
Summary and Next Steps
Requirements
- An understanding of data modeling and SQL for government applications
- Experience with SQL and command-line interface (CLI) in a government context
- Python programming experience relevant to public sector projects
Audience
- Data Engineers for government agencies
- Data Analysts working in the public sector
- Data Scientists supporting government initiatives
21 Hours
Testimonials (3)
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.
Ian - Archeoworks Inc.
Course - ArcGIS Fundamentals
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
Course - QGIS for Geographic Information System
The thing I liked the most about the training was the organization and the location
