Scribd Logo
Upload

Welcome to Scribd!

  • 7 views

    Tasks

    Uploaded by

    aniruddhaphadke

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Tasks

    Uploaded by

    aniruddhaphadke
    7 views2 pages

    Original Title

    Tasks (4)

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    7 views2 pages

    Tasks

    Uploaded by

    aniruddhaphadke

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    Tasks

    Learners have to develop a dashboard to support the answers to the


    following questions and suggestions for places for newer restaurants.

    Objective Questions:
    1. What is the total no. of tables present in the data?

    2. What is the total no. of attributes present in the data?

    3. How many categorical columns are there in the data? [Search about
    categorical and continuous data, and try to answer this question]

    4. The data consists of some inconsistent and missing values so ensure that the
    data used for further analysis is cleaned.

    5. Using the LookUp functions, fill up the countries in the original data using the
    country code.

    6. Create a table to represent the number of restaurants opened in each country.

    7. Also, the management wants to look at the number of restaurants opened


    each year, so provide them with something here.

    8. What is the total number of restaurants in India in the price range of 4?

    9. What is the average number of voters for the restaurants in each country
    according to the data?

    10. Calculate the average rating for all the restaurants that have price_range < 4
    and provide online delivery. Use only the “IF” function, Logical Operators, and
    Aggregation functions to solve this problem. [Note: Don’t use Conditional
    aggregation in this question.]

    11. Using Conditional formatting highlight the rows of restaurants that are located
    in the countries or cities that you’ve suggested to the management for
    opening new restaurants.

    12. Create a new customized price column that consists of the


    abbreviation/symbol of the currency along with the Average_cost_for_two
    value. [Use string operations to do this task]

    13. How can you create an array formula in Excel or Google Sheets to count the
    number of restaurants listed that do not offer online delivery, are in the lowest
    price range, and have an average cost for two people less than or equal to
    250 Indian Rupees?

    Subjective Question:

    1. Suggest a few countries where the team can open newer restaurants with
    lesser competition. Which visualization/technique will you use here to justify
    the suggestions?

    2. Come up with the names of States and cities in the suggested countries
    suitable for opening restaurants.

    3. According to the countries you suggested, what is the current quality


    regarding ratings for restaurants that are open there?

    4. Also, what is the current expenditure on food in the suggested countries, so


    we can keep our financial expenditure in control?

    5. Come up with the names of restaurants from the recommended states that
    are our biggest competitors and also those that are rated in the lower
    brackets, i.e. 1-2 or 2-3.

    6. Which cuisines should we focus on in the newer restaurants to get better


    feedback? Does the choice of cuisines affect the restaurant ratings?

    7. According to our current data, should we go for online delivery and table
    booking? Does that affect the customer’s ratings?

    8. Should the team keep the rate of cuisines higher? Will that affect the
    feedback? According to our data are the rates of cuisines and ratings,
    correlated?
    9. What is the distribution of the number of restaurants of different price ranges
    in all the countries?
    10. Explain your approach in brief for suggesting countries/cities in order to open
    new restaurants, if the objective and subjective questions would have been
    given to assist you. [you have to give bullet pointers in order to answer
    this question]

    The dashboard must consist of Year-wise and country slicers.

    You might also like