Data Analyst skilled in PowerBI, SQL, MySQL, Python and R @Godwithus
Here is my Second Runner-up winning solution for the DSN 2024 Artificial Intelligence Bootcamp Project Participation.
This analysis seeks to answer questions like:
Which health sectors are performing well, and where can improvements be made?
What are the most dangerous conditions based on standardized death rates?
What are the top 5 diseases contributing to the highest mortality?
.png)
.png)
The insights show interesting patterns in taxi usage. Most trips are shared, indicating a collective preference. Errands are the primary purpose, with Uptown being the busiest location.Understanding these trends can help taxi companies optimize their operations, enhance customer satisfaction, and ultimately increase revenue.
.png)
This project seeks to Analyze the sales performance across different regions, product categories, and time periods as well as the profitability of different products and regions.
The sinking of the Titanic is one of the most infamous shipwrecks in history.
On April 15, 1912, during her maiden voyage, the widely considered “unsinkable” RMS
Titanic sank after colliding with an iceberg. Unfortunately, there weren’t
enough lifeboats for everyone on board,
resulting in the death of 1502 out of 2224 passengers and crew.
While there was some element of luck involved in surviving,
it seems some groups of people were more likely to survive than others.
This analysis seeks to understand the passesngers using the dataset obtained
from kaggle.
Some visualizations built were:
Passengers Survival Proportion by Sex, Passengers Survival Proportion by Ticket Class, and many more.
The Africa Cup of Nations commonly referred to as the TotalEnergies Africa Cup of Nations
for sponsorship reasons,or simply AFCON or CAN, is the main international men's association
football competition in Africa. Since 1968, it has been held every two years,
switching to odd-numbered years in 2013.
This Analysis seeks to understand some key highlights about AFCON since its inception.
Some visualizations built were:
Number of African Countries to have ever participated in the competition,
Countries who have won the finals the most, countries who have scored own
goals the most and many more interesting insights.
This project seeks to find out
from the data the following insights.
What day of the week are vehicles most often and least often stolen?
What types of vehicles are most often and least often stolen?
What is the average age of the vehicles that are stolen?
Which regions have the most and least number of stolen vehicles?
A year's worth of sales from a fictitious pizza place, including the date and time of each order
and the pizzas served, with additional details on the type, size, quantity, price, and ingredients.
This seeks to answer questions like:
Which pizza category is sold the most
What size of pizza is sold the most
Are there peak hours with respect to pizza order, and many more.
WeRateDogs is a twitter account which share dog images and write a brief panegyric about the dog, then they let their followers to rate it by favoriting it. By asking WeRateDogs to share with us some of their tweets, they did. They have shared 5000+ of their tweets which contains some basic data. using the data, this project made use of python to wrangle the dataset, and perform some exploration using the data.
In this project, we seek to understand using the available dataset to explore and inform what criteria predicts if a patient would show up for a scheduled appointment
The dataset used in this project includes information about individual rides made in a bike-sharing system covering the greater San Francisco Bay area. In this project, exploration was done to understand what days of the week The main interest was to know which day of the week is the most busy, what is the most popular gender and user type, the top 10 start_station name, and the most popular station destination.
Predicting the selling price of a residential property depends on a number of factors, including the property age, availability of local amenities, and location. In this project, I used a dataset of real estate sales transactions to predict the price-per-unit of a property based on its features
Wine experts can identify wines from specific vineyards through smell and taste, but the factors that give different wines their individual
charateristics are actually based on their chemical composition.
In this challenge, I trained a classification model to analyze
the chemical and visual features of wine samples and classify them based on their cultivar (grape variety)
The relationship between cigarette smoking and body weight has been studied in Western
countries for more than a century, either comparing body
weights between current smokers and nonsmokers or evaluating the effect of smoking on weight change over time.
This analysis seeks to answer questions like:
What relationship exists between the weight of respondents and their desired weight
Is there any association between gender and general health status
What is the confidence interval for the population mean of body mass index, and many more.
MySQL provides a robust relational database management system (RDBMS) that
allows for efficient storage and retrieval of data. This makes it an ideal
choice for storing large volumes of structured data, which is often necessary for data analysis.
This analysis cuts across the use of basic MySQL syntax,
Use of Wildcards for Data Manipulation, Order By clause
Simple and Compound Join, Copying and Updating a table, to mention but a few.