09 Dec dbt 101 (EU and US-friendly), Fishtown Analytics
Adam M. , Northwest USA – Just Host the WORST Hosting Company on the Internet! – I work in internet marketing and know for myself that #Justhost is the worst hosing company you can find. Over a year after I cancled my hosting with them I got 3 e-mails demanding overdue payments. Upon called them after each e-mail I received some lame excuse on why they sent it to me and how it was a mistake. After that I got a letter from them and had the threaten to sew before they would stop contacting me. Terrible customer service, Very Unethical behavior and crappy you have to threaten to sew before they stop giving you crap. Don’t walk away from #Justhost RUN!!!
You probably know that data is a huge part of how the world runs now, including how businesses report on metrics and how they operate.
One of the difficult parts of working with data is communicating enough context and information to everyone in the organization so they understand the data they’re looking at and whether it answers their questions.
That’s where dbt comes in. dbt is a data transformation and documentation tool that helps data analysts, data engineers, and business stakeholders collaborate on data.
This dbt tutorial will walk you through: a short history of ELT, what is dbt (data build tool), and dbt core concepts.
The core dbt concepts include:
– Expressing transforms with SQL select
– Automatically build the DAG with ref(s)
– Tests ensure model accuracy
– Documentation is accessible and easily updated
– Use macros to write reusable SQL
Learn more about dbt at:
Tweets by getdbt
Learn more about Fishtown Analytics at:
Tweets by fishtowndata