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.
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.
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.