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

(Links to an external site.)

3 min. (start at 1:25min. as I am providing the data set – in Step 3)

Tableau – Explaining Dimensions and Measures

(Links to an external site.)

– 3 min.

Tableau – Creating Bar Charts

(Links to an external site.)

– 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”

(Links to an external site.)

– Starting at 8:43min create a new dashboard and then at 12 min shows the Interactive Dashboard

Tableau Dashboard Tips

(Links to an external site.)

13min – This video shows how to build an excellent Interactive Dashboard

2.. Download the Windows or Mac Application file to install (below)

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

download

  • 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)

(Links to an external site.

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

download

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”

(Links to an external site.)

9. Review – Ex. of a student Tableau video that passed and received credit!

Student Video with a Tableau Interactive Dashboard

(Links to an external site.)

After you are done please write the script analysis for each data for the video. The example is the in Number 9.