PinnedMadison SchottinTowards Data ScienceHow I Organize My Snowflake Data WarehouseThe databases, schemas, and tables where you should store your data·10 min read·Apr 6, 2022--9--9
PinnedMadison SchottinTowards Data ScienceThe Most Efficient Way to Organize Dbt ModelsNaming conventions, yml files, and folder structures·7 min read·Nov 24, 2021--1--1
PinnedMadison SchottinTowards Data ScienceTired of Airflow? Try This.A new tool that does what Airflow does but better·4 min read·Oct 5, 2021--6--6
PinnedMadison SchottinTowards Data ScienceIs dbt the Future of Analytics?How this tool is changing the way data analysts work·6 min read·Oct 21, 2021--1--1
Madison SchottinTowards Data Science3 Best Practices for Bridging the Gap Between Engineers and AnalystsAssigning code owners, hiring analytics engineers, and creating flywheels·6 min read·Apr 19, 2024----
Madison SchottinTowards Data Science5 Redshift SQL Functions You Need to KnowWith code examples on how to use them·5 min read·Mar 8, 2024----
Madison SchottinTowards Data Science5 Bad Habits Killing Your Potential as a Data EngineerAnd easy solutions that can immediately turn them around·6 min read·Feb 16, 2024----
Madison SchottinTowards Data ScienceData Model Design 101: Composite vs Surrogate KeysWhen to know which type of key to use in your data models·4 min read·Feb 9, 2024--5--5
Madison SchottinDev Genius3 Tips for Dimensional Data Modeling in dbtdbt’s built-in features make it easier than ever to produce high-quality data models·5 min read·Feb 5, 2024--2--2
Madison SchottinTowards Data Science4 Things All Analytics Engineers Must Learn in 2024Foundational knowledge and upcoming trends in the modern data stack·6 min read·Jan 26, 2024--1--1