You have connected to an excel sheet that has two tables "orders" and "returns". You need to create a data extract and store it as Multiple Tables. But multiple tables option is greyed out. What is the possible reason for this?
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?
Connect to the "Life Expectancy at birth" data source, combine sheets Data_20th century and Data_21st century. Find the moving average for the average life expectancy for 10 years before 2000 and 10 years after 2000 for New Zealand.
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?