Offonry Larry Okechukwu
Business Intelligence | Data-Driven Decisions
Professional Portfolio
Nollywood Cinema Archive Database
The Challenge
West Africa's film industry had zero structured historical data. Film metadata lived in fragmented blog posts, oral histories, and incomplete sources making cultural research, distribution tracking, and industry analysis impossible.
My Approach
- Designed Excel-based relational database with normalized schema
- Built zero-hallucination verification protocol: every data point cross-referenced against 3+ primary sources
- Created weekly research pipeline documenting 8-12 films per week with full metadata (directors, cast, release dates, distribution channels, themes)
- Delivered professional research reports with academic-grade citation standards
Impact & Results
- 120+ films documented, each cross-verified against 3+ primary sources
- Created West Africa's first structured cinema archive database
- Enabled cultural research, distribution pattern analysis, and academic scholarship
Tools Used
Advanced Excel (VLOOKUP, INDEX-MATCH, Data Validation), Google Sheets, Database Design, Research Methodology
PowerBi Project
The Challenge
Transform raw FIFA World Cup squad data into actionable insights about team strategies, player demographics, and global football dynamics for the Qatar 2022 tournament.
My Approach
- Analyzed player demographics across all 32 participating nations (age, position, international caps)
- Examined performance metrics including goals scored, World Cup goals, and tournament readiness indicators
- Mapped league and club affiliations to identify talent concentration patterns
- Built interactive Power BI dashboard revealing team composition strategies and competitive advantages
Impact & Results
- Uncovered patterns in team age strategies (veteran-heavy vs. youth-focused squads)
- Identified league dominance trends showing which domestic leagues supplied most World Cup talent
- Revealed position-specific insights on squad construction across different footballing philosophies
- Demonstrated data modeling skills with multi-dimensional player and team datasets
Tools Used
Power BI (Interactive Dashboards, DAX Measures, Data Modeling), Data Cleaning, Exploratory Data Analysis
PowerBi Project
The Challenge
Analyze Super Bowl commercial performance across multiple years to uncover patterns in creative themes, cost efficiency, engagement trends, and brand competitiveness for media buyers and brand strategists.
My Approach
- Aggregated multi-year Super Bowl commercial data including costs, themes, viewer engagement, and brand performance
- Built DAX measures to calculate cost-per-engagement, brand frequency, and creative theme effectiveness
- Designed interactive Power BI visuals answering key business questions: Which themes drive engagement? Which brands get best ROI?
- Created thoughtful data model enabling drill-down analysis by year, brand, and creative category
Impact & Results
- Identified highest-performing creative themes based on engagement metrics
- Revealed cost efficiency patterns showing which brands maximize impact per dollar spent
- Uncovered brand competitiveness trends across tournament years
- Demonstrated marketing analytics capabilities and storytelling for non-technical stakeholders
Tools Used
Power BI (DAX, Interactive Visuals, Data Modeling), Marketing Analytics, Data Storytelling
SQL Project
The Challenge
Nigeria's agricultural export sector operates with fragmented data across products, markets, exporters, and logistics hubs. Without structured analysis, stakeholders couldn't identify which crops drive profitability, which markets offer expansion potential, or which logistics routes perform best leading to inefficient resource allocation and missed trade opportunities.
My Approach
- Imported and cleaned Nigeria's agricultural export dataset using Microsoft SQL Server (SSMS)
- Wrote SQL queries to analyze product performance, market concentration, exporter profitability, and logistics efficiency
- Conducted comparative analysis across crops (Sesame, Cocoa, Cassava), destination markets (Italy, Denmark, France), and export companies
- Calculated profit-per-unit metrics and volume distribution to identify strategic opportunities
Impact & Results
- Identified top revenue drivers: Sesame and Cocoa contribute highest export value justifying capacity expansion investment
- Revealed key markets: Italy, Denmark, and France account for majority of exports enabling targeted trade relationship strategies
- Highlighted profitability leader: AgroExport Ltd shows strongest margins, indicating operational efficiency benchmark for sector
- Discovered premium product opportunity: Cassava records highest profit-per-unit, positioning it for value-added export strategy
- Confirmed logistics hub: Lagos Port handles majority volume, reinforcing its critical infrastructure role
Tools Used
Microsoft SQL Server (SSMS),
Work Experience & Education
Highlighted analytics roles + operational leadership
40% time savings, 12% cost reductions, 15% delivery improvements
Education
Bachelor of Science in Education
University of Lagos, Akoka, Lagos
Graduated: 2012
Let's Work Together
Ready to turn your data chaos into clarity? I specialize in building dashboards that replace manual reporting, SQL pipelines that surface insights, and data infrastructure that drives measurable business outcomes.
What I Can Help With
- Building automated reporting dashboards (Power BI, Tableau)
- SQL data pipelines and database design
- Operations analytics and process optimization
- BI strategy for African markets and emerging economies
Let's talk about how I can deliver results like these for your team.
Get in Touch
📧 Email
📞 Phone
💼 LinkedIn
Follow @wonda_dataanalyst on LinkedIn, TikTok, and Facebook for data insights, tutorials, and analytics content.