Waldo Ketonou
Business & Data Analyst
SQL • Python • R • Tableau • Excel • Google Sheets
Welcome to my analytics portfolio. I combine 18+ years of operational leadership with modern data analytics to solve real business problems. My work focuses on KPI development, forecasting, dashboard design, and data storytelling that drives measurable impact.
Featured Projects
Walmart Sales Forecasting & KPI Dashboard (SQL + R + Tableau)
End‑to‑end analytics project analyzing Walmart weekly sales across multiple stores and departments.
Includes SQL-based data cleaning, R forecasting models, and a polished Tableau dashboard.
🔗 Dashboard:
View Tableau Dashboard
- Cleaned and structured raw Walmart sales data using SQL
- Built forecasting models in R (Random Forest + baseline models)
- Designed KPI cards and weekly trend visuals in Tableau
- Delivered insights on seasonality, holiday lift, and store performance
Repo:
View Project
Lettuce Growth Optimization (R + tidyverse)
Exploratory data analysis and predictive modeling of environmental factors affecting lettuce growth.
Built regression, random forest, and XGBoost models to predict harvest time.
Simulated environmental improvements to estimate operational impact.
🔗 View Modeling Notebook
- Identified key drivers of growth
- Built visualizations using ggplot2
- Delivered actionable recommendations
Repo:
View Project
Dashboard:
View Tableau Dashboard
Currently Working On
CMS Hospital Readmission Analytics (Snowflake + SQL + R + Tableau)
A full end‑to‑end healthcare analytics project using CMS Hospital Readmissions Reduction Program data.
This project includes Snowflake‑based data warehousing, SQL data cleaning and feature engineering, R modeling and evaluation, KPI development, and a Tableau dashboard.
Status: In progress — results coming soon
Technical Skills
- Languages: SQL, Python, R
- Tools: Tableau, Excel (Advanced), Google Sheets
- Analytics: Data Cleaning, EDA, Forecasting, KPI Design
- Visualization: Dashboard Design, Data Storytelling
- Business: Operations Management, Budgeting, Process Optimization
Certifications
- Google Data Analytics Professional Certificate
- Foundations: Data, Data, Everywhere
- Ask Questions to Make Data‑Driven Decisions
- Prepare Data for Exploration
- Process Data from Dirty to Clean
- Analyze Data to Answer Questions
- Share Data Through the Art of Visualization
- Data Analysis with R Programming
- Google Data Analytics Capstone: Complete a Case Study
About Me
I’m a Business & Data Analyst with a unique hybrid background: deep operational experience paired with strong analytical skills. I help organizations turn messy data into clear insights that improve efficiency, profitability, and decision‑making.
I’m currently building a portfolio of dashboards and case studies through WaldoSphere Group.
🔗 Connect With Me
- LinkedIn: https://www.linkedin.com/in/oswald-s-ketonou-12834197
- GitHub: https://github.com/Oswaldketonou