Steffi Ogbatuo | Data Analyst

Steffi Ogbatuo

Data Analyst

Based in Liverpool, UK

About

I am an undergraduate student studying Business and Computing & IT modules at the Open University. I’m also a Data Analyst Intern at Vephla Group learning and practicing data analytics. I love analysing and transforming raw data into easy to understand actionable insights. I’m open to analysing Sales datasets, Marketing analytics, supply chain datasets etc. If you’re impressed with my portfolio then let’s work together to solve your business data problems!

Skills

Projects

Adiflo Sales Dashboard for 2014

This sales dashboard shows the company’s monthly sales performance in a trend line. It shows how much revenue each of their sales representatives have generated, total sales generated by each region, their top 10 customers as well as sales generated by each product category.

Superstore Sales dashboard for 2015-2018

This a dashboard giving a quick overview of the company’s sales performance from 2015-2018. It shows the sales generated from each of their customer segments, the 1.0 cities that generated the lowest sales, the preferred shipping mode by customers and a sales trend analysis trend line.

Serene Beauty Ltd Supply Chain analysis dashboard for 2023

This is a Supply chain analysis dashboard from a dataset sourced from Kaggle for a fictional company " Serene Beauty Ltd".

US Marketing Agencies Campaign Analysis for 2021 Dashboard

This is Marketing Analysis Dashboard sourced from Kaggle analysing the performance of different Advertising campaigns run by different companies across different channels.

SQL INVESTIGATIVE ANALYSIS

This SQL project was undertaken to solve the popular SQL Murder Mystery by uncovering the killer and the person who hired the killer. Throughout this project, I utilised various SQL functions including SQL Joins, GROUP BY AND LIKE to sift through the datasets. Project was done using Postgre SQL

HR EMPLOYEE ATTRITION REPORT - SQL & POWER BI PROJECT

This project was done by using a HR Attrition dataset sourced from Kaggle. Firstly i used Postgre software to query the data using SQL. I went ahead to download the queries as CSV files and imported them to Power Bi where i visualised the results of my Query.

COLLEGE STUDENT FINANCIAL TRACKER - SQL & POWER BI PROJECT

This Project was done using Postgre SQL software to query the data and Power Bi to visualise the results gotten. The dataset has 1000 rows and records college students spending across different spending categories.

JASMINE MART SALES REPORT FOR 2017 - SQL & POWER BI PROJECT

This project was done by using a sales dataset on customer's order of a fictional Store. The dataset was queried using Postgre SQL and the queried tables were then exported as CSV files to PowerBI were data visualisation was carried out.

NETFLIX USERBASE ANALYSIS

This project focuses on analysing Netflix Userbase from 2021 - 2023. The dataset was sourced from Kaggle and It was cleaned using Excel and then imported to Power Bi where i analysed the dataset and visualised my findings.

NERO FINANCE LTD LOAN APPLICANT ANALYSIS - POWER BI PROJECT

This project is an analysis of a fictional loan dataset sourced from Kaggle. The aim of the project was to determine demoghraphics of applicants applying for loans from Nero Finance Ltd. Simple DAX formulas were used throughout the project.

CHARISS BANK CUSTOMER CHURN RATE DASHBOARD

Education

2023-Ongoing

Open Degree at Open University

As an Open Degree at the Open University i have chosen to do some modules in Business and marketing to gain the necessary knowledge needed for working in a business environment. I also have modules in Computing & IT and will be taking modules specialising in Object oriented Javascript, Web Technologies, and modules on Analysing Data and statistical modelling.

2023-Ongoing

Data Analytics at Vephla University

At Vephla University, I have been on an intensive 6 months certified course learning to analyse data with Microsoft Excel, Power BI, Tableau, SQL and R Language.