MIS771 Descriptive Analytics: Las Vegas Dataset Analysis and Dashboard

This project presents an analysis of the Las Vegas dataset, focusing on hotel data and reviews. The assignment includes a detailed breakdown of the data elements, their classification, and ethical considerations. The solution utilizes Tableau to create a live dashboard and incorporates storytelling through visualizations to identify trends and relationships within the data. The analysis explores various aspects of the hotels, including review counts, hotel stars, facilities, and member demographics across different continents. The project aims to provide insights into the business strategies of the hotels by analyzing the relationships between hotel ratings, facilities, and customer reviews. The document includes a bibliography and references to support the analysis.

Running head: LAS VEGAS DATASET
Las Vegas dataset
Name of the Student
Name of the University
Author Note

1LAS VEGAS DATASET
Table of Contents
A. Process Component...............................................................................................................2
1: Description of the audience for the data set visualization................................................2
Page name: AUDIENCE....................................................................................................2
2: Identification of the data elements.....................................................................................2
Page Name: DATA ELEMENTS PAGE...........................................................................2
Classification of the data....................................................................................................4
3: High level description of the charts which can be used to display the data.......................4
The RIGHT FIT page.........................................................................................................4
4: Data ethics considerations..................................................................................................5
Ethics Page.........................................................................................................................5
B. Solution component...............................................................................................................6
1: Live dashboard...................................................................................................................6
2 Story Telling........................................................................................................................6
Bibliography...............................................................................................................................7
Reference....................................................................................................................................9

2LAS VEGAS DATASET
A. Process Component
1: Description of the audience for the data set visualization
Page name: AUDIENCE
The primary determination of the data visualization is to understand the relationship
between each the Las Vegas dataset. The outliners, pattern and trends of a business can be
identified in the first place using the data visualization process. The issues as well as the
response time of the business can be revised in a business after the introduction of the data set
visualization.
The prime determination of this report is to focus on the Las Vegas data which
provides a detailed description of a list of hotels which provides free internet facilities and
other facilities like the description of the availability of the rooms, location wise rooms. The
detailed description of the multi variate dataset shall be illustrated in the following sections of
this paper which will be done using the Tableau desktop software. The three aspects of the
data set are Review, User and Hotel campaign of Beautiful Data Inc.
2: Identification of the data elements
Page Name: DATA ELEMENTS PAGE
 Nr. Reviews: The Nr. review has different numerical value which describes the
reviews of each of the hotels.
 Nr. Hotel reviews: The review of each of the hotels is stated using numerical value.
 Helpful votes: The helpful votes can also be determined using the numerical value.
 Score Period of stay: Specific months has highlighted the period of stay. With the
help of this data the specific period of stay of each of the hotels can be understood.

3LAS VEGAS DATASET
 Traveller type: The different category of traveller associated with each of the hotels
can be understood using this data set.
 Pool: The availability of the pool is be understood from this data set which is
represented using numerical value.
 Gym: The availability of the gym in each of the hotels can be understood in the first
place using the numerical value.
 Tennis: The availability of tennis courts can be understood from this dataset.
 Spa: The availability of SPA in each of the hotels can be understood from this
dataset.
 Casino: The availability of the casino can also be identified in the first place using
this data set.
 Free internet: Free internet service can be obtained in the first place using this
dataset.
 Hotel name: The name of each of the hotels can be obtained from this table.
 Hotel stars: The reputation of each of the hotels can be understood in the first place
using this data set.
 Number of rooms: The number of room in each of these hotels can be identified
from this dataset itself.
 User continent: The location of each of the hotels continent wise can be identified in
the first place using the user continent.
 Review month: The review month of each of the hotels can be understood from this
data set as well.
 Review weekdays: The day of review can also be identified in the first place using
this dataset.

