INVESTIGATIVE ANALYSIS OF SQL CITY

This is an investigative analysis of SQL city, a man was murdered and I was tasked with finding out the killer. Series of data was used to investigate and provide insights on the actual killer and the mastermind behind the crime, this was ranging from the interview, gym members, license id and the r

PIZZA JUNGLE SALES REPORT

I analyzed this sales report using 3 tools, excel, SQL and power bi. This project shows the linking pattern of these 3 tools and how none is more relevant than the other. I worked on sundry foods subsidiary PIZZA JUNGLE, provided insights on the rush hour, monthly trend, daily trend, total pizza sol

GLOBAL SUPERSTORE ANALYSIS

This analysis focuses on a global superstore, which means data from different continents are included in this dataset. The use of excel, power query for data cleaning was explored, SQL for queries, power bi for visualization which also included the use of DAX to create new measures.

Kilimanjaro Food Prep Analysis

This project is centered on the use of DAX. DAX is in a tool in power bi known as (Data Analysis Expressions) is a formula expression language and can be used in different BI and visualization tools. DAX is also known as function language, where the full code is kept inside a function. DAX programm

JORDAN CLINICS HEALTH ANALYSIS

This project aims to derive insights from the screening activities meant to quickly establish the health relevance of the policy, programme. It then investigates the key issues and public concerns and creates boundaries and expectations. R was a major tool used for this project. I was able to achiev

FIFA PLAYERS PERFORMANCE ANALYSIS 2019

During my studies at vephla, I analyzed this dataset that centers on FIFA players performance, this includes different teams, players, weak foot, wages, countries with the most players. I derived insights on this dataset using power BI tools.

COVID 19 CASES AND WORLD HAPPINESS ANALYSIS

This is a joint project that focuses on COVID-19 AND HAPPINESS report, this analysis has insights on the countries with most cases, countries with happy citizens, regions with most cases of covid, I analyzed this project using power BI.

GLOBAL POVERTY INDEX

This project focuses on regions, countries with high and low poverty index. It also derives insights on the key issues leading to high poverty index. This is a global concern, I have tailored this project to provide details, answer queries related to global poverty index

Corruption Index

As a data analyst in training, I worked on this project, analysing the corruption index of the regions in the world. I worked with different data sets having to ascertain the corruption index of different countries and regions. From this dasboard, anyone can decipher regions with high CI.

POPULATION IN THE US

While studying at Vephla, I worked on different projects using different tools like excel, power BI and tableau. This project was analyzed using Tableau tools, I derived insights on the population in different states and cities in the US, annual change, area mile, density and land mass in the US.

C.H.O SUMMIT ON TB ANALYSIS

This project gives detailed insights on tuberculosis, countries with most cases, highest cause, death rate. While studying at Vephla, I worked on this dataset to help prevent tuberculosis and also to create awareness.

HOPKINS VETINARY

I analyzed this data set during my studies in Vephla Uni, this data set is about dogs and their different breeds and characteristics.

GRACE SCHOOL REPORT

During my studies at Vephla Uni, I analyzed this dataset on Grace school and was able to derive insights on the student with the highest cgpa, willingness to participate in sports, absentee, parental suppprt. This report will serve as a guide for the administration and parents

CIA SUMMIT 2023

This project was analyzed using power BI tools, I was able to derive insights on this dataset for the CIA summit 2023. Insights like countries with the highest CPI, highest ranking regions from year 2020 till date. This will serve as a guide to world leaders to investigate and regulate these countri

CALIFORNIA UNIVERSITIES

I analyzed this data while studying at Vephla Uni, I derived insights on the different universities in California, ones with most enrolled students in a year, one with most apps, most university and so on. Further more this can serve as a guide to intending students.

SUNDRY SALES

I advanced more in my studies at Vephla Uni, I analyzed a project using Power BI. I indulged in using power query to clean and uncheck unnecessary information from my dataset before loading my data and creating a dashboard using data visualization tools.

BEST SELLING BOOKS

This project evolves around the best selling books in the world, I worked on this project during my studies at Vephla. This project gives insights on the best authors, books that generate more sales, genre that people love most and ranking of different books.

CAPE UNIVERSITY ANALYSIS REPORT

This is a project that revolves around the statistics of Cape university, it provides insights on the different faculties and courses that are offered in the university. Studying in Vephla developed my interest in universities and the affairs of students in those universities.

HOPKINS VETINARY 2023

Hopkins Vetinary is a world class pet hospital, in a bid to improve and have a more standard data set that helps them present their growth and research. While studying at Vephla I used Power BI to analyze the dataset.

US POPULATION DATA

During my studies in Vephla Uni, I worked on this project analyzing the population in US between the year 2020 and 2024. The variations in these years also focuses on the different states and cities in the US and also their growth pattern. This project provides insights in this areas.

AIDEN MARRKETS

As a sales representative, I can assure you that you can not have a successful business without a detailed report. Working on this dataset gives us an insight on the sales trend, top products, gross income by branch and customer count. I worked on this during my studies at Vephla University.

CJAN AUTOS

I made a detailed report on the insights derived from the dataset of CJAN Autos. During my studies at Vephla as a lover of automobiles I decided to work on cars dataset showing the strongest model, the most produced model, top color used and size.

Analysis of universities in California

While studying at Vephla university, I analysed, cleaned and created a dashboard using the data set of universities in California. I was able to achieve this after studying the data set throughly and also from this dashboard, an individual can ascertain the strengths and weakness of some schools.

NBA players report 2024

This is a detailed report that provides insights on NBA players and their various teams. While studying at Vephla I worked on this dataset and derived these insights which focuses on NBA players.