We can create variable size bins using ___________?

• A.Groups
• B.Calculated Fields
• C.Sets
• D.Hierarchies

Comment: *

Name: *

Email: *

Verification: *

Which of the following are valid calculations?

• A.MAX(SUM(Profit), (Sales))
• B.SUM([Profit]) * SUM([Quantity])
• C.SUM([Profit]) * 1000
• D.SUM([Profit]) * [Quantity]

Comment: *

Name: *

Email: *

Verification: *

Connect to the "Global Superstore" data source and use the Orders table. Find out the percentage of total sales in all the categories in 2015 by customers who have purchased any product in the Phones sub-category in
2014? Use Customer ID.

• A.4.90%
• B.5.03%
• C.4.53%
• D.3.45%

Correct Answer: D

Explanation
Approach 1 - Using Groups
Drop the Customer ID to the Rows.
Add sub-category to the filter and select phone.
Add Order date to the filter and select the year 2014.

Select all the customers and click on paper clip icon to create the group.
So here we got all the customers who have purchased any product in the Phones subcategory in 2014.
Edit the group and select Include other

Clear the filter shelf, and again add Order date to the filter and select 2015.
Drop Sales to the Text.
Add 'Percent of Total' Quick Table Calculation to the Sales field.
Your view will look like this:

Approach 2 - Using LOD
Create a LOD expressions as:

It will return 1 for the customers who have purchased any product in the Phones sub-category in 2014. For others, it will return 0.
Drop this field to the Rows and add Order date to the filter and select the year 2015.

Comment: *

Name: *

Email: *

Verification: *

Connect to the "Education" data source. Create a histogram using the Total score field and having a bin size of
100. Find out in which bin the students scored the highest verbal percentage? [Note: Verbal percentage should be calculated by considering how many marks scored in the verbal out of the total marks scored.]

• A.900
• B.1000
• C.1500
• D.1600

Correct Answer: B

Explanation
Create a calculated field to compute the contribution of verbal marks in percentage:

Select the Total Score field and using Show me create a histogram.
Edit the Total Score(bin) and provide the Size of bins as 100:

Drop the % Verbal field to the Label, your view will look like this:
Chart, histogram Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

Extract can't be created in which of the scenario?

• A.When you perform cross-database joins
• B.When you perform the blend
• C.When you perform the union
• D.When you perform the traditional join

Comment: *

Name: *

Email: *

Verification: *