I have technical proficiency includes SQL, Python, R, Matplotlib/Seaborn, Excel, and Tableau, along with knowledge of big data technologies like Hadoop Spark, Hive, and serverless big data solutions such as AWS.
This project utilized clustering and regression analysis to assess EV efficiency and rebate distribution, identifying gaps in efficiency measurement and limitations of battery range as a predictor. It highlighted the superior efficiency of battery-powered EVs and performance disparities among manufacturers.
.jpg)
The "Cleaning Data in SQL Queries" project improves the Nashville housing dataset by standardizing dates, filling missing values, splitting addresses, updating categorical values, removing duplicates, and deleting unused columns. These steps ensure data quality and consistency for accurate analysis and reporting.
.jpg)
The "Covid 19 Data Exploration" project uses advanced SQL techniques to analyze COVID-19 data from 2020 to 2024, deriving insights on cases, deaths, and vaccination rates across regions. It employs joins, CTEs, temporary tables, window functions, and views to ensure comprehensive and organized analysis.
The project examines current real estate listings to understand market dynamics, highlighting that single-family homes and condos dominate listings. It also assesses housing affordability, revealing that while many Bay Area cities have high-priced properties, some cities like Brentwood and Concord offer more affordable options.
The project uses Excel pivot tables to analyze bike purchase behavior based on commuting distance, income, and age brackets, helping to inform targeted marketing strategies. The findings are visualized in an interactive dashboard for easy exploration and decision-making.
.jpg)
The project utilizes historical stock data and Excel tools to develop an optimal investment portfolio, balancing risk and return, and visualizing the Efficient Frontier. The optimized portfolio demonstrates diversification and favorable risk-adjusted performance, guiding informed investment decisions.
These Tableau projects include dashboards for HR, customer and sales analysis, financial complaints, flu shots, and British Airways reviews. Each dashboard provides visual insights to enhance data-driven decision-making across various domains.
.jpg)
This project scrapes real estate data from Realtor.com for San Francisco properties using Python, extracting details like prices, beds, baths, and addresses, and then cleans and structures the data for analysis. It leverages libraries such as requests and BeautifulSoup for web scraping, and pandas for data manipulation.
Milpitas, CA