3RI Technologies
Data Analytics
1. What is data analytics, and why is it important?
2. How does data analytics differ from data science?
3. Explain the data analysis process in brief.
4. What are the different types of data?
5. What are the key skills required for a data analyst?
6. Explain structured, semi-structured, and unstructured data.
7. How do you handle missing data in a dataset?
8. What are outliers, and how do you handle them?
9. Describe your experience with data cleaning.
10. What are the main responsibilities of a data analyst?
11. What tools and software have you used for data analytics?
12. How do you choose the right tool for a specific project?
13. What is your experience with Excel for data analysis?
14. How do you use Tableau/Power BI for data visualization?
15. What is SQL, and how is it used in data analytics?
16. Explain the difference between Tableau and Power BI.
17. Describe a scenario where you used Python/R for data analysis.
18. What is your experience with Google Analytics?
19. Can you explain the purpose of Apache Hadoop in data analytics?
20. What are some common libraries in Python used for data analytics?
21. What is the difference between a primary key and a foreign key?
22. Explain the difference between OLAP and OLTP.
23. What are joins in SQL, and how many types are there?
24. Write an SQL query to find duplicate values in a column.
25. How would you optimize a slow-running SQL query?
26. What is the difference between DELETE and TRUNCATE commands in SQL?
27. How do you create a temporary table in SQL?
28. Explain the concept of indexing in a database.
29. Write an SQL query to calculate the average salary from an employee table.
30. What is a self-join in SQL?
31. What is the difference between descriptive and inferential statistics?
32. Explain the concepts of mean, median, and mode.
33. What is standard deviation, and why is it important?
34. How do you calculate correlation and covariance?
35. What is the significance of p-value in hypothesis testing?
36. Explain the concept of a normal distribution.
37. What are Type I and Type II errors?
38. What is regression analysis?
39. How do you handle multicollinearity in regression?
40. What is the central limit theorem?
41. What are the best practices for data visualization?
42. How do you decide which chart to use for a dataset?
43. What is the importance of storytelling in data visualization?
44. Explain the difference between a heatmap and a scatterplot.
45. How do you create a dashboard in Tableau/Power BI?
1
3RI Technologies
46. What are some common mistakes to avoid in data visualization?
47. How do you visualize trends in time-series data?
48. What is the role of interactivity in dashboards?
49. Explain the concept of KPI in data visualization.
50. Describe a challenging data visualization project you worked on.
51. What is machine learning, and how does it relate to data analytics?
52. Explain the difference between supervised and unsupervised learning.
53. How do you evaluate the performance of a predictive model?
54. What are the main differences between classification and regression?
55. Explain the concept of clustering in analytics.
56. What is A/B testing, and why is it used?
57. How do you handle imbalanced datasets in analytics?
58. Explain the difference between ETL and ELT.
59. What is big data analytics, and how does it differ from traditional analytics?
60. How do you handle real-time data in analytics?