John Ohaka

Entry-level data analyst | SQL Server, Power BI, Excel

View My GitHub Profile

About

I am an entry-level data analyst. I use SQL Server, Power BI and Excel to turn raw data into clear findings. I work as a Data & Operations Intern at a nonprofit alumni organization, where I build enrollment leaderboards, performance trackers and quarterly trend analyses. I completed the Data Analytics training at ALIWA (Africa Leadership Initiative West Africa) and I am building a public portfolio of real projects. I am open to remote opportunities.

Projects

MallPulse Istanbul: Retail Shopping Intelligence

Analysis of 99,000+ retail transactions across 10 Istanbul malls (2021 to 2023). I cleaned the data and wrote the SQL analysis that answers 8 business questions. A Power BI dashboard is being rebuilt for this portfolio.

Tools: Excel, SQL Server, Power BI (dashboard rebuild in progress)

View the project on GitHub

Coming next

Skills

Contact