About
Highly analytical and detail-oriented Data Analyst with a strong foundation in data manipulation, visualization, and insight generation using Excel, SQL, Python, and Power BI. Proven ability to transform complex raw datasets into actionable intelligence, as demonstrated through an end-to-end data analysis project that delivered clear, user-friendly visual reports and supported data-driven decision-making. Eager to leverage strong technical skills and a commitment to accuracy to drive impactful results in a dynamic data environment.
Work
EleganceTech Hub
|Intern
Osogbo, osun, Nigeria
→
Trainee
End-to-End Data Analysis Project
|Data Analyst (Project Lead)
Remote, Nigeria
→
Summary
Led a comprehensive end-to-end data analysis project, applying a full spectrum of skills in data cleaning, transformation, analysis, and visualization to deliver actionable insights and user-friendly reports.
Highlights
Engineered robust data cleaning and preprocessing workflows using Excel and Power Query, ensuring data accuracy and consistency by removing duplicates, standardizing formats, and correcting data types.
Utilized advanced Excel functions (IF, SUMIFS, XLOOKUP, VLOOKUP) and Pivot Tables to efficiently explore and summarize complex datasets, revealing critical trends and patterns.
Developed and executed precise SQL queries to extract, transform, and load datasets into databases, enabling deep dives into data to uncover specific business insights.
Leveraged Python (Anaconda) for comprehensive dataset inspection and preliminary analysis, validating data integrity and preparing data for advanced modeling and reporting.
Designed and deployed an interactive Power BI dashboard, integrating data from multiple sources to visualize key performance indicators and trends, enhancing stakeholder decision-making.
Orchestrated a seamless end-to-end data analysis workflow, combining Excel, SQL, Python, and Power BI to transform raw data into comprehensive, actionable reports and presentations.
Education
University of Ilorin (UNILORIN)
→
B.Sc.
Zoology
Courses
Scientific Research Methods
Statistical Analysis
Data Collection Techniques
Languages
English
Fluent
Skills
Data Analysis Tools
Microsoft Excel, SQL (MySQL), Python (Anaconda), Power BI, Power Query.
Data Manipulation & Cleaning
Data Cleaning, Data Structuring, Data Transformation, Duplicate Removal, Missing Data Handling, Inconsistent Data Resolution, Date Formatting, Data Type Correction.
Excel Expertise
TRIM, FIND, UNIQUE, SUM, AVERAGE, MIN, MAX, LARGE, UPPER, LOWER, RIGHT, LEFT, MID, IF, SUMIFS, AVERAGEIF, XLOOKUP, VLOOKUP, HLOOKUP, Calculated Columns, Automated Data Processes, Pivot Tables, Dashboards, Conditional Formatting.
SQL Proficiency
SELECT, WHERE, Data Loading, Querying Datasets, Database Operations.
Python for Data Analysis
Dataset Loading, Dataset Inspection (.info()), Data Cleaning (Python), Data Exploration (Python), Anaconda.
Power BI Development
Data Connection (Excel, SQL, Python), Data Cleaning (Power BI), Data Transformation (Power BI), Calculated Columns (Power BI), Measures (Power BI), Interactive Dashboards, KPI Tracking, Performance Monitoring, Visual Reports Design, User-Friendly Reports.
Core Competencies
Detail-Oriented, Analytical Thinking, Problem-Solving, Data Visualization, Insight Generation, Accuracy, Reporting.