프로젝트 (1)

[Summary]
Introduction:
•
This case study is done upon the customer data of Databel, a telecom company in US.
•
The objective is to analyze the churn rate of Databel's customers, deliver extracted insights, and propose following solutions to the managers.
Customer Churn Rate Analysis
Excel
Churn Rate
Data Analysis
[Summary]
Introduction:
•
Identifying distinct customer segments within a heterogeneous customer base was the primary challenge, which would enable the implementation of more targeted and effective marketing strategies.
Context:
•
A company requested a robust model to segment customers based on their behavioral and demographic characteristics, ensuring that marketing efforts could be precisely aligned with customer needs and preferences.
Marketing Campaign Customer Segmentation
Data Analysis
Python
Statistics
Summary:
Overall, the advanced excel visualization tools are touched in this project and used accordingly.
Introduction:
•
This project was initiated in an attempt to upscale the level of data visualization skills in Excel
•
The objective is to provide advanced data visualization dashboard of customer data from a company operating in US using Pivot Table, Pivot Chart, and VBA.
Dataset:
Delivery App Customer Segmentation
Excel
Visualization
•
I collected and analyzed 39 current Data & Business Analyst job recruitment posts for personal excel data analysis project. I especially collected the data from international companies rather than completely local ones.
Top 10 Skills required to work in international companies as data analyst:
Learning programming languages like SQL, Python, and R is super important
SQL is required more often than Python or R; therefore, it will be important for me to prioritize mastering SQL first.
Top Skills required for Data & Business Analyst in Tokyo
Excel
Data Analysis
Visualization
Summary:
Objectives:
•
This case study is done upon analyzing dataset of VanArsdel and its competitors.
•
The datasets include:
1. Sales-dataset
Analyzing a company’s market competitiveness
Power BI
Data Analysis
Visualization