Environmental Sustainability Dashboard
Summary
Developed an interactive dashboard analyzing waste management and environmental sustainability trends across 30 Local Government Areas (LGAs) in Osun State, providing data-driven recommendations.
About
Results-oriented Data Analyst adept at leveraging Microsoft Excel (Power Query, Pivot Tables, advanced formulas), SQL (MySQL), and Power BI to transform complex datasets into actionable insights. Proven ability to clean data, build interactive dashboards, and drive data-driven decisions across diverse domains including environmental sustainability, election analytics, and financial performance.
Work
Excelerate
|Data Analyst Intern (Team Lead)
Remote
→
Summary
Led a team in a 3-week compliance analysis project, developing a unified master table and delivering strategic recommendations to university leadership.
Highlights
Spearheaded a 3-week compliance analysis for Saint Louis University, leading Team-2 to integrate data from 3 disparate systems (totaling 45,087 rows) into a unified master table with a 99.7% join match rate.
Executed comprehensive data cleaning and standardization using SQL functions (ROW_NUMBER(), TO_TIMESTAMP(), REGEXP_REPLACE(), SPLIT_PART()) to ensure data integrity and accuracy across all datasets.
Uncovered 7 critical compliance risk areas, including 1,869 unpaid I-901 fees, 4,485 unissued I-20s, and 1,990 SEVIS-Applicant ID mismatches, alongside country-specific hotspots (Ghana 72.7%, Nepal 84.4% unpaid).
Developed and presented 5 strategic recommendations to SLU leadership, supported by a Looker compliance dashboard with automated alerts, enhancing proactive risk management.
Education
Osun State University Osogbo
Osogbo, Osun State, Nigeria
Bachelor's Degree / Diploma
Microbiology
Languages
English
Certificates
Microsoft Power BI Data Analyst (PL-300)
Issued By
Microsoft
Skills
Data Analysis & Visualization
EDA, Data Cleaning & Transformation, Dashboard Design, KPI Reporting, Geospatial Analysis, Compliance Analytics, Variance Analysis, Performance Analysis, Trend Analysis, Statistical Analysis.
Microsoft Excel
Pivot Tables, Power Query, VLOOKUP, XLOOKUP, IF/IFS, SUMIFS, COUNTIFS, Conditional Formatting, Currency Formulas, Advanced Formulas.
Microsoft Power BI
Multi-page Reports, DAX Measures, Choropleth Maps, KPI Cards, Cross-page Navigation, Slicers, Drill-downs, Dashboard Building.
SQL
MySQL, DDL/DML, ROW_NUMBER (), REGEXP_REPLACE (), TO_TIMESTAMP (), SPLIT_PART (), Subqueries, Data Cleaning.
Tools
MySQL Workbench, Looker.
Projects
Nigeria 2023 Presidential Election Dashboard
Summary
Designed a national dashboard for the Nigeria 2023 Presidential Election, visualizing voter turnout and results across geo-political zones.
Expenses-Claims Analysis Dashboard
Summary
Built a multi-currency dashboard tracking $426,042 in expenses with detailed breakdowns and monthly trends for 2023–2025.
Budget Forecast Analysis Dashboard
Summary
Tracked $3.79M actual vs. $3.74M budget across 6 departments (FY2024–2025), surfacing a $54,639 variance and 55% under-budget rate.
Access to Basic Services - United Nations
Summary
Created a relational database to track global basic service access metrics and authored DDL schema with numeric precision and NOT NULL constraints.