This is the account I’ll be using from now on for all my data analysis content.
I’m leaving this one inactive for some reasons,
so follow me here to stay connected.
First things first : NULL isn’t a value. It doesn’t mean empty or zero. It means we don’t know what’s here.
That’s why comparisons like = or != doesn’t work with NULL. SQL can’t say if it’s equal to something because it’s literally unknown.
Instead, SQL has a special check: IS NULL and IS NOT NULL
So if you want all users who actually have an email, you write:
SELECT * FROM Users WHERE Email IS NOT NULL;
The other options will fail because they try to compare NULL like a normal value, and that just doesn’t work.
5 weeks of learning.
EXCEL101 was practical, interactive, and most of all fun.
We covered a lot together: from basic data entry to Functions, Descriptive Statistics, Tables, Pivot Tables, Slicers/Timeline, Pivot Chart, Power Query, Power Pivot, DAX, Wireframing..
#Excelboss
Don't feel guilty for using AI when you get stuck. asking ChatGPT to fix a broken SQL query will not make you less of an analyst. It just saves your sanity.
Nobody is giving awards for suffering through errors you could solve in minutes. Your work is judged by accuracy and speed, not by how long you stare at a red syntax message.
Leverage AI, use the tools, and learn from the answers. Keep your energy for the real battles, like understanding your data and delivering insights that matter.
Work smart.
What's your favorite data analytics task to tackle on a Saturday morning!
A) Data cleaning
B) Building dashboards
C) Querying data
D) Other (comment with your preference)