Top Data Analyst Interview Questions 2026
Updated 28 days ago · By SkillExchange Team
Preparing for data analyst interview questions can feel overwhelming, especially with the boom in remote data analyst jobs and entry level data analyst opportunities popping up everywhere. In 2026, companies like Rightsideup, Proxima, and Highspot are hiring aggressively, with 96 open roles across the board. Salaries range from $27,000 for fresh grads to $200,000 for seniors, with a median of $112,193 USD. Whether you're eyeing data analyst jobs near me or dreaming of data analyst freelance gigs, nailing the interview is key to unlocking that data analyst entry level salary or climbing to senior data analyst salary levels.
What does a data analyst do exactly? You clean data, build dashboards, uncover insights, and help businesses make smarter decisions. Interviews test your SQL prowess, Excel wizardry, and ability to tell stories with data. Expect questions on data analyst vs data scientist (you're more focused on analysis than building models), data analyst vs business analyst (you dive deeper into data), and data analyst vs data engineer (they handle pipelines, you analyze). Fresh from a data analyst bootcamp? Build a killer data analyst portfolio with real projects to stand out in data analyst jobs remote postings.
This guide dives into 18 practical data analyst interview questions, balanced for beginner, intermediate, and advanced levels. You'll get sample answers drawn from real-world scenarios at places like Mobileye or Truveta, plus tips to shine. Pair this with strong data analyst resume examples highlighting your data analyst requirements met, and you're set for data analyst career progression from entry level to freelance data analyst jobs. Let's get you interview-ready.
What does a data analyst do exactly? You clean data, build dashboards, uncover insights, and help businesses make smarter decisions. Interviews test your SQL prowess, Excel wizardry, and ability to tell stories with data. Expect questions on data analyst vs data scientist (you're more focused on analysis than building models), data analyst vs business analyst (you dive deeper into data), and data analyst vs data engineer (they handle pipelines, you analyze). Fresh from a data analyst bootcamp? Build a killer data analyst portfolio with real projects to stand out in data analyst jobs remote postings.
This guide dives into 18 practical data analyst interview questions, balanced for beginner, intermediate, and advanced levels. You'll get sample answers drawn from real-world scenarios at places like Mobileye or Truveta, plus tips to shine. Pair this with strong data analyst resume examples highlighting your data analyst requirements met, and you're set for data analyst career progression from entry level to freelance data analyst jobs. Let's get you interview-ready.
beginner Questions
What is the difference between a pivot table and a regular table in Excel?
beginnerA regular table in Excel is just a grid of data, like sales records with columns for date, product, and amount. A pivot table lets you summarize that data dynamically. For example, in a sales dataset, you can drag 'product' to rows, 'date' to columns, and 'amount' to values to get totals by product and month without formulas. It's great for quick insights in entry level data analyst roles.
Tip: Practice building pivot tables with sample sales data. Mention how they save time in remote data analyst jobs where quick reporting is key.
Explain what SQL is and why it's essential for data analysts.
beginnerSQL stands for Structured Query Language. It's used to query and manipulate relational databases. For data analysts, it's essential because most company data lives in databases like PostgreSQL or MySQL. You use it for tasks like filtering customer orders with
SELECT * FROM orders WHERE date > '2025-01-01', aggregating sales, or joining tables from marketing and sales for insights.Tip: Relate it to data analyst requirements. Practice basic queries on free sites like LeetCode or HackerRank.
How do you handle missing values in a dataset?
beginnerFirst, I assess why data is missing: random, systematic, or at random. For numerical data, I might impute with mean or median using pandas:
df['column'].fillna(df['column'].median(), inplace=True). For categorical, mode or 'Unknown'. If it's a lot, I flag it for stakeholders. In a real retail dataset, I dropped rows with missing revenue only after confirming it didn't bias results.Tip: Show a step-by-step process. Interviewers love seeing you think about data quality in data analyst portfolio projects.
What is the difference between COUNT, COUNT(*), and COUNT(DISTINCT)?
beginnerCOUNT(column) counts non-null values in that column. COUNT(*) counts all rows, including nulls. COUNT(DISTINCT column) counts unique non-null values. Example: In a users table,
COUNT(email) ignores null emails, COUNT(*) counts all users, COUNT(DISTINCT city) gives unique cities.Tip: Run these on sample data. Crucial for accurate metrics in data analyst jobs near me.
Describe a time you used Excel for data analysis.
beginnerIn my last role at a startup like Coefficient, I analyzed customer churn. I used VLOOKUP to match customer IDs across sheets, pivot tables for monthly trends, and conditional formatting to highlight high-risk accounts. This revealed a 15% churn spike tied to support tickets, leading to process changes.
Tip: Use STAR method (Situation, Task, Action, Result). Tailor to entry level data analyst experiences.
What are primary and foreign keys in a database?
beginnerA primary key uniquely identifies each row in a table, like
user_id in users table. It can't be null or duplicate. A foreign key in another table references the primary key, enforcing relationships, like order.user_id linking to users.user_id. This prevents orphans in joins.Tip: Draw a quick ER diagram on paper. Key for understanding data structures in interviews.
intermediate Questions
Write a SQL query to find the second highest salary in an employees table.
intermediateSELECT MAX(salary) AS second_highest
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);Tip: Know window functions alternative:
SELECT DISTINCT salary FROM (SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) as rnk FROM employees) WHERE rnk=2. Practice variations.How would you create a dashboard in Tableau for sales performance?
intermediateConnect to data source, drag measures like sales to rows, dimensions like region to columns. Add filters for date/product. Use calculated fields for YoY growth:
(SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / ABS(LOOKUP(SUM([Sales]), -1)). Add trend lines, maps. At Truveta, I built one showing regional KPIs updated daily.Tip: Mention interactivity. Build a sample dashboard for your data analyst portfolio.
Explain INNER JOIN vs LEFT JOIN with an example.
intermediateINNER JOIN returns only matching rows from both tables. LEFT JOIN returns all from left table, nulls for non-matches on right. Example:
SELECT u.name, o.amount FROM users u LEFT JOIN orders o ON u.id = o.user_id gets all users and their orders (null if none). Crucial for complete views in analysis.Tip: Visualize with Venn diagrams. Test with small datasets to see differences.
What is normalization in databases, and why do it?
intermediateNormalization reduces redundancy by splitting data into related tables, following rules like 1NF (atomic values), 2NF (no partial dependencies), 3NF (no transitive dependencies). Example: Split customer and orders to avoid repeating addresses. It saves storage, ensures integrity, but can slow queries needing many joins.
Tip: Know when to denormalize for performance in data warehouses.
How do you perform a cohort analysis in Python?
intermediateUsing pandas: Group users by signup month cohort, then retention by period.
cohort_data = df.groupby(['cohort_month', 'period'])['user_id'].nunique()
cohort_data = cohort_data.groupby(level=0).apply(lambda x: x / x.iloc[0])Tip: Reference libraries like pandas. Share a GitHub link in your data analyst resume examples.
Describe A/B testing and how you'd analyze results.
intermediateA/B testing compares two variants (A control, B treatment) on a metric like conversion rate. Analyze with t-test for significance: null hypothesis no difference. Use
scipy.stats.ttest_ind(control, treatment). Check p-value <0.05. In e-commerce, I tested button colors, found 10% lift with 95% confidence.Tip: Discuss sample size, power. Relate to business impact for data analyst vs business analyst questions.
advanced Questions
How would you detect outliers in a dataset using Python?
advancedUse IQR method: Q1 = 25th percentile, Q3=75th, IQR=Q3-Q1. Outliers < Q1-1.5*IQR or > Q3+1.5*IQR.
Q1 = df['col'].quantile(0.25)
Q3 = df['col'].quantile(0.75)
IQR = Q3 - Q1
outliers = df[(df['col'] < Q1 - 1.5*IQR) | (df['col'] > Q3 + 1.5*IQR)]Tip: Explain business context: remove or investigate? Key for senior data analyst salary roles.
Explain window functions in SQL with an example.
advancedWindow functions compute over a set of rows without collapsing like GROUP BY. Example: Running total sales:
SELECT date, sales, SUM(sales) OVER (ORDER BY date ROWS UNBOUNDED PRECEDING) as running_total FROM sales. PARTITION BY for per-group. Used at Highspot for leaderboard rankings.Tip: Master ROWS vs RANGE. Practice on Mode Analytics datasets.
How do you optimize a slow-running SQL query?
advanced1. EXPLAIN the plan for indexes/joins. 2. Add indexes on WHERE/JOIN columns. 3. Limit rows with WHERE early. 4. Avoid SELECT *. 5. Use CTEs for complex logic. Real scenario: Indexed
user_id, reduced 10min query to 5s at Array.Tip: Talk indexes, partitioning. Show query before/after.
What is ETL, and how have you implemented it?
advancedETL: Extract from sources, Transform (clean, aggregate), Load to warehouse. Used Airflow for pipeline: Extract CSV/API, transform in pandas (dedupe, type conversions), load to Snowflake. Scheduled daily for marketing data at Ventricle Health, handling 1M rows.
Tip: Mention tools like dbt, Airflow. Ties into data analyst vs data engineer.
Design a schema for a ride-sharing app like Uber.
advancedTables: Users (id PK, name, email), Drivers (id PK, user_id FK), Rides (id PK, driver_id FK, passenger_id FK, start_loc, end_loc, fare, status), Payments (ride_id FK, amount). Indexes on locations for queries. Denormalize for speed with ride_status summary table.
Tip: Think scalability, relationships. Sketch on whiteboard.
How would you forecast sales using time series in Python?
advancedUse Prophet or ARIMA. With Prophet:
from prophet import Prophet
m = Prophet()
m.fit(df)
future = m.make_future_dataframe(periods=30)
forecast = m.predict(future)Tip: Discuss assumptions, validation. Differentiates data analyst vs data scientist.
Preparation Tips
1
Build a data analyst portfolio with 3-5 projects showcasing SQL, Python, and Tableau. Include GitHub links on your resume for remote data analyst jobs.
2
Practice data analyst interview questions on LeetCode, StrataScratch, and mock interviews. Time yourself for SQL queries.
3
Tailor your data analyst resume examples to job descriptions, quantifying impacts like 'Reduced report time by 40%'.
4
Learn company-specific tools; research top companies like Mobileye or Truveta before interviews.
5
Prepare behavioral stories using STAR for data analyst career progression questions.
Common Mistakes to Avoid
Not explaining your thought process; always talk aloud during technical questions.
Forgetting edge cases in SQL, like NULLs or duplicates.
Over-relying on tools without understanding basics, e.g., memorizing without knowing why pivot tables work.
Ignoring business context; always tie analysis to impact.
Poor communication; practice explaining complex insights simply.
Related Skills
SQL and database queryingPython or R for data manipulationExcel and Google Sheets advanced functionsTableau or Power BI for visualizationStatistics and hypothesis testingETL processes and data pipelinesBusiness acumen and storytelling
Top Companies Hiring Data Analyst Professionals
Explore More About Data Analyst
Frequently Asked Questions
What is the data analyst entry level salary in 2026?
Entry level data analyst salaries start around $27,000-$60,000 USD, with median at $112,193 overall. Seniors can hit $200,000 in high-demand remote data analyst jobs.
How do I prepare for data analyst bootcamp interviews?
Focus on basics: SQL selects/joins, Excel pivots, simple stats. Build quick projects for your portfolio.
Data analyst vs data scientist: key differences?
Data analysts focus on descriptive analytics and reporting; data scientists build predictive models and ML.
Are there many data analyst jobs remote available?
Yes, with 96 openings now at companies like Proxima and The Daily Wire, remote roles are plentiful.
How to stand out in senior data analyst interviews?
Demonstrate advanced SQL, forecasting, schema design, and business impact stories.
Ready to take the next step?
Find the best opportunities matching your skills.