Richard Noruwa

Business Analyst | Data Analyst | SQL, Python, Tableau, Power BI, Excel

Skills | Key Projects | Video Insights | Contact Me

Skills

SQL, Python, Tableau, Power BI, Excel


Key Projects

Python | Fuel Economy Data Visualization

Analyzed 398 vehicle records using Python and Seaborn to identify how weight, engine power, region, and model year affect fuel efficiency. Found that heavier vehicles averaged up to 30% lower MPG. For a company managing a vehicle fleet, this type of analysis could save thousands annually by guiding purchasing toward lighter, more efficient models.

SQL | Art Across Borders

Used SQL joins, subqueries, and aggregations to analyze collections across 50+ museums and 20+ art styles. Found that Impressionism dominated the Metropolitan Museum's holdings at 244+ works. A museum or gallery could use this kind of analysis to identify gaps in their collection, plan exhibits around underrepresented styles, or target acquisitions strategically.

Power BI | Adventure Works

Built an interactive Power BI dashboard analyzing sales and profit trends by product, category, and region. Designed for executive-level reporting so leadership could quickly identify which product lines and regions were driving revenue and where margins were shrinking.

Python | Yelp Review Bias Detection

Analyzed 109,000+ Yelp reviews across 16,000+ businesses in Philadelphia, Tampa, and Indianapolis using Python. Found a 0.63-star rating gap between cuisine types (pizza at 3.52 vs Indian at 4.15), extreme neighborhood disparities with some zip codes averaging under 2 stars, and that 18% of 1-star reviews contained positive language — suggesting retaliatory reviewing behavior. A platform like Yelp could use this to audit its recommendation algorithm for geographic and cuisine-type bias, and restaurant owners could better understand how location and category affect their visibility.

Tableau | COVID-19 Impact on Food Consumption

Built an interactive Tableau dashboard analyzing global food consumption shifts during COVID-19 across demographics. A grocery chain or food manufacturer could use this to anticipate demand changes during disruptions and adjust inventory or product strategy ahead of the curve.

Excel | Movie Profitability: Revenue vs. Budget

Analyzed movie budgets against box office revenue using pivot tables, statistical calculations, and visualizations. Found that family films with PG ratings and medium-to-high scores consistently delivered the highest return on investment, while horror films with high scores also showed strong profitability. A production studio or investor could use this to prioritize funding toward genres and rating categories with the best ROI track record.


Video Insights


[email protected]
linkedin.com/in/richard-noruwa-166a622b2
(317) 660-5741
https://calendly.com/noruwa-richard/30min