Warangkhana D.
Home
About
More
01
Query a dealership's vehicle and sales tables in SQL to rank the best-selling vehicle types, crown the top salesperson by revenue, and tag every model as "Flagship" or "Normal" — turning raw transaction rows into a performance leaderboard.
02
Analyze employee, team, and salary data to extract insights, summarize roles, and evaluate salary trends.
03
Design a 5-table factory database from scratch — customers, quotations, staff, invoices, sales channels — then write SQL queries built to exercise a WITH clause, a subquery, and aggregate functions, breaking revenue down by product type and payment method.
04
Build a conversational chatbot in R that walks a customer through ordering a drink and dessert at a café, remembers their choices as the conversation goes, and reads the full order back to confirm before saying goodbye.
05
Build a playable Rock-Paper-Scissors game in R that pits the user against a randomized computer opponent, keeps score round by round, and reports a final win/loss/tie tally and win-rate percentage when the player quits.
06
Clean and explore a 10,000-row retail sales dataset in Python/pandas to answer ten real analyst questions — regional sales splits, top-selling products, year-over-year comparisons — then tag every transaction as "bad," "good," or "very good" by sales value.
