- DBT building blocks
- DBT environment – yml files and structure
- Develop an ELT from source to target – transformations
- Using macro, Jinja and hooks
- Test your code and transformations
- Case study – DVD rental chain from operational DB to DWH.
- Deploy DBT
I am in the field of information technology for more than 15 years.
I have a master’s degree (MBA) in information technology.
I worked as an ERP consultant, BI team leader,
ETL team leader and a CIO of a company.
During those years I worked will all kinds of software like:
ERP, CRM, custom applications and BI (DWH, ETL, BI tools).
I designed tens of data warehouses (SQL / NoSQL) like:
Postgres, SQL Server, Mysql, Oracle, Redshift, BigQuery,
Vertica, MongoDB, and others Big Data and regular relational ones.
Also, I have worked with all kinds of visualization tools like:
YellowfinBI, Sisense, Pentaho, Tableau, Power BI and more.
I am an expert in business processes.
my main Job was to translate those into working solutions.
My experience includes:
More than 10 years working with Pentaho kettle
as the leading Data integration tool.
"All of these areas gave me a unique perspective
of business processes
and how to analyze a company by looking at the large picture.
Today, I want to share my knowledge with you."