Group Project and Individual Project
Group Project
.png)
KEN JEE'S
YouTube Data
Role : Data Cleaning and Analysis.
​
Task : Data cleaning such as data manipulation, analysis data using descriptive statistic and support creating interactive dashboard to visualize.
Tools : Google colab and Tableau Public
Project Description: Ken Jee is a YouTube content creator who have been working in the data science field, doing sport analytics for the last 5 years, which is also his passions. Ken jee wants to know why the number of Ken Jee’s YouTube channel’s subscribers gained in 2020 had dropped significantly by 56% in 2021.And why the most of Ken Jee’s YouTube videos only being viewed until 30-40% mark.
Result : We recomended to make a clean thumbnail with text color light (white,yellow,skyblue) over dark. Expand and merge topics. Talk about a popular “mainstream” topic related to data science, but in thumbnail let very clear that you will talk about machine learning/analytics or data science.
Individual Project
People Analytics
Role: Data Analyst
Task: Data Preparation (Import library and import data source), Data Cleaning, EDA
Tools: Google Colab and Looker Studio
Project Description: Analysis of employees who will retire based on age.
Result: Make Employee Analysis. With this segmentation, they can create campaigns to deal with sudden and inefficient hiring.
Customer Segmentation in E-commerce start-up
Role: Data Analyst
Task: Data Preparation (Import library and import data source), Data Cleaning, EDA, Clustering, Customer Segmentation, Recommendation.
Tools: Google Colab
Project Description: Increasing convertion rate refer to customer segmentation.
Result: Creating​ customer segmentation. With this segmentation, they can create marketing programs for each segment, which are customers with a small payment (small spender) and a big payment (big spender) where a low spender is a customer targetting in the campaign for increasing the conversion rate.
Overview monthly monthly Growth of bike trips in San Fransisco
Role: Data Analyst
Task: Time series analysis
Tools: BigQuery
Project Description: How monthly growth of bike trips is in San Fransisco by implementing window function (i.e Lead)
Result: San Francisco have a Bikeshare program where people can use bikes to travel within the city, the data I used in this analysis is the data between 2014 and 2017. Delivering the requested data in time, helped the team to deliver report on the analysis in time.
EDA and Overview Film Dataset
Role: Data Analyst
Task: Identify the data and create interactive dashboard.
Tools: Tableau Public and Google data studio (GDS)
Project Description: Utilize Tableau to conduct EDA and create interactive dashboard by Tableau Public and GDS.
Result: EDA of Film dataset to understand the data profile by seeing dominating data refer to numerical variables such as listing price, minimum night and availability besides categorical variables such as total number of titles, average total number of title/year, release year/title, production countries/title.
Future sales prediction for E-commerce
Role: Data Analyst
Task: Correlation Analysis, Regression Analysis and statistic for hypothesis testing.
Tools: Spreadsheet
Project Description: How to predict future sales by analyzed using Regression Linear and defined variable which have correlation.
Result: I cleaned the data, removing irrelevant/missing values, handling outliers, and did some data formatting to help me with the analysis. I also delivered insight from the regression analysis. I analyze the number of purchases of wine and meat because wine is the most purchased product. Meanwhile, meat is a product that has a strong correlation with other products. Therefore, the higher the sales of meat, the higher the other products will also be. This indicates that when a buyer buys meat, there is a possibility that the buyer will buy another product