Desktop-Certified-Associate Exam Question 16

Connect to the "Education" data source. Analyze the Math score and create 3 categories. If the score is less than 500 then consider the student as 'Low Performer'. If the score is greater than or equal to 500 but less than
600 then call it 'Average Performer'. If the score is greater than or equal to 600 then 'High Performer'. Find out the percentage of Average Performers in males?
  • Desktop-Certified-Associate Exam Question 17

    Connect to the "Kiva Loans - India" data source, create a chart using the continuous disbursed month (Disbursed Time field) and sum of the loan amount, exclude the null values. What is the skewness of this chart?
  • Desktop-Certified-Associate Exam Question 18

    Connect to the "Global Superstore" data source and use the Orders table. Create a map that shows the number of unique customers in Australia. Find the state of Queensland. Which neighboring state has the minimum number of unique customers?
  • Desktop-Certified-Associate Exam Question 19

    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
  • Desktop-Certified-Associate Exam Question 20

    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.