Bakare S. Aderonke
I'm a Data Analyst
About Me
I’m driven by data and powered by purpose. My journey began in 2019 with Excel and PowerPoint, creating reports to share my findings and insights. Over the years, I became more confident handling data, building my expertise for over 4 years before earning my certification as a Data Analyst two years ago. What started as curiosity, wondering why some businesses thrive while others stall, led me to the world of data analysis, where I now transform raw numbers into narratives that drive action. With hands-on skills in Excel, SQL, Python, and Power BI, I’ve built dashboards that cut reporting time by 60%, uncovered patterns that predicted customer churn, and equipped decision-makers with the clarity to act faster. To me, every dataset tells a story and I’m here to help teams read it, understand it, and use it to move forward smarter.
Data Analyst & Database Administrator.
My edge? A solid background in Marketing & Business Management, I connect the dots that matter.
- Birthday: 21 November
- Gmail: [email protected]
- Phone: +234 814 309 3564
- Country: Nigeria
- Years of Experience: 4+ years
- Degree: Higher National Diploma
- Website: https://Aderonke101.github.io
- Freelance: Available
Fun Fact: When I'm not uncovering insights from rows of data, I’m either revamping old dashboards for fun or turning everyday questions into SQL queries lol, yes, even grocery lists.
Open to Relocation: I’m currently based in Nigeria, but fully open to remote roles or relocation opportunities where data challenges await!Data Projects Completed Across multiple industries
% Reporting Time Saved Through dashboard automation
Actionable Insights Delivered That informed real decisions
Collaborations With cross-functional teams
Skills
Tools & technologies I use to turn raw data into valuable business insight.
Resume
Data-informed Data Analyst and Data Scientist in Training with 4+ years of experience in data analysis, visualization, and business intelligence. Skilled in Excel, Power BI, and SQL for data modeling, reporting automation, and dashboard creation that drive strategic decision-making. Adept at managing and cleaning large datasets, ensuring data integrity, and delivering actionable insights in fast-paced environments. Currently expanding expertise in advanced analytics and predictive modeling to solve complex business challenges.
Summary
Bakare Sukurat Aderonke
Data Analyst with a strong foundation in Marketing and Business Management. I transform raw data into actionable insights that inform strategic decisions, optimize performance, and drive measurable impact.
- Ogun State, Nigeria
- +234 81 4309 3564
- [email protected]
Soft Skills
Critical Thinking
Communication Skills
Attention to Detail
Problem-Solving Ability
Storytelling with Data
Collaboration & Teamwork
Interests
- Data Storytelling & Visualization – turning raw data into compelling stories
- Business Process Optimization – finding smarter, faster ways to work
- Machine Learning & Predictive Analytics – exploring how algorithms solve problems
- Mentoring Aspiring Analysts – helping others grow in the data field
- Technology Trends & Innovation – staying ahead with new tools and methods
Education
Higher National Diploma (HND), Marketing
2022
Federal Polytechnic Ede, Osun State, Nigeria
National Diploma (ND), Business Administration & Management
2016
Federal Polytechnic Ede, Osun State, Nigeria
Certifications
- Data Analytics with SQL, Excel & Power BI - Digitaley Drive (2025)
- Python Programming - NanoEdge International (2024)
- National Youth Service Corps (2024)
- Customer Relationship Management - Alpha Consulting Services (2024)
- Data Science Training – Tech Crush Bootcamp (In-Progress)
Professional Experience
Property & Data Administrator
September 2025 – Present
Eastcastle Infrastructure Nigeria Ltd | On-Site
- Built and maintained Excel dashboards to track over 400+ telecom sites across RFI, WIP, and HOC stages, improving project visibility and reporting accuracy by 25%.
- Designed and monitored KPIs for project timelines, completion rates, and payments, while updating and validating data on Invedis for real-time stakeholder visibility.
- Processed vendor, Federal/State Permits, and landlord payments using Adobe Sign and Proforma Invoices, collaborating with Finance, Legal, and Operations teams to reduce payment delays by 20%.
- Combined administrative support with data analysis to enhance operational efficiency, improve compliance tracking by 30%, and support informed decision-making.
Data Analyst
Jan 2025 – August
His-grace | Hybrid
- Developed an Ancillary Revenue Dashboard in Power BI and Excel to monitor add-on service performance, boosting upsell conversion strategies by 18%.
- Optimized reporting efficiency by automating SQL-based report generation from business queries, reducing analyst workload by 10+ hours weekly and ensuring error-free outputs.
- BBuilt an Inventory Optimization Model using SQL and Python, improving route-level pricing accuracy by 15% for airline simulations.
- Revamped reporting systems with automated KPI tracking, accelerating pricing decision-making cycles by 20%.
Data Analyst Intern
Jul 2024 – Dec 2024
NanoEdge International | Remote
- Designed and deployed Call Center & E-Commerce Dashboards in Power BI and MSSQL, identifying trends that drove a 12% improvement in operational efficiency.
- Engineered Python-based EDA automation scripts, cutting processing time by 30% and improving data validation accuracy across multi-source datasets.
- Streamlined ETL workflows by developing SQL scripts for multi-source data pipelines, reducing data load time by 40% and improving dataset consistency.
Data Analyst
May 2023 – Apr 2024
Mercy of God Schools | Ogun, Nigeria
- Created Excel dashboards to track academic and financial metrics, reducing manual reporting time by 25% and improving decision-making speed.
- Implemented advanced data validation checks, boosting reporting accuracy by 20%.
- Developed SQL stored procedures to automate budget and performance reporting, cutting manual work by 50% for leadership teams.
Data Entry / Data Analyst (Volunteer)
Feb 2018 – Dec 2020
Adex Bakery | Lagos, Nigeria
- Designed and implemented Bakery Sales Performance Dashboard in Excel and Google Sheets to track product categories, seasonal trends, and customer purchase patterns, increasing upsell of premium baked goods by 18%.
- Improved reporting efficiency by automating daily, weekly, and monthly sales and inventory reports in Excel and Google Sheets, reducing manual data entry time by 10+ hours weekly and ensuring accurate, up-to-date records for production planning.
- Created Ingredient Inventory Tracking and Optimization System in Excel to forecast stock needs, reducing waste by 15% and ensuring consistent availability of best-selling bakery products.
- Revamped reporting systems with automated KPI tracking, accelerating pricing decision-making cycles by 20%.
Project Highlights
- Dano Airline Performance Analysis – A project analyzing Dano Airlines' customer satisfaction, service quality, and operational performance. Dashboard built with Power BI. View on GitHub
- Sales Performance Analysis – End-to-end Excel project analyzing sales performance with calculated KPIs and slicers.View on GitHub
- Global Superstore Analysis – Data storytelling in Power BI using DAX, filters & advanced visuals to identify profit gaps.View on GitHub
- Fintech Customer Performance Intelligence – Excel-based dashboard to track churn risk and retention rate based on behavior metrics.View on GitHub
- Walmart Sales Analysis – SQL-based deep dive into branch and product performance, customer patterns, and financial insights. View on GitHub
- Layoffs Data Cleaning – Cleaned and analyzed global layoff data using MySQL, with detailed documentation. View on GitHub
Additional Info
- Tools: Power BI, Excel, SQL Server, Snowflake, Python, Git, GitHub
- Interest: Adaptable, detail-oriented, self-motivated, strong communicator
- Languages: English (Fluent)
- Availability: Open to relocation and remote opportunities
Portfolio
Explore a curated selection of my data analytics projects. Each piece showcases my ability to transform raw data into actionable insights using tools like Excel, Power BI, and SQL.
Sales Analysis Performance
One-page Excel dashboard showing comprehensive analysis of sales trends, product performance, and regional breakdown.
Tool: Excel
View on GitHub
Fintech Customer Intelligence & Performance
Excel dashboard analyzing customer retention, churn risk, and performance segmentation for a fintech company.
Tool: Excel
View on GitHub
Global Superstore Profitability Analysis
Power BI dashboard exploring regional/Country performance, profit gaps, and sales trends with advanced filters and visuals.
Tool: Power BI
View on GitHub
Omniretail Customer Satisfaction & Loyalty
Power BI dashboard analyzing satisfaction, loyalty trends, and regional feedback across different product categories.
Tool: Power BI
View on GitHub
Precision Mapping of Nigeria's Food Inflation
Interactive Power BI report mapping inflation trends across Nigerian states using geospatial, 5years Forecast and time series visuals.
Tool: Power BI
View on GitHub
Walmart Sales Analysis
SQL-driven dashboard visualizing product performance, Sales performance, financial insights, and customer behavior trends.
Tool: MSSQL (SQL)
View on GitHub
Layoff Data Cleaning & Analysis
Comprehensive MySQL project involving data wrangling, missing value handling, and insight extraction from global layoff datasets.
Tool: MySQL (SQL)
View on GitHub
Market Basket Analysis
Market Basket Analysis using Python. This project explores market trends and customer behaviour through data analysis and visualization(Outcome with-held due to client confidentiality and data security).
Tool: Python, Vscode
View on GitHubServices
I help businesses make smarter decisions through clean data, insightful dashboards, and powerful visual storytelling. Here are some of the services I offer as a Data Analyst/ Database Administrator.
Data Cleaning
Cleaning, validating, and transforming raw data into a structured format using Excel, SQL, and Python to ensure accuracy and consistency.
Dashboard Development
Designing interactive dashboards in Power BI or Excel to track KPIs, trends, and performance metrics that support business decisions.
Exploratory Data Analysis
Using statistical methods and visualization tools to uncover patterns, trends, and relationships in data for actionable insights.
SQL Reporting
Writing advanced SQL queries and procedures to extract, analyze, and summarize data from relational databases like MSSQL, MySQL and PostgreSQL.
Business Insights
Interpreting data to provide clear, actionable insights and recommendations that drive business performance and growth.
Training & Support
Offering hands-on training sessions on Excel, Power BI, and SQL for teams or individuals looking to strengthen their data skills.
Testimonials
Words of encouragement, gratitude, and impact from those I’ve supported in their data journey.
Thanks so much Ronke… This is enough motivation and DIRECTION. I'm definitely spending my free time here with you!
Dessy
Community Member
After the meeting we had, I started feeling much better. Thank you for the support and encouragement, Ronke!
John
Student
Yes o! Dem say follow who know road. Na why I say make I dey follow you as you sabi the way!
Olabode
Colleague
Thank you for all the support and guidance during my capstone project session. From Glory to Glory, Sis!
Oluwafunmi
Data Analysis Student
My Techy lady! Your resilience inspires me. You constantly show up, and your impact is paying off. I’m still coming to learn more!
Mrs Tayo UK
Devops Engineer/Educator & Learner
Working with Ronke was a game changer. Her ability to break down complex data made decision-making so much easier for us.
Isaac
Project Manager
We needed clarity in our customer trends, and she delivered beyond expectations. Highly recommend her for any data project!
Mr. Ryan (Canada)
Business Owner
Aderonke transformed our messy data into clear dashboards that helped us improve sales by 15% in one quarter.
Sir Francis
Director of Operations
Contact
Interested in working together or have a question? Reach out using the details below or fill the form to get in touch with me.
