https://www.linkedin.com/in/erickmwangome/

Erick Mwangome - Data & AI, 00100, Moi (2026)

15/12/2025

Most beginners get Power BI completely wrong.

When I started interacting with aspiring data professionals,
I noticed a common pattern:

They think Power BI projects are just:
✅ Importing an Excel file
✅ Building pretty visuals
✅ Sending the PBIX file
✅ Repeating this every week.

But in the real world?
That’s NOT how it works.

I remember speaking to a junior analyst who was
excited about their first reporting task.

Two weeks later, they were frustrated:

“Why am I manually updating this report every day?
Isn’t Power BI supposed to automate this?”

That’s when it hit me:

Power BI is NOT just about dashboards.

It’s about automation, insight delivery,
and strategic decision-making.

Here’s how Power BI really works in business projects:

🔹 Extracting live data with proper ETL (not manual uploads)
🔹 Designing reports based on real business requirements
🔹 Publishing to Power BI Service with scheduled refreshes
🔹 Build once → deliver continuous value

✅ No more repetitive work
✅ No more sending files daily
✅ Real-time insights that drive action

11/12/2025

The Harsh Truth: The Market Has Already Shifted

There was a time when being good at Power BI or SQL alone
could land you a solid data job.

Not anymore.

These days, organizations don’t just want “dashboard creators.”
They want problem solvers, data analysts who understand the entire data journey.

From collecting raw data → cleaning and transforming it → modeling → visualizing insights → and explaining business impact.

If you’re only focused on visuals, you’re already behind.
Because now, most analysts are learning how to:
- Build ETL/ELT pipelines
- Design data models using dbt
- Automate dashboards and insights

AI may not replace you right now.
But someone who can execute end-to-end definitely will.

09/12/2025

You’re not a real BI professional just because you can build dashboards.

Tough truth,
but let’s be real for a second.

Most “portfolio projects” you see online?
They’re just visuals with no backbone.

No data modeling.
No transformation logic.
No automation behind the scenes.

Just a CSV → Power BI → pretty dashboard → post on LinkedIn.

That’s not Business Intelligence.
That’s chart design.

Real BI happens when data flows like it does inside real companies —
from source → database → transformation → model → dashboard → automation.

But here’s the gap:
Most analysts are taught the tools, not the system.
They know Power BI, SQL, maybe Excel,,
but can’t connect the dots.

That’s why dashboards look good,
but don’t run like real systems.

I learned this the hard way.
I once thought visuals were everything,,
until I worked on a project that demanded consistency, automation, and business logic.

That’s when I realized how much I didn’t know.

If you’re feeling stuck between “I can build dashboards”
and “I can build BI systems,”
you’re not alone.

12/11/2025

AI will replace you.

It’s not a question.
It’s not a speculation.
It’s not a futuristic thought.

It’s a statement.

In fact, it already has.

Junior Analysts are using AI to analyze data like Senior Analysts.
Senior Analysts are having ego battles.
And Managers? They’re skipping entry-level hires altogether —
because a small team + AI tools are getting everything done faster.

People might hate me for saying this.
But it’s the truth.

We’re still debating:
“Power BI vs Tableau.”
“SQL or Python — which is better?”

Meanwhile, AI is quietly:
✅ cleaning your data
✅ writing your SQL queries
✅ generating DAX formulas
✅ summarizing dashboards

Whether you like it or not — the game has changed.

Even as a BI professional, it hurts my ego too.
But denial won’t save your career.

So how do you survive this? 👇

Simple.
Let AI automate tasks.
You focus on:
— understanding the business
— asking better questions
— communicating insights that drive action

Because in the AI era, the best analysts aren’t the ones who know the most tools — they’re the ones who create the most impact.

11/11/2025

The reason I don’t attend these “Software, AI & Data Science Summits”

(It’s pure bu****it )

90% of the talk will be:
- “What is AI?”
- “How AI will affect jobs.”
- “AI and Vision 2030.”
- “Our national AI strategy.”

All explained by people who’ve never built anything.

The real gap:

The people talking about AI don’t know how it works,
and the people building it are never invited.

Kenya Software AI Summit 2025
Real builders don’t show up in three-piece suits looking like auditors.

Same script every year:

- Slap “AI” on it
- Fill it with politicians & celebs
- Take photos
- Tweet hashtags
- Call it innovation

We don’t need more summits,
we need builders, funding, and ex*****on.

Say hello to these “AI Engineers & Developers” in the pic below

10/11/2025

Dear recruiters,

If you're looking for a Data Analyst who knows:

-SQL, Python, R, Excel
-Power BI, Tableau, Looker
-Machine Learning & AI
-Web scraping, APIs, Automation
-Data Modeling, ETL pipelines
-A/B Testing, Forecasting
-Cloud tools like Azure, GCP, AWS
-And also great at storytelling, stakeholder management, and making dashboards “pretty”

You’re not looking for a Data Analyst
You’re looking for an entire Analytics Team. 😅

Let’s keep job expectations realistic.
Data Analysts are powerful, but they’re not magicians.

Startups are we together!

08/11/2025

To the client, data analysts look way more handsome/beautiful than data engineers.

Here’s why:

Picture this 👉

Client says:
1️⃣ “The SQL scripts and data pipelines are working great…”
2️⃣ “The Tableau dashboard is really helping us improve our sales performance!”

Now, who do you think they’re more impressed with?

While both roles are equally important,
the data analyst’s work is what the client sees.

-The insights.
-The visuals.
-The KPIs that guide decisions.

It’s like a movie

the director (data engineer) does the magic behind the scenes,
but the actor (data analyst) gets the applause.

Truth is:
-Data analysts often get the spotlight.
-Data engineers build the stage.

So here’s a shoutout to the data engineers making analysts look good.

Without your clean, reliable pipelines and data models,
we’re just making pretty charts out of chaos.

Tag a data teammate who deserves more credit.

Let’s give flowers to both the beauty and the brains behind every data project

07/11/2025

Being “skilled”, ''Guru'' in SQL, Power BI, or Python won’t guarantee you a great data career in 2025.

Dear Data Analyst freelancers

Let me be real with you for a second

Back when I started learning SQL, Power BI, and Python,

I thought mastering the tools was the hard part.

But here’s what I’ve learned working with hundreds of aspiring analysts:

Being smart isn’t rare anymore.
Being visible is.

I’ve seen people with average technical skills land great roles
just because they knew how to package their work and show up online.

I’ve also seen incredibly talented analysts
certified, skilled, and capable, get zero responses…

simply because no one knows what they can do.

It’s not a skills problem.
It’s a visibility problem.

If you’re building a career in data analytics in 2025,

here’s what actually moves the needle:

1.) Positioning > Buzzwords
-Please stop calling yourself “a passionate, detail-oriented individual.”
-Start saying who you help,
-what problem you solve, and how you do it.

Example:
“I help retail businesses make faster inventory decisions by building easy-to-use dashboards in Power BI.”

That tells me what you do
not just who you are.

2.) Proof > Promises

Don’t just say you’re great at analytics.
→ Show me a project.
→ Break down your process.
→ Tell me what impact your dashboard could make.

A simple LinkedIn post explaining a business insight you found is worth more than 5 lines on a résumé.

3.) Visibility > Certifications

Certs are good
but the market rewards visibility.

I’ve seen people with fewer tools in their toolbox get the job because they consistently shared their work and growth journey.

You don’t need 10 badges to show value.
You need to show up.

4.) Proactivity > Potential

-Don’t wait for a job before building projects.
-Don’t wait for permission to teach what you know.
-Don’t wait to feel 100% ready, you won’t.

Apply.
Post.
Build.
Share.
Repeat.

If you feel stuck right now, the problem probably
isn’t your ability to analyze data.

It’s the world not knowing how good you are
because you haven’t told them yet.

Let them see you.

Follow Erick Mwangome - Data & AI

06/11/2025

You were told to “learn high-paying skills” — and you did.
But months later… you’re still broke. Let’s be honest why 👇

1️⃣ You learned the skill... but never learned how to sell it.
2️⃣ You have skills, but no visibility. No one even knows what you can do.
3️⃣ You’re speaking to everyone and attracting nobody.
4️⃣ You’re waiting to be “perfect” — while imperfect people keep getting paid.
5️⃣ You’re not building relationships — just chasing opportunities.
6️⃣ You have no clear offer. If I asked what you sell, would you know?
7️⃣ You’re learning five things at once, so you’re mastering none.
8️⃣ You’re still in “free trial” mode — scared to charge what you’re worth.
9️⃣ You’re stuck in course mode, watching instead of implementing.
🔟 You’re selling to people who don’t even need what you offer.

🎯 The truth?
It’s not your skill that’s holding you back — it’s your strategy and positioning.

Visibility, clarity, and action >>> certifications, every time.

So stop hiding behind “I’m still learning.”
Start showing what you can do, and charge for the value you bring.

06/11/2025

If I married “Business Intelligence” in 2026

These are the people I’d invite to the wedding

1.) SQL & Power BI – the power couple that made BI famous

2.) dbt – the disciplined cousin who loves structure and documentation

3.) PostgreSQL – the reliable old friend who stores everyone’s secrets

4.) Python – the automation buddy who always has a script ready

5.) ETL Tools (Airbyte, Fivetran) – the event planners making sure data arrives on time

6.) Data Modeling – the architect who ensures the house doesn’t collapse

7.) DAX – the mathematical genius who solves family arguments with logic

8.) Power Query – the patient aunt cleaning up everyone’s mess

And of course.,

9.) Stakeholders & Business Teams – the VIP guests, because without them, this whole event makes no sense

People I won’t let near the gate:

⏩ “Dashboard in 10 minutes” YouTube tutorials

⏩ “Learn Power BI = Get a High Paying Job” reels

⏩ “BI is just visualization” myths

Because Business Intelligence isn’t a wedding of tools,

it’s a partnership of data and decisions.

05/11/2025

Stop Calling Dashboards “Business Intelligence”
Most Analysts Are Missing 90% of the Picture!

Most Data Analysts still think dashboards = BI.
Truth is, that’s just the tip of the iceberg.

Here’s what a complete BI system really looks like:

1.) Data Extraction (E)
Pulling data from anywhere:
→ (SQL databases, Excel, APIs, or Google Sheets, you name them,,)

2.) Data Transformation (T)
Cleaning, reshaping, and standardizing:
Power Query, dbt, Python, whatever it takes to make your data usable.

3.) Data Modeling (M)
Structuring tables and relationships that reflect real business logic.

5.) Analytics & Visualization (A)
Crafting reports that actually drive decisions, not just look pretty.

6.) Automation & Deployment (D)
Scheduling refreshes, documenting logic, publishing for stakeholders, and ensuring it runs reliably.

Dashboards are only the surface.
The real power is under the hood.

04/11/2025

They Taught You Power BI.
They Didn’t Teach You Business Intelligence.

Your degree and certifications taught you how to work with data,
but not how to work with the business that depends on it.

They showed you how to import tables,
not how to turn vague business questions into measurable KPIs.

They taught dashboards,
but not how to design data models that reflect how a business actually runs.

They told you to clean data,
but not how to manage stakeholders who panic when numbers change.

They made you think BI is about visuals,
when in reality, it’s about decision systems.

And that’s the gap most analysts never cross,
the gap between reporting data and driving decisions.

Because Business Intelligence isn’t just about Power BI or SQL.
It’s about connecting data logic to business logic,
and that’s something no classroom or certification can truly teach.

You learn it by building.
By breaking things.
By explaining insights to non-technical people until they get it.

If you’re feeling stuck, remember this:

You weren’t hired to build dashboards.
You were hired to help businesses think clearly, using data.

That human, decision-driven side of BI?
It’s not a soft skill.
It’s the core skill.

Erick Mwangome - Data & AI

15/12/2025

11/12/2025

09/12/2025

12/11/2025

11/11/2025

10/11/2025

08/11/2025

07/11/2025

06/11/2025

06/11/2025

05/11/2025

04/11/2025

Address

Website

Alerts

Shortcuts

Share

Category

Listing takedown request