Henry Umar
178 posts

Henry Umar
@htmanalytics
I turn numbers into narratives that empower smarter decisions. Data Analyst | Excel | Power BI | SQL | ODK | Python| SPSS |📩[email protected]
Abuja, Federal Capital Territo Katılım Eylül 2024
119 Takip Edilen11 Takipçiler


@Adikastakes It is still the same you guys will say, Arsenal is playing boring football. Now, Leverkusen cannot withstand Arsenal’s pressure
English

@Waspapping_ Welcome back, Sarki. I am elated seeing you online
English

Following my interaction with the relevant security agencies, I have reflected on some of my past tweets and recognize that the tone may have come across stronger than intended. My comments were made in the context of online political commentary, not out of hostility toward any country or its people.
I deeply respect the longstanding relationship between Nigeria and the United States @USinNigeria , as well as other friendly nations, and the many Nigerians who live, work, and thrive in those countries.
Where my words were misunderstood or caused offence, I sincerely regret that. As a patriot, I remain committed to promoting peace, mutual respect, and the security of our dear country while continuing to advocate for a better future for all.
I appreciate all the well-meaning Nigerians and friends who have stood by me during this phase of my first encounter with the security authorities, and I commend the professionalism shown, as well as the respect accorded to me by the personnel throughout the process. I do not take this support for granted.
English

@PoojaMedia Too many competitions in the premier league. The players are fatigued
English

𝗧𝗵𝗲 𝗶𝗺𝗮𝗴𝗲 𝗼𝗻 𝘁𝗵𝗲 𝗹𝗲𝗳𝘁 𝘄𝗮𝘀 𝗺𝘆 𝘀𝗲𝘁𝘂𝗽 𝗮𝘁 𝘁𝗵𝗲 𝗲𝗻𝗱 𝗼𝗳 𝟮𝟬𝟮𝟯.
Learning data analytics.
Earning ₦30k per month.
The one on the right is my current setup.
I’m sharing this not to flex. But to encourage you.
Have I gotten to where I envisioned? No.
Did I fail multiple times? Yes.
Did I win? Absolutely.
Success isn’t linear.
There were months I didn’t know how I’d pay bills. Projects that went nowhere. Clients who ghosted. Opportunities that fell through.
But I kept learning. I kept building. I kept showing up.
And things started compounding.
One skill led to another. One project led to the next. One person I helped came back with someone else who needed help.
It wasn’t dramatic. It was gradual.
But it was real.
Here’s what I learned:
Everything compounds.
The SQL you learn today might not pay off for 6 months. But when it does, it pays.
The portfolio project you build when no one’s watching? Someone will see it eventually.
The person you help for free? They might become your biggest advocate.
Nothing is wasted.
Hardwork pays. But smart work pays faster.
I worked hard in 2023. But I didn’t work smart.
I was learning everything. Building nothing specific. Chasing every opportunity.
Now I focus. I build in public. I teach what I learn. I help people solve real problems.
That shift changed everything.
Don’t give up.
I know it’s hard. I know it feels like everyone else is moving faster. I know the rejections hurt.
But keep going.
Learn every day. Build every day. Pray every day.
Success is inevitable if you don’t quit.
I’m still on this journey. I haven’t arrived. But I’m not where I was.
And neither will you be if you keep moving.
One step at a time.
#DataAnalytics #Datafam


English

Big boy purchase…
The main one 😏😏
Thank you Jesus..
Thank you Data Analytics
Thank you Ife mi
#dataengineering #Datafam




English

