Author: Jose S
What to do when a coworker asks for access to your company’s production database
Match access to the question: sample, masked, or production read with an owner and an end date. Least privilege survives deadlines better than forever prod grants.
How to ask better data questions in meetings
Ask data questions that name the decision, window, segment, and success criteria. Use a question ladder so meetings end with an answerable next action.
How to build and test your first data models with dbt, a SQL tool
Turn layout into working models. Write your first staging and mart SQL, wire refs, add unique and not-null tests, and run a small build you can actually explain…
How to calculate a conversion rate correctly
Write conversion as success over eligible with a clear window. Definition cards beat dashboard magic when the same funnel stage means three rates.
Data warehouse, data lake, or plain database: which one does your data need?
App database, warehouse, or lake? Walk a plain decision tree for where data should live so product traffic, cheap history, and certified analytics stop fighting over one system.
