top of page
Fredyandu - White Banner.png

DATA ANALYSIS PROJECT

Porto_DA1.png

PROJECT BACKGROUND

The hotel has conducted an NPS survey and some data that needs to be known for
improving the quality and standard of the hotel are as follows:
▪ Survey objective : to determine the level of customer satisfaction with the performance, service and
quality of the hotel
▪ Total respondents : 482 person
▪ Average age : 53 years
▪ Average cost : £119.62

METHODOLOGY

Business Background

DARCI

Problem Statement

Objective

Root Cause

Hypothesis and Metrics

Conclusion

Tools : Google Spreadsheet, XLMiner

Tools : Google Spreadsheet, Statistics

Porto_DA2.png

PROJECT BACKGROUND

On every twin date, such us October 10 (10.10), TokoBli have
a campaign to always held with a big flash sale promo and
free shipping for all transactions. twin date event applies in
all regions in Indonesia. During this campaign period, the number of transactions will increase up to 10 times compared to normal days.
During the last 3 campaign periods, the team has tried 3 types of campaign scenarios

METHODOLOGY

Business Background, Business Understanding,

Business Metrics
Data Cleaning
Descriptive Statistics
EDA
Hypothesis Testing
Recommendation

Tools : Google Spreadsheet, Phyton, Tableau

Tools : Google Spreadsheet, XLMiner

Porto_DA5.png

PROJECT BACKGROUND

The primary goal of this project is to provide in-depth insights into ESM Sport’s pickleball sports customers. The project key aspects :
● Customer Segmentation : Identify customer groups based on demographics, behaviors, and transaction patterns for pickleball court
rentals
● Court Rental Time Analysis : Understand court rental trends based on time of day (e.g.,
daily, weekly, or seasonal)

METHODOLOGY

Problem Understanding
Data Preparation and Cleaning
Exploratory Data Analysis
Data Analysis
Data Visualization
Insight and Recommendation

Tools : Google Spreadsheet, Phyton, Tableau

Tools : Google Spreadsheet, Phyton, Tableau

Porto_DA3.png

PROJECT BACKGROUND

Analyze historical transaction data from RevoBank customers about credit card usage and can identify trends and customer usage patterns for credit card products. So as to create detailed customer personas to be able to create segmentation, needs, and preferences for credit card product customers.

METHODOLOGY

Analytical Objective
Data Cleaning, Preparation and Communication
Descriptive Statistics
Cluster Analysis
Cluster Interpretation
Conclusion
Recommendation

​

​

Tools : Google Spreadsheet, Phyton, Tableau

Tools : Phyton (Google Colab)

Porto_DA4.png

PROJECT BACKGROUND

The company wants to monitor the development of stores in several locations to find out the value of successful sales transactions, segmentation of sales data based on customer gender, customer segmentation based on store location demographics, company profits, product transactions based on product categories, and analysis of payment methods from customer transactions.

METHODOLOGY

Worksheet Objective
Data Source Preparation and Communication
Basic Visualization
Advance Calculation Fields
Fundamentals of Data Visualitation
Tableau Dashboard
Business Acumen​

​

Tools : Google Spreadsheet, Phyton, Tableau

Tools : Tableau

GRAPHIC DESIGN PROJECT

WEB DESIGN PROJECT

Subscribe Form

Thanks for submitting!

Phone : +62 895 0799 7924

©2024 by Fredyandu Rombelayuk. Proudly created with Wix.com

bottom of page