AirBnB's 2016 Listing

Investigated 2016 Seattle AirBnB’s 100000+ listing to optimize clients’ AirBnB profits. Constructed data visualization utilizing Tableau Public and joining relevant data. Consulted with clients on the most profitable during summer and holidays.

Bike Sales

Organized and examined 1000+ customers in Excel and created a visual dashboard on bike sales. Revised the dataset to remove identical and sorted the dataset to be categories for pivot tables. Generated a dashboard using charts and judged middle age customers are the highest in sales.

World's Layoffs

Cleaned and analyzed 2000+ companies’ layoffs in SQL and understanding the impact of post pandemic. Utilized MySQL to remove duplicates and errors in a copy database. Created an analysis and learned the tech industries are the highest layoffs.

ABC’s Website Acquisition

Analyzed the 350+ digital acquisition campaigns in Excel and devised an optimization for the campaigns. Arranged the separate datasets in categories for pivot tables and visualized the aggregate.Detected and advised the clients on launch campaigns between late July to early August is best.

Bike-Share Membership Success

Created a marketing strategy to maximize annual bike-share memberships by data visualizations. Obtained 1000+ bike-share customers using a public dataset of Divvy from 2021 into R for data cleaning. Showed charts with ggplot and identified bike-share membership increase during the summer.