Data Cleaning in SQL
This project demonstrates SQL-based data cleaning on a housing dataset, covering essential techniques such as date standardization, address completion, and parsing, breaking out address components, standardizing categorical values, and removing duplicates. Additionally, it optimizes data structure by removing unnecessary columns, improving both the dataset’s integrity and usability for analysis.
View ProjectData Exploration in SQL
This project analyzes COVID-19 data using SQL, focusing on infection, death, and vaccination rates worldwide. It combines datasets to calculate mortality and infection rates, tracks global trends, and visualizes vaccination progress as a percentage of each population. This work showcases SQL’s power in handling public health data for impactful insights and reporting.
View ProjectCOVID-19 Data Analysis with SQL and Tableau
Conducted comprehensive data analysis on global COVID-19 statistics, including cases, deaths, and vaccination rates. Cleaned and transformed data in SQL to calculate metrics like infection rates, death percentages, and vaccination coverage by location, enabling insightful visualizations in Tableau.
View Project Tableau PageMovie Dataset Analysis with Python
This project explores a movie dataset to uncover trends in budgets, earnings, and release years. Using Python, the analysis includes data cleaning, statistical evaluations, and visualizations, providing insights into financial performance and release patterns in the film industry. The project offers a detailed look into factors influencing a movie's success and is a great example of data handling and analysis skills.
View Project
Nutrition API Project
This project involves the development of a Nutrition API that provides detailed nutritional information about various food items. Using a combination of Java and Spring Boot, the API efficiently retrieves data from a database, enabling users to search for food items and obtain vital nutrition facts, such as calories, proteins, carbs, and fats. This application is designed to assist users in managing their dietary choices and promoting healthier eating habits. The project emphasizes RESTful principles and utilizes effective database management techniques to ensure seamless data retrieval and accuracy.
HTML, CSS, and PHP Web Development Project
This project showcases my foundational skills in web development, utilizing HTML, CSS, and PHP to create a dynamic and interactive website. It features user authentication, dynamic content generation, and seamless interaction with a MySQL database. The responsive design ensures compatibility across devices, while best practices in security and data validation are emphasized throughout. This project represents my commitment to mastering full-stack development and delivering an engaging user experience.
