Yaw Assensoh Opoku

Hello, I'm Yaw Assensoh Opoku Data Analyst · Operational Background · Business-First Mindset

I translate complex data into actionable business insights. With hands-on experience in operations and logistics, I bridge the gap between technical analysis and real-world business impact. Former logistics entrepreneur turned analyst — I don't just find patterns, I solve problems

View Featured Projects My Story

Featured Case Studies

Data-Driven Business Impact

Selected projects demonstrating how I transform complex data into actionable business strategies and measurable outcomes.

Real Estate & Economic Analytics

US Housing Affordability Analysis

3-phase analytics project examining affordability crisis across 5 major US cities (2015-2024). Combined Excel, SQL, and Python with machine learning forecasting and interactive Streamlit dashboard.

2.22 LA affordability index — requires $200K+ income for median home

3 distinct market clusters via K-Means validated by SQL

36-month SARIMA forecasts with 95% confidence intervals

View Full Case Study

Supply Chain & Operations

NYC Citi Bike Supply Optimization

Developed demand forecasting model with 0.82 temperature-usage correlation to optimize bike distribution across 1,500+ stations, reducing operational costs while improving customer satisfaction.

40% seasonal fleet scaling recommendation

20-25% revenue increase through dynamic pricing

4-week advance forecasting for proactive planning

View Full Case Study

E-commerce & Retail Analytics

Instacart Market Basket Analysis

Customer segmentation and product association analysis that identified 12 high-probability product pairs, enabling targeted marketing and strategic bundling to increase average order value.

35-37% high spenders identified for targeting

15% AOV increase through product bundling

65%+ co-purchase rates on identified product pairs

View Full Case Study

Financial Analytics & Investment

Financial Markets Intelligence Platform

Quantitative analysis of technology stocks delivering 243% average returns vs. 100% SPY benchmark, with risk-adjusted portfolio optimization and momentum-based allocation strategies.

343.9% TSLA returns with risk management framework

Optimal risk-adjusted positioning with MSFT core strategy

58.9 RSI momentum signals for tactical allocation

View Full Case Study

Healthcare Analytics & Forecasting

Influenza Staffing Forecast Model

ARIMA-based predictive model with 89% accuracy for 4-week influenza forecasts, enabling optimized hospital staffing and resource allocation during peak seasons.

23% overtime cost reduction through optimized staffing

95% mortality in 65+ group identified for targeted care

4-week advance planning for proactive resource allocation

View Full Case Study

View All 9 Projects

My Professional Journey

From Logistics Operations to Data Insights

For years, I owned and operated a logistics business in Hamburg, where every decision—from route optimization and dispatch planning to customer segmentation—depended on understanding complex operational data. I wasn't just analyzing numbers; I was using them to make real-time decisions that directly impacted revenue, efficiency, and customer satisfaction.

This hands-on entrepreneurial experience taught me that data isn't just about finding patterns—it's about solving practical business problems. When I discovered I could formalize these skills through data analytics, it wasn't a career change; it was a natural evolution. I've simply added Python, SQL, and Tableau to the toolkit I'd been developing for years.

Proven Business Impact:

                
                10% monthly revenue increase through data-driven demand forecasting in my logistics business
              

15% delivery efficiency improvement via route optimization analysis

20% growth in repeat business from customer segmentation insights

25% reduction in maintenance downtime through proactive monitoring systems

What Makes My Approach Unique:

Business-First Mindset: I start with "What problem are we solving?" not just "What does the data show?"
Entrepreneurial Perspective: Having run a business, I understand how insights translate to revenue and customer satisfaction
Operational Experience: Years in logistics mean I understand process optimization from the ground up
Communication Bridge: I excel at translating technical findings into actionable business recommendations
Multilingual Advantage: Fluent in 5 languages (English, German, Italian, Spanish, French), I bring cultural awareness to global data challenges

Today, I combine my operational expertise with advanced analytical skills to help organizations make smarter, data-driven decisions. Whether it's optimizing supply chains, predicting customer behavior, or uncovering revenue opportunities, I bring a practical, results-oriented approach to every project.

Explore My Projects Download Full Resume

Portfolio