OLORUNSHOGO IBISAGBA

OLORUNSHOGO IBISAGBA

Gwagwalada, 902101, Abuja, Nigeria.
Financial Performance KPI Dashboard (Excel Dashboard Redesign)Monthly Personal Budget Template (Google Sheets)Automated Dashboard & Reporting System (Interconnected Google Sheets)Football KPI Dashboard | Player Performance & Analysis (Google Sheets)Live TikTok Analytics Dashboard (Google Sheets)Data Cleaning, Merging 12 Years of Crime Data (2012–2024) in ExcelGoogle Sheets Automation Task Tracker + Dashboard (Email + Calendar)Health care (Power Bi Dashboard)Interactive Spotify Music Dashboard (Microsoft Excel )

About

I’m a Data Analyst | Excel & Google Sheets specialist focused on building spreadsheet systems, KPI dashboards, and structured workflows that help businesses turn messy data into clear, actionable decisions.

I specialize in transforming raw, disorganized data into automated and reliable systems that save time, reduce errors, and improve day-to-day business operations. My work goes beyond analysis, I design systems that give teams real visibility into performance and remove the stress of manual reporting.

Service i offer:

• Clean, structured data systems
• Automated reporting workflows
• KPI dashboards that highlight what truly matters
• Simple, scalable tools that teams can actually use

My goal is to help your businesses move from scattered spreadsheets and guesswork to organized systems that support faster and better decision-making.

I’m constantly improving how data is structured and delivered, with a focus on making information not just available, but useful.

Projects

Automated Dashboard & Reporting System (Interconnected Google Sheets)
Automated Dashboard & Reporting System (Interconnected Google Sheets)

Freelance

→

Summary

I designed and built a fully automated Google Sheets system that connects multiple spreadsheets and updates data in real time. The system includes a structured data flow where a single input sheet feeds into a master database and dynamically updates dashboards, reports, and analytics without any manual work. -Interconnected sheets using IMPORTRANGE and QUERY -Real-time dashboard with charts, KPIs, and filters -Interactive dropdown(City) -Automated revenue, orders, and performance tracking These help businesses eliminate repetitive tasks, reduce errors, and make faster data-driven decisions.

Financial Performance KPI Dashboard (Excel Dashboard Redesign)
Financial Performance KPI Dashboard (Excel Dashboard Redesign)

Freelance

→

Summary

I redesigned and delivered a fully automated, executive-ready dashboard that updates instantly with new P&L YTD or Monthly data, no manual refresh needed. Features include a polished first-page overview, dynamic charts, automated monthly & YTD summaries, key financial metrics (AP/AR days, current ratio, cash balance), and a seamless structure that stays compatible with Google Sheets if they ever migrate. The redesign emphasizes clarity and actionable insights, saving time, reducing errors, and giving executives instant visibility into financial performance.

Football KPI Dashboard | Player Performance & Analysis (Google Sheets)
Football KPI Dashboard | Player Performance & Analysis (Google Sheets)

Freelance

→

Summary

I designed and delivered a fully automated Football KPI Dashboard that transforms raw match data into clear, real-time insights with no manual updates. It features an interactive player overview, radar and bar charts, automated profiles, rotation planning, and smart team selection powered by formulas like FILTER, SORT, and TEXTJOIN. The goal was simple: To make performance analysis easier for coaches and teams. Instead of guessing, they can see exactly who is performing, spot improvements, and make better lineup decisions while saving time and reducing errors using Google Sheets. Skills and deliverables

Live TikTok Analytics Dashboard (Google Sheets)
Live TikTok Analytics Dashboard (Google Sheets)

Freelance

→

Summary

I built a Google Apps Script that connects public TikTok profile and post data to Google Sheets using the Apify TikTok Scraper API. It authenticates using an API token and dataset ID, fetches post-level metrics such as views, likes, comments, captions, and publish dates, and writes clean, structured data directly into a spreadsheet. The script runs on a scheduled trigger, keeping the data automatically updated and powering a live TikTok analytics dashboard. TikTok → Apify API → Google Apps Script → Google Sheets → Dashboard

Monthly Personal Budget Template (Google Sheets)
Monthly Personal Budget Template (Google Sheets)

Freelance

→

Summary

The goal of this project was to design a clean, easy-to-use personal budget spreadsheet for sale as a digital product. While keeping a familiar layout, the spreadsheet includes unique scorecard-style indicators that guide users step by step as they add income and track spending throughout the month, making the budgeting process simple and intuitive.

Data Cleaning, Merging 12 Years of Crime Data (2012–2024) in Excel
Data Cleaning, Merging 12 Years of Crime Data (2012–2024) in Excel

Freelance

→

Summary

