Marie TruonginTowards Data ScienceA Guide to Building Performant Real-Time Data Models4 ways to build fast live models·7 min read·Aug 12, 2023--3--3
Marie TruonginLearning SQL4 Techniques to Solve Hard SQL ProblemsWrite complex queries easily with these tips·5 min read·Jul 18, 2023--13--13
Marie TruonginTowards Data ScienceHow to Build an ELT with PythonExtracting, Loading and Transforming Data·7 min read·Feb 7, 2023--9--9
Marie TruonginTowards Data ScienceCan ChatGPT Write Better SQL than a Data Analyst?A LeetCode SQL Competition Between ChatGPT and Me·6 min read·Jan 5, 2023--94--94
Marie TruonginBetter ProgrammingA Guide to Arrays and Structs in BigQueryLearn to work with records and repeated fields·5 min read·Nov 23, 2022----
Marie TruonginLevel Up Coding5 Hacks to Become a Jinja MasterWrite efficient templates with these tips4 min read·Nov 15, 2022--1--1
Marie TruonginTowards Data ScienceHow to Create a dbt PackageReuse models and macros in different projects·4 min read·Nov 4, 2022--1--1
Marie TruonginBetter ProgrammingAre You Making These SQL Join Mistakes?Two common mistakes and how to avoid them·3 min read·Oct 27, 2022--2--2
Marie TruonginTowards Data ScienceHow to Replace DataFrames with Lists of DictionariesSave storage and time·6 min read·Jul 25, 2022--3--3
Marie TruonginTowards Data SciencePredict Transactions On Your Website Using Big Query MLTrain a model on Google Analytics data·5 min read·May 18, 2022----