Public and sanitized examples that demonstrate dashboard design, KPI thinking, data quality, reporting systems, and decision-focused analysis.
A compact dashboard that explains whether sales growth is turning into stronger profit.
What drove the change in revenue and profit, and where is performance below plan?
Matching-period comparisons, order and revenue-per-order effects, margin contributions, and reconciled totals.
An executive dashboard that makes a large public dataset easy to explore without losing the important patterns.
How are electric vehicles distributed across Washington’s counties, manufacturers, vehicle types, and model years?
KPI hierarchy, dynamic filtering, geographic analysis, dashboard UX, and data-quality controls.
An executive view of federal award activity, small-business participation, and socioeconomic goal performance.
Where is federal contract spending concentrated, and how are agencies performing against small-business goals?
Power BI modeling, DAX measures, agency and fiscal-year filters, KPI design, and visual theme refinement.
SELECT year, revenue, profit,
profit / NULLIF(revenue, 0) AS margin
FROM annual
ORDER BY year;5 investigations · 576 fictional records
Source data → queries → reconciled findings
Five reproducible investigations explain what sits behind the Excel dashboard.
What drove growth, which margins weakened, and where is the largest gap to plan?
CTEs, window functions, weighted margins, ranked comparisons and independent validation.
Built with real work, shared responsibly. Client-confidential data is never placed on the public site.
Browse GitHub ↗Biweekly analysis and leadership reporting across headcount, pipeline stages, time-to-fill, conversion rates, applicant volume, placements, and revenue pipeline metrics.
A high-volume reporting portfolio created as the sole data analyst on a 12-person team, spanning executive dashboards, analytical models, reports, and process maps.