dbt coaching
Learn how to use dbt to empower your data team 🚀
Meet your instructor
Oleg Agapov
Oleg is an experienced Analytics Engineer with more than 8 years of experience in data analytics and engineering, and over 2 years of experience in dbt. He is passionate about teaching others how to use dbt and build reliable, scalable, well tested, and documented data models.
Are you looking for a way to improve your knowledge about dbt? 🤔
If so, you might be interested in my dbt coaching program.
This program is designed to help you master the best practices of dbt, such as writing modular and reusable code, testing and documenting your data models, as well as deploying your projects to production.
Starting a new project? ✨
Learn how start a dbt project and avoid common pitfall impede the progress. Set higher standards of your project from the beginning to achieve exceptional results.
Team education 🧑🏻💻👩🏾💻
Dedicated coaching sessions can help your team improve their skills and deepen their knowledge. These sessions can be tailored to the needs of the team and your business.
Advanced features 🛠️
Master advanced dbt concepts such as macros, materializations, hooks, packages, etc, that can improve the efficiency of your dbt project.
Coaching topics 🎓
dbt basics and fundamentals
✅ Purpose of dbt
✅ Installing dbt
✅ Writing data models
✅ Data sources
Data modeling best practices
✅ Modeling layers
✅ Naming conventions
Testing and documentation
✅ Generic and singular tests
✅ Writing dbt documentation
Advanced topics
✅ Macros and packages
✅ Advanced materializations
✅ Snapshots and hooks
Deployment and scaling
✅ Dev vs Prod
✅ dbt Cloud and custom schedulers
✅ CI/CD
FAQs
-
dbt (data build tool) is a command-line tool that enables data analysts and engineers to transform data in their warehouses more effectively. It provides a framework to write modular, testable, and reusable SQL code, manage complex dependencies between models, and deploy changes to production.
-
This program is designed for anyone who wants to learn how to use dbt effectively, including data analysts, data engineers, and business intelligence professionals. Whether you're just starting out with dbt or looking to deepen your knowledge, this program can help you take your dbt skills to the next level.
-
The program covers a wide range of topics related to using dbt effectively, including data modeling best practices, testing and documentation, advanced features like macros and packages, and deployment and scaling. We can also tailor the program to your specific needs and interests.
-
Coaching sessions are conducted remotely using Zoom or similar video conferencing tools. We can also arrange in-person coaching sessions, depending on your location and preferences.
-
If you need to reschedule a coaching session, please let me know as soon as possible. I understand that schedules can change, and I'll do my best to accommodate your needs.
-
If you have additional questions or concerns about the program, please don't hesitate to contact us using the contact form. I'll be happy to answer any questions you may have and provide additional information as needed.
Ready to start? 🚀
Or just having a question?
Fill out the form below and I will contact you as soon as possible. Feel free to reach out for a free introductory call to discuss your needs and requests.