Connect to the "Global Superstore" data source and use the Orders table. Find out the average quantity ordered by customers whose first name starts with an 'S' alphabet?

• A.3.43
• B.3.56
• C.4.02
• D.3.39

Correct Answer: B

Create a Calculation to get the first alphabet of the customer name.
Graphical user interface, text, application Description automatically generated

Now drop the First Alphabet field to Rows and Quantity field to the Text on the Marks card. Change the aggregation from SUM to AVG. Your view will look like this:

Comment: *

Name: *

Email: *

Verification: *

Connect to the "Global Superstore" data source and use the Orders table. What is the total profit earned by all the cities in Wake County, North Carolina from the year 2012 to 2014?

• A.$527
• B.$403
• C.$427
• D.$503

Correct Answer: B

Drop the State to the View. And drop the Country to the Filter Shelf and Select the United States.
Drop the City to the view, and add the State to the Filter shelf and select North Carolina.
Also, drop the Order Date to the Filters and select year 2012, 2013, 2014 Graphical user interface, text, application, email Description automatically generated

Now, drop the Profit field to the tooltip. As of now, your view should look like this:
A picture containing map Description automatically generated

Now, we have to find the total profit earned by all the cities in Wake County.
Drop the City field to the view and drop the state to the Filters shelf and Select North Carolina only.
Graphical user interface, text, application, chat or text message Description automatically generated

To show the County go to the Map->Map Layers.
Check County Names and County Borders.
Graphical user interface, text, application Description automatically generated

the total profit earned by all the cities in Wake County is $403.
A picture containing map Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

You need to create a filled map using the City field, you drop the City field to your view. And you get the location error 'Ambigious', what does it mean, and how you will fix this issue?
Larger image

• A.The city name must be misspelled. Correct the spelling to fix the issue.
• B.More than one city has that name. Update the data type of the field to fix this issue.
• C.More than one city has that name. Adjust the geographic roles to fix this issue.
• D.Click on the Reset matches button to fix this issue.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Business
• B.Communication
• C.Education
• D.Public Affairs

Correct Answer: A,D

Explanation
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.

Comment: *

Name: *

Email: *

Verification: *

Which LOD calculations can be used in Columns shelf to create this view?
Larger image

• A.{ FIXED [Category] : SUM([Profit])}
• B.{ FIXED [Region] : SUM([Profit])}
• C.{FIXED : SUM([Profit])}
• D.{SUM([Profit])}

Comment: *

Name: *

Email: *

Verification: *