OLAJIDE

Behind every successful decision is data interpreted correctly. As a Data Analyst, I focus on understanding problems, building structured models, and delivering insights that actually matter. Here’s a quick introduction to who I am and what I stand for. Growth. Clarity. Results. #datafam #DataCommunity #PowerBI #BusinessAnalytics #dataanalystplaybook

We barely see gospel like this spread and go viral

ESG Data Analytics TikTok LIVE Session Day 2. We went from: Business Understanding → Data Understanding → Dashboard Build Built: - Overview Page - Environmental Dashboard This is how real data analysts work. Follow to see the full ESG project unfold youtu.be/YYZxBE_EUXw

@ibn_wittig Congratulations

Our bundle of joy is here A bouncy baby girl ❤️ Mother & daughter are both fine and well.

@manufcnow @zhasball 🤣😂😂

🚨Leaked footage of how Man United sold Garnacho to Chelsea. 😂

Omo who did this? 😂😂🤣🤣

Here’s the truth most people won’t tell you: Your Excel model isn’t wrong. You are. And it shows up the moment you drag a formula, and everything breaks. Most Excel errors don’t come from complex formulas. They come from one thing: 👉 You don’t control how your references move So Excel does exactly what you told it to do, and your numbers quietly go off. No warning. No error message. Just wrong results. Let me show you what’s really happening: The rule is simple: • Don’t want it to move at all → use $A$1 • Don’t want it to move down → use A$1 • Don’t want it to move across → use $A1 • Want it to move freely → use A1 If you don’t control movement, your model will break. 1️⃣ Relative Reference (A1) This is the default. And where most mistakes start. You write: =B2*C2 Drag it down → Excel shifts it: =B3C3, =B4C4 ✔ Works for row-by-row calculations ❌ Breaks when something should stay fixed Real life: You’re calculating total sales (Price × Quantity). Works, until you introduce a constant. 2️⃣ Absolute Reference ($A$1) This is control. You lock the cell so it never moves. =$A$1*B2 Drag it down → still uses $A$1 ✔ Perfect for constants ✔ Prevents silent errors Real life: VAT (20%) sits in A1. Every calculation must use that exact cell. Without this? Your tax logic quietly breaks. 3️⃣ Mixed Reference (A$1 or $A1) This is where most analysts get exposed. You lock part of the reference: • A$1 → Row locked • $A1 → Column locked ✔ Used in scalable models ✔ Critical for working across rows and columns Real life: • Discounts across top row → use B$1 • Exchange rates in a column → use $B2 Miss this, and your logic collapses at scale. What’s actually going wrong? You think Excel failed. But Excel followed your instructions perfectly. You just didn’t define how your references should behave when copied. When you get it right: • Your models scale cleanly • Your numbers stay consistent • You stop fixing formulas repeatedly When you don’t: • Totals break • Rates shift • Reports become unreliable And worst of all, you might not even notice. Pro move most people ignore: Press F4 after selecting a cell reference. It cycles through: A1 → $A$1 → A$1 → $A1 One key. Full control. So here’s the real question: When your formulas break. Do you actually understand why? Or are you just fixing symptoms? #Excel #DataAnalytics #PowerBI #DataSkills #AnalyticsTips

@FamozzyyK @ManUtd Congratulations

God added a beautiful girl to this family. @ManUtd has a new fan. Congratulations to me and mine 🎊

Stop struggling to find datasets for your data projects. Here are 24 high-quality websites where you can get real-world datasets 🧵👇🏾

@NetworkNoya @Surgexyz_ Keep shipping

NOYANS, we have extra time and loyal Noyans get extra perks. ⭐ We have partnered with @Surgexyz_ and we are competing in the Ignition Race. Bonus Stars are dropping for our most dedicated community members. Here is everything you need to know. 👇

@PamelaNjoku2 😂😂😂😂

Thank God I don collect my 3 points before them sack rosemary 😂😂😂

@chidirolex @jinero234?_r=1&_t=ZS-95khqWg8fAW" target="_blank" rel="nofollow noopener">tiktok.com/@jinero234?_r=…

I’m planning to try out the TikTok Live feature as part of our ESG & Sustainability Week, and I’d love to have you join in. Starting this week, I’ll be going live by 7 pm daily for 30 minutes to 1 hour to work through the ESG Power BI Project together in real time 🫣. Drop Links to your TikTok so I can follow as well. @dataanalyst.playbook" target="_blank" rel="nofollow noopener">tiktok.com/@dataanalyst.p…

God

If your SQL results still need Excel cleanup, you’re doing it wrong. When I started working with SQL, my queries ran, but my results were messy. Extra spaces. Inconsistent casing. Null values everywhere. It felt like cleaning a house with a broken broom. That’s when I realized SQL isn’t just about pulling data, it’s also about cleaning it. And once I learned the right functions, my workflow shifted completely I remember a project where customer names came in all sorts of formats “john doe”, “JOHN DOE”, “ John Doe ” At first, it looked unfixable. But with a mix of TRIM(), UPPER(), and REPLACE(), the dataset went from chaos to clean in minutes. That was the moment SQL stopped feeling like just a query tool, and started feeling like a data workshop 👉Here are 20 SQL functions that changed everything for me: Text Cleanup TRIM(): Remove leading and trailing spaces LTRIM(): Remove spaces from the left side RTRIM(): Remove spaces from the right side UPPER(): Convert text to uppercase LOWER(): Convert text to lowercase REPLACE(): Replace parts of a string SUBSTRING(): Extract part of a string LEFT(): Extract characters from the left side RIGHT(): Extract characters from the right side Set 2: Null & Type Handling CAST(): Change data type CONVERT(): Change data type with formatting option COALESCE(): Handle nul values NULLIF(): Return null if two expressions are equal ISNULL(): Replace null with a specified value CONCAT(): Combine multiple columns Set 3: Quick Checks LEN() / LENGTH(): Get the length of a string CHARINDEX() / INSTR(): Find the position of a substring ROUND(): Round numeric values ABS(): Return absolute value Set 4: Date Handling DATEPART() / EXTRACT(): Extract parts of a date (Year, Month, Day) Cleaning data with these functions completely changed the quality of my reports. Instead of patching issues downstream in Excel or Power BI, I could fix them at the source faster, cleaner, and more reliable. Here’s the pro move: Don’t just use these one by one. Start nesting them - TRIM(UPPER(REPLACE())) and watch messy raw data transform into analysis-ready datasets. So let me ask you which SQL cleaning function do you lean on the most in your daily work ??

@Sanyaa011 Inspired by Balanciaga 😂😂

what do we call this outfit ??

Even the 100k job no dey

🙏🙏🙏

Keep shipping..... gNoya @NetworkNoya

@abazwhyllzz I am sure the husband will give his wife from the swallow he collected when the camera is off.

Tinubu economy no dey affect this family😂