Archive - Brian’s Substack

Major Issues in Causal AI dismantled by a Quantum Physicist at Spotify

A Brief Summary of "From Quantum Physics to Causal AI at Spotify | Ciarán Gilligan-Lee S2E2 | CausalBanditsPodcast.com"

Jun 22 •

January 2025

A Family Tale of Macroeconomic Models

Embedding Solow Model, Diamond OLG Model, Learning-by-Doing Model and their respective problems

Jan 9 •

October 2024

A Tale of Two Friends, Two Loves, and Two Economic Perspectives

A love story that helps you demystify Preference-based and Choice-based approaches in Mircoeconomics

Oct 26, 2024 •

February 2024

7 Deadly Fears I Have Faced - Part 3 - A Data Analyst Journal

Hello everyone!

Feb 15, 2024 •

October 2023

7 Deadly Fears I Have Faced — Part 2 — A Data Analyst Journal

I am glad to have you for the second part of my career journal.

Oct 21, 2023 •

September 2023

Data Cleaning 101 in SQL - #4.2 A Practical Tutorial for Data Deduplication

I am glad to have you for the fourth part of my complete guide on data cleaning.

Sep 17, 2023 •

7 Deadly Fears I Have Faced — Part 1 — A Data Analyst Journal

There are six things the Lord hates, seven that are detestable to him: haughty eyes, a lying tongue, hands that shed innocent blood, a heart that…

Sep 11, 2023 •

August 2023

Data Cleaning 101 in SQL - #4.1 Where does data duplication come from?

Unlike the Queen in Snow White, we data analysts do not possess a Magic Mirror that reveals the location of duplicated data

Aug 21, 2023 •

Data Cleaning 101 in SQL — # 3.2 The Origin of Outliers & Detection Techniques

Everything that exists has an explanation for its existence

Aug 1, 2023 •

July 2023

Data Cleaning 101 in SQL — # 3.1 A discussion on the Nature of Outliers

I like weird people.

Jul 27, 2023 •

Data Cleaning 101 in SQL — #2 Dealing with Missing Data

When you are missing someone, time seems to move slower, and when I’m falling in love with someone, time seems to be moving faster.

Jul 16, 2023 •

Data Cleaning 101 in SQL — #1 Tidying Messy Data

Data cleaning has always been a nightmare that every single analyst has to walk through (like through fire and flames).

Jul 16, 2023 •

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts