Yet overall satisfaction was only 49.16%.
Sometimes the biggest business problem isn't where everyone is looking.
Built with Excel, Power Query, and AI-assisted Power Query functions.
#DataAnalytics#DataStorytelling#Excel
I thought the airline had a service problem.
The data showed it had a digital problem.
After analyzing passenger satisfaction data, I found that in-flight service and baggage handling were among the strongest-performing areas.
#DataAnalytics#DataStorytelling#DataStorytelling
Customer satisfaction doesn’t drop for no reason—it usually tells a story.
I analyzed a Dano Airlines dataset to identify the decline drivers, using Power Query’s Unpivot feature to prepare the data for analysis.
#DataAnalytics#Excel#PowerQuery#DataStorytelling
VAR – Stores intermediate calculations in variables, making formulas cleaner and easier to maintain.
Eample
VAR CurrSales = [TOTAL SALES]
VAR PrevSales = [PY SALES]
RETURN
DIVIDE(CurrSales - PrevSales, PrevSales)
#Excel#DAX#PowerPivot#DataAnalytics
Did you know that you can use DAX functions directly in Excel?
I recently discovered that you can use DAX functions in Excel through Power Pivot.
After watching a tutorial by Freedom Oboh, I built a few DAX measures myself and discovered a whole new side of Excel.
Power Pivot also lets you create relationships between different tables, making data modeling much easier.
Two concepts I found particularly useful:
✅ Measures – Dynamic calculations that update based on filter context.
Worked on a Data Jobs dataset today using Power Query in Excel.
Cleaned salary data, standardized job titles, transformed location fields, corrected data types, and merged related datasets.
Big news! 🚀 I've been selected for the Tech4Africans Scholarship — Cohort 7!
Proud to be part of a program shaping the next generation of African tech professionals. The Data Analyst journey continues! 📊✨
Grateful to @TechCrushHQ 🙌
#Tech4Africans#DataAnalyst#TechCrush
Statistics isn't just about numbers. 📊
It's about:
→ How your data is collected
→ How your results are interpreted
Ignore either, and you risk falling into the Causality trap — mistaking correlation for cause-and-effect.
#DataScience#Statistics#DataAnalytics#DataLiteracy