Connect to the World Indicator saved dataset in Tableau

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Question: 1

Forecasting & Analytics Pane 

Part B:

Connect to the World Indicator saved dataset in Tableau (see picture below to connect to this dataset). Create a scatterplot that compares internet usage and mobile phone usage by country. 

How has the correlation between Internet Usage and Mobile Phone Usage changed from 2000 and 2012?

• Create a scatterplot to compare mobile phone usage and internet usage by country.

• Insert a trend line to determine how correlated the data points are for the year 2000 (hover over the trend line to see the r-squared and p-value). Learn more about the P-Value and r-squared here.

• Create a copy of the worksheet and change the year filter to 2012.

• Put the two worksheets together on a dashboard to compare how the relationship has changed over time

Note: You could also use the ‘pages’ shelf to see how the data has changed over time. Click here to read more about the pages shelf.

 

 

Question: 2

Joins Part B:

Use the Calculated Fields & Joins start.twbx to complete this assignment.

Create a bar chart to show the average discount by manager in the technology department in 2013.

What Manager(s) have the highest average discount for the technology department in 2013?

• Create an outer join on orders & users on the data source tab

• Create a bar chart to show average discount by manager

• Format the average discount to be a percentage

• Use filters to find the answer to the question above

 

Question; 3

 

Part B: Level of Detail

Question:

Connect to the Summer Olympic Medals 1896 – 2008 and select the first tab called “ALL MEDALISTS.”  

This data set contains all the medals that have been won in the summer Olympics since 1896. Use this 

data to answer the following question: 

What country has the highest percent of Olympic medals won by women?

Tasks:

• Create a bar chart that shows the percent of medals won by country

o Create a fixed level of detail calculation at the country level that shows the total medals 

(Number of records) by country. Call this field Total Medals by Country

o Create a calculated field that divides the number of records by the country total medal 

calculation. Call this field Percent of Total

o Filter your view by “gender” to just women and sort descending

o Create a chart that shows the Gender Percent of Total by country

o Add Country Total Medals to Tooltip to show the total number of country medals won

 

 

Attachments:

Expert's Answer

852 Times Downloaded

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of