CHARLES GYAMFI
PORTFOLIO
Collect, process, analyze, and present data by report
Embedded Files
One of the fascinating things about being a data analyst is you are a storyteller. You look at the data and every data point out there has a story to tell.
Practical Hands-on Project
Dataset - Marketing Campaign
Marketing campaign is an organized course of action to promote and sell a product or service. I was asked to check the preferences of the customers and how they react to the products bought from the company.
Key Insights
Out of 116M Total Income,
10M income represent 2n Cycle
1M income represent Basic
59M income represent Graduation
19M income represent Master
27M income represent PhD
Consequently,
* A higher average of 56.94%, 53.33%, 47.85%, 48.50% and 52.76% representing the costumers who accepted the offer in the 1st campaign, 2nd campaign, 3rd campaign, 4th campaign and 5th campaign respectively for Graduation(Education)
* Out of 21 complains, A high of 14 Graduation(Education) complain of the products purchase
* 24 of the customers had no income
* A high average of 38.96% customers purchase from the store and a low average of 15.64% customers purchase from deals.
* A high of 8 complains came from Married people and we recorded zero(0) complain from Absurd, Alone, Widow and YOLO
* Customer ID 9432
- Income was 1M(highest income so far)
- Didn't complain
- Visit the web 6 times a month
- Number of Catalog purchase was 1
- Number of Deals purchase was 4
- Number of store purchase was 3
- Number of web purchase was 3
Dataset - Covid 19 in Africa
Key Note
* Nigeria has the highest population of 213 Million. As a result of the Covid Pandemic, it population reduced to 21262 thousand.
* Seychelles has the least population of 99122.But it population reduced to 99004 in the cause of the Covid 19 pandemic.
* South Africa recorded the highest death cases of 88317 in Africa and Burundi recorded the least death cases of 38
* At 2791256, South Africa had the highest Total Recovered and was 360,993.92% higher than Burundi, which had the lowest Total Recovered at 773.
*South Africa accounted for 36.18% of Total Recovered.
* Across all 53 Country, Total Recovered ranged from 773 to 2791256.
Dataset - Hotel Booking
Data Cleaning & Preparation : Power Query
Visualization : Power BI
Key Insight from Smart Narrative
* At 24,970, 30-45 had the highest Count of Customer ID and was 35.39% higher than 15-30, which had the lowest Count of Customer ID at 18,443.
* 30-45 had the highest Count of Customer ID at 24,970, followed by 45 and above at 23,122 and 15-30 at 18,443.
* 45 and above had 23,122 Count of Customer ID, 30-45 had 24,970, and 15-30 had 18,443.
* 2019 accounted for 15.56% of Booking Price[SGD].
* HSBC in Gender made up 5.65% of Average of No. Of People.
* Average No. Of People was higher for Female (4.01) than Male (3.99).
* Average of No. Of People for Female and Male diverged the most when the Bank Name was DBS Bank, when Female were 0.11 higher than Male.
Dataset - Restaurant
Below was my attempt on the Restaurant Challenge by Maven Analytics.
Key Insights
* The high rated restaurants are in the City of San Luis Potosi. These restaurants offer:
- Medium Price
- Mexican Cuisine
- Selective smoking and Alcohol service
* 87 of consumers who are single preferred Mexican while 8 married consumers preferred Mexican
* 138 Consumers representing Full Bar for Alcohol service
* We recorded a high drink_level of 51 for Abstemious and a low drink_level of 40 for Social_Drinker
Consequently, It will be a good idea to invest in a restaurant that offers Mexican Cuisine at a Medium Price. At least the restaurant should be located in San Luis Potosi. Also, it would be preferable for the restaurant to have a closed dining area with the option to different smoking or drinking services.
Dataset - Analyzing the test score of students
My task was to examine the relationship between the test score of students using the pretest and the posttest.
After a prudent investigation,
* UKPGS school had the highest score in both pretest and posttest
* 7140 and 5490 representing a total number of students who qualified for reduced/free lunch from GOOBU School
* Urban school had the highest posttest score and Suburban was recorded as the highest pretest score of 45774
* The scores for both posttest and pretest in the public school were very encouraging as compared to the Non- public
* ID number "QXTHU" representing IDGFP" school topped the score in both pretest and posttest
Dataset - Spotify songs played in some country
Spotify is one of the most popular music streaming services worldwide. One of the reason why it is loved by most is because of its amazing collection of playlists.
After a thorough analysis, we had a total of 1099 Explicit song of which, 586 represent Europe, 197 representing North America, 124 representing South America, 102 representing Asia, 44 representing Australia, 23 representing Africa and 23 representing the Global.
Greece was ranked with a higher Explicit song of 42
Dataset - Online Chess Games
Online chess is chess that is played over the internet, allowing players to play against each other in real time.
Key Points;
* 9107 Black Chess
* 10001 White Chess
* 950 Draws
* A minimum values of 784 and 789 representing white_rating and black_rating respectively
* A maximum values of 2700 and 2723 representing white_rating and black_rating respectively
* Mean of 1596.63 and 1588.83 for white_rating and black_rating respectively
* We had 55.57% representing the victory_status for Resign
* A total of 18140575 representing White_rating and 18041698 representing Black_rating for Resign
* There is a positive relationship between black_rating and white_rating
Page updated
Google Sites
Report abuse