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.
Individual Project Instructions:
Open a sample Dataset from Tableau: Example, from:
C:Users<your_name>DocumentsMy Tableau RepositoryDatasources2019.2en_US-US Ã Select the Sample Superstore Excel file
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
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)
Click on the Sheet1 to open the Data and Analytics page. Rename the Sheet1 to Assessment2
On the Pages/Filter/Marks section: Fill in the Columns and Rows
Drag to the Rows -> Dimensions
Example: Category, City, Country, Customer ID, Product Name, Segment
Drag to the Columns -> Measures
Example: Discount, Profit, Quantity, Sales
Result shows a horizontal bar:
Save the horizontal bar screenshot as Assess2-1-horizontal_bar
Right click on the Assess2-1-horizontal_bar, select Duplicate to create sheet2
Rename to Assess2-2-Stacked_bars
From the right side, Click on Stacked bars to change the graphical display.
Repeat same to save 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
Appendix D: Assess2-4 – circle views
Appendix E: Assess2-5 – scatter plots
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
Using sample sheets above create your new design of another Dimensions and Measures
Rename the Sheet to your design name. Capture screenshot and save as Appendix G: Assess2-7 – your name
Save all the four sheets, use Snipping Tool to do screen capture of the seven sheets, copy and paste to a word doc, and save.
Add an overview about one paragraph to explain each sheet. Save and submit for grading in iLearn. Maximum page about 4-6 pages (title page and Appendixes included).
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
0 comments