- Correctness, readability, then optimization.
- Make your Haystacks as small as possible before searching for your needles
- Prefer = to LIKE
- Avoid bookending wildcards in WHERE statements
Read More
Hide
- The goal of any analytics stack is to be able to answer questions about the business with data
- Where data comes from : production data stores, instrumentation, SaaS tools, and public data
- Where data goes : managed data warehouses and homegrown storage
- How data moves around : ETL tools, SaaS connectors, and streaming
- How data gets ready : modeling, testing, and documentation
- How data gets used
Read More
Hide