![Omolara Akanni](https://res.cloudinary.com/read-cv/image/upload/c_fill,h_92,w_92/dpr_1.0/v1/1/profilePhotos/LAExgocH92OzqjEpqGsmytK5Zqt1/d9011562-4e76-4500-aaaa-c1090c53bfdc.jpg?_a=DATAdtfiZAA0)
Omolara Akanni
Data Analyst in Lagos, Nigeria, She/Her
About
I’m a data analyst based in Lagos, Nigeria with 3 years of experience in using data analytics tools such as Excel, SQL, Python, Tableau, and Metabase, to clean, analyse and visualize large datasets in order to gather insights and inform business decisions.
Tools I use: Excel, Metabase, SQL, Amplitude, Postman, Asana, Notion, Slack, Python, Tableau.
Projects
This data analysis project highlights cancer cases diagnosed across 13 states in Nigeria from 2009 to 2016. For this project, I used Google Sheets, SQL & Tableau to clean, analyse and visualize the dataset. Here’s a link to an article I wrote which highlights my entire process from the initial data research and sourcing to the final data visualization.
Data Source:
Cancer in Nigeria Volume II by Nigerian National System of Cancer Registries Federal Ministry of Health of Nigeria
This Tableau visualization shows the top 50 world’s highest-paid athletes of 2023. Here, I made use of treemaps to show the breakdown of each athlete’s earnings. I also included some interesting facts I observed in this dataset. Did you know that Serena Williams is the only woman on the list, ranking 49th?
I worked on the data extraction and analysis for our first infographic, which highlights the top industries that users share their identity data with, leveraging Mono’s APIs. I collaborated with the design and the marketing team to achieve this.
This dataset collects information from 100k medical appointments in Brazil and is focused on the question of whether or not patients show up for their appointments.
I made use of Jupyter Notebook, Python, Pandas, Numpy, Matplotlib and Seaborn for this project.
A Tableau Visualization
Over the years, the USD to Naira exchange rate has increased significantly. From February 2023 to the 18th of December 2023 alone, there has been an increase of 63.20%, resulting in the current rate of 1,221.33 naira per dollar. This means that any amount saved or invested in February has appreciated by 63.20%, showing the high devaluation of the Nigerian Naira, and its impact on the value of savings and investments over the years.
It's interesting to note that the first recorded spike in the exchange rate dates back to 2016 with an increase of 43.27% compared to the previous year.
Writing
This article highlights my entire process from the initial data research and sourcing to the final data visualization of this cancer project. The cancer project focuses on cancer cases diagnosed between 2009 and 2016 across 13 states in Nigeria.
Work Experience
-
Analyze product data for postpaid billing monthly using SQL and Metabase to ensure partners understand the data and the finance team can process invoices.
-
Analyze product performance using Amplitude, and PostHog to proactively measure product success.
-
Analyze data using SQL, Google Sheets, and Metabase to understand customer behaviour related to revenue generation. This collaboration aims to enhance our ability to make accurate projections and analyze revenue effectively.
-
Created a churn retention playbook by studying various patterns to recognize churn for different products and proactively preventing it. By collaborating closely with our partners, I gathered insights into their specific needs and challenges, which informed our strategies to improve partner retention and satisfaction.
-
Created and monitored partner dashboards, product, growth and marketing reports, weekly using data analysis and this improved customer retention by 25%.
-
Manage 15-20 key partners at Mono by providing service support, maintaining good relationships, and analysing internal data to maximise retention and, in turn, increase the company’s revenue.
-
Monitor product funnels and drop-off behaviours using Amplitude which has reduced churn by 13%.
-
Observed trends in partner’s API usage using Metabase, created a system to reduce churn and won back up to 20 businesses within a quarter.
-
Collaborated with the compliance, marketing teams to analyse the onboarding process which led to an increase in account sign-ups by 20%.
-
Built an Upselling framework using Excel and Metabase and led the strategy to upsell other products, product features, and higher pricing plans to customers, increasing the company’s revenue by converting as many as 25 businesses in two quarters.
-
Onboarded up to 5 new partners per week by helping with product thinking, product walkthroughs and product articles for the successful integration of Mono’s products.
-
Worked with a team of 12 product managers and engineers to resolve customer issues by analyzing data, troubleshooting and testing products.
-
Led the product thinking, documentation, management and walkthroughs of the Mono issuing product (a product that allows businesses to leverage Mono’s APIs to issue virtual accounts and virtual cards to their customers), onboarding up to 50 customers.
-
Upsold the product to new businesses and doubled the company’s revenue.
-
Conducted product knowledge sessions to enable the Sales and Partner Operations team of eight to successfully onboard partners to make use of Mono Issuing.
-Analyzing defects data with Excel to check for trends and determine corrective actions.
-Preparing comprehensive reports using Tableau and Excel to visualize monthly quality defects
-Making sure all products conform to specifications
-Leading ISO implementation for Quality, Environmental and Occupational Health and Safety Management Systems.
-
I developed a daily collation order sheet with Excel, used in tracking orders.
-
Using Excel, I came up with a mass balancing process for the chemicals used in production and created a calculator to aid the balancing process.
-
Reviewed existing faulty processes on the production floor and proferred solutions.
-
Monitored and analyzed the daily production records of different units to ensure variance compliance.
-
Developed an excel template to calculate and analyze the overall efficiencies of machines.
-
Supervised and managed industrial trainees in my unit.
-
Analyzed payment data of previous contracts and created a pricing structure that was adopted by the company in determining pay for future contracts.
-
Reviewed environmental evaluation study, biological monitoring study reports, and environmental impact assessment reports.
Volunteering
Education
2nd Class Upper Division
Certifications
Issued Apr 2021
Credential ID #18,652,851
Issued Apr 2021
Credential ID #18,683,507
Awards
I was nominated and recognised as a talented #datafam alongside, 94 individuals from 21 countries, spanning six continents.