PORTFOLIO
Ramy Batta
This portfolio houses my projects along with a list of a skills and forms of contact. Thank you for visiting.
These skills are the foundations of my projects. I earned certification in SQL and Tableau, and gained practical experience with Excel at work. Additionally, I took courses using STATA and the rest of Microsoft Office Suite during school.
All of my published projects can be found here. I worked with various public datasets to practice my skills while focusing the projects on analyzing data to find insights, trends, and aggregations that I genuinely consider interesting and useful. Click on the title of a project to visit it.
It has been estimated that 25% of all travelers in the US and Europe use Airbnb for their stay. This project delves into a public Airbnb dataset that contains information about 10 cities around the world where tourists are common. Through data exploration using MySQL it focuses on finding trends, insights, and research that can be useful to someone who wants to become an Airbnb host, and for people who are going on a vacation soon.
This project uses sales data from a bicycle shop to ultimately create a dashboard that uncovers customer insights. The dataset is cleaned and enhanced to build easy-to-understand tables and charts, offering suggestions for better customer acquisition. All the work is organized in an Excel file with different sheets displaying the project's progress.
The Bureau of Labor Statistics predicts a surge in data science jobs, reaching 11.5 million by 2026. Using Tableau, this project analyzes Glassdoor's data science dataset, presenting key industry insights on job patterns, salaries, and company ratings. The focus is to understand how different factors impact the job market, particularly in terms of salary trends, employee satisfaction ratings, and other crucial metrics.