— Anything & Everything Data
John Kyalo
In a world overflowing with data, clarity is a competitive advantage. I specialize in creating that clarity. I transform fragmented data into intuitive dashboards and meaningful stories that help organizations see patterns, uncover opportunities, and ask better questions.
Projects
SELECT * FROM projects ORDER BY curiosity DESC;
Live and interactive dashboards, end to end analytical work.
01Sales Analytics Dashboard
Interactive Power BI dashboard providing real-time sales insights, KPIs, and trend analysis for a retail company — across regions, products and time periods.
02HealthCare Analysis
A data-driven look at patient data across 10 major hospitals — uncovering trends, costs and insights to improve outcomes and inform smarter healthcare decisions.
03BAL 2026 — Scores to a Story
Near real-time analytics on the Basketball Africa League: live standings and player stats ingested with Microsoft Fabric notebooks into a Lakehouse, modeled, and served in Power BI.
04Profit & Loss Statement
A finance-grade P&L in Power BI: a structure table encodes accounting logic into the model, so Gross, Operating and Net Profit compute — and order — themselves correctly.
05Moving Data Through Fabric
All about the plumbing: Excel sources land in a Lakehouse, Dataflow Gen2 cleans and enriches, a pipeline keeps a Warehouse in sync, and a semantic model with DAX time-intelligence serves the final report.
06Football Merchandise Sales
A Power BI report on fictional football merchandise data, tracking revenue, top-selling products and fan buying patterns across clubs and seasons.
07Credit Analysis
A Power BI deep-dive into lending: disbursements, repayment behavior and portfolio quality in one view — showing where credit risk concentrates and which borrower segments actually perform.
Writing
I think in public. Fresh pieces on data, BI and Microsoft Fabric.
live-synced from Medium
Skills
The toolkit behind the insights.
Data Analysis
Data Visualization
Databases & SQL
Programming
Data Platforms
Certificates
Credentials behind the craft — click any to verify.
Get In Touch
Have a question or want to work together? Feel free to reach out!
Contact Information
Let me help with your data needs
- •Data Analysis & Visualization
- •Business Intelligence Solutions
- •Dashboard Development
- •Data Strategy Consulting