100 Data Analyst Interview Questions and Answers
1. SQL - Q: What is the difference between INNER JOIN and LEFT JOIN?
A: INNER JOIN returns only the matching rows from both tables, while LEFT JOIN returns all rows
from the left table and matching rows from the right table.
2. SQL - Q: How would you optimize a slow-running SQL query?
A: Use indexing, avoid SELECT *, filter data early, analyze execution plans, and break complex
queries into smaller parts.
3. SQL - Q: Explain window functions with examples.
A: Window functions perform calculations across a set of table rows. Example: ROW_NUMBER()
OVER (PARTITION BY dept ORDER BY salary DESC).
4. SQL - Q: How do you use CTEs (Common Table Expressions) in SQL?
A: CTEs are temporary result sets used for modularizing queries. Example: WITH cte AS (SELECT *
FROM Employees) SELECT * FROM cte WHERE Salary > 50000;
5. SQL - Q: What are aggregate functions and how are they used?
A: Aggregate functions like SUM, COUNT, AVG, MAX, MIN summarize data and are used with
GROUP BY clauses.
6. Power BI - Q: How do you handle data refresh in Power BI?
A: Configure data sources with credentials, schedule refreshes in Power BI Service, and monitor
using refresh history.
7. Power BI - Q: Explain the difference between calculated columns and measures.
A: Calculated columns are computed during data load and stored in the model; measures are
calculated dynamically based on the context of the report.
8. Power BI - Q: What is DAX and give an example of a DAX formula you use frequently.
A: DAX (Data Analysis Expressions) is a formula language. Example:
CALCULATE(SUM(Sales[Amount]), Sales[Region] = 'East')
9. Power BI - Q: How do you implement row-level security in Power BI?
A: Define roles in Power BI Desktop using DAX filters, then assign users to roles in Power BI
Service.
10. Power BI - Q: What are the different types of filters available in Power BI?
A: Report level, page level, visual level, and slicers.
11. Excel - Q: What are pivot tables and how do you use them?
A: Pivot tables summarize large datasets by grouping and aggregating data, making trends and
patterns easier to identify.
12. Excel - Q: Explain VLOOKUP, HLOOKUP, and XLOOKUP functions.
A: VLOOKUP searches vertically, HLOOKUP searches horizontally, and XLOOKUP replaces both
with more flexibility and error handling.
13. Excel - Q: How do you clean and prepare data in Excel?
A: Use functions like TRIM, CLEAN, TEXT TO COLUMNS, Remove Duplicates, and Power Query.
14. Excel - Q: What is conditional formatting and how is it useful?
A: Conditional formatting highlights cells based on rules, useful for drawing attention to trends or
outliers.
15. Excel - Q: How do you handle large datasets in Excel?
A: Use filters, tables, Power Query, and pivot tables; avoid volatile formulas and unnecessary
formatting.
16. Azure Data Factory (ADF) - Q: What are the key components of Azure Data Factory?
A: Pipelines, activities, datasets, linked services, integration runtimes, and triggers.
17. Azure Data Factory (ADF) - Q: How do you create and schedule pipelines in ADF?
A: Design pipelines with activities, set parameters, and use triggers (schedule, tumbling window, or
event-based) to automate execution.
18. Azure Data Factory (ADF) - Q: Explain the difference between linked services and
datasets in ADF.
A: Linked services define connections to data stores, while datasets represent data structures within
those stores.
19. Azure Data Factory (ADF) - Q: How do you handle error handling and retries in ADF?
A: Use activity-level retry settings, 'on failure' paths, custom logging, and alerts with Azure Monitor.
20. Azure Data Factory (ADF) - Q: What integration runtime types are available in ADF?
A: Azure, Self-hosted, and Azure-SSIS integration runtimes.
21. Behavioral / General - Q: Can you describe a challenging data project you worked on?
A: I led a project integrating data from multiple sources for a sales dashboard. The challenge was
inconsistent data formats, which I resolved using Power Query and SQL transformations.
22. Behavioral / General - Q: How do you ensure data quality and accuracy in your reports?
A: I perform data validation checks, use version control, conduct peer reviews, and reconcile data
with source systems.
23. Behavioral / General - Q: Have you worked with cross-functional teams? How did you
collaborate?
A: Yes, I collaborated with business and engineering teams using Agile practices, regular stand-ups,
and shared documentation.
24. Behavioral / General - Q: What steps do you take when you identify a data discrepancy?
A: Trace the data flow back to the source, validate against requirements, log findings, and
communicate with data owners.
25. Behavioral / General - Q: How do you prioritize tasks when working on multiple projects?
A: I prioritize based on deadlines, impact, and dependencies, and use tools like JIRA or Trello to
manage tasks.
26. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
27. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
28. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
29. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
30. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
31. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
32. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
33. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
34. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
35. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
36. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
37. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
38. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
39. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
40. SQL - Q: What is a common challenge in SQL and how do you handle it?
A: A common challenge in SQL is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
41. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
42. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
43. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
44. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
45. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
46. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
47. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
48. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
49. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
50. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
51. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
52. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
53. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
54. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
55. Power BI - Q: What is a common challenge in Power BI and how do you handle it?
A: A common challenge in Power BI is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
56. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
57. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
58. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
59. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
60. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
61. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
62. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
63. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
64. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
65. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
66. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
67. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
68. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
69. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
70. Excel - Q: What is a common challenge in Excel and how do you handle it?
A: A common challenge in Excel is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
71. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
72. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
73. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
74. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
75. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
76. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
77. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
78. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
79. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
80. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
81. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
82. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
83. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
84. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
85. ADF - Q: What is a common challenge in ADF and how do you handle it?
A: A common challenge in ADF is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
86. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
87. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
88. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
89. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
90. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
91. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
92. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
93. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
94. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
95. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
96. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
97. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
98. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
99. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.
100. General - Q: What is a common challenge in General and how do you handle it?
A: A common challenge in General is dealing with complex scenarios. I handle it by breaking the
problem into smaller parts, validating data at each step, and using best practices specific to the tool
or technology.