Hi there! I'm Ayomide Gbadegesin.
I specialize in creatively leveraging data for innovative products, optimized operations, and sustainable growth.
Intro
I am a data professional and graduate of the University of Ilorin, Nigeria and based in Lagos, Nigeria.
As serious looking as my face might present itself, I'm actually quite jovial.
Over the years, I've had the opportunity to work on various amazing projects with one of the project being featured on Zikoko,
I was also an assistant tutor at Chaste Intellect International School, teaching ICT and Data Processing to intellects of different ages and class.
In my spare time, I work on some pretty interesting projects and I write around topics related to data. You can find more on the projects I have worked on here.
My technology stack includes;
Writing complex queries to solve business problems in SQL.
Building insightful dashboards and reports in Tableau, Excel and Power BI.
Performing Exploratory Data Analysis.
Scripting in Python.
Technical writing.
Cleaning, Transforming and Manipulating data on spreadsheets (Excel and Google sheets)
For fun, you'd usually find me doing one of the following things;
Playing mobile games. The looks on faces of people when they find out what level I am in Candy Crush or how good I am in CODM has be believing that I am a fairly decent gamer.
Reading random articles and stories that peak my interest.
Binge watching movies or series.
Taking long strolls at night.
Planning my next bucket list activity.
Close
Projects
The Nigerian Election Story
In this project, I cover Nigeria’s political history in a 3-part data visualization series.
The first part gives an overview of Nigeria’s leaders since independence in 1960. It also highlights some significant events that occurred duirng that time.
The second part examines the electoral landscape to study trends and patterns in previous elections.
The third part is a projection for the 2023 election cycle. It seeks to chart a path to victory for each of the 3 major contestants in the 2023 election cycle.
I was scrolling randomly on X (formerly Twitter) when I came across this case study and I decided to attempt it.
The case study aims to analyse data on Mobile Money services and customer experiences in three Kenyan districts so as to provide key initial findings that will be discussed by a Specialist Advisory Board.
So I worked on this in two stages.
Stage one involved overall data exploration, cleaning and analysis
Stage two involved creating a Summary report addressing all the major key findings and recommendations where necessary.
This challenge is a hands-on learning experience that simulates real world scenarios.
There are 8 case studies and each case study is designed to cover different aspects of data analysis and SQL usage commonly encountered in professional settings.
I have endeavoured to solve each case study, documenting my approaches and solutions.
You can review my solution here and a detailed summary of my approach here.
Tech Stack: SQL
Read More...
SQL Practice
Over time, I have attempted to solve interview questions from various top companies like Google, Meta, Amazon and AirBnB and also random SQL assessment questions I find on the internet.
I have documented every attempt, alongside the questions, solution breakdown and results.
You can check it here.
Tech Stack: SQL
Read More...
Data Visualizations
Recruitment Dashboard
Sign-ups dashboard
Exchanges Dashboard
These are samples of dashboards I have created using various data visualization tools.
The links to each visualization would be attached to the description.
I am unable to include direct links to some dashboards because they are not personal projects. However, I have permission to include screenshots of the dashboards in my portfolio.
Tech Stack: Google Looker Studio
Read More...
Close
Resume
Skills
Programming : SQL, Python, HTML, CSS
Data Analysis Tools : BigQuery, Google Sheets, MS Excel, Tableau, Mixpanel, Looker Studio, Pandas, Microsoft Power BI, Jupyter Notebook
Technical : Git/Github, Notion, Slack
Personal : Critical Thinking, Problem Solving, Team Work, Effective Communication, Time Management, Project Management, Data Storytelling
Visualized and communicated OD Model reports on a monthly basis
Team Member (Data and Intelligence)
AIESEC in Ilorin, Ilorin NigeriaFebruary 2024 - Present
Developed a structured database to enhance the efficiency of storing and retrieving member information.
Contributed to the design and implementation of a task tracking system, resulting in a 60% increase in task completion among members.
Collaborated with other members to brainstorm on the various way to improve alumni relations and communicated the recommendations to the VP incharge.
Data Analyst Intern
Eden Life, Lagos NigeriaDecember 2023 - Present
Revamped the operations dashboard, resulting in a 40% improvement in the efficiency of daily tracking and monitoring of company operations.
Enhanced the maintenance process for data pipelines, streamlining operations and facilitating the identification of potential issues within the workflow.
Executed a thorough overhaul of the reporting process, resulting in its full automation. This eradicates all manual tasks involved in reporting, guaranteeing the prompt and precise dissemination of metrics.
Education & Certifications
University of Ilorin
B.Sc.(Ed.) Computer Science September, 2019 - July 2024
Product School - Product Analytics Micro-Certification (PAC) TMApril 2024
Udacity - Data Analyst Nanodegree August 2022 - November 2022
Coursera - Data Visualization in Excel June 2022 - July 2022
Udacity - SQL for Data Analysis April 2022 - June 2022
Coursera - Excel Essentials for Data Analytics March 2022 - April 2022
Download a copy of my resume below.
Close
Contact
Feel free to contact me on any of the following social media platforms
