General Data Analyst interview prep
2 live roles at GrowwSQL, Excel, statistics and storytelling with data — the analyst interview for product, BI and analytics teams across India.
Typical Data Analyst interview rounds
- 1 SQL round. Joins, aggregations, window functions and query writing.
- 2 Excel / spreadsheet round. Lookups, pivot tables and formulas.
- 3 Case / analytics round. Business case: define metrics, analyse and recommend.
- 4 Tool & viz round. Power BI / Tableau dashboards and stakeholder communication.
Commonly-asked Data Analyst questions
- What is the difference between INNER JOIN, LEFT JOIN and FULL OUTER JOIN?
- Write a SQL query to find the second-highest salary in a table.
- What is the difference between WHERE and HAVING?
- Explain window functions like ROW_NUMBER(), RANK() and DENSE_RANK().
- What is the difference between mean, median and mode, and when is each misleading?
- How do you handle missing or null values in a dataset?
- Explain the difference between a primary key and a foreign key.
- What is normalisation, and why does it matter for analysis?