Data Analyst & BI Consultant

Daniel Olatunji

I turn messy, disconnected data into dashboards, automated workflows, and decisions people can act on. My work focuses on data quality, governance, and building analytics that hold up when someone actually questions the numbers.

Case studies

Every one of these documents the business problem first, the data quality issues found along the way, and what the analysis actually showed, including where the first hypothesis turned out wrong.

Data Analytics & ETL Portfolio

Four Excel/Power Query ETL case studies covering CRM, HR, inventory, and sales, each built on the same data-quality engine and star-schema model.

ExcelPower QueryDAX

Everdale Retail Analytics

194K-row omnichannel retail dataset. Caught and corrected a metric definition error before it reached a KPI.

ExcelPower QueryForecasting

Kavora CRM Migration & Data Governance

Migrated 7 fragmented CRM exports into a governed Company/Contact/Deal model, with the data gaps documented honestly instead of smoothed over.

CRMData GovernanceSQL

Stock Performance, Risk & Forecast Monitoring

Python/SQL/Power BI pipeline on a 10-stock watchlist. Walk-forward ARIMA reported honestly as a tie against baseline, not oversold as a trading signal.

PythonPostgreSQLPower BI

WeatherIntel: Global Weather Analytics

NOAA station warehouse spanning up to 255 years of daily records. XGBoost next-day forecast beat both a persistence and a climatology baseline.

PythonXGBoostPower BI

Bloomcrest Revenue Intelligence

PostgreSQL revenue warehouse plus a HubSpot CRM layer, RFM/CAC/LTV segmentation, and deal-routing automation.

PostgreSQLHubSpotPython

Also on GitHub

A wider set of SQL and Power BI case studies across banking, energy, and logistics. Browse the full profile for the rest.

Toolkit

SQLPythonRPower BITableau Excel & Power QueryDAXMakeZapierGoHighLevel