Nezzar.Knowles 🗽

Data 📊 | Analytics Engineer 👨💻 | Obsessed with Modern Data Stack | Behind the Scenes 🎥 | Rants 🙂

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

This is a thread that highlight all I have done this year, relating to my journey as an Analytics Engineer & Data Analyst.

If you come across any of the quotes, your kind act of supporting either through liking, reposting or commenting will mean a lot to me.

Cheers 🥂

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

Claude did what I wanted end to end but I’mma spend more time (debugging & understanding) than I could have spent on doing it end to end myself. 🥲

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 7

Do you know you can write Python in dbt as a model?

I had read about the 'how' going through the docs when I started, but never really questioned the 'why' and 'when.'

I did this around.

This is Day 07

#dbt #Analyticsengineer #21daysofdbt

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 6

Today's question: Why do we use macros and when?

As much as the obvious 'why' can be D.R.Y, there's also another one you most likely don't know.

Read along to learn something new.

This is Day 06

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 6

Today's question: Why do we use macros and when?

As much as the obvious 'why' can be D.R.Y, there's also another one you most likely don't know.

Read along to learn something new.

This is Day 06

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 5

Do you know most teams prefer to materialize their intermediate models as ephemeral, which is actually a best practice too?

Read along to learn something new.

This is Day 05

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

If this resonates with you, check the last picture.

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 5

Do you know most teams prefer to materialize their intermediate models as ephemeral, which is actually a best practice too?

Read along to learn something new.

This is Day 05

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 4

Today’s question was born out of realising that every primary key of each table must be tested for uniqueness and not null.

But what happens when it’s not unique, even if not null?

This is Day 4 of 21.

Retweet if you found it valuable.

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

Having your mentor onboard with your plans and also getting a “go ahead” from them >>>>

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

@Saamu_Eleja Vn on whatsapp boss

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

@Saamu_Eleja Amazing one 👏

Quick one: What if someone has already started the community that fits the target audience for your potential product, what should you start doing as a member of the community to prepare the ground before you then launch your product?

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

You mean for the next 90+ days, I won't be hearing ads on Spotify??

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

Really want to attend foreign events online, but no Starlink and 1tb data, yet.

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

@getdbt 🔥🔥🔥🔥

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

Swipe through - If this resonates, then there is something for you at the end.

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 4

Today’s question was born out of realising that every primary key of each table must be tested for uniqueness and not null.

But what happens when it’s not unique, even if not null?

This is Day 4 of 21.

Retweet if you found it valuable.

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 3

Have you always been curious as to why it’s only CTEs we write in the staging layer and not subqueries?

Just like you, I’ve been there. I decided to explore the answer here.

This is Day 3 of 21.

Kindly retweet if you found it useful.

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

Swipe through — and if this resonates, the last picture has something for you.

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 3

Have you always been curious as to why it’s only CTEs we write in the staging layer and not subqueries?

Just like you, I’ve been there. I decided to explore the answer here.

This is Day 3 of 21.

Kindly retweet if you found it useful.

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 2

I’ve had to define source freshness test at the source where my data is coming from, which makes sense, but why not also at the downstream models?

This is Day 2 of 21.

Swipe through — and if this resonates, the last slide has something for you.

[Nezzar.Knowles 🗽 @ebenezer_tomoye]

🚀 21 Days of dbt — Day 2

I’ve had to define source freshness test at the source where my data is coming from, which makes sense, but why not also at the downstream models?

This is Day 2 of 21.

Swipe through — and if this resonates, the last slide has something for you.