4LAS VEGAS DATASET
Classification of the data
Data Classification of the data
Nr. Reviews Numerical value
Nr. Hotel reviews Numerical value
Helpful votes Numerical value
Score Period of stay Categorical
Pool Categorical
Gym Categorical
Tennis Categorical
Spa Categorical
Casino Categorical
Free internet Categorical
Hotel name Categorical
Hotel stars Numerical
Number of rooms Numerical
User continent Categorical
Member years Numerical
Review month Categorical
Review weekdays Categorical
Table 1: Categorization of the tables
(Source: Created by the author)
3: High level description of the charts which can be used to display the data
The RIGHT FIT page
The correlation between each of the datasets and the information can be understood
by the description of high level charts. The objectives of each persona can also be understood
in the first place using the charts and the visualization tools. The data scientists as well as the
engineers can be significantly benefited using the charts and visualizations. The product and
service offered by each of these hotels can be understood in the first place using charts and
visualization.
There are different categories of charts and dual axis, line graph, bar graph, bullet
chart, scatter plot diagram and high level flow chart. Comparative analysis of each of the
specifications which are provided in the website can be studied in the first place using the
high level description of the charts. The necessary details which are associated with each of

5LAS VEGAS DATASET
the services provided by the students can be examined and analysed using the high level
description of the charts. Different categories of symbol maps can be very much useful to
depict the different designs within a topographic map.
4: Data ethics considerations
Ethics Page
There are different categories of ethical concerns associated with each of the data sets
which are described in the datasets. The prime ethical considerations associated with these
data sets are maintaining the privacy of the data sets, and maintaining the confidentiality of
the data.
Privacy Invasion
Data privacy is one of the most significant aspect of the data sets, any sort of privacy
concern can have a huge impact on the growth and privacy of Beautiful Data Inc. The needs
and expectation of each of the consumers of this organization can also be compromised if the
privacy of the datasets are not maintained. Thus, it can be said that the organizational target
can get affected if privacy of the data sets is compromised. These datasets have to be
protected by securing the organizational network from the cyber security attacks like botnets
attacks and spam mails.
Breaches in confidentiality
The growth and development of the organization depends upon the confidentiality of
the data. New attacking approaches are increasingly introduced by the social engineers these
days and at the same time, it can be said that the practise of ethical hacking can also be
responsible for any kinds of breaches in the confidentiality of the data. Thus, based on the
above discussion, it can be understood that each of these ethical considerations should be

6LAS VEGAS DATASET
considered in the first place so that these gathered data can be successfully used to create new
business strategies.

7LAS VEGAS DATASET
B. Solution component
1: Live dashboard
Figure 1: Live dashboard
(Analysis of the live dashboard)
The above dashboard can be very much useful to understand the specification of the
data sets of this business.

8LAS VEGAS DATASET
2 Story Telling
Figure 2: Facilities provided in each of the hotels continent wise
(Source: Created by the author)
The above diagram can be very much useful to identify the free internet facilities
which are provided by each of the hotels. The count of SPA, count of Cassino, count of free
internet in each of the countries is illustrated in the above pictorial diagram. Thus, based on
the above figure it can be stated that the amount of SPA is much more in the North America
as compared with other continents like Asia, Africa and Europe and South America. The
count of casino is also on the higher side in North America. The count of free internet is also
on the higher side in North America.

9LAS VEGAS DATASET
Figure 3: Spa count in each of the hotels country wise
(Source: Created by the author)
The above pictorial diagram is very much useful to understand the SPA count in each
of the hotels. Thus, it can be understood that countries India, China, Saudi Arabia, Brazil,
Mexico, France, Spain, and Portugal have the least amount of SPA as compared with the
other countries like USA, Canada and United Kingdom. Countries like Australia and have a
moderate rate of SPA count. Thus, this value creating activity is more popular in North
America as compared with the other continents.

10LAS VEGAS DATASET
Figure 4: Name of the hotel, average score and number of reviews
(Source: Created by the author)
The above pictorial diagram can be very much useful to understand the reputation of
each of the hotels. The business reputation of Marriot Grand Chateau is much better than the
other hotels like Bellagio Las Vegas, Caesars palace, Encore at Wyn Las Vegas, Pallazo hotel
report, Wyndham grand resort, Cromwell and Cosmopolitan Las Vegas. The number of
reviews of Marriot Grand Chateau is much better than rest of the hotels. Thus, the efficiency
of the business strategies adopted by each of the hotels can be understood in the first place
using this pictorial diagram.

11LAS VEGAS DATASET
Figure 5: Average members per year continent wise
(Source: Created by the author)
The above pictorial diagram can be very much useful to understand the average
members per year continent wise. Thus, it can be understood that the average members of
Puerto Rico and Mexico is much better than other countries like Australia, Kenya and USA.
France, China and Greece have minimal number of members.