Transform dirty data into meaningful information Below is a website (landing page link) for students. Each student should go to the landing page to download Tableau Desktop and Prep, then enter the product key noted below to activate each application. This key will allow you to activate Tableau Desktop and Prep for the duration of the course. 

ITS836Residency Day 2 Assessment Paper

Page 1 of 3

2nd Assessment – Due Saturday, Possible Score = 34 points

Course ITS836 – Data Science & Big Data Analytics
(Part 1) –
Download
Tableau

A hands-on assessment project to explore the world of data analytics in

operational excellence. Transform dirty data into meaningful information.

Overview:

Tableau desktop (Business analytics anyone can use) – Tableau Desktop is

based on breakthrough technology from Stanford University that lets you drag

& drop to analyze data. You can connect to data in a few clicks, then visualize

and create interactive dashboards with a few more. Tableau is a system that

supports people’s natural ability to think visually. Shift fluidly between views,

following your natural train of thought. You’re not stuck in wizards or bogged

down writing scripts. You just create beautiful, rich data visualizations.

Assignment Type: Individual Project

Transform dirty data into meaningful information

Below is a website (landing page link) for students. Each student should go to

the landing page to download Tableau Desktop and Prep, then enter the product

key noted below to activate each application. This key will allow you to

activate Tableau Desktop and Prep for the duration of the course.

Please use these instructions:

1. Download Tableau Desktop and Tableau Prep here
2. Select each product download link to get started. When prompted, enter

your school email address for Business E-mail and enter the name of

your school for Organization.

3. Activate with your product key: Request for student license or
use the 14 days free trial

Note1: Are you new to Tableau? Use the user guide to get up to speed and get

started:

Data Analytics for University Students guide
Note2: Students can continue using Tableau after the class is over by

individually requesting their own one-year license through the Tableau for
Students program.
Note3: Need additional help? Check out the FAQs.

Part (2) –
Using
Tableau to
Analyze Data
(4-6 pages)

Assignment Type: Individual Project

A hands-on assessment project to explore the world of data analytics,

using Tablaeu Sample Dataset: Sample Superstore Dataset to transform
the raw data into meaningful information. The dataset contains product

information, customer orders, and regions. The dataset will benefit local

suppliers and the offshore industries.

https://www.tableau.com/tft/activation

https://www.tableau.com/university-students

http://tableau.com/students

http://tableau.com/students

https://community.tableau.com/docs/DOC-10250

ITS836 Residency Day 2 Assessment Paper

Page 2 of 3

Individual Project Instructions:

1. Open a sample Dataset from Tableau: Example, from:

C:\Users\\Documents\My Tableau

Repository\Datasources\2019.2\en_US-US

– Select the Sample Superstore Excel file

2. On the left Navigation pane “Connect” to open a File, click on

Microsoft Excel – Browse to select the sample dataset from step
#2 above: Sample Superstore Dataset: Click Open à Result Displays
the Sheet1

3. From Connections: Sample Superstore: Drag Sheets to the working pane

• Orders

• People

• Returns

• In the top center Working page, Connection, select Extract -> Add

(displays the Sheet 1 – ready for your to do drag and drop to analyze the data)

4. Click on the Sheet1 to open the Data and Analytics page.

Rename the Sheet1 to Assessment2

5. On the Pages/Filter/Marks section: Fill in the Columns and

Rows

6. Drag to the Rows -> Dimensions
◼ Example: Category, City, Country, Customer ID, Product Name,

Segment

7. Drag to the Columns -> Measures
◼ Example: Discount, Profit, Quantity, Sales
◼ Result shows a horizontal bar:

8. Save the horizontal bar screenshot as Assess2-1-
horizontal_bar

9. Right click on the Assess2-1-horizontal_bar, select
Duplicate to create sheet2

◼ Rename to Assess2-2-Stacked_bars

10. From the right side, Click on Stacked bars to change the
graphical display.

11. Repeat the same to save a total of five additional graphical
display as follows:

◼ Appendix A: Assess2-1 – horizontal bar
◼ Appendix B: Assess2-2 – stacked bars
◼ Appendix C: Assess2-3 – text tables

ITS836 Residency Day 2 Assessment Paper

Page 3 of 3

◼ Appendix D: Assess2-4 – circle views
◼ Appendix E: Assess2-5 – scatter plots

12. From the right side, try to change selections to get a Highlight
Tables in the graphical display.

◼ Double click to Rename the sheet to Highlight_Tables
◼ Capture screenshot and save as Appendix F: Assess2-6 – highlight

tables

13. Using sample sheets above create your own two new
designs of another Dimensions and Measures

◼ Rename the Sheet to your design name.
◼ Capture screenshot and save as Appendix G: Assess2-7-(your name)
◼ Capture screenshot and save as Appendix H: Assess2-8-(your name)

14. Save all the eight sheets, use the Snipping tool to do a screen

capture of the entire eight sheets, copy and paste to a word doc,

and save.

15. Add an overview about one paragraph to explain each of the

sheets. Save and submit for grading in iLearn. Maximum

page about 5-8 pages (title page, auto-generated table of content,

and Appendixes included).

Part (3) –
Identify
about five
other Data
Analysis

Identify about five other Data Analysis and Visualization Tools and

compare with Tableau (1 page)
Save your file with your name before submission: Example:
LastName_FirstInitial_ITS836_wk11_2nd_Assessment