
DATA ANALYSIS PROJECT

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

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

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

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)

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