Data Analyst · Analytics Instructor

Soliu Fatai Olukayode

Data Analyst | Excel • Power BI • SQL

“Transforming complex data into meaningful insights that support better decisions.”

I work with data to uncover patterns, communicate insights and build analytical solutions that help organizations understand their performance and make informed decisions.

Soliu Fatai Olukayode
Excel logoExcel
MySQL logoMySQL
Power BI logoPower BI
AI logoAI

15+

Analytics Projects

3

Core Analytics Tools

300+

Professionals Trained

200+

Student Projects Mentored

About

Analytical thinking, applied and taught.

I am a Data Analyst with practical experience in Excel, Power BI and SQL, passionate about transforming raw data into meaningful insights.

My approach combines analytical thinking, data transformation, visualization and storytelling to help people and organizations understand what their data is saying.

Beyond working with data, I am committed to developing analytical skills in others through teaching, mentorship and practical project-based learning.

My Analytical Approach

01

Understand the Problem

Clarify the question behind the request, the decision it supports and how success will be measured.

02

Transform the Data

Clean, reshape and model raw data into a reliable structure that can be trusted for analysis.

03

Analyze and Visualize

Explore patterns, build measures and design dashboards that make the findings visible at a glance.

04

Communicate Insights

Translate results into clear recommendations that stakeholders can act on with confidence.

Skills

Technical Skills

The tools and practices I rely on to move data from raw extract to confident decision.

Microsoft Excel

Advanced formulas, lookups, pivot tables and structured workbooks for fast, reliable analysis.

Power BI

Interactive reports and data models that let stakeholders explore performance on their own.

SQL

Querying, joining and aggregating relational data to answer precise business questions.

Data Cleaning

Resolving duplicates, inconsistencies and missing values so results stand up to scrutiny.

Data Transformation

Shaping raw extracts with Power Query into analysis-ready tables and repeatable pipelines.

DAX

Calculated measures, time intelligence and context-aware logic for meaningful metrics.

Data Visualization

Chart choices and layouts that highlight the signal instead of decorating the noise.

Data Storytelling

Framing analysis as a narrative so non-technical audiences reach the right conclusion.

Dashboard Development

End-to-end dashboards from requirement gathering to publishing and stakeholder handover.

Portfolio

Featured Analytics Projects

Exploring real-world datasets to uncover insights, solve analytical problems and support better decisions.

Car Sales Performance Analysis dashboard

Sales Analytics

Car Sales Performance Analysis

A sales dashboard presenting vehicle revenue, customer totals, average price and monthly sales performance across customer segments.

ExcelPower BIDAX
Restaurant Order Analysis dashboard

Hospitality Analytics

Restaurant Order Analysis

A restaurant dashboard tracking orders, revenue, ratings, delivery time, cuisine costs and preparation performance.

ExcelData Visualization
Superstore Sales & Profit Performance dashboard

Retail Analytics

Superstore Sales & Profit Performance

A superstore dashboard analyzing orders, sales, profit, product categories, regions, delivery modes and customer segments.

ExcelData Visualization
Student Mental Health & Academic Performance dashboard

Health & Education Analytics

Student Mental Health & Academic Performance

An interactive dashboard examining mental-health prevalence, treatment uptake and academic risk across student groups.

ExcelPower BIDAX
Tata Retail Sales Performance dashboard

E-Commerce Analytics

Tata Retail Sales Performance

A retail performance dashboard exploring revenue, transactions, customers, products and sales distribution across countries and time.

ExcelPower BI
Aviation Airplane Crash & Fatality Analysis dashboard

Aviation Analytics

Aviation Airplane Crash & Fatality Analysis

An aviation safety dashboard covering total incidents, fatalities, aboard counts and fatality rate across routes, years, locations and operators.

ExcelData Visualization

Experience

Experience & Impact

Data Analyst Intern

Jan 2026 — Jun 2026

Bliss Analytics

Delivered 15+ analytics projects across health, e-commerce, procurement, sales, finance and education using Excel, Power BI and SQL.

Data Analytics Instructor

Sep 2025 — Present

Pathway360 Tech Academy

Trained 80+ aspiring analysts and mentored 200+ student projects across Excel, Power BI and data analytics.

Head of Administration

2021 — Present

Odi-Olowo/Ojuwoye LCDA ICT Institute

Maintains student and staff records and coordinates orientation training for incoming ICT students.

Teaching Through Practical Projects

I believe the best way to develop analytical confidence is through practical experience. My training approach challenges learners to work with real-world datasets, solve complex problems and communicate their findings with clarity.

Training photographs

Students taking part in a practical data analytics training session
Soliu Fatai Olukayode facilitating a practical data analytics training session
Learners working on Excel exercises during a classroom training session

Student projects

Student Nigeria presidential election analysis dashboard
Nigeria Presidential Election Analysis
Student superstore sales performance dashboard
Superstore Sales Performance Dashboard
Student Netflix analysis dashboard
Netflix Analysis Dashboard

Student testimonials

Student feedback from Hafsat
Student feedback from Abdulshobur Zurakat
Student feedback from Muktar Ganiyu
Student feedback from Cyril Egenti

Credentials

Certifications

Recognized training and credentials across Excel, Power BI, SQL and data analytics.

Data Analytics Bootcamp (DAB) — Bliss Analytics certificate

Data Analytics Bootcamp (DAB)

Bliss Analytics

June 2026

Data Analysis with Microsoft Excel — Digital World Tech Academy certificate

Data Analysis with Microsoft Excel

Digital World Tech Academy

September 2025

Strategic Thinking — LinkedIn Learning certificate

Strategic Thinking

LinkedIn Learning

June 2020

Information and Communication Technologies — SAED NYSC certificate

Information and Communication Technologies

SAED NYSC

November 2019

Contact

Let's Connect

Whether you are looking for a Data Analyst, interested in collaborating on a project or simply want to discuss data and technology, I would be happy to connect.