Skip to content
View Richie-Rokka's full-sized avatar
🎯
Focusing
🎯
Focusing
  • GTHA, Ontario, Canada

Block or report Richie-Rokka

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Richie-Rokka/README.md

Hi, I'm Abodunrin Richard Oketade 👋

Data Analyst | Business Intelligence | Data Quality & Analytics Systems

I turn raw data into accurate, decision-ready insights by combining analytics, data validation, and business context.

🔍 What I Do

  • 📊 Analyze structured datasets using SQL & Python
  • 📈 Build dashboards (Power BI, Tableau) for performance tracking
  • 🧠 Translate data into business insights and recommendations
  • 🔍 Design data quality frameworks to ensure data integrity

🚀 Featured Projects

📊 Marketing Mix Modeling Revenue Optimization

  • Designed and developed a 3-page executive marketing analytics dashboard in Power BI to analyze channel performance, revenue trends, customer acquisition costs (CAC), and conversion efficiency across multi-channel campaigns.

  • Built advanced DAX measures for KPI reporting, rolling 4-week/12-week revenue analysis, MoM growth, time intelligence, forecasted revenue, forecasted ROI, and marginal return simulation.

  • Developed channel diagnostics and optimization logic to identify high-performing acquisition channels, improving strategic visibility into marketing efficiency and marginal ROI performance.

  • Utilized Python to generate and refine realistic marketing performance datasets, improving KPI realism and analytical consistency for scenario-based simulations.

Tools: Python, Power BI, Power Query

👉 View Project

📉 Property Tax & Assessment Data Quality Dashboard

  • Identified 22.2% data quality issues across 500+ records
  • Built validation checks (duplicates, mismatches, completeness)
  • Enabled structured data cleansing and improved reporting reliability

Tools: Excel, Power Query

👉 View Project

📊 Cohort-Based Marketing Funnel Analysis

  • Replaced misleading snapshot analysis with cohort tracking
  • Identified time-driven conversion patterns (majority within 30 days)
  • Improved accuracy of performance interpretation and decision-making

Tools: SQL, Python, Power BI
👉 View Project

🚚 Operational Intelligence & Performance Dashboard

  • Analyzed operational and revenue data to identify inefficiencies
  • Built KPI dashboards to support performance monitoring
  • Enabled data-driven operational decisions

Tools: SQL, Power BI

👉 View Project

🧩 Core Skills

Analytics: SQL, Python (Pandas), Excel
Visualization: Power BI, Tableau
Specialties: Data Quality, Data Validation, Business Insights, KPI Tracking

🧠 My Approach

Data is only valuable when it is accurate, understood, and actionable.

I focus on:

  • Ensuring data reliability
  • Identifying root causes, not just trends
  • Translating insights into business decisions

📫 Let’s Connect

⭐ Currently seeking Data Analyst roles focused on analytics, data quality, and business intelligence

📌 Career Focus

I am actively seeking opportunities as a Data Analyst, where I can apply data-driven insights to solve business problems and support decision-making.

⭐ Thank you for visiting my profile!

Pinned Loading

  1. Marketing-Mix-Modeling-Revenue-Optimization Marketing-Mix-Modeling-Revenue-Optimization Public

    Marketing Mix Modeling (MMM) and revenue optimization system analyzing CAC, ROI, channel efficiency, revenue forecasting, and scenario-based budget allocation using Power BI and advanced business a…

    Jupyter Notebook

  2. Property-Tax-Data-Quality-Dashboard- Property-Tax-Data-Quality-Dashboard- Public

    An automated data quality and governance dashboard for municipal property tax and assessment data, built using Power Query and Excel to detect inconsistencies, validate records, and provide actiona…

  3. Cohort-Based-Marketing-Funnel-Analysis-SQL-Python-Power-BI Cohort-Based-Marketing-Funnel-Analysis-SQL-Python-Power-BI Public

    End-to-end cohort-based marketing funnel analysis identifying conversion trends over time. Demonstrates data cleaning, cohort modeling, and insight generation to avoid misleading snapshot analysis …

    Python

  4. Operational-Intelligence-Performance-Dashboard Operational-Intelligence-Performance-Dashboard Public

    An end-to-end Power BI dashboard analyzing sales performance, inventory efficiency, and logistics operations to identify revenue growth drivers and operational risks such as stockouts and late deli…

  5. Automated-Inventory-and-Sales-Reporting-Dashboard Automated-Inventory-and-Sales-Reporting-Dashboard Public

    Automated Excel dashboard built using Power Query and data modeling to analyze sales and inventory performance, reducing manual reporting effort by 80%.

  6. Inventory-Risk-Demand-Optimization Inventory-Risk-Demand-Optimization Public

    Tableau dashboard and business analysis of stockout risk, overstock, and lost sales to improve inventory planning and warehouse allocation.