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