Data Analyst interview questions and answers

Q.1Explain the process of data analysis?
A.Data analysis refers to the process of collecting data, cleaning, interpreting and visualizing it to derive insights or conclusions and generate reports to help make business decisions..
Q.2 What are the different challenges you face during data analysis?
A.While analyzing data, a Data Analyst can encounter the following issues:1) Duplicate entries and spelling errors due to which data quality can be hampered
2) Incomplete data. Leads to errors and faulty analysis
3) Dirty data which leads to a lot of time getting wasted in cleaning
4) Business stakeholders’ unrealistic timelines and expectations
5) Data integration from multiple sources
6) Insufficient data architecture and tools to achieve the analytics goals on time.
Q.3 Explain data cleaning
A.Data cleaning is a process of identifying and then modifying, replacing, or deleting the incorrect, incomplete, inaccurate, irrelevant, or missing portions of the data as the need arises. This fundamental element of data science ensures data is correct, consistent, and usable.
Q.4 Explain OUTLIER
A.In a dataset, Outliers are values that differ significantly from the mean of characteristic features of a dataset. With the help of an outlier, we can determine either variability or an experimental error. There are two kinds of outliers i.e., Univariate and Multivariate.