Projects
Scroll down to see some of the projects that I've completed so far. I've used a variety of tools to complete them including: Google Sheets, Google Slides, MySQL/MySQL Workbench, and Tableau. Links to my SQL code on GitHub and to my visualizations on Tableau Public are included.
Exploratory Data Analysis - Listings123
Tools Used: Google Sheets, Google Slides
​
View the Case Study here
​
View the Presentation here
Business Problem
Listings123 is an up-and-coming home-sharing service (similar to Airbnb). The company provides an online marketplace that connects people looking to rent their homes or rooms (hosts) with people who are looking for temporary accommodations (guests).
​
The CEO wants to expand to new cities but has a problem with raising money for the marketing campaign. The investors and VCs will not fund the campaign until they are presented with data-based evidence on what traits (qualities and actions) make a successful host specifically for Listings123.
​
Analysis
I performed an exploratory data analysis on Listing123 data from 2020. Discovered patterns, spotted anomalies, framed hypotheses, and checked assumptions in Google Sheets. Wrangled data by cleaning data, using pivot tables, VLOOKUP, and much more. Visualized data and calculated statistics to support exploratory data analysis findings.
%20Kayden.jpg)
Results and Impact
I identified 4 traits of successful Listings123 Hosts that include:
-
Listings that are for an Entire Home or Apartment generate the most revenue of all listing types
-
Listings that offer a Real Bed generate the most revenue compared to other bed offerings.
-
Internet and a kitchen were the two most prevalent amenities amongst all listings.
-
Hosts generate more revenue the longer they use the platform.
​
These 4 traits were presented to the investors and venture capitalists to secure funding for a nationwide marketing campaign that will drive expansion into new cities and revenue growth.
Data Analysis with SQL - LetsMeet
Business Problem
LetsMeet is an online network for professionals, hobbyists, and enthusiasts to meet up in real life with groups that share common interests. With locations in New York, Chicago and San Francisco, users are able to find new groups of friends in their city and make lasting connections. Various stakeholders needed answers to the following questions.
​
-
How many Toastmasters events are there using LetsMeet in New York, Chicago, and San Francisco?
-
Is LetsMeet membership leveling off?
-
What five groups should marketing feature in their upcoming campaign?
​
Analysis
I conducted a thorough assessment of the existing database tables, applied changes to the relational database, designed an Entity-Relationship Diagram (ERD) of the updated database, created over 25 DDL and DML MySQL queries to answer questions and derive key insights, and developed summarized ad hoc reports​.
Data Visualization - World Bank Data
Business Problem
Senior executives at a highly respected digital media company were looking for insights into the economic, social, and environmental trends of countries around the world to help make a decision on the best, business-friendly country. This country would be a featured article in their next publication.
​
-
What are the top 5 countries for Ease of Business?
-
Which of the top 5 countries should be the focus of further analysis?
-
What business factors make the selected country a good place for business?
​
Analysis
I analyzed the World Bank's World Indicators data set and created a tableau story that combines tables, graphs, maps and dashboards to highlight the most favorable country for business.
Results and Impact
Singapore, Hong Kong SAR, China, New Zealand, the United States and Denmark are the top five countries for ease of business. Of these five countries, Singapore holds the second highest GDP per capita. A large percentage of its population falls in the 15-64 age category, ensuring a large pool of talent for potential employees as well as a large customer base. Singapore has the least start up time to start a business, offers a very competitive interest rate for business loans, and has a low business tax rate.
Singapore shows opportunity and growth and therefore is ideal for starting a business.
​
Singapore should be focus of a feature article in their next issue.
Data Visualization - NYC Real Estate
Business Problem
NYC Real Estate investors want to gain information on trends in the market through answering the following questions.
​
-
What area is the cheapest to invest in?
-
What is the most profitable month?
-
Which area is most expensive?
-
Which area is the least expensive?
-
Where are sales prices the highest?
-
What areas had the highest amounts of commercial units sold? What area had the highest number of residential units sold?
​
Analysis
I preprocessed data and created visualizations which involved cleaning tables, creating calculated fields, and building maps, line graphs, and treemaps with annotations.
Results and Impact
The insights that I uncovered include:
-
Bronx is the borough that is the cheapest to invest in.
-
May was the most profitable month.
-
Zip code 10039 is the most expensive area.
-
Zip code 10453 is the least expensive area.
-
Midtown CBD is the neighborhood with the highest sales price.
-
Manhattan was the borough with the most commercial units sold, while Bronx had the most residential units sold.
These insights were presented to investors to help them understand market trends and make better investment decisions.
Data Visualization - Series A Funding
Business Problem
The CEO at an eCommerce start-up was looking for insights into the best place to obtain Series A funding.
​
Analysis
I analyzed a Crunchbase data set and used Tableau to created a Tableau story that incorporates maps, line charts and tables that showed the best location for a start-up to obtain Series A funding.
Results & Impact
The San Francisco Bay region is the ideal region to search for Series A funding. It is the area where the most companies have secured their Series A funding. It's also the area where the greatest amount of funding overall has been secured.
Data Visualization - Nvidia Stock
Business Problem
Stock traders need stock market data to help them make trading decisions.
​
Analysis
I preprocessed and filtered stock market data, focusing on Nvidia. Created calculated fields and incorporated relevant designs. Created a dashboard that incorporated a candlestick chart to show daily performance of Nvdia stock, a bar chart to show the change in volume (positive or negative), and a line chart to show cumulative returns.
​
​
​
Results and Impact
Built a visualization of NVIDIA's stock history that shows daily changes in the stock's share value, as well as the variability in daily values, the trading volume for each day, and how much profit one would gain or lose from a given investment over time
​