In your view, you are using a background image. How can you find the X and Y coordinates on your image?

• A.Using custom geocoding
• B.By annotate a point
• C.By annotate an area
• D.Using drop lines

Comment: *

Name: *

Email: *

Verification: *

Connect to the "Flight" data source and create a hierarchy as City-Airport Name-Carrier Name. Find out which combination was having the lowest number of on-time flights?

• A.Boston-Logan International-SkyWest
• B.Orlando-Orlando International-SkyWest
• C.Phoenix-Phoenix Sky Harbor International-Pinnacle
• D.Salt Lake City-Salt Lake City International-Mesa

Correct Answer: C

Explanation
Create a hierarchy using City-Airport Name-Carrier Name.
Filter using Ontime Category field and select the Ontime.
Drop the hierarchy to the view and Number of flights to the Text.
Check each combination from the answers:

Comment: *

Name: *

Email: *

Verification: *

Connect to the "Kiva Loans - India" data source, find out which sector has the highest distribution of loan amount using interquartile ranges?

• A.Education
• B.Entertainment
• C.Retail
• D.Wholesale

Correct Answer: D

Create a box plot using Sector and Loan amount.
Chart, box and whisker chart Description automatically generated

The IQR is maximum for the Wholesale sector.

Comment: *

Name: *

Email: *

Verification: *

Connect to the "Global Superstore" data source and use the Orders table. Find out how many new customers were acquired in the year 2014?

• A.4419
• B.5412
• C.4719
• D.5216

Correct Answer: A

Explanation
If customer first order is equal to the order date, then this is the new customer.
Create a calculated field to find the first order date:

Find If the order date is equal to the day of first purchase for that customer, flag that row as a
'New Customer'

Find the unique customers:

Drop the Order date to filter shelf and select the year 2014 to find out the new customer acquired in 2014.
Drop New Customer field to Rows and Unique customer field to Text marks card.

Comment: *

Name: *

Email: *

Verification: *