Portfolio
Project 1: Airbnb Analysis - La Jolla, CA
​Project 1 includes Excel and PowerBI analysis and visualization in exploring potential revenue streams that a retired couple could potentially take to offset the rising cost of living and increase their travel budget.
Tools: PowerBI, Excel, Google Slides
Project 2: Capital Bikeshare Expansion Analysis
Project 2 includes the use of SQL and Tableau to query and visualize big data. This project discusses the potential upgrades that Capital Bikeshare can make to their stations to increase their revenue and retain their customer base.
Tools: Postgre SQL, Tableau, PgAdmin4
Project 3: Data Sprint - Wind Energy Analysis
Project 3 used Python, SQL, and Tableau to analyze the U.S. wind energy market. This project looked into wind turbine locations, manufacturers, and operators. Also compared it with hydropower and solar power. Finally, provided recommendations for the stakeholder - Windy Waters & Co.
Tools: Postgre SQL, Tableau, PgAdmin4, Python, Jupyter Notebook
Project 4: Clark's Charter Business Case
Project 4 entails analyzing Clark's Charter company's vehicle replacement program. Using data and Excel tools to access cost, benefits, risk, and demand factors. This analysis will guide the company in making informed decisions about fleet upgrades.
Tools: Excel, Google Slides
Project 5: Capstone Project - EV Analysis in Washington State
Project 5 is dedicated to BMW as the primary stakeholder. It entails employing SQL, Excel, and Python for data processing. Utilizing Tableau to investigate the electric vehicle (EV) charging market in Washington state. The overarching goal is to offer BMW straightforward, actionable recommendations to refine its market strategy in this dynamic landscape.
Tools: Postgre SQL, Tableau, PgAdmin4, Python, Excel