Skills | Key Projects | Video Insights | Contact Me
SQL, Python, Tableau, Power BI, Excel
Python | Fuel Economy Data Visualization
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.
[email protected]
linkedin.com/in/richard-noruwa-166a622b2
(317) 660-5741
https://calendly.com/noruwa-richard/30min