Femi Ola, BIDA

Microsoft Certified: Power BI Data Analyst Associate || Fabric Analyst

[Femi Ola, BIDA @olamfe]

Great to be part of this! 🚀

I'll be sharing insights from my journey as:

🏆 #2 Global Rank (Power Up)

🛠️ Solution Supplier (Fabric) 📊 37 Solutions Authored

Join me this Saturday! 🔗 https://t.co/3uw7nJqM5S

#MicrosoftFabric #PowerPlatform #DP600

[Femi Ola, BIDA @olamfe]

@cheftee_lead @learnyx_africa New founder? Start here:
• Lean Startup - Eric Ries
• Mom Test - Rob Fitzpatrick
• E-Myth - Michael E. Gerber
• Hard Thing - Ben Horowitz
• Atomic Habits - James Clear
• Deep Work - Cal Newport
Build → validate → sell → systemize → stay disciplined.

[Femi Ola, BIDA @olamfe]

@officialladi_T .xls is the legacy Excel 97–2003 binary format (65,536 rows limit, larger files).

.xlsx is the modern XML-based format (1,048,576 rows, smaller, faster, supports new features).

Note: .xlsx doesn’t support macros (.xlsm does).

Microsoft docs: https://t.co/c9s9ypFKyA

[Femi Ola, BIDA @olamfe]

If you understand this, you’re ahead of most beginners.

📌 Save this
🔁 Repost

Part 2 (Aggregation) next.

#SQL #DataAnalytics #DataAnalyst #LearnSQL #TechTwitter

[Femi Ola, BIDA @olamfe]

Most junior data analysts struggle with SQL…

Because they think it’s coding.

It’s NOT.
Here’s how to start the right way 👇

[Femi Ola, BIDA @olamfe]

This is how analysts actually think:

👉 What do I want?
👉 Where is the data?
👉 Do I filter, group, or sort?

Don’t memorize SQL. Learn patterns.

[Femi Ola, BIDA @olamfe]

@TheIbibioGirl

[Femi Ola, BIDA @olamfe]

@TheIbibioGirl VBA → still powerful for desktop automation
https://t.co/4CDFDUDR17

So Excel is no longer just a spreadsheet.

👉 A lightweight automation platform for business workflows
VBA → desktop automation
Office Scripts → cloud automation
Power Automate → cross-app workflows

[Femi Ola, BIDA @olamfe]

@TheIbibioGirl .xls is the legacy Excel 97–2003 binary format (65,536 rows limit, larger files).

.xlsx is the modern XML-based format (1,048,576 rows, smaller, faster, supports new features).

Note: .xlsx doesn’t support macros (.xlsm does).

Microsoft docs: https://t.co/c9s9ypFKyA

[Femi Ola, BIDA @olamfe]

@ExtracoolBB @mrfuture1999 B / B / B ✅

Most “analysis” problems are actually data quality issues.
Handle blanks, fix data types, and use
Power Query for scalable transformations.

[Femi Ola, BIDA @olamfe]

@RuthChika12 = mem.customer_id
JOIN menu m ON s.product_id = m.product_id
WHERE s.order_date >= mem.join_date
) t
WHERE rn = 1;
```

ROW_NUMBER() = assigns numbers per customer (1 = first purchase)

[Femi Ola, BIDA @olamfe]

@RuthChika12 ```sql
SELECT customer_id, product_name, order_date
FROM (
SELECT s.customer_id, m.product_name, s.order_date,
ROW_NUMBER() OVER (
PARTITION BY s.customer_id
ORDER BY s.order_date
) rn
FROM sales s
JOIN members mem ON s.customer_id

[Femi Ola, BIDA @olamfe]

@RuthChika12 You can strip symbols but only after you have extracted and stored the currency separately. If you just strip them and stop, £100 and $100 both become “100” (wrong). Correct workflow: extract → strip → convert with exchange rates → normalize.

[Femi Ola, BIDA @olamfe]

@omoafe @JA_Olaoye 🔥 Hot take: Don’t start Azure AI with AI‑102 — it retires June 30, 2026 (exam) / July 31, 2026 (cert)
Replacement: AI‑103 (GenAI + Agents)

AI‑102: https://t.co/FxAbdoFLuJ

Cert retirement: https://t.co/43bPdUzOtJ

AI‑103: https://t.co/nMdkwMK2Ym

[Femi Ola, BIDA @olamfe]

@RuthChika12 Follow @DataFestAfrica here on X and visit https://t.co/8komAe9v46.

Pro-tip: Turn on notifications for their tweets so you don't miss the Early Bird tickets- they go fast! 🚀 #Datafam