Hotel Bookings Data Analysis

Project Description

This project focuses on the analysis of the HotelBookingDemandDatasets.pdf article and the hotel_bookings.csv dataset, providing insights through a rigorous analysis and visualization process.

Contents

1. Exploratory Data Analysis (EDA)
2. Conceptual Diagram Design
3. Table Creation
4. Star Schema Implementation
5. Dashboard Design and Development
6. PDF Analysis

PDF Analysis

The detailed analysis of the HotelBookingDemandDatasets.pdf article can be found here.

Exploratory Data Analysis (EDA)

The EDA was performed in Python, analyzing the variables into hotel_bookings.csv dataset. This initial analysis helps identify patterns and prepare the data for further modeling.

Conceptual Diagram Design

Once on the EDA was completed, a conceptual diagram was designed to facilitate understanding and organizing the relationships between different variables into dataset.

Table Creation

Several tables were created to efficiently structure the data:

• Dimension Tables: Using Python to extract and define dimensions.
• Fact Table: Created with Talend to join dimensions and load fact table.

Star Schema Implementation

The star schema was implemented on two data tools:

• Microsoft SQL Server Database: For data storage and management.
• Power BI: For reporting and dashboard creation. Additionally, Power Query was used to optimize the data transformation process.

Dashboard Design and Development

The interactive dashboard was designed and developed in Power BI, using advanced techniques such as:

• Bookmarks
• Field Parameters
• Calculation Groups
• DAX for creating advanced measures

This approach provides a dynamic and detailed visualization of the data, allowing users analyze the information interactively.

---

I hope this project provides valuable insights and a greater understanding of patterns in hotel bookings!