Superstore Time Intelligence
Previous-year sales and rolling two-year sales analysis using SQL window functions, then translated into Power BI for trend communication.
View case study ↗I use SQL, Excel and Power BI to uncover patterns, explain what they mean, and build analytical stories that help people make better decisions.
Not just dashboards. Each project starts with a question and ends with a clearer way to understand the problem.
Previous-year sales and rolling two-year sales analysis using SQL window functions, then translated into Power BI for trend communication.
View case study ↗Loan performance, borrower risk and portfolio health using MoM trends, DTI and good-vs-bad loan classification.
View case study ↗Sales performance and product association analysis designed to surface seasonality, cross-selling and bundling opportunities.
View case study ↗Scenario testing for rider allocation and order batching. The analysis treats delivery performance as a systems problem, not a single-factor problem.
View case study ↗A fictional public-finance data story examining budget allocation, leakage, workforce compensation and the difference between performative and substantive development.
View case study ↗Revenue trends, customer contribution, product demand and country-level performance from 2011 retail data.
View case study ↗I'm Mayokun Olayiwola, an operations-focused professional with a foundation in ethical judgment, administrative operations and analytical thinking. My current portfolio focuses on using data to understand business performance, operational problems and public systems.
I enjoy taking a messy question, structuring it into something measurable, and communicating the result in a way that makes sense to a decision-maker.
Querying, joins, aggregations and analytical window functions.
MYSQLData modeling, interactive dashboards, KPI design and visualization.
DASHBOARDSAnalysis, modeling, scenario testing and business reporting.
MODELINGMeasures, calculated logic and analytical metrics inside Power BI.
METRICSFor analyst roles, research, BI work or data-driven projects, I'd be glad to connect.