Do no harm but take no shit
White
Joined May 2024
- Tweets2.2K
- Following684
- Followers2K
- Likes3.8K
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.
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)
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.
SQL isn’t scary at all.
Most of the time you’re just doing a few simple things:
-Get data with SELECT
-Filter what you need with WHERE
-Combine tables with JOIN
-Summarize everything with GROUP BY
Repeat and rinse.
Femi: This IF Function in Excel… how does it really work?
Me: Excel’s IF Funtion is basically like a judge sitting in your cell. You give it a question, it looks at the situation, and it decides what answer to return.
You’re not doing magic. You’re just saying, “Excel, check this thing. If it’s true, say this. If it’s not, say that.”
That’s the whole idea.
Say you want to check if the number in A1 is greater than 5.
If it is, Excel should say “YES.”
If it’s not, it should say “NO.”
Here’s the formula:
`=IF(A1>5,"YES","NO")`
Nothing complicated. It’s built on three simple parts:
1. What do you want Excel to check
2. What to show if the condition is true
3. What to show if it’s false
Think of it like asking a friend, is the weather hot?
If they say yes, you wear a T-shirt.
If they say no, you grab a hoodie.
You set those up, Excel does the rest. Across hundreds of rows if you want.
And here's where it gets good—once you get the basic idea, you can build bigger logic. String multiple IFs together. Nest them. Layer them until your spreadsheet starts doing the thinking for you.
Want more beginner-friendly breakdowns? Stick around.
If you understand ERD diagrams in SQL, you already know how Power BI Data Modeling works and vice versa.
Here's why they're essentially the same. Both help you: map table relationships, define cardinality (one-to-many, etc.), visualize data structure
The key difference is just that ERDs is for planning your database structure while Power BI is for building your analytics model.
ERDs and Power BI modeling are basically two doors into the same room. Which door did you walk through first?
Null, zero, empty… they seem the same, right? Almost every beginner mixes them up.
At first glance, all three can look like “nothing.” But in data analysis, they mean completely different things. Once you understand this, datasets stop being confusing and start making sense.”
Null is the true “unknown.”
It doesn’t mean 0. It doesn’t mean blank. It means no value was ever given—the system simply doesn’t know.
Think of it like asking someone their age and they stay silent. They didn’t say 0. They didn’t leave it blank… they just didn’t answer. That’s NULL.
Zero is an actual value.
It means something happened, and that something is 0. If a customer made 0 purchases, that’s still useful information. If a discount is 0%, that tells you something. Zero isn’t empty. It’s a number with meaning.
Empty is a blank field that still exists.
Think of a form where someone typed nothing inside a box and submitted it. The field is there, but it holds empty text. It isn’t unknown like Null, and it isn’t a number like Zero—it’s just a space with no characters.
Here’s the quick way to keep them straight:
Null = no answer
Zero = answer is 0
Empty = answer box was left blank
Once you understand this, you start cleaning and analyzing data with far fewer mistakes. A lot of confusing results suddenly make sense. This is one of those small concepts that changes how you read data forever.
