Madison Schott

I help data professionals learn analytics engineering skills, and companies build scalable modern data stacks using best practices.

[Madison Schott @madisonmaeorg]

SQL case statements are great, but a lot of times they can be replaced by a simpler, more readable function.

Let's look at a SQL case statement and how this can be replaced by the IFNULL function -->

[Madison Schott @madisonmaeorg]

@dbt_labs @Snowflake Overall, I'm most excited to see how performance improves through the new Fusion engine!

I do have my hesitations, though, about dbt Canvas, as this will require some thoughtful considerations for how to implement it across your team.

What do you think? Are you excited?

[Madison Schott @madisonmaeorg]

dbt Labs just launched something HUGE.

Here's what you need to know and what it means for you as analytics engineers:

➡️

[Madison Schott @madisonmaeorg]

@dbt_labs @Snowflake 🆕 dbt Explorer is now dbt Catalog

For Snowflake users, you can now search through tables and views previously only in Snowflake, making it easier to find data assets.

[Madison Schott @madisonmaeorg]

Want a deeper dive on data modeling?

🔔 Be sure to follow me to learn from upcoming
Data Modeling May posts!

📧 And subscribe to my newsletter (link in bio) for weekly analytics engineering resources.

[Madison Schott @madisonmaeorg]

Data Modeling May- Day #1

Why do I need a data model?

Data models take data from multiple sources, transform it, and deliver it in a way that makes querying easier.

[Madison Schott @madisonmaeorg]

Other benefits of data models include:

- improved data quality
- increased scalability
- ability to test
- better data warehouse performance

[Madison Schott @madisonmaeorg]

Do you ever wake up and your brain just decides to choose chaos for the day?

Yup, that's me right now.

A thousand thoughts a minute, but also extreme productivity.

Is this a blessing or a curse? 😅

[Madison Schott @madisonmaeorg]

One of my phrases for 2025 was "just go for it".

So I signed up for a memoir writing class and seriously can't wait.

I've always loved memoirs and have wanted to learn how to write one for the longest time!

If there's something you want to do... just go for it!

[Madison Schott @madisonmaeorg]

@purva_sawant_p Love it!

[Madison Schott @madisonmaeorg]

I'm giving away a 3-month subscription to my paid newsletter, Learn Analytics Engineering.

All you need to do is comment below something you want to learn in 2025.

⬇️ ⬇️ ⬇️

[Madison Schott @madisonmaeorg]

This is a job opportunity you don't want to miss! Our engineering team is building some really awesome features.

[Brendan Carney @brendanrc2]

Kit is hiring an engineering manager with experience leading teams and working in Ruby on Rails.

Join a growing, profitable, fully remote company on a mission to help creators build more valuable businesses.

[Madison Schott @madisonmaeorg]

🔔 Don't forget to follow along so you can see new dbt tips in the month of December!

[Madison Schott @madisonmaeorg]

🎄Day 4 of 12 days of dbt- persist_docs

Have you ever noticed the different properties available on fields when you describe a table in your data warehouse?

Your warehouse allows you to see the datatype, null status, and other features of your columns.

[Madison Schott @madisonmaeorg]

When setting up persist_docs with dbt, ask yourself the questions:

Who is using the model?

Do they have access to dbt docs?

This will help you determine whether or not to enable this feature on the table in your data warehouse!