Joshua Olayori's Portfolio

Projects on cleaning, querying, transforming, analyzing, interpreting, and visualizing data on tools such as Excel, SQL, Python, Tableau & Power BI; done by @JoshuaOlayori

Exploring European Soccer in Python

This European Soccer database contains more than 25,000 matches, 10,000 players, 11 European Countries with their lead championship, information on Seasons 2008 to 2016, players' and teams' attributes sourced from EA Sports' FIFA video game series, weekly updates, team line up with squad formation (X, Y coordinates), betting odds from up to 10 providers, and detailed match events for 10,000+ matches. Questions on penalties, height and heading accuracy, weight and jumping, balance level, finishing level, etc were answered.

Olist Store Data Analysis in Power BI

This dataset analyzed has information of 100k orders from 2016 to 2018 made at multiple marketplaces in Brazil. Its features allow viewing an order from multiple dimensions: from order status, price, payment and freight performance to customer location, product attributes and finally reviews written by customers.

Flights' Analysis in Power BI

Having records for 5,000,000+ commercial airline flights in 2015, compiled for the U.S. DOT Air Travel Consumer Report, I analyzed flight volume by month, percentage of departure delay, average delay time, cancelled flights, etc.

World Energy Consumption

This dataset explored contains energy consumption information from 83 countries. I analyzed different metrics from various energy sources including coal, fossil fuel, solar, wind, etc.

Address


Lagos, Nigeria

Phone

+2348131241170

Email

olayorijoshua@gmail.com

Social