Data Analytics

Fact Room Bookings

SK_Dim_Time

SK_Dim_Geography

SK_Dim_Hotels

SK_Dim_Customer

SK_Dim_Ratings

Number_of_days

Avg_number_of_days

Room_count

Star_rating

Dim Hotels

SK_Dim_Hotels

Hotel_id

Country_code

Hotel_name

Hotel_address

Hotel_city

Hotel_zipcode

Dim Rooms

SK_Dim_Room

Room_type_code

Room_standard_rate

Room_description

Smoking_YN

Room_number

Room_floor

Dim Time

SK_Dim_Time

Year

Month

Day

Checkin_date

Dim Geography

SK_Dim_Geography

Country

State

City

Zipcode

Dim Customer

SK_Dim_Customer

Customer_number

Customer_name

Customer_address

Customer_city

Customer_zipcode

Customer_email

Hotel Performance Data Mart