@q1
Nothing here yet.
Nothing here yet.
May 4, 2025 · 2 min read · WHAT IS COALESCE()? In simple terms, COALESCE() helps you choose the first non-null alue from a list. BASIC SYNTAX COALESCE(value1, value2, value3, ...) It checks each value in order and returns the first one that is not NULL. SIMPLE EXAMPLES -- exa...
Join discussionMay 4, 2025 · 3 min read · Once I had cleaned the raw files (visit_history_clean, client_info_raw, and invoice_raw), my next goal was to combine them into a single, master-level view of every customer—no matter which dataset they appreaed in. Each dataset offered part of the p...
Join discussionApr 21, 2025 · 2 min read · After importing the raw CSV files into PostgreSQL, the first thing I tacked was cleaning and standardizing the datasets to make them analysis-ready. What kind of cleaning? It started with the basics: Fixing blank or inconsistent values Converting d...
Join discussionApr 19, 2025 · 2 min read · After importing the raw CSV files into PostgreSQL, I noted that many of the columns were set to generic data types like varchar(50) or even just text. Totally normal, but definitely not ideal if you’re planning to run serious analysis. What does ALTE...
Join discussionApr 19, 2025 · 2 min read · This is my very first Business Intelligence analysis project after pivoting from a 7-year career in eCommerce strategy to business intelligence. I wanted to get closer to the data, explore customer behavior on a deeper level, and build an analytical ...
Join discussion