El-hanan Garba

Data Analyst & Business Intelligence Analyst

Interactive Projects • SQL • Power BI • Excel • Python • AI-Driven Analysis

I’m a Data Analyst and Business Intelligence Analyst focused on turning raw data into clear, actionable insights that drive measurable results. I work with SQL, Power BI, Excel, Python, and AI-assisted tools to handle everything from data modeling and DAX calculations to ETL processes, data visualization, and statistical analysis. I enjoy building reliable dashboards and reports that support day-to-day decisions while also contributing to long-term data strategy. Explore my projects below and feel free to reach out at the end.

PROJECTS

CYCLISTIC BIKE SHARE ANALYSIS (SQL PROJECT)

I explored 12 months of Cyclistic bike-share data. 5.5 million trips from Nov 2024 to Oct 2025 to understand how annual members and casual riders use the service differently. Using PostgreSQL, I broke down ride frequency, duration, daily and weekly patterns, seasonal trends, and bike type preferences to uncover what influences each group’s behavior. The goal was to surface insights the marketing team could use to convert more casual riders into annual members. See the full project on GitHub linked here.

AWESOME CLINIC PERFORMANCE DASHBOARD (POWER BI PROJECT)

This project leverages visual analytics to help Awesome Clinic track operational performance, uncover what’s driving patient volume, and identify areas for improvement. It highlights patient trends, departmental demand, referral variability, and inpatient utilization using key KPIs. Built with Power Query, a relational data model, and DAX measures, the dashboard transforms 4,000 patient records into clear, actionable insights for leadership decision-making. See the full project on Power BI right here.

VIVA CALIF E-COMMERCE SALES DASHBOARD (EXCEL PROJECT)

>I investigate pricing patterns across neighbourhoods, how accommodation capacity drives listing prices, and whether new host activity and average pricing shifted in the years following the 2015 short-term rental regulations. Through Python-driven analysis, I explore the key factors affecting pricing and the measurable effect of regulation on the Paris market. See the full project on GitHub linked here. Analyzing the Paris Airbnb market reveals a compelling story about the real world impact of policy change.

AIRBNB LISTING ANALYSIS (PYTHON PROJECT)

I investigate pricing patterns across neighbourhoods, how accommodation capacity drives listing prices, and whether new host activity and average pricing shifted in the years following the 2015 short-term rental regulations. Through Python-driven analysis, I explore the key factors affecting pricing and the measurable effect of regulation on the Paris market. See the full project on GitHub linked here. Analyzing the Paris Airbnb market reveals a compelling story about the real world impact of policy change.

Contact

Send a Message

Socials

© 2026 El-hanan Garba. All rights reserved.