Role guide
Analyst interviews are SQL-first, then a business case where they check whether you can turn a number into a decision.
Why they ask: The single most-asked analyst SQL question in India.
How to answer: Show the DENSE_RANK window-function version and mention the subquery alternative plus the duplicate-salary edge case.
Why they ask: Tests structured thinking under ambiguity.
How to answer: Rule out tracking and data-pipeline issues first, then segment by platform, geography, version and new vs returning, then look for a release or outage.
Why they ask: A fast filter for whether you actually write SQL.
How to answer: WHERE filters rows before aggregation, HAVING filters after grouping. Give a one-line example of each.
Why they ask: Analysts who pick charts by habit produce dashboards nobody reads.
How to answer: Match chart to question: comparison, composition, distribution, trend or relationship. Mention one dashboard you simplified.
Why they ask: Real analyst work is defending a definition, not writing a query.
How to answer: Align on the metric definition and date range first, walk them through the source, and agree a single source of truth going forward.
Interview Copilot generates the remaining 20 questions for Data Analyst from your own resume, runs a mock interview by voice or text, scores each answer on structure, relevance and specificity, and rewrites a stronger version. New accounts start with 60 free credits.
