20+ TOP Data Analyst Interview Questions & Answers
1. What is involved in typical data analysis?
Data analysis involves collection and organization of data, correlation between analyzed data and the rest of the company and market, and the ability to then creatively think of solutions to existing problems, or point out problems and initiate preventive measures.
2. Do you have any experience with corporate websites?
Relevant experience might involve creating the rules for various corporate consumer websites, depending on market conditions and company goals. Analysts might also help design website features, so that they align with their analysis of company data and performance predictions.
3. How do you handle database as a data analyst?
Data analysts may be responsible for database design and security. They are responsible for upgrading the database on a regular basis so that it meets the demands of the market and company needs. And they make sure that the database runs smoothly in general.
4. Are you comfortable spending prolonged periods of time in front of a desktop computer?
All data analysts spend much time using computers. The job requires no physical strain except the ability to focus on the job of analyzing and offering creative solutions.
5. Have you ever developed any programs or products relevant to your profession?
As a business analyst working in the software and technology industry, you might have experience actually developing information-related products for the company, which can be used for data analysis and data presentation.
6. What are your best traits that are suitable for this position?
Name relevant skills including one’s:
-Excellent analytical skills
-Exceptional communication skills
-Outstanding writing abilities
-Orientation to detail
-Advanced knowledge of current programs such as Microsoft Access and Excel
-Demonstrated problem solving abilities
7. Describe a time when you solved a problem that benefited your company.
Though providing analyses may always be helpful in one way or another, the interviewers are looking to see if you have done anything to directly contribute to a past company’s noteworthy success. You must then:
-Talk about how you understood the origins of the problems
-Indicate that you were able to delve into the details and fix what was necessary
-Discuss the desired results
-Conclude with mentioning how your positive, optimistic, and focused attitude assisted in resolving such an issue
8. Can you outline the various steps in an analytics project?
Broadly speaking these are the steps. Of course these may vary slightly depending on the type of problem, data, tools available etc.
1. Problem definition – The first step is to of course understand the business problem. What is the problem you are trying to solve – what is the business context? Very often however your client may also just give you a whole lot of data and ask you to do something with it. In such a case you would need to take a more exploratory look at the data. Nevertheless if the client has a specific problem that needs to be tackled, then then first step is to clearly define and understand the problem. You will then need to convert the business problem into an analytics problem. I other words you need to understand exactly what you are going to predict with the model you build. There is no point in building a fabulous model, only to realise later that what it is predicting is not exactly what the business needs.
2. Data Exploration – Once you have the problem defined, the next step is to explore the data and become more familiar with it. This is especially important when dealing with a completely new data set.
3. Data Preparation – Now that you have a good understanding of the data, you will need to prepare it for modelling. You will identify and treat missing values, detect outliers, transform variables, create binary variables if required and so on. This stage is very influenced by the modelling technique you will use at the next stage. For example, regression involves a fair amount of data preparation, but decision trees may need less prep whereas clustering requires a whole different kind of prep as compared to other techniques.
4. Modelling – Once the data is prepared, you can begin modelling. This is usually an iterative process where you run a model, evaluate the results, tweak your approach, run another model, evaluate the results, re-tweak and so on….. You go on doing this until you come up with a model you are satisfied with or what you feel is the best possible result with the given data.
5. Validation – The final model (or maybe the best 2-3 models) should then be put through the validation process. In this process, you test the model using completely new data set i.e. data that was not used to build the model. This process ensures that your model is a good model in general and not just a very good model for the specific data earlier used (Technically, this is called avoiding over fitting)
6. Implementation and tracking – The final model is chosen after the validation. Then you start implementing the model and tracking the results. You need to track results to see the performance of the model over time. In general, the accuracy of a model goes down over time. How much time will really depend on the variables – how dynamic or static they are, and the general environment – how static or dynamic that is.
9. What do you do in data exploration?
Data exploration is done to become familiar with the data. This step is especially important when dealing with new data.
There are a number of things you will want to do in this step –
a. What is there in the data – look at the list of all the variables in the data set. Understand the meaning of each variable using the data dictionary. Go back to the business for more information in case of any confusion.
b. How much data is there – look at the volume of the data (how many records), look at the time frame of the data (last 3 months, last 6 months etc.)
c. Quality of the data – how much missing information, quality of data in each variable. Are all fields usable? If a field has data for only 10% of the observations, then maybe that field is not usable etc.
d. You will also identify some important variables and may do a deeper investigation of these. Like looking at averages, min and max values, maybe 10th and 90th percentile as well…
e. You may also identify fields that you need to transform in the data prep stage.
10. What do you do in data preparation?
In data preparation, you will prepare the data for the next stage i.e. the modelling stage. What you do here is influenced by the choice of technique you use in the next stage.
But some things are done in most cases – example identifying missing values and treating them, identifying outlier values (unusual values) and treating them, transforming variables, creating binary variables if required etc,
This is the stage where you will partition the data as well. i.e create training data (to do modelling) and validation (to do validation).
11. How will you treat missing values?
The first step is to identify variables with missing values. Assess the extent of missing values. Is there a pattern in missing values? If yes, try and identify the pattern. It may lead to interesting insights.
If no pattern, then we can either ignore missing values (SAS will not use any observation with missing data) or impute the missing values.
Simple imputation – substitute with mean or median values
Case wise imputation –for example, if we have missing values in the income field.
12. How will you treat outlier values?
You can identify outliers using graphical analysis and univariate analysis. If there are only a few outliers, you can assess them individually. If there are many, you may want to substitute the outlier values with the 1stpercentile or the 99th percentile values.
If there is a lot of data, you may decide to ignore records with outliers.
Not all extreme values are outliers. Not all outliers are extreme values.
13. How do you assess the results of a logistic regression analysis?
You can use different methods to assess how good a logistic model is.
a. Concordance – This tells you about the ability of the model to discriminate between the event happening and not happening.
b. Lift – It helps you assess how much better the model is compared to random selection.
c. Classification matrix – helps you look at the false positives and true negatives.
Some other general questions you will most likely be asked:
What have you done to improve your data analytics knowledge in the past year?
What are your career goals?
Why do you want a career in data analytics?
14. According to you, which are the qualities that a data analyst must possess to be successful at this position?
Answer: Analytical and problem solving skills are crucial to be successful at this position. Also, one needs to be skilled at organizing and formatting data, so that information is available in an easy -to-read manner. Technical proficiency is important too, especially if your organization depends largely on the software and data processing tools.
15. Describe the most difficult database problem you have faced? Why was it so difficult than other analytical problems you solved?
Answer: My toughest challenge was to make prediction sales during the recession period and estimate the losses the organization may suffer in the coming quarter. It was difficult since I had to interpret information and forecast future trends. Till then I had analyzed the information that I already had and concluded on what had already happened. I had to evaluate the impact of receding economic conditions on different income groups and make an inference on the purchasing capacity of that group. I used different statistical methods and economic parameters to make this conclusion. (This is a personal interpretative question that must be answered as per your experience. Introduce the problem and highlight the exact nature of the problems faced. Give details of how you perceived the problem, analyzed the information, applied principles of analysis, managed information and found solutions to the objectives.)
16. What procedure do you follow to analyze the given data?
Answer: The procedure I adopt to solve analytical problems depends upon the objective of the analysis. At first, I organize information by making categories. Secondly, I find relationship between two or more categories such that any changes in one category affects the results of the other. Further, the procedure includes data cleaning, defining structure of samples, determining quality verification measures, computing statistics and making reports on the analysis.
17. What do you understand from the term data cleaning?
Answer: Data cleaning refers to the task of inspecting and cleaning data. From the given data, it is important to sort out information that is valuable for analysis. Also, one needs to eliminate information that is incorrect, unnecessary or repetitive. However, the entire database should be retrievable. Data cleaning does not impose deleting information completely from the database.
18. Besides analyzing, have you ever participated in database designing and database development tasks?
Answer: I have not directly participated in data designing and data development activities since we had a dedicated team to perform those functions. However, I have given valuable inputs to those teams during the discussions and helped them in research and data formatting. (Customize this answer as per your experience)
19. I have provided you here some data regarding the sales figures of last 5 quarters. It shows the expenses incurred as a part of the sales activities? How would you analyze this data?
Answer: (The answer to this question depends upon the nature of the problem that is given to you to solve. However, here are some steps that you should follow while solving the problem. Read the problem and the data carefully. Ask for an explanation for the terms that you could not understand. Extract the unusual and interesting trends that need attention. Apply the various statistical analysis methods and principles. Make a presentation or give a verbal account of your analysis as demanded.
20. Which technical tools do you use often for analysis and presentation purpose?
Answer: The tools to be used depend upon the nature of analysis being done. I am comfortable using the QDA (Qualitative Data Analysis) Miner, KNIME (Konstanz Information Miner), Root, PAW, etc. Also, most of my work is done using MS Excel features of shewhart control charts, stratification, histogram, scatter diagram, correlation and covariance, etc. I am keen on learning new tools as may be necessary to work at this organization.