Kayode Olatunji Portfolio

Kayode help businesses and companies make sense of the large amounts of data by Developing Anaytical Solutions to help them achieve their data-driven goals. He is skilled in SQL, DAX, M, Python, Power Apps, Power Automate and Advanced Excel @KayodeOlatunji

Analytics Engineering (MDS):Fashion Industry Use Case

Built a containerized Loader in Docker using Airbyte, that will extract and Load data from Google Sheets to BigQuery. Performed transformations in version-controlled manner using dbt and Github and generate insights using Metabase to help the business answer key questions.

Data Exploration in R using RSTUDIO

Data Exploration of Health and Wellness data using R in Rstudio Cloud using functions like Unite to concatenate columns, Mutate for calculated columns, filter to limit scope,rename to rename columns, separate to split columns, Piping Technique to run series of tasks as one process, Groupby and other Aggregate functions.

Data Cleaning and Analysis using SQL

In this project we analysed shipping data in PostgreSQL using Basic and Advanced techniques to generate insights from data. Using Basics of SQL like SELECT, FROM, WHERE,HAVING, ORDER BY, LIMIT, Aliases, Dealing with JOINS, AGGREGATIONS and FUNCTIONS, CASE STATEMENTS, SUB-QUERIES, CTEs and WINDOW or ANALYTICS Funtions

Location

Lagos, Nigeria

Phone

(+234) 70 6202 8089

Email

olatkem@outlook.com

Social