Adeveecky | VicAnalytics

Analyst | Data analysis, reporting & dashboards that drive performance | Urban Planner | Infrastructure & Development | 📩 [email protected]

[Adeveecky | VicAnalytics @AnalyticsVic]

I’m Adewale Idowu Victor, a Data & Operations Analyst.

I help organizations analyze data, improve processes, and build dashboards that turn messy information into clear, actionable insights.

#DataAnalytics #BusinessAnalysis #Operations

[Technical Ben @TechnicalBben]

You promised to put yourself out there.

So can you quote this tweet and shamelessly sell yourself? tell us what you do with picture proof.

[👑S.A.L.A.K.O🕊 @UnkleAyo]

I think I understand why they worship Mbappé in France 🇫🇷

Was having an absolute stinker in the first half only to turn it around in the last 10 mins, at wish.

[Adeveecky | VicAnalytics @AnalyticsVic]

@UnkleAyo Solid points. Happy International Men’s Day to all men out there.

[Adeveecky | VicAnalytics @AnalyticsVic]

@TechnicalBben @NdyRajas Happy birthday, Chief. Keep shining 🎊

[Adeveecky | VicAnalytics @AnalyticsVic]

@stellaanalyzes Congratulations and more wins 🎉

[ChiefHerbalist @HerbalistChief]

Rub the inside of your avocado with lime before storing to keep it fresh for longer period of time.

[Adeveecky | VicAnalytics @AnalyticsVic]

@omoAgbabiaka Congratulations…bigger wins on the way. Keep building 🎉

[Benjamin Bennett Alexander @RealBenjizo]

🚫 NEVER Use COUNT to Check for Existence

If you just want to confirm if a particular item exists in your data, do not use COUNT() with a filter (WHERE clause).

SELECT COUNT(*)
FROM users
WHERE email = 'https://t.co/wNujS3iRKR'

The problem is that COUNT(*) answers a different question. It counts the number of rows that meet the condition, even though you only want to know if at least one exists.

When you use COUNT(*), the database may scan all matching rows to compute the total. Even if it finds one match immediately, it can keep going because you asked for a full count. That’s unnecessary work if you are dealing with large tables.

Instead of using COUNT(), use EXISTS

SELECT EXISTS (
SELECT 1
FROM users
WHERE email = 'https://t.co/wNujS3iRKR'
);

👑 With EXISTS, the database will stop as soon as it finds the first match. No counting. No extra scanning.

[Maximus 🪐 @plutostats]

5B66LJV || 5B66W3B

#Bet9jaCode

[Adeveecky | VicAnalytics @AnalyticsVic]

@Mr_Deelaw Yes, I’m in

[Adeveecky | VicAnalytics @AnalyticsVic]

@IyelolaIge I’m well my bro, pushing!

[Adeveecky | VicAnalytics @AnalyticsVic]

@Victor_Odumosu Happy Easter, my Chief 🥂

[Adeveecky | VicAnalytics @AnalyticsVic]

Big lesson:
Stop building generic dashboards.
Nobody pays for a “dashboard.”

They pay for the system that explains why a problem exists.
Operations + Data + Finance = Real asset insight.

[Adeveecky | VicAnalytics @AnalyticsVic]

In many facilities and real estate portfolios, operations happen daily:
• inspections
• maintenance
• complaints
• service
• upgrades

But the data behind these activities is often scattered.
Emails
WhatsApp
Maintenance Logs
Random spreadsheets

Which means insight gets lost

[Adeveecky | VicAnalytics @AnalyticsVic]

Example:
Higher maintenance costs → lower NOI
Lower NOI → weaker DSCR
Meaning operational inefficiencies eventually show up in financial performance.

#ProcessImprovement #Operations #FacilityManagement #BusinessAnalysis #RealEstateAnalytics #DataTracking

[Adeveecky | VicAnalytics @AnalyticsVic]

@emmanuelbasy Communication is a critical part of any data related role and any role at all. Being able to clearly explain your thinking/approach is important as having the technical skills, especially in situations where you’re not directly asked to demonstrate them 👌

[Adeveecky | VicAnalytics @AnalyticsVic]

@Victor_Odumosu @IyelolaIge Beautiful morning, brother