Computer Science Homework Help
University of South Florida Tableau Data Analysis
I’m working on a computer science project and need support to help me learn.
instructions
1.Video Review
- Watch the 3 short videos for an overview of what Tableau can do
Tableau – Connecting to a Data Set
3 min. (start at 1:25min. as I am providing the data set – in Step 3)
Tableau – Explaining Dimensions and Measures
– 3 min.
– 6 min.
- Watch the 2 longer videos showing Interactive Dashboards
- **Note** For Business Majors – An Interactive Dashboard Video (3 -5 min.) is needed to receive credit towards your Data Science Certification**
Tableau Mock “Hollywood movies”
– Starting at 8:43min create a new dashboard and then at 12 min shows the Interactive Dashboard
13min – This video shows how to build an excellent Interactive Dashboard
2.. Download the Windows or Mac Application file to install (below)
- Product key = TCK9-A98C-CC40-EAB4-5E11- Click here for Install Instructions
- download Windows Tableau App – Install file
download Mac Tableau App – Install file download
- Review free Tableau videos below -you will have to login (after you install Tableau)
Tableau – Free training videos
3. Download the Excel Data set file (below) – Save to a location on your computer
Tableau Cyber Security Breaches Data Set
- Launch Tableau and Open the Cyber Security data set file (Watch video from Step 1)
4. Analyze the data using Tableau (Use the Lab for assistance)
For Assistance – Join Tableau Help Lab (Microsoft Teams Meeting)
5. Create 4 Tableau visualization sheets (Q1 – Q4 – below)
- Then Upload screenshots or doc with sheets via Canvas – 1 pt. per sheet
- IF YOU ARE A BUSINESS MAJOR – Continue to Step 6
(Links to an external site.)
Q1. Create a bar graph showing the states with number of breaches. sort the bar chart in descending order
Click here for creating Q1 Tableau Visualization sheet
Q2. Create a Map based visualization showing states with total individuals affected
Q3. Create a Pie chart with types of breaches. show the ‘Percentage of total’ for the type of breaches
Q4. Show the sum of individuals affected based on location of breach. And, show only location where more than 500k individuals were affected. also, Exclude ‘other’ from the visualization
6. a Tableau Interactive Dashboard video (3-5 min.)- showing 3 of the 4 sheets in an Interactive Dashboard
Links to an external site.)
7. Record your Tableau Interactive Dashboard data analysis session
- Review Video link below – it will show you how to record your Tableau Interactive Dashboard data analysis session using Teams
- You will turn on the Camera and introduce yourself: Name, Course and that you are doing a Tableau data analysis session
- **Note** – At first you can’t hear so just follow along – Once he accesses Teams you will be able to hear good
- The USF Tableau mentor created this for us ;0)
Teams “How to Recording Tableau Interactive Dashboard Data analysis session”
9. Review – Ex. of a student Tableau video that passed and received credit!
Student Video with a Tableau Interactive Dashboard
After you are done please write the script analysis for each data for the video. The example is the in Number 9.