I clean, standardize, and consolidate over 12 years of crime records (2012–2024) stored across multiple Excel sheets into a single master dataset. The raw data contained duplicates, missing values, inconsistent formats, and varied naming conventions across different years. My task was to transform this fragmented historical data into a clean, structured, and analysis-ready dataset suitable for reporting. The output was an Excel file with consistent formatting, accurate records, and clear categorization of offence groups and subgroups, making long-term crime analysis efficient and reliable.

Health care (Power Bi Dashboard)
Health care (Power Bi Dashboard)

Freelance

→

Summary

I built an interactive Power BI healthcare dashboard that provides a clear overview of patient volume, costs, care performance, and trends. The dashboard tracks key KPIs such as total patients, estimated costs, adherence rate, follow-up rate, and average length of stay, with breakdowns by diagnosis, gender, age group, satisfaction level, and month.

Google Sheets Automation Task Tracker + Dashboard (Email + Calendar)
Google Sheets Automation Task Tracker + Dashboard (Email + Calendar)

Freelance

→

Summary

I built a Smart Workflow Automation Dashboard in Google Sheets, tracks task progress across departments with real-time updates. It displays task status, overdue tasks, weekly trends, and assignments using charts and color-coded visuals. Departments and assignees can be filtered to monitor performance and workload distribution. An integrated AI Weekly Summary automatically highlights trends, delays, and top performers. Built with advanced formulas, conditional formatting, Google Apps Script, and data validation. This improving efficiency, and staying on schedule.

Interactive Spotify Music Dashboard (Microsoft Excel )
Interactive Spotify Music Dashboard (Microsoft Excel )

Freelance

→

Summary

This project showcases a comprehensive Spotify Music Dashboard built using Microsoft Excel and Google Sheets to analyze and visualize a dataset of over 3,000 songs. The goal was to provide meaningful insights into listening habits, artist performance, genre distribution, and content characteristics such as song duration and explicit content. The workflow began with thorough data cleaning and preparation, ensuring accurate filtering and consistent formatting across fields like artist names, genres, and song durations. Using advanced Excel formulas and Spreadsheet Software functionalities, I was able to streamline the dataset and extract actionable metrics. I developed an interactive dashboard using Microsoft Excel Key highlights of the dashboard include: - Total songs analyzed and number of unique artists. - Top 10 most featured artists (with Eminem ranking #1). - Genre popularity via pie chart breakdown. - Average popularity and song duration metrics. - Song length distribution visualization. - Most popular albums and top songs by genre. - Explicit vs. non-explicit content summary. A great example of how data, when well-structured and visualized, can provide deep insights into user behavior and content trends.

Work

Freelance
|

Sports Footage Analyst & Performance Data Tracking Expert

Longmeadow, Longmeadow, United State

→

Summary

- Analyzed youth soccer player performance data using Google Sheets and Excel to identify strengths, weaknesses, and improvement trends. - Built sports performance tracking dashboards with automated calculations, player rankings, visual charts, and game-by-game statistics reporting. - Created organized Google Forms and spreadsheet systems for easy sports data collection by coaches, players, and parents. - Reviewed match footage and logged detailed player statistics, including passes, goals, fouls, assists, and performance metrics with high accuracy. - Supported sports analytics and AI training projects through accurate data entry, event validation, statistical tracking, and structured reporting workflows.

Freelance
|

Google Sheets Dashboard Designer | KPI & Data Visualization Specialist

United State

→

Fixed

Summary

- Redesigned a basic Google Sheets workbook into a modern executive-style dashboard for an appliance rental company, improving reporting clarity and business performance tracking. - Built dynamic KPI dashboards featuring MRR, CAC, churn rate, active customers, maintenance costs, and sales analytics using advanced Google Sheets formulas and charts. - Improved multiple business tracking tabs, including financials, inventory, customer retention, sales funnels, and weekly scorecards with clean formatting and automation. - Developed mobile-friendly dashboards with conditional formatting, auto-updating charts, data validation, filters, and professional visual hierarchy. - Created easy-to-use reporting systems with branded layouts, interactive summaries, and organized workflows that helped streamline business operations and decision-making.

Eugene
|

Google Sheets & Excel Analyst

Abuja, Fedra Capital Territory, Nigeria

→

Fixed

Summary

- Designed KPI dashboards and financial tracking systems in Excel and Google Sheets with clean layout, spacing, and presentation-ready visuals. - Created interactive dashboards using PivotTables, slicers, and charts to allow non-technical users to filter and explore performance data confidently. - Automated reporting workflows using Apps Script, eliminating repetitive manual updates and reducing the risk of broken formulas. - Built print-ready and PDF-export dashboards, ensuring reports were easy to share with leadership. - Delivered structured, well-documented spreadsheets with clear data entry points and protected logic, making ongoing updates fast and error-proof.

Education

The Federal Polytechnic Bida
NIGER, NIGER, Nigeria

→

In Class

Chemical Engineering

Grade: 3.086

References

Eng'r David

Lecturer