lanang.work (lanang.work)

2023: KING COUNTY, WASHINGTON HOUSE SALES DASHBOARD
Personal Project

- Created an interactive dashboard with Tableau Public with dataset that contains the listing of all
house sales in King County, Washington from May 2014-2015.
- Created 6 visuals containing: Daily Average House Sales Price Line Chart, Map of Zip code Areas
in Washington with the Average House Sales Price, Distribution of House Prices, Distribution of
Bedrooms, Distribution of Bathrooms, and View vs Condition of Houses Heatmap.
- Filtered by: Selecting Month from Dropdown that adjusts the Daily Average House Sales Price and
Map Visualization, Select Day from Calendar that changes the Distribution charts, Select the Year
Build of House that changes the Distribution charts, Select Sqft Living of House that changes the
Distribution charts, and Select Sqft Lot of House that changes the Distribution charts.

2023: AIRBNB LISTINGS 2016 DASHBOARD
Personal Project

- Created an interactive dashboard with Tableau Public with dataset that contains the AirBnB listing
of all house sales in Seattle 2016.
- The case of this project is “Your working for a client that wants to start an AirBnB business. So, you
want to find out where to buy a house to put in AirBnB and to rent it out, where’s the best location
for it, and what other factors should be considered.
- Insights: Zip code (areas) in Seattle where the AirBnB can charge the most based on its average
price. We can see from the Revenue by 2016 graph, that revenues are low because there’s not a lot of
people travelling in the beginning of January 2016. But in Summer and holidays in the end of the
year, a lot of people are travelling and that’s when revenues are high. From the Average Price by
Bedrooms, we can say that AirBnB’s with 1 bedroom are not generating enough profit but maybe
low cost in front. In the other hand, AirBnB’s with more bedrooms will generate a higher return.
From the Distinct Count of Bedroom Listings, we can acknowledge that there’s a high competition
for listings with 1 bedroom, and the more bedrooms the lower the competition.