Published inTDS ArchiveA Guide to Building Performant Real-Time Data Models4 ways to build fast live modelsAug 12, 20233Aug 12, 20233
Published inLearning SQL4 Techniques to Solve Hard SQL ProblemsWrite complex queries easily with these tipsJul 18, 202314Jul 18, 202314
Published inTDS ArchiveHow to Build an ELT with PythonExtracting, Loading and Transforming DataFeb 7, 20239Feb 7, 20239
Published inTDS ArchiveCan ChatGPT Write Better SQL than a Data Analyst?A LeetCode SQL Competition Between ChatGPT and MeJan 5, 202398Jan 5, 202398
Published inBetter ProgrammingA Guide to Arrays and Structs in BigQueryLearn to work with records and repeated fieldsNov 23, 2022Nov 23, 2022
Published inLevel Up Coding5 Hacks to Become a Jinja MasterWrite efficient templates with these tipsNov 15, 20221Nov 15, 20221
Published inTDS ArchiveHow to Create a dbt PackageReuse models and macros in different projectsNov 4, 20221Nov 4, 20221
Published inBetter ProgrammingAre You Making These SQL Join Mistakes?Two common mistakes and how to avoid themOct 27, 20222Oct 27, 20222
Published inTDS ArchiveHow to Replace DataFrames with Lists of DictionariesSave storage and timeJul 25, 20223Jul 25, 20223
Published inTDS ArchivePredict Transactions On Your Website Using Big Query MLTrain a model on Google Analytics dataMay 18, 2022May 18, 2022
