Ayodeji Osinusi
Available for new projects · Lagos, Nigeria

Data Analyst Turning Raw Data Into Actionable Business Insights

I design dashboards, analyze business performance, and translate complex datasets into clear stories that support smarter decisions.

View My Projects
Download Resume
Analytics Portfolio Snapshot
Live Portfolio
Years of Experience
1+ Years
Data Analytics & BI
Analytics Workflow
Data Cleaning
Analysis
Dashboards
Insights
About

A clear mind for messy data.

Data Analyst. I handle the full journey — raw data in, clear business answers out. I'm genuinely fascinated by where AI and technology are taking this field, and my work reflects that curiosity.

What I Bring

  • Data Cleaning & Transformation
  • Exploratory Data Analysis
  • Dashboard Design
  • Business Reporting
  • Insight Communication
  • Problem Solving
Skills

The toolkit behind the insights.

A grounded mix of analysis, visualization, and the soft skills needed to make data useful.

Data Analysis & Business Intelligence

  • Excel
  • Power BI
  • SQL
  • Power Query
  • DAX
  • Data Cleaning
  • Exploratory Data Analysis
  • KPI Reporting
  • Dashboard Design
  • Business Intelligence
  • Data Storytelling

Programming & Analytics

  • Python
  • Pandas
  • Jupyter Notebook
  • Statistical Analysis
  • Automation
  • Data Transformation

Business Analysis & Process

  • BRD
  • FRD
  • User Stories
  • Process Mapping
  • Visio Workflow Diagrams
  • Stakeholder Collaboration
  • Requirements Documentation
  • Problem Solving

Tools & Platforms

  • GitHub
  • Google Sheets
  • Tableau
  • Microsoft Excel
  • Power BI Desktop
Selected Work

Dashboards and analyses with measurable impact.

Sales Performance Dashboard preview

Sales Performance Dashboard

Excel-Based Business Intelligence and Sales Performance Diagnostic System

An Excel-based business intelligence system that transforms raw sales and logistics data into diagnostic insights. The project evaluates revenue performance and introduces a custom Business Health Score to rank products using revenue, quantity sold, and shipping cost efficiency.

ExcelPower QueryPower PivotData CleaningPareto AnalysisWaterfall AnalysisDashboard Design

Key insight: A custom Business Health Score revealed that 53% of product categories generated approximately 80% of revenue, with Coffee and Curry Sauce as the top performers.

GitHub Repo
Loan Portfolio Overview preview

Loan Portfolio Overview

Power BI Dashboard for Loan Risk, Recovery, and Borrower Performance

A Power BI dashboard for analyzing loan portfolio performance, borrower risk, bad loan exposure, loan recovery, and lending health indicators.

Power BIDAXPower QueryData ModelingKPI DesignLoan Portfolio AnalysisDashboard Design

Key insight: Recovery rate reached 108.56%, while a 13.8% bad loan rate flagged meaningful credit risk exposure.

GitHub Repo
Delivery Performance & Lead Time Analysis preview

Delivery Performance & Lead Time Analysis

Power BI Supply Chain Diagnostic Dashboard for SLA, Returns, and Profitability

A Power BI supply chain diagnostic system that analyzes delivery failures, margin erosion, and return risk across retail orders. The dashboard connects delivery performance, profitability, and fulfillment risk in one view.

Power BIDAXPower QueryData ModelingSLA AnalysisKPI DesignDashboard Design

Key insight: An Efficiency Score combining delivery speed, return rate, and profit contribution exposed a 30.07% late delivery rate and $180.50K lost to returns.

GitHub Repo
Customer Churn Analysis preview

Customer Churn Analysis

Power BI Dashboard for Telecom Customer Retention and Churn Risk

A Power BI dashboard analyzing telecom customer churn behavior, contract mix, tenure, and service-level drivers to support retention strategy and reduce monthly revenue loss.

Power BIDAXPower QueryData ModelingChurn AnalysisKPI DesignDashboard Design

Key insight: A 26.5% churn rate is costing the business ~$139K per month, with month-to-month contracts and low-tenure customers driving the majority of losses.

GitHub Repo
Inventory Optimization preview

Inventory Optimization

Excel-Based Inventory Analysis for Stock Planning and Operational Efficiency

An Excel-based inventory health check that analyzes capital tied up in stock, stockout exposure, and forecasting accuracy across product categories.

ExcelPower QueryPower PivotData CleaningInventory AnalysisDashboard Design

Key insight: $136.1M in capital is tied up in stock while $2.99M in revenue is lost to stockouts, with an average forecast error of 308.4%.

GitHub Repo
Sentiment Analysis Using Python preview

Sentiment Analysis Using Python

Python + Cohere API for Customer Review Sentiment Classification

A Python-based sentiment analysis project that classifies customer reviews into positive, neutral, and negative sentiment using the Cohere API, then summarizes patterns to support product and customer experience decisions.

PythonPandasCohere APIJupyter NotebookNLPData Visualization

Key insight: Automated sentiment classification made it possible to quantify customer mood at scale and identify the themes driving positive and negative feedback.

GitHub Repo
Experience

A track record built on clarity.

  1. Business Analyst Intern · Preferred Digital Business Solution

    April 2026 – Present
    Lagos, Nigeria · Remote
    • Document business requirements using BRDs, FRDs, and user stories to support stakeholder alignment in an Agile team.
    • Analyze datasets with Excel and SQL to surface actionable insights for data-driven decision-making.
    • Map and improve operational processes using Visio workflow diagrams and KPI dashboards.

  2. Finance Data Analyst Intern · DataVerseAfrica

    Nov 2025 – April 2026
    Lagos, Nigeria
    • Performed loan portfolio analysis covering default tracking, delinquency segmentation, and repayment trends for credit risk reporting.
    • Built and maintained Power BI dashboards tracking disbursement volumes, portfolio at risk, and financial KPIs for stakeholder reviews.
    • Transformed financial datasets in Excel and Power Query, reduced manual report preparation effort, and developed DAX measures for client-facing deliverables.
Education

Foundations & continuous learning.

Academic

Federal University of Agriculture, Abeokuta (FUNAAB)

2025

B.Sc. · Agriculture

Nigeria

AltSchool Africa

2025

Diploma · Data Analysis

Certifications

  • Data Analyst Associate
    2025
    DataCamp
  • Advanced SQL, Power BI Desktop, EDA in Python, Power Query & DAX
    Maven Analytics
  • Introduction to Generative AI
    2025
    AWS
Contact

Let's turn your data into decisions.

If you need clear dashboards, data analysis, reporting, or insight-driven recommendations, I'd be happy to connect.

Submitting opens your email client with a pre-filled message.