From Dirty Data to Business Insights: Building the Tembo Hotel Suites Database

说明与用途

该项目清理并规范化了混乱的酒店预订数据集，创建了结构化的关系数据库，使得能够使用 SQL 进行准确的收入和客房绩效分析。

问题

The original hotel booking dataset was messy with inconsistent formatting, missing values, and varied data types, making reliable analysis impossible.

结果

The project produced a clean, normalized database that enabled accurate SQL queries to answer key business questions such as monthly revenue trends and room performance metrics.

工作流

• Create a staging table to import raw data
• Inspect each column for inconsistencies
• Standardize names, phone numbers, dates, monetary values, and categorical fields
• Clean and transform data using SQL UPDATE/INSERT statements
• Design relational schema with separate tables and foreign keys
• Migrate cleaned data from staging to final tables
• Run verification queries to ensure data integrity
• Perform business analysis queries (revenue, room performance, guest locations)

证据

I divided the project into five main stages: Database and staging setup, Data cleaning, Database design, Loading clean data, Business analysis.

来源

The original dataset contained hotel booking information such as: Guest details, Phone numbers, Room information, Booking dates, Staff information, Salaries, Payment methods, Booking status, Services used, Guest ratings, Revenue information.

来源