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 Richard Abodunrin Oketade

📊 Data Analyst | Business Intelligence | Sales, Operations & Marketing Analytics

I build end-to-end analytics solutions that transform raw data into actionable business insights.

🚀 What I Do

  • Design interactive dashboards in Power BI
  • Build data models using star schema
  • Analyze data using SQL & Python
  • Translate data into business decisions and insights

🛠 Skills & Tools

  • Data Analysis: SQL, Excel (Advanced, Power Query), Google Sheets
  • Visualization: Tableau, Power BI
  • Programming: Python
  • Core Skills: Data Cleaning, Data Visualization, KPI Reporting, Business Analysis, Problem Solving

📂 Featured Projects

🏡 Property Tax & Assessment Data Quality Dashboard

I built an end-to-end data quality and validation solution for property tax and assessment datasets. Using Power Query, Excel, and interactive dashboards, the solution automates the detection of data inconsistencies, enhances governance, and supports evidence-based decision-making.

  • Designed an automated ETL and reporting framework validating 500+ records, reducing manual data processing by 80%.
  • Built interactive dashboards providing executive visibility into KPIs and data quality metrics.
  • Implemented statistical outlier detection and comprehensive validation checks to ensure reliable analytics.

🔗 https://github.com/Richie-Rokka/Property-Tax-Data-Quality-Dashboard-

📦 Automated Inventory & Sales Reporting Dashboard,

I developed an automated data analytics solution using Excel to streamline reporting, improve data accuracy, and deliver actionable business insights. By using Power Query, structured data modeling, and interactive dashboards, the solution transforms raw operational data into a scalable reporting system that supports decision-making across sales and inventory functions.

  • Developed scalable data pipelines integrating sales and inventory datasets, enabling self-service analytics for stakeholders.
  • Delivered executive dashboards tracking revenue, profit, and operational performance.
  • Reduced reporting time by 80%+ by automating data workflows and eliminating repetitive manual tasks

🔗 https://github.com/Richie-Rokka/Automated-Inventory-and-Sales-Reporting-Dashboard

📦 Inventory Risk & Demand Optimization Analysis

Analyzed inventory data to identify stockout risks, overstock conditions, and lost sales opportunities using Tableau.

  • Built KPIs: Stockout Rate, Overstock Rate, Estimated Lost Sales
  • Identified inefficiencies in inventory allocation and warehouse distribution
  • Provided recommendations for demand-driven inventory planning

🔗 https://github.com/Richie-Rokka/Inventory-Risk-Demand-Optimization

🚴 Cyclistic Bike-Share Analysis

Conducted a full case study analyzing rider behavior to support marketing strategy decisions.

  • Cleaned and analyzed large datasets using SQL and Excel
  • Identified behavioral differences between casual riders and members
  • Delivered insights to support customer conversion strategy

🔗 https://github.com/Richie-Rokka/Data-Analytics-Capstone-Project-Cyclistic-Bike-Share

📈 What I'm Working On

  • Building end-to-end data analytics projects
  • Strengthening SQL and Python skills
  • Preparing for data analyst roles

🤝 Let's Connect

📌 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. sales-logistics-revenue-risk-dashboard-powerbi sales-logistics-revenue-risk-dashboard-powerbi 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…

  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. 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%.

  4. Data-Analytics-Capstone-Project-Cyclistic-Bike-Share Data-Analytics-Capstone-Project-Cyclistic-Bike-Share Public

    Data analysis project exploring bike-share user behavior to drive membership conversion using Python, Excel, and Tableau.

    Jupyter Notebook

  5. 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.