Use custom geocoding, when you need ___________ locations to map your data.
Custom geocoding means that you assign latitude and longitude coordinates to your locations
so Tableau can plot them accurately.
Refer: https://help.tableau.com/current/pro/desktop/en-us/custom_geocoding.htm
Which of the following are true regarding custom geocoding and data blending?
Refer to the quick comparison of data blending and custom geocoding -
https://help.tableau.com/current/pro/desktop/en-us/maps_customgeocode_datablend.htm
Topic 3, Exam Pool C
Download the Dataset from here:
https://drive.google.com/file/d/1hGTUYyq6Y7DLt-DwxVaR4tNLS-FYvD22/view?usp=sharing
Use the above data set to answers the questions under Exam Pool C.
Connect to the "Education" data source. Which college(s) average math, verbal, and writing scores are lesser than the overall 70% percentile in these subjects?
Create a bar chart using field college and Math. Change the Math aggregation to AVG.
Drop the Verbal field to Y axis, to create the combined axis chart. And change the aggregation
to Avg.
Follow the same for Writing field.
Now from the Analytics menu, drop the Distribution band to the view, select the scope as
entire table, and select the value as 70 percentiles.
Your view will look like this:
70 percentiles are 547.8
Business and public affairs have all the individual subject values lesser than 547.8.
Connect to the "WorldBank Data" and use the Development Indicators table. Create a relationship between the avg. birth rate and avg. death rate using scatterplot aggregated at the region level, plot death rate on Y-axis and birth rate on X-axis. Add an exponential trendline and find out how many regions are above the trend line?
After following the steps mentioned in the question your view will look like this:
Here, 5 points are above the exponential trend line.
Connect to the "World Cup Results" and use tables WorldCupMatches, WorldCups. Which of the following year had the highest percentage of Away goals? Consider only those years when the host country did not win the world cup.
In WorldCupMatches table, we have the information of Away goals, and in the WorldCups
table, we have the information of the Winner team and goal scored.
In WorldCups, there is only row for each year. But in WorldCupMatches, there is a separate
row for each match. This is the perfect example to use blend as here we need to first
aggregate the data from WorldCupMatches table.
Let's establish the blend relationship between these two data sources, on the basis of Country
and Year.
Let's use WorldCups as the primary data source, so add the field from this data source to the
view. Drop Year to Rows and change it discrete. Drop Country and Winner field as well to the
rows.
In WorldCupMatches data source, create a calculated field :
Drop this field to the Text, and format it so that it will be shown in percentage.
Out of the given options, only in 1934 host country won the world cup
2010 is the correct answer.
Elliot
14 hours agoTorie
12 days agoInes
13 days agoBrice
15 days agoRory
26 days agoWillodean
30 days agoIrma
1 months agoLindsay
2 months agoLashawn
2 months agoDolores
2 months agoSylvie
2 months agoGracie
2 months agoBelen
4 months agoClemencia
5 months agoSherron
5 months agoQuentin
5 months agoAleshia
5 months agoEllsworth
6 months ago