第 45 号 Connect to the “Significant Volcano Eruption” data source. Create a histogram using field Death and having a bin size of 500. Find out which country reported 9 deaths in the bin of 0-500?

第 46 号 Connect to the Olympic Athletes data source, find out the average age of players who won at least one gold medal for the country?

NO.47 Connect to the “Significant Volcano Eruption” data source. Using the elevations field, create bins of size 1000 and find out in which bin has the most total deaths?

第 48 号 In Forecast, what is the shaded region?

NO.49 Connect to the “Global Superstore” data source and use the Orders table. Find out how many products from the Office Supplies category are in the Top 10 most profitable product list?

NO.50 Which of the following are true regarding custom geocoding and data blending?

第 51 号 Connect to the “Flight” data source and find out which carrier was having the highest percentage of delayed flights in 2013?

第 52 号 Connect to the “Significant Volcano Eruption” data source. How many volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year?

第 53 号 Which of these chart types are primarily used to compare measures against goals?

第 54 号 Connect to the “Covid data” source. Create a line chart using continuous months and new deaths. Find the Excess Kurtosis for the sum of new deaths.

第 55 号 In a combined axis chart, using which field we get multiple measures on a single axis?

NO.56 Connect to the “Global Superstore” data source and use the Orders table. Find out how many days in the 4th quarter of 2015 had a profit ratio greater than 25%?

NO.57 Connect to the “Significant Volcano Eruption” data source. What percentage of total deaths caused by volcanoes which were having a volcano index greater than 2 and elevation greater than 5000?

NO.58 Using the Sales Analysis Dashboard, If you click on any of the products, it should navigate to the All Products worksheet. How you will accomplish it?

第 59 号 When it is recommended to create multiple table extracts?

NO.60 I have a view that shows the top 5 countries as per the sales, I also have a region filter, but most of the region filter values we don’t need. For example – We don’t have any country which is part of the Eastern Europe region. So we want to hide all those regions which are not valid here. How to do it?
Larger image

第 61 号 Connect to the “Global Superstore” data source and use the Orders table. Create a filter on a product name to find out the top 10 profitable products. Create a crosstab to show these products along with profit value. Now filter this chart to show only the products from the European market. What is the 10th most profitable product?