𝗔 𝗳𝗲𝘄 𝘄𝗲𝗲𝗸𝘀 𝗮𝗴𝗼, 𝗜 𝗴𝗼𝘁 𝗰𝗮𝗹𝗹𝗲𝗱 𝗶𝗻𝘁𝗼 𝘁𝗵𝗲 𝗼𝗳𝗳𝗶𝗰𝗲.
“We’re moving to a cloud solution. It works seamlessly with PostgreSQL.”
“Great.”
“Our entire database is in SQL Server.”
“…oh.”
“Can you migrate it? Two weeks.”
Sure. No problem.
(It was absolutely a problem.)
I had to move 1,055,008 rows without losing a single record or breaking production.
𝗙𝗶𝗿𝘀𝘁 𝘀𝘂𝗿𝗽𝗿𝗶𝘀𝗲: 𝘆𝗼𝘂𝗿 𝗱𝗮𝘁𝗮 𝗶𝘀 𝗮𝗹𝘄𝗮𝘆𝘀 𝗺𝗲𝘀𝘀𝗶𝗲𝗿 𝘁𝗵𝗮𝗻 𝘆𝗼𝘂 𝘁𝗵𝗶𝗻𝗸.
Pre-migration audits found:
→ 4,514 customers with NULL names
→ 27,318 invalid emails
→ 24,700 orphaned foreign keys
→ 775 negative prices
This system had been “working” for years.
𝗟𝗲𝘀𝘀𝗼𝗻 𝘁𝘄𝗼: 𝘆𝗼𝘂 𝗰𝗮𝗻’𝘁 𝗷𝘂𝘀𝘁 𝗲𝘅𝗽𝗼𝗿𝘁 𝗮𝗻𝗱 𝗶𝗺𝗽𝗼𝗿𝘁.
So I built a proper pipeline:
→ Automated schema extraction
→ Dynamic SQL Server → Postgres type mapping
→ Batched bulk loads (1k rows at a time, 100x faster)
→ Full validation checks on every table
There’s nothing more terrifying than pressing “execute” on 900k customer records.
So I built a validation dashboard first.
If the numbers didn’t match exactly, nothing shipped.
𝗙𝗶𝗻𝗮𝗹 𝗿𝗲𝘀𝘂𝗹𝘁:
✅ 1,055,008 rows migrated
✅ 100% validation pass
✅ Zero downtime
✅ One very relieved manager
The migration wasn’t the hard part. Trusting the data was.
Documentation : github.com/Nte-Daniels/Da…
Thank you @sdw_online for the tutorial
#DataEngineering #SQL #ETL #Python #Datafam




English

@Waspapping_ Happy birthday to the twins.
Wishing them Allah’s blessings
English

Every Monday morning at Saint Freedom Health, the same conversation happened, but in two different languages.
Kunle from Finance would walk into the boardroom, staring at his spreadsheets. All he saw was the ₦12.9M outstanding balance and a collection rate that was sitting at 56.2%. To him, the hospital was a "leaky bucket" of revenue. "We need to tighten the belt," he’d say. "The numbers aren't adding up."
On the other side of the table sat Folashade, the Medical Director. She wasn't looking at the naira; she was looking at the people. She was worried about why 27.3% of their patients were hypertensive and why clinical risk factors were trending upward. To her, "tightening the belt" meant compromising on the care that kept those 2,000 patients alive.
The problem? Kunle didn't see the patients, and Folashade didn't see the payroll. They were two captains steering the same ship in different directions.
That’s where the data comes in.
I built this two-page dashboard to be the bridge between Kunle’s ledger and Folashade’s stethoscope.
Page 1 (The Pulse of the Patient): Gives Folashade a 360-degree view of population health, from BMI distributions to real-time vitals trends.
Page 2(The Pulse of the Business): Gives Kunle the clarity he needs on claims, revenue by payer, and AR days. No more guessing where the money is stuck.
When we put these two pages together, the conversation changed.
Kunle realized that healthy, well-managed patients lead to better insurance claims. Folashade realized that a financially stable hospital is the only way to afford the best equipment.
At Saint Freedom Health, we’ve stopped speaking two different languages. We’ve started speaking the language of Data.
Because at the end of the day, you can’t have clinical excellence without financial sustainability, and you can’t have either without a clear view of the truth.
To my Health Professionals & Data Community:
I’m curious to hear your thoughts.
Does this capture the reality of the "Finance vs. Clinical" tension in healthcare?
How did I do with the metrics? Do these KPIs give you enough direction to make a decision?
I’d love your feedback in the comments! 👇
Tool: @msexcel
#DataAnalytics #HealthIT #HealthcareManagement #BusinessIntelligence #DataStorytelling #Excel



English













