Android Motorsport Manager Interview Questions

Q Design a view in a map such that if a user selects any country, the states under that country has to show profit and sales.

According to your question, you must have a country, state, profit and sales fields in your dataset.

  • Double-click on the country field.
  • Drag the state and drop it into Marks card.
  • Drag the sales and drop it into size.
  • Drag profit and drop it into color.
  • Click on size legend and increase the size.
  • Right-click on the country field and select show quick filter.
  • Select any country now and check the view.
  • Q What is the difference between Data Mining and Data Analysis?

    Data Mining Data Analysis
    Used to recognize patterns in data stored. Used to order & organize raw data in a meaningful manner.
    Mining is performed on clean and well-documented data. The analysis of data involves Data Cleaning. So, data is not present in a well-documented format.
    Results extracted from data mining are not easy to interpret. Results extracted from data analysis are easy to interpret.

    Table 1: Data Mining vs Data Analysis – Data Analyst Interview Questions

    So, if you have to summarize, Data Mining is often used to identify patterns in the data stored. It is mostly used for Machine Learning, and analysts have to just recognize the patterns with the help of algorithms. Whereas, Data Analysis is used to gather insights from raw data, which has to be cleaned and organized before performing the analysis.

    Q What are the different types of Joins?

    The various types of joins used to retrieve data between tables are Inner Join, Left Join, Right Join and Full Outer Join. Refer to the on the right side.

  • Inner join: Inner Join in MySQL is the most common type of join. It is used to return all the rows from multiple tables where the join condition is satisfied.
  • Left Join: Left Join in MySQL is used to return all the rows from the left table, but only the matching rows from the right table where the join condition is fulfilled.
  • Right Join: Right Join in MySQL is used to return all the rows from the right table, but only the matching rows from the left table where the join condition is fulfilled.
  • Full Join: Full join returns all the records when there is a match in any of the tables. Therefore, it returns all the rows from the left-hand side table and all the rows from the right-hand side table.
  • Q How to represent a Bayesian Network in the form of Markov Random Fields (MRF)?

    To represent a Bayesian Network in the form of Markov Random Fields, you can consider the following examples:

    Consider two variables which are connected through an edge in a Bayesian network, then we can have a probability distribution that factorizes into a probability of A and then the probability of B. Whereas, the same network if we mention in Markov Random Field, it would be represented as a single potential function. Refer below:

    Fig 8: Representation of Bayesian Network in MRF – Data Analyst Interview Questions

    Q What are the most common questions you should ask a client before creating a dashboard?

    Well, the answer to this question varies on a case-to-case basis. But, here are a few common questions that you can ask while creating a dashboard in Excel.

  • Purpose of the Dashboards
  • Different data sources
  • Usage of the Excel Dashboard
  • The frequency at which the dashboard needs to be updated
  • The version of Office the client uses.
  • Android Developer Interview Questions with Answer Examples

    Related Posts

    Leave a Reply

    Your email address will not be published. Required fields are marked *