SQL at Work #5: Find the number of inspections for each risk category by inspection type
Based on the inspection type distribution, routine unscheduled visits catch most risks while follow-ups mostly close them.
SQL at Work #4: Reviews of Categories
A SQL analysis of Yelp business data using PostgreSQL, exploring review distribution across business categories with string-splitting techniques.
SQL at Work #3: Ranking Most Active Guests
Using DENSE_RANK() and GROUP BY to rank Airbnb guests by total messages sent, and why window functions let us skip the CTE entirely.
SQL at Work #2: Finding Users Who Bought Again Within a Week
StrataScratch practice solution. Using LAG(), PARTITION BY, and a CTE to find users with consecutive purchases within 7 days transactions.
SQL at Work #1: Flagging Overspending Projects
Learn how to identify projects where prorated employee costs exceed budget using joins, aggregations, and the HAVING clause.
A Curated Appreciation of Data Visualization
An appreciation of great data visualization with a curated list of favorite sites.
Zoom Through the New Normal Taxi Trips
Data Cleaning and Exploratory Data Analysis (EDA) on the Chicago Taxi Trips Dataset from March 2022 to February 2023.
Record the Evidences: Build Goodreads Best Crime and Mystery Books Dataset
Web scraping to get the best crime and mystery books data by scrapping from Goodreads using the beautiful soup library.
![[Fun Project] Label Random Colors Based on Hue](https://ilmaandayana.com/wp-content/uploads/2023/02/hue-thumb.jpg)
[Fun Project] Label Random Colors Based on Hue
We drew a square and fill it with random colors. With help from the hue, we printed the color of that square.
About {this-website}
This website is my playground. Besides showcasing my works: websites, case studies, and visualizations, I use this website to sharpen my web development skill.