Data Analysis Interview Questions by Tool
Excel / Google Sheets Interview Questions
- What is a pivot table? How would you use it for sales data?
- Explain the difference between VLOOKUP, HLOOKUP, and INDEX-MATCH.
- How would you handle duplicate values in a dataset?
- What is conditional formatting, and how have you used it?
- How do you use IF, AND, OR, and nested formulas?
- How do you create dynamic charts or dashboards in Excel?
- What is the difference between absolute and relative cell references?
- What is the use of the TEXT and DATE functions in Excel?
- How would you use Excel to identify trends in monthly data?
- What are slicers in pivot tables?
SQL Interview Questions
- What is the difference between WHERE and HAVING?
- Write a query to find the top 5 highest-paid employees.
- What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
- Write a SQL query to count the number of orders placed in each month.
- How do you remove duplicates using SQL?
- What is a subquery? Can you give an example?
- How would you find NULL values in a column?
- What are window functions? (e.g., RANK(), ROW_NUMBER())
- How do you optimize a slow SQL query?
- Explain primary key vs foreign key.
Python for Data Analysis (pandas, matplotlib, seaborn)
- What is pandas? How do you read a CSV file using it?
- How do you check for and handle missing values in pandas?
- What is the difference between .loc[] and .iloc[]?
- How do you group data and calculate aggregate statistics? (groupby)
- How do you merge/join two DataFrames?
- How do you filter rows based on conditions in pandas?
- How do you plot a histogram or bar chart using matplotlib or seaborn?
- What are some common methods to clean data in Python?
- How do you convert a column's data type in pandas?
- What is the use of describe() and info() in pandas?
Power BI Interview Questions
- What are the different types of visualizations in Power BI?
- What is DAX? Can you write a basic DAX formula?
- What is the difference between a calculated column and a measure?
- How do you create relationships between tables in Power BI?
- What are slicers, and how do you use them?
- How do you publish a Power BI report?
- What is Power Query, and how is it used?
- Explain filters: visual-level vs page-level vs report-level.
- How do you handle large datasets in Power BI?
- What is the use of bookmarks in Power BI dashboards?
Tableau Interview Questions
- What is the difference between live and extract connections in Tableau?
- What is a calculated field? Can you give an example?
- How do you create a dual-axis chart?
- What is the difference between a worksheet, dashboard, and story in Tableau?
- Explain the order of operations in Tableau.
- How do you create a hierarchy?
- What are filters, and how do they work?
- How would you show trends over time in Tableau?
- What is a context filter?
- Can you explain what LOD (Level of Detail) expressions are?
