Business Data Analysis
Page 1 of 7
Scenario
Your employer, Beautiful Data Inc., create insightful and dynamic dashboards for their clients.
Todd has requested you to come up with an interactive dashboard for one of the clients. In his memo
sent to the analytics team via SLACK (see next page), Todd has provided some guidelines to tackle the
task. In particular, you are expected to explore the LasVegas dataset and develop an interactive
dashboard using Tableau Desktop software. Then, you should convey your design process as web report
comprising a process component and a solution component via the WordPress platform (a template is
provided).
Dataset Details
The ‘LasVegas’ dataset is a multivariate dataset that provides 504 TripAdvisor reviews of 21 hotels located
in the Strip, Las Vegas.
The data collected is grouped into “Review”, “User” and “Hotel” features. A
ief data description is
available from the Variable_Descriptions worksheet in the Excel file.
For a more detailed look http:
dx.doi.org/ XXXXXXXXXX/tsf9sjdwh2.1 and the associated journal paper
http:
www.sciencedirect.com/science/article/pii/S XXXXXXXXXX
Hints:
• You may add additional Statistical analysis and/or supporting data of your own
(additional Latitude/Longitude data, web links etc.) At minimum, the focus of the
assignment should be on the core data provided in the dataset.
• Fix issues with data quality (if any).
http:
dx.doi.org/ XXXXXXXXXX/tsf9sjdwh2.1
http:
dx.doi.org/ XXXXXXXXXX/tsf9sjdwh2.1
http:
www.sciencedirect.com/science/article/pii/S XXXXXXXXXX
http:
www.sciencedirect.com/science/article/pii/S XXXXXXXXXX
Page 2 of 7
Todd’s memo sent to the Analytics team via SLACK 1
12:50 pm
Today
Todd Nash 3:17 PM
#VisCallenge #LasVegas #Project
Hey, team DataViz.
Let us all start working on #LasVegas data and see who can develop the best interactive
visualisations. Remember, our work will be showcased in the upcoming online marketing
campaign. More on this in my next post.
Todd Nash pm 3:20
#VisCallenge #LasVegas #Project
The #Data_Visualisation challenge consists of the following steps:
a) Review the #LasVegas dataset first.
) Define a #Business/User_Persona that will be the #Audience of your data visualisation
and develop a #story to help focus and guide your design process.
c) Identify key #Data_Elements in the selected dataset that could be used to explore
further using data visualisation methods.
d) Discuss why you may use certain #Visualisations
e) Keep in mind #Ethical considerations of using #3 rd party_data
f) Develop an #Interactive_Dashboard (using the #TableauDesktop )
g) Describe key components of your final #Dashboard .
h) Deliver your project as a #Web_Report via #WordPress
Todd Nash 3:43 pm
#VisCallenge #LasVegas #Project
Team, remember all the points mentioned in my previous comments should be done via
#WordPress !
Good luck all!
Ah, and remember… I expect your projects submitted to me by Thursday 9 th June 2022,
8:00 pm.
Page 3 of 7
1 Slack
ings team communication and collaboration into one place so you can get more work done, whether you belong to a large enterprise or a small business.
Check off your to-do list and move your projects forward by
inging the right people, conversations, tools, and information you need together. Slack is available on
any device, so you can find and access your team and your work, whether you are at your desk or on the go.
Assignment Deliverables via WordPress
The assignment consists of two main sections (web pages): Process and Solution (accessible via Menu in
the WordPress template). You are required to complete both parts. This assignment is equivalent to 2,500
words.
A) Process Component
You are required to complete this section by completing four pre-set web pages under the process menu.
Content presented here should be written in a ‘professional’ language and must cover the following four
aspects:
1) Describe the audience for your Data Visualisation
(to be written under AUDIENCE page)
Describe the audience of the Data Visualisation you intend to create. This section should
include a general description of the persona, questions they want to be answered,
actions/outcomes your dashboard will be supporting, and the feeling you would like to
convey.
2) Identify Data Elements
(to be written under DATA ELEMENTS page)
Using what you have learnt in the lectures and tutorials, first, please describe each column
in the dataset (note: you should describe all columns regardless of whether you will
ultimately use them in your visualisation or not). Then classify the data (example,
Categorical, Numerical: Discrete, Continuous / Scales of measurements: Nominal, Ordinal,
Interval and Ratio / Time/Date, Location).
3) Describe at a high level what types of charts you might use to display the data.
(to be written under THE RIGHT FIT page)
Based on the data types you described earlier in this section, along with the objectives of the
persona you described, describe what charts and visualisations you think might work well to
communicate the information.
4) Finally, describe any data ethics considerations there with the data you intend to use.
(to be written under ETHICS page)
Describe any considerations you think you should keep in mind while developing and sharing
your visualisation.
Note: While adding content, images, and tables are allowed under these sections (web pages);
students are strictly prohibited from moving web page locations, renaming web pages or
adding new pages under the PROCESS component.
https:
slack.com/?cvosrc=ppc.google.slack&cvo_campaign=&cvo_crid= XXXXXXXXXX&Matchtype=b&utm_source=google&utm_medium=ppc&c3api=5523, XXXXXXXXXX,slack&gclid=CjwKEAjwutXIBRDV7-SDvdiNsUoSJACIlTqlzQSKLaVeXEwZoour-SKRO45OiKchz8HCRQFgIugiihoCwnbw_wcB&gclsrc=aw.ds&dclid=CIfElPmE6tMCFdEZKgodregODg
https:
slack.com/?cvosrc=ppc.google.slack&cvo_campaign=&cvo_crid= XXXXXXXXXX&Matchtype=b&utm_source=google&utm_medium=ppc&c3api=5523, XXXXXXXXXX,slack&gclid=CjwKEAjwutXIBRDV7-SDvdiNsUoSJACIlTqlzQSKLaVeXEwZoour-SKRO45OiKchz8HCRQFgIugiihoCwnbw_wcB&gclsrc=aw.ds&dclid=CIfElPmE6tMCFdEZKgodregODg
https:
slack.com/?cvosrc=ppc.google.slack&cvo_campaign=&cvo_crid= XXXXXXXXXX&Matchtype=b&utm_source=google&utm_medium=ppc&c3api=5523, XXXXXXXXXX,slack&gclid=CjwKEAjwutXIBRDV7-SDvdiNsUoSJACIlTqlzQSKLaVeXEwZoour-SKRO45OiKchz8HCRQFgIugiihoCwnbw_wcB&gclsrc=aw.ds&dclid=CIfElPmE6tMCFdEZKgodregODg
https:
slack.com/?cvosrc=ppc.google.slack&cvo_campaign=&cvo_crid= XXXXXXXXXX&Matchtype=b&utm_source=google&utm_medium=ppc&c3api=5523, XXXXXXXXXX,slack&gclid=CjwKEAjwutXIBRDV7-SDvdiNsUoSJACIlTqlzQSKLaVeXEwZoour-SKRO45OiKchz8HCRQFgIugiihoCwnbw_wcB&gclsrc=aw.ds&dclid=CIfElPmE6tMCFdEZKgodregODg
Page 4 of 7
B) Solution Component
Under the SOLUTION component (WordPress web page), you are expected to have two deliverables,
namely, Live Dashboard and Story Telling.
First, using the skills you have developed in the tutorial sessions (and leveraging any additional training
and online support provided by Tableau Inc.), you should create an interactive dashboard using Tableau
Desktop. Then, you should embed your interactive dashboard on the Live Dashboard web page.
Note: Instructions on retrieving embed code and importing the interactive dashboard to WordPress
websites are available in the WordPress Instruction Manual.
Under the Story Telling web page, you are expected to capture and describe various screenshots of your
interactive dashboard developed using Tableau Desktop.
Hint:
You can capture screenshots using the Print Screen Key on the keyboard or by using
the snipping tool (Windows machines), or you can easily export “Screen images” by
using the “Export Image” option from Dashboard menu.
Alternatively, you can annotate the dashboard using “Story” tab in Tableau Desktop.
Your descriptions, comments, or annotations of the interactive dashboard should detail how you have
considered the data visualisation framework while developing the interactive dashboard.
The questions below will give you some ideas of the type of comments you should include in this section:
I. What types of charts have you selected and why? II.
How have you used colour (or not)?
III. How have you used hierarchy in your approach?
IV. What interactive components did you introduce?
V. How have you supported the motivations of the persona you defined?
VI. Comment on data sources and any data manipulation you may have performed.
Note: While adding content, images and tables are allowed under these sections (web pages);
students are strictly prohibited from moving web page locations, renaming web pages or
adding new pages under this PROCESS component.
C) Other components of the WordPress website
There are three web pages on the WordPress website template where you need to provide additional
information. These include Welcome to Beautiful Data Inc. (Home page), About Us, and Contact pages.
In the Welcome page, you may provide some information about Beautiful Data Inc. operations and the
visualisation project, i.e. Las Vegas (be creative).
In the About Us page, you should
iefly introduce yourself.
Page 5 of 7
Finally, students can provide their contact information (you should use fictitious contact information),
including phone number, email address, and social media pages such as LinkedIn etc.
Note: While adding content, images and tables are allowed under these sections (web pages); students
are strictly prohibited from moving web page locations and renaming web pages.
Students are allowed to add site pages at the top level Menu ONLY.
Criteria Criteria Weight Not Attempted
Needs
Improvement Satisfactory Good Very Good Exemplary
PROCESS
Component
(40%)
GLO1
GLO2
• Audience
• Data Elements
• The Right Fit
• Ethical
Considerations
35%
None of the specified Topic
areas answered clearly or
completely.
Only a generic description of
the audience and/or
questions are given. Some
variables are inco
ectly
classified. Ethical
considerations NOT
addressed.
There is NO explanation
(support) for the use of
different charts, graphs etc.
(0 – 10.4)
Only a few of the specified
Topic areas answered clearly
or completely.
Audience (the persona of
interest) poorly described or
questions developed are too
asic to justify a need for an
interactive visualisation.
(10.5 – 17.4)
All Topic areas were
addressed, but most topics
lack clarity and/or incomplete.
A clear alignment between
visual elements (charts, graphs
etc.) and objectives of the
persona described is lacking.
Ethical considerations could be
discussed in further details.
(17.5 – 20.9)
All Topic areas were
addressed, but some topics
lack clarity and/or incomplete.
The persona of interest needs