Connect to the "Global Superstore" data source and find out which region was having the highest percentage of returned orders in 2013?
Create a left outer join, so that we can calculate the percentage of the returned orders
Create a calculated field ''% of returned orders'':
Drop the Order Date to the filters shelf and select the year 2013
Drop the Region to the rows and % of returned orders to the Text:
You have connected to the employee table in your data source and are adding a join on the Employee Manager table. If you would like to see all of the records from the employee table and only matching records from the employee manager table. Which join type will you use?
When you use a left join to combine tables, the result is a table that contains all values from the left table and corresponding matches from the right table.
Refer Join Types: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm
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.
Twana
3 days agoLashawna
9 days agoOnita
17 days agoStefania
21 days agoTanesha
24 days agoRex
1 months agoElliot
1 months agoTorie
2 months agoInes
2 months agoBrice
2 months agoRory
2 months agoWillodean
2 months agoIrma
3 months agoLindsay
3 months agoLashawn
3 months agoDolores
3 months agoSylvie
3 months agoGracie
4 months agoBelen
6 months agoClemencia
6 months agoSherron
6 months agoQuentin
6 months agoAleshia
7 months agoEllsworth
7 months ago