Data Analysis

This is a Data analytics project of my interest.

Project lists

Stock data analysis (Part 1)🔥🔥Recommend

• This is a project that a finance job interviewer asked me to do. I will explore the datasets to find interesting insights for investment purposes.
• In the first part, I will analyze the datasets to develop trading strategy.
• I found the percentage change of today's closing price from today's morning opening price are correlate with the percentage change of afternoon opening price from today's morning opening price.
• So I got strategy "Buy Afternoon opening price (ATO2), Sell today closing price (ATC)"
• Tool : Python
• Skill : Data analysis, Data visualization, Trading ideas

Bangkok Condo for sale🔥🔥Recommend

• It's a project about solving the problem of selling my brother's condo. And find opportunities to invest in condos by comparing prices from real estate web sites.
• The market price of my brother’s condo room is 3,130,330 THB, which is information that helps to decide sale price again for my brother, for example, if he want to sell faster, maybe consider a 10%, 20% or 30% reduction from initial price.
• Tool : R, SQL, Tableau
• Skill : Web scraping, Data analysis, Dashboard

Workforces Analysis🔥🔥Recommend

• This is a test project for a Data Analyst position applying. The company applying has provided call center operation data for analysis.
• The customer side will incoming the most on Wednesday, average to over 2000 case. We can consider adding extra staff on Wednesdays.
• Tool : Google Sheet, Python, Tableau public
• Skill : Data Analytic, Pivot Table, Visualization, Hypothesis testing, Dashboard, Presentation

Major Event affect to Asset🔥🔥Recommend

• This is the basis for studying important events over the past 43 years, to understand how each event impacted asset prices and to use this information as a guide for investment allocation.
• Tool : Google Sheets, Tableau Public
• Skill : Dashboard

Data Analyst, Data Scientist and Data Engineer Salaries

• This project about Dashboard with show Data Analyst, Data Scientist and Data Engineer Salaries around the world during paid in 2020-2022.
• Tool : Google Sheet, Tableau public
• Skill : Dashboard

Business Case: What affect to Yulu's revenues

• I'm interested in trying statistics to solve real-world problems. So I'm going to try to solve why the company's revenue is declining and how to improve it.
• The number of cycles rented is significant different across seasons by highest rented in Rainy season
• Tool : R and SQL programming
• Skill : Data Analytic, Visualization, Hypothesis testing