The topic for the Lab for this week is Lab Assignment 1. This assignment involves using Tableau. Tableau is not available on uni
The topic for the Lab for this week is Lab Assignment 1.
This assignment involves using Tableau.
Tableau is not available on university computer labs, so if you want to work on the assignment during your scheduled lab, then you will need to bring your own laptop.
Also, you will need to fill out the form at https://www.tableau.com/products/trial to get your 30-day trial copy of Tableau. You will need to answer some basic questions, but other than that you can get the temporary software at no cost.
Downloading Tableau
For Lab Assignment 1
IDS 270
You Will Need to Install Tableau on Your PC
Follow the link to get the 14-day trial of Tableau
https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.tableau.com%2Fproducts%2Fdesktop%2Fdownload%3Futm_campaign%3DTFT%2520License%2520and%2520Online%2520-%2520Confirmation%2520-%2520Student%2520Lab%2520-%2520Text%26utm_medium%3DEmail%26utm_source%3DEloqua%26domain%3Duic.edu%26eid%3DCTBLS000005942998%26elqTrackId%3Db6f625c3dcd348ddbb836a2dc3280528%26elq%3D75dbc57edf324dd080483e3cd6ce3eaa%26elqaid%3D24643%26elqat%3D1%26elqCampaignId%3D&data=04%7C01%7Cjspark4%40uic.edu%7C90e75822d7c64fdf62d008d97ed5d4a3%7Ce202cd477a564baa99e3e3b71a7c77dd%7C0%7C0%7C637680279127503289%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Vsp500VMaNGTtXdxRz%2BWWisgriafsc2BJglXq2PF3dI%3D&reserved=0
Tableau Will Download Automatically
Downloaded without
having to ask
Version for Mac also available
Open The Exe File, Check the Boxes, Click on Install
Might Require Re-Boot; Save Your Files First!
Fill In Fields and Click Register
Registration may take a few minutes
That’s It!
Tableau should be work-able
Your screen won’t look exactly like
mine because I have some Tableau
files on my hard drive
Use Open Text File, Open Crime Data (After Download that Crime Data)
Now can definitely go to
next presentation and video
,
Lab Assignment 1
IDS 270
Download data file
The data is located on Blackboard under Week 8 / Lab Assignment 1
Go to Blackboard, right-click on the data file and scroll down to “save target as” or “save link as”.
Save file to Downloads, or wherever you can work with it
2
My Tasks Vs. Your Tasks
The data for this assignment are for reported crimes in Chicago
In hopes that you will find it more interesting vs. generic data sets out there
The instructional material uses data through 2016
The file for you to use on Blackboard uses data through 2017
You are to complete all the tasks with the data on Blackboard that goes through 2017
So you cannot simply copy the images in these instructions and turn them in
Where the instructions call for you to isolate data for 2016 and work only with it, you may use either 2016 or 2017
3
Open Tableau; Click on Text File; Find File & Open
4
After loading the data, click on ‘Sheet 1’ on the bottom left corner
5
Crimes Per Year in Chicago (1)
Go to the Tables tab on the left and Click on ‘Primary type’ and drag it to rows.
This may cause delay the first time you do it.
Should then
Look like this
6
Go to the Tables tab and click on ‘Chicago_Crimes_2011_to_2016.csv(Count)’ and drag it to ‘Text’ that’s located on the Marks box.
Results
7
From Tables tab click and drag ‘Date’ to the columns.
8
Drag ‘Chicago_Crimes_2011_to_2016.csv(Count)’ to color on Marks box.
Results
9
Then, click on the drop down menu next to ‘Automatic’ and instead select ‘Square’
Results
10
Crimes per Month
To start a new visualization add a new worksheet by clicking on the Add Worksheet icon
This will create sheet 2
Click and drag ‘Chicago_Crimes_2011_to_2016.csv(Count)’ to Rows.
11
11
Click and drag ‘Date’ to columns.
Crimes per Month
12
Right click on the drop down menu from ‘Date’ and select Month with the format: May 2015. See next for results
Crimes per Month
13
Crimes per Month
Results
14
To add the line with the average: Go to the ‘Analytics’ tab, Select ‘Average Line’ and drag it into the worksheet and you’ll see the ‘Add a Reference Line’ box appear.
Lastly, drop it into the ‘Table’ square.
Crimes per Month
15
Crimes per Month
Results
16
Location of crimes
Add a new worksheet
Click and drag ‘Chicago_Crimes_2011_to_2016.csv(Count)’ into Rows and ‘Location Description’ into Columns.
17
Location of crimes
Go to the top right corner and click on the ‘Show Me’ tab.
Select ‘Treemaps’
Results
18
Changing Color Scheme– Trickiest Part
If your screen looks like this, then click on Show Me tab
To expose color tab behind.
If already seeing color tab, then OK
19
Location of crimes
To change the treemap colors, right click on the drop down menu of the ‘CNT(Chicago_Crimes_2011_to_2016.csv(Count))’ located to the right.
Select Edit Colors and choose the wanted palette [Red-Gold].
(Chicago_Crime
(Chicago_Crim
20
Location of crimes
Click and drag ‘CNT(Chicago_Crimes_2011_to_2016.csv(Count))’ to Label on the Marks tab.
Results
21
Crimes per District
Add a new worksheet
Drag ‘Chicago_Crimes_2011_to_2016.csv(Count)’ to rows
22
Crimes per District
Locate District variable and right click on its drop-down menu.
Select ‘Convert to dimension’.
(You will see District variable’s symbol to the left of its name changes from green to blue and move up to the first half of the variables list)
Results
23
Crimes per District
Now, you will add ‘District’ to columns (at top of Tableau, as you have done previously)
Click and drag ‘Description’ into Marks—Color
(Select ‘Add all members’ if asked)
Results
24
Map of Crimes per District in 2016
Create New Sheet
Click on the drop down menu from the ‘Latitude’ variable
Go to ‘Change Data Type’
Select ‘Number (decimal)
Again select the drop down menu from ‘Latitude’->’Geographic Role’-> ‘Latitude’
Do the same steps for Longitude but select ‘Longitude’ on last step.
25
Map of Crimes per District in 2016
Drag ‘Longitude’ to columns
Drag ‘Latitude’ to rows
26
Map of Crimes per District in 2016
‘Chicago_Crimes_2011_to_2016.csv(Count)’into ‘Size’ located in the Marks box
27
Map of Crimes per District in 2016
Click and drag ‘District’ into ‘Color’
28
Map of Crimes per District in 2016
Click and drag ‘District’ into ‘Label’ to display the dist. Number in map
29
Map of Crimes per District in 2016
To filter data of year 2016 only: drag ‘Date’ into Filters
->Years->Next->Select ‘2016’ only-> Ok
30
To change how the map looks like, go to ‘Map’-> ‘Background Maps’ ->’Streets’ (the one depicted)
Results
31
District 11 Type of Crimes
Add a new worksheet
‘Chicago_Crimes_2011_to_2016.csv(Count)’ into rows
Drag ‘District’ into Filters -> None-> Select ‘11’ only-> Ok
32
District 11 Type of Crimes
Primary Type into ‘Label’
33
District 11 Type of Crimes
Go to the top right and click ‘Show me’ and select packed bubbles
Results
34
District 11 Type of Crimes
Drag Primary Type into ‘Color’
click Add all members if asked
35
‘Chicago_Crimes_2011_to_2016.csv(Count)’ into ‘Label’
Right click on the ‘[T]CNT(Chicago…)’ to get the drop down menu-> Quick Table Calculation-> ‘Percent of Total’
District 11 Type of Crimes
36
District 11 Type of Crimes(3)
Results
37
District 8 & 11 Weekly Crimes
We are comparing district 8 and 11 since they are the two districts with the most cases of crime
Drag ‘Chicago_Crimes_2011_to_2016.csv(Count)’ into rows
Drag ‘Date’ into columns
38
District 8 & 11 Weekly Crimes
Right click ‘Date’ from columns to get the drop-down menu, select ‘Week number’
39
District 8 & 11 Weekly Crimes
Drag ‘District’ into Filters and select 8 and 11 only
40
District 8 & 11 Weekly Crimes
Drag ‘District’ into Color
41
Percentage of arrests in Chicago
Drag ‘Arrest’ into rows
42
New sheet
Percentage of arrests in Chicago
‘Chicago_Crimes_2011_to_2016.csv(Count)’ into columns
43
Percentage of arrests in Chicago
Go to ‘Show me’-> Pie charts
44
Percentage of arrests in Chicago
To change the size of chart-> Click on the Drop-down menu of ‘Standard’-> Click ‘Entire View’
45
Drag ‘Arrest’ into Label
46
‘Chicago_Crimes_2011_to_2016.csv(Count)’ into Label
47
Right click on drop down menu ‘[T]CNT(Chicago…)’ -> Quick Table Calculation-> ‘Percent of Total’
48
Save as twbx file
49
What to Turn In
Save and then submit your tableau document to the blackboard turn-in slot
Sheets in order as shown here
Crimes by Year and type table
Count of crimes with trendline
Tree map of crime location
Colored graph of crimes by type by district
Colored street map of crimes by district
Bubble chart of crimes by type
Crimes by Week for District 8 & 11
Pie chart of percentage of arrests
50
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
