Manuel humble
212 posts
Manuel humble
@ManuelHumble_
Empty pocket and a bag of dreams📊
Katılım Şubat 2017
94 Takip Edilen126 Takipçiler
Just completed my Data Analytics Capstone Project @TechSphereAcad and I genuinely cannot believe how far I've come! 🚀
From staring at 14 tables of raw data to building a 5 page Executive Logistics Dashboard in Power BI! 📊🔥
The struggles were REAL but was worth it! 💪🔥
#DataAnalytics #PowerBI #TSAcademy #CapstoneProject #DataVisualization #GrowthMindset
English
@ObohX Knowing this is q game changer.
Especially when you are dragging down a formula if not properly examined would lead to a misleading result
English
One of the biggest mindset shifts in Excel is understanding "Cell References"
Most people learn formulas like:
=SUM(B2:B10)
…but don’t really understand *why* formulas behave differently when copied across rows and columns.
That’s where Cell References come in.
There are 3 major types:
📌 Relative Reference → `A1`
📌 Absolute Reference → `$A$1`
📌 Mixed Reference → `A$1` or `$A1`
And understanding when to use each one changes everything.
Relative Reference (`A1`)
This changes automatically when copied.
Example:
If you copy:
```excel
=A1+B1
```
down one row, it becomes:
```excel
=A2+B2
```
Excel assumes you want the formula to move with the data.
Best used for:
✔ Row-by-row calculations
✔ Totals
✔ Repetitive calculations across datasets
Absolute Reference (`$A$1`)
This locks both the row and the column.
No matter where the formula is copied, the reference stays fixed.
Example:
```excel
=A2*$F$1
```
If `$F$1` contains a tax rate or exchange rate, every calculation will always reference that exact cell.
Best used for:
✔ Fixed rates
✔ Constants
✔ Parameters
✔ Tax/discount calculations
Mixed Reference (`A$1` or `$A1`)
This locks either:
* the row
or
* the column
but not both.
Example:
`A$1`
→ Row is locked
→ Column can change
`$A1`
→ Column is locked
→ Row can change
This becomes extremely useful in:
✔ Dynamic tables
✔ Matrix calculations
✔ Forecast models
✔ Advanced reporting structures
The interesting thing is this:
Most Excel mistakes are not formula mistakes.
They’re reference mistakes.
People think Excel is “calculating wrong” when in reality the formula is pointing to the wrong cells after being copied.
That’s why understanding references is such a major turning point.
Once you understand how Excel thinks about references, formulas stop feeling random and start becoming predictable.
English
Your Normal Day is someone's Dream , so be thankful
#manuelhumble
English
Be impatient with your actions.
Be patient with your results.
English
Manuel humble retweetledi
5 CLEAR signs you’re LEVELING up as a Power BI dev:
1️⃣ Model first. DAX second.
2️⃣ You think in filter context, not formulas.
3️⃣ Performance Analyzer becomes your best friend.
4️⃣ You don’t build until your questions are answered.
5️⃣ You love reusable assets: themes, design assets, calculation patterns, UDFs
What else?
#powerbi #growth #career #skills #data
English
English
Hi #datafam,
Thrilled to share my submission for the Onyx Data #DNA Challenge (Jan–Feb 2026 edition).
This report dives into sales trends, product performance, regional contributions, site insights, and promotional impact. #DataAnalytics #dataanalysis
English
Daberechi studied Microbiology at the University of Nigeria, Nsukka.
She will tell you, if you ask, that this is not the obvious path to a career in data analytics and she would be right.
But she will also tell you that Microbiology taught her something that no Data Analytics course ever could, how to think in systems, how to trace causality, how to look at something that isn't behaving as expected and ask, calmly, why.
When you spend years studying the behaviour of microorganisms, invisible, complex, operating according to logic that only reveals itself under the right conditions, you develop a patience for ambiguity and a trained eye for pattern.
It turns out these are exactly the skills that make a good data analyst.
And Daberechi is a Very Good Data Analyst!
English
God, if there is anything I need from You this year, it's for You to lead me clearly, and without confusion, into the greatness You already intended for my life. Not greatness for applause or validation, but the kind that brings peace, alignment, and rest in my spirit. I know there will be hills, moments of doubt, and seasons where I don't fully understand what You're doing. Still, I'm asking You not to let me wander, not to let me mistake movement for purpose, and not to let me settle just because I'm tired.
If I try to rush ahead of You, slow me down. If fear makes me shrink, stretch me anyway. Remove what looks good but isn't God, and detach me from what feels familiar but delays my growth.
Teach me how to trust You when You're quiet, how to obey You when it costs me comfort, and how to stand firm when waiting feels heavy. Shape my character for where You're taking me, even when the shaping hurts, even when I don't understand it yet.
I don't need easy, I need right. Cover my mind when fear tries to speak louder than faith, cover my heart when disappointment tries to harden it, and order my steps so I don't miss what You prepared just for me. I give You permission to do the work in me, all of it. I trust You with the becoming, the timing, and the version of me I haven't met yet. Lead me, God, and I will follow. Amen.
English
Hello #Datafam,
For my last dashboard of the year, I built a Power BI dashboard on Primary Health Care (PHC) performance, using simulated data hosted in an Amazon Redshift data warehouse to analyze frontline healthcare delivery across Nigeria.
To explore: bit.ly/4smh30M
English
I am giving you free access to my complete 50 Days SQL Superstar Program.
The earlier SQL playlist helped millions, but interviews today need more depth.
So I am rebuilding everything from scratch to help you crack top product based companies.
I am also organising it in one clean portal with daily videos, notes, datasets, quizzes and certificates.a
To get the enrolment link just:
- Follow me so that I can DM you
- Like and Retweet
- Comment "SQL Superstar"
Free access available for a limited time.
These 50 days can change your life!
#sql #dataengineering #databases
English
Manuel humble retweetledi
𝗚𝗼𝗼𝗱 𝗺𝗼𝗿𝗻𝗶𝗻𝗴, 𝗵𝗮𝗽𝗽𝘆 𝗻𝗲𝘄 𝘄𝗲𝗲𝗸.
Power BI isn’t just about charts and dashboards.
Most people think it’s all visualization, but that’s barely scratching the surface.
Here’s how I’d learn Power BI if I’m starting from scratch today.
𝟭. 𝗘𝗧𝗟 𝘄𝗶𝘁𝗵 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆
This is where everything begins.
Learn to connect to multiple data sources - Excel, SQL databases, APIs, web data, cloud services.
Then master transformations:
→ Cleaning messy data
→ Changing data structures
→ Normalizing tables
→ Enriching datasets
→ Automation with M language
Your data is never perfect. Power Query is how you fix it.
𝟮. 𝗗𝗮𝘁𝗮 𝗠𝗼𝗱𝗲𝗹𝗶𝗻𝗴
This separates average reports from professional analytics.
Learn:
→ Primary and foreign keys
→ Relationships (one-to-many, many-to-many)
→ Star schema vs snowflake schema
→ Normalization techniques
Bad modeling = slow reports and wrong insights.
Good modeling = fast, accurate, scalable solutions.
𝟯. 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝘄𝗶𝘁𝗵 𝗗𝗔𝗫
This is your analytical engine.
Learn:
→ Calculated columns vs measures
→ Filter context and row context
→ Time intelligence functions
→ Iterator functions
DAX turns your data model into a powerful analysis tool.
𝟰. 𝗗𝗮𝘁𝗮 𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻 & 𝗥𝗲𝗽𝗼𝗿𝘁 𝗕𝘂𝗶𝗹𝗱𝗶𝗻𝗴
Now the fun part - but it comes AFTER the foundation.
Learn:
→ Wireframing and layout design
→ Color psychology
→ Chart selection
→ Storytelling with data
→ Interactive features
Your reports should answer questions, not create confusion.
𝗔𝗳𝘁𝗲𝗿 𝘁𝗵𝗶𝘀:
→ Power BI Service for deployment
→ Orchestration and pipelines
→ Performance optimization
→ Advanced features
That’s the roadmap.
Power BI isn’t just drag and drop. It’s a complete data transformation and analysis platform.
Master the fundamentals first. The visuals will follow.
#PowerBI #DataAnalytics #BusinessIntelligence #DataVisualization #Datafam
English
Small reminder
You don’t need to know everything before you start.
You just need to start and stay consistent.
#manuelHumble
English
Manuel humble retweetledi