Excel Sales Dashboard
Summary
Developed an Excel-based sales dashboard to analyze bike sales data, identify purchasing patterns, and generate actionable recommendations for sales optimization.
About
Highly analytical Data Analyst with a strong post-graduate foundation in Economics and quantitative analysis, adept at leveraging tools like SQL, Power BI, and Excel to transform complex datasets into actionable insights. Proven ability to conduct in-depth data cleaning, analysis, and reporting, driving measurable improvements in user engagement, operational efficiency, and strategic decision-making.
Work
Divine Favour Group of Schools
|Administrative Officer
Abeokuta, Ògún State, Nigeria
→
Summary
Managed administrative operations and data management, developing a comprehensive student database and proposing strategies that enhanced enrollment and efficiency.
Highlights
Collected and digitized critical data, including documents and files, into electronic systems, significantly improving data accessibility and organization.
Built a comprehensive student performance database by integrating attendance, assessment scores, and demographic data, effectively reducing data processing time by 45%.
Managed client inquiries across email, chat, and live support platforms, ensuring timely and effective communication and issue resolution.
Proposed and developed a social media advertising strategy that directly resulted in a 3% increase in student enrollment.
Volunteer
OpenGov Africa
|Data Analyst (Volunteer)
Abeokuta, Ògún State, Nigeria
→
Summary
Analyzed complex datasets and developed interactive reports to enhance user engagement and provide strategic recommendations for marketing and outreach initiatives.
Highlights
Conducted comprehensive data cleaning and preprocessing using Excel and spreadsheet tools, ensuring data accuracy and integrity for analytical reporting.
Provided key insights from attendee demographics and webinar performance data, directly contributing to the development of an effective speaker and panel engagement pipeline.
Delivered data-driven recommendations that strengthened marketing and outreach strategies across the organization, optimizing campaign effectiveness.
Performed cohort analysis of platform usage and presented findings through interactive reports, successfully increasing user engagement by 30%.
Education
University of Ibadan
Ibadan, Oyo State, Nigeria
→
Masters
Economics
Chrisland University
Abeokuta, Ogun State Nigeria, Nigeria
→
Bachelor
Economics
Grade: 3.7/5.0
Certificates
Introduction to Data Analysis using Microsoft Excel
PWC Book to tax difference
Issued By
PWC
Certificate of National Service (NYSC)
Entrepreneurship and Leadership Development
Statistical Package for Social Statistics
Issued By
New Horizons Worldwide
Skills
Technical Proficiency
Microsoft Office Suite (Word, Excel, PowerPoint), SQL, SPSS, Eviews, PowerBI, Stata.
Data Analysis & Reporting
Data Cleaning, Data Preprocessing, Analytical Reporting, Quantitative Analysis, Cohort Analysis, Actionable Insights, Dashboard Development.
Business Acumen
Strategic Recommendations, Market Research, Process Improvement, Stakeholder Communication.
Projects
Pizza Sales Performance (SQL & Power BI)
Summary
Conducted a comprehensive analysis of one year of pizza sales data using SQL and Power BI, focusing on customer demographics, order sizes, and peak hours to inform business strategy.