Common Interview Questions for Entry-Level Data Analysts

Data analyst interviews for freshers focus on SQL, analytical thinking, and communication. Unlike software engineering loops, you will rarely get algorithm puzzles. Instead, expect a SQL test, a case study or take-home dataset, and questions about how you define metrics and present findings. Companies hiring entry-level data analysts in India include fintech firms, e-commerce teams, consulting units, and SaaS product companies.

SQL: the non-negotiable skill

Most data analyst interviews include a live SQL round or a timed test. Practice these patterns until they are automatic:

• INNER JOIN vs LEFT JOIN: when to use each
• GROUP BY with HAVING filters
• Window functions: ROW_NUMBER, RANK, LAG, LEAD
• CASE WHEN for bucketing and conditional logic
• Subqueries vs CTEs for readability
• Date handling: extracting month/year, calculating differences
• Aggregations: COUNT, SUM, AVG, and handling NULLs correctly

Sample question: "Given a table of orders with user_id, order_date, and amount, find the top 3 users by total spend in the last 90 days." Follow-up: "What if we want users who made at least 2 orders?"

Use StrataScratch, DataLemur, or LeetCode Database for practice. Aim for 40 to 50 SQL problems at medium difficulty.

Excel and spreadsheet skills

Many India-based roles still test Excel or Google Sheets:

• VLOOKUP/XLOOKUP and INDEX-MATCH
• Pivot tables for quick summaries
• Basic charts and when to use bar vs line vs pie
• Conditional formatting to highlight outliers

If the job description mentions Excel, expect a practical question. Know how you would analyze a CSV export of sales data in 20 minutes.

Case study and business questions

Interviewers pose scenarios like:

• "Daily active users dropped 15% last week. How would you investigate?"
• "Define a metric for customer retention. How would you calculate it?"
• "Marketing spent more but revenue flatlined. What data would you pull?"

Use a structured approach:

1. Clarify the question and time period 2. State hypotheses (product bug, seasonality, tracking issue, market change) 3. Name the tables or data sources you would query 4. Suggest segments to compare (platform, region, user cohort) 5. Recommend next steps based on what you might find

There is often no single right answer. They evaluate how you think.

Statistics and analytics basics

Entry-level candidates should know:

• Mean vs median: when median is more appropriate
• Basic probability and conversion rates
• A/B testing concept: control group, sample size, statistical significance at a high level
• Correlation vs causation

You do not need a PhD. You need to explain concepts clearly to a non-technical stakeholder.

Communication and presentation

Some loops include: "Here is a chart. Summarize the insight in two sentences for a product manager." Practice describing trends without jargon. Bad: "The KPI showed negative momentum." Good: "Sign-ups fell 12% week over week, mostly from mobile users in tier-2 cities."

Portfolio projects that help

Build one end-to-end project and host it on GitHub:

• Download a public dataset (Kaggle, government open data)
• Clean and load it into a database or notebook
• Write 5 to 10 SQL queries that answer business questions
• Create a dashboard in Metabase, Superset, or Tableau Public
• Write a one-page summary of findings

Link this in your resume. It differentiates you from candidates who only list "SQL, Excel, Python" with no proof.

Prep timeline

• Week 1: SQL practice daily (5 problems). Review JOINs and window functions.
• Week 2: One case study per day. Build or polish one portfolio dashboard.
• Before interview: Research the company's product and prepare 2 metrics you would track if hired.

Find entry-level data analyst jobs with disclosed salary ranges on fresherGO to target roles that match your skill level.