Learning to drive decisions quickly, a bias to action, is a critical competency for an analyst.
Every skill you learn – communication, storytelling, experimentation, metrics design, causal inference – supports this.
Here are a few tactics I use to speed up time-to-decision. https://t.co/gtPAnyy0MS (View Tweet)
I lived through the first JS boom, where code moved from server to client.
It was a bad idea, but we did it anyway. It enabled new use cases (like WYSIWYG) and sometimes better UX.
I see a similar shift with data warehouses: code moving from client to (DB) server. This is new. https://t.co/QmeAxddEIg (View Tweet)
Databases like Postgres use indexes. If we query a single row in a table, adding an index makes it fast.
Snowflake doesn’t have indexes. But there are other features that help speed queries up:
1/ Pruning
2/ Clustering
3/ Query Plan Rewriting
Let’s look at each. https://t.co/GXtiOPvA04 (View Tweet)
Let’s talk about actual cost issues with Snowflake and how they could be fixed.
There’s 3 categories that matter:
I have done hundreds of analytical SQL coding interviews. My standards are higher than most. Here’s what you need to know to pass it. https://t.co/twaMvGxi1f (View Tweet)
@imightbemary Major trust builder! I like to include:
what data is busted
why
who owns it
link to fixit ticket
affected areas of reporting (name specific reports if they’re important) (View Tweet)
