DataScience
Paper type:- live assignment with tablu
Pages – 5-8 (with screen shots and explanation)
Dead line 6 hours
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\
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