Data Analytics Interview Questions & Answers
All 414 unique questions in one place — 115 easy, 214 medium, 85 hard — grouped by topic.
Practise by topic
Practise the way your interview works
SUMIFS vs COUNTIFS?
Show answer
What is the difference between COUNT, COUNTA and COUNTIF?
Show answer
VLOOKUP vs INDEX-MATCH vs XLOOKUP?
Show answer
What is a pivot table and when do you use it?
Show answer
What does the IF function do and how do you nest it?
Show answer
How do you remove duplicates in Excel?
Show answer
What is conditional formatting?
Show answer
Your FILTER formula shows #SPILL! instead of results. Why, and how do you fix it?
Show answer
Write Excel formulas to get a sorted list of unique customer names and their count.
Show answer
How do you combine text from several cells with a separator in Excel?
Show answer
What are named ranges in Excel and why are they useful?
Show answer
How do you calculate working days between two dates in Excel, excluding holidays?
Show answer
What does Flash Fill do in Excel, and when should you not rely on it?
Show answer
Tell me about a time you found an error in someone else's spreadsheet.
Show answer
What is a PivotTable and when do you use it?
Show answer
What is the difference between a table and a normal range?
Show answer
How do you remove duplicates in Excel but keep the latest record?
Show answer
What is the difference between Goal Seek and Solver?
Show answer
What are absolute and relative cell references?
Show answer
Explain INDEX and MATCH together.
Show answer
How do you create a dynamic dashboard in Excel?
Show answer
How do you handle errors like #N/A and #DIV/0!?
Show answer
How do SUMIFS and SUMPRODUCT differ?
Show answer
What is the difference between a calculated field and a helper column in Excel?
Show answer
What do the match_mode and search_mode arguments of XLOOKUP control?
Show answer
How does the FILTER function work in Excel? Write a formula to list all North region orders.
Show answer
What is the LET function in Excel and why would you use it?
Show answer
What is Power Pivot and the Excel Data Model?
Show answer
Write an Excel formula to put invoices into ageing buckets (0-30, 31-60, 61-90, 90+ days).
Show answer
What is a Data Table in Excel's What-If Analysis?
Show answer
You share a forecasting workbook and users keep overwriting formulas. How do you protect it?
Show answer
Tell me about a time you automated a manual Excel task.
Show answer
Write an Excel formula to look up a price using two criteria, product and city.
Show answer
You inherit a monthly Excel report and suspect some numbers are hard-typed over formulas. How do you audit it?
Show answer
How would you reconcile two large lists in Excel?
Show answer
Your workbook has 200,000 rows and hundreds of VLOOKUPs and takes minutes to recalculate. What do you do?
Show answer
What is the LAMBDA function in Excel and when would you use it?
Show answer
What is Power BI and its main components?
Show answer
What are slicers and filters?
Show answer
What is a date table in Power BI and why should you mark it as one?
Show answer
What is the difference between Power BI Desktop, Power BI Service and Power BI Report Server?
Show answer
A profit margin visual shows errors for products with zero sales. How do you fix it in DAX?
Show answer
How do you improve Power BI report performance?
Show answer
What is Row-Level Security?
Show answer
Explain time intelligence functions.
Show answer
What does the CALCULATE function do?
Show answer
Import mode vs DirectQuery?
Show answer
What is Power Query's role in Power BI?
Show answer
What is a gateway in Power BI?
Show answer
What is DAX and how does it differ from Excel formulas?
Show answer
What are relationships and cardinality in Power BI?
Show answer
Explain row context and filter context.
Show answer
What is Power Query and why is it useful?
Show answer
DAX: calculated column vs measure?
Show answer
What are bookmarks and drill-through in Power BI?
Show answer
What is a star schema?
Show answer
What is the difference between SUM and SUMX in DAX?
Show answer
Tell me about a time requirements kept changing on a report you were building.
Show answer
Write a DAX measure for year-over-year sales growth percentage.
Show answer
Write a DAX measure for cumulative sales from the start of the data to the selected date.
Show answer
What is bidirectional cross-filtering in Power BI and when is it risky?
Show answer
What are variables (VAR) in DAX and why are they useful?
Show answer
What is a dataflow in Power BI?
Show answer
What are field parameters in Power BI?
Show answer
A stakeholder says the Power BI report shows different revenue than their Excel file. How do you troubleshoot?
Show answer
What is the difference between a calculated table in DAX and a table created in Power Query?
Show answer
A measure shows correct values per row in a table visual, but the grand total looks wrong. Why, and how do you fix it?
Show answer
Users say a Power BI report still shows yesterday morning's data, although a refresh is scheduled every few hours. What do you check?
Show answer
What does CALCULATE do in DAX?
Show answer
What is the difference between ALL, ALLEXCEPT and REMOVEFILTERS in DAX?
Show answer
What is a composite model in Power BI?
Show answer
Your Power BI dataset with five years of transactions takes two hours to refresh. How would you fix it?
Show answer
Two tables have a many-to-many relationship and your report totals look inflated. What do you do?
Show answer
Your Sales table has OrderDate and ShipDate. How do you analyse sales by ship date when only OrderDate is the active relationship?
Show answer
Your manager wants a visual that always shows the top 5 products for whatever region is selected in a slicer. How do you build it?
Show answer
Write a DAX measure that counts new customers, meaning customers who bought in the selected period but never before it.
Show answer
Tell me about a time you handled a request for access to sensitive data.
Show answer
How do you read a CSV and inspect it in Pandas?
Show answer
How do you deal with missing or duplicate data?
Show answer
Show a Pandas groupby example.
Show answer
Which Python libraries do analysts use most?
Show answer
What is the difference between loc and iloc in pandas?
Show answer
What is the difference between a list, tuple, dictionary and set in Python?
Show answer
What is the difference between concat, merge and join in pandas?
Show answer
What is the difference between pd.cut and pd.qcut?
Show answer
What is a lambda function in Python and where do analysts use it?
Show answer
Write pandas code to extract month name, weekday and hour from a timestamp column.
Show answer
Tell me about a time you had to learn a new tool or library quickly for a project.
Show answer
What does value_counts do in pandas, and how do you show percentages instead of counts?
Show answer
What is a virtual environment in Python and why should analysts use one?
Show answer
How do you merge two DataFrames on different column names?
Show answer
What is vectorisation and why does it matter?
Show answer
How do you detect outliers?
Show answer
How do you handle outliers in Pandas?
Show answer
How do you create a new column from conditions?
Show answer
How do you change data types and parse dates?
Show answer
How do you handle large CSV files that do not fit in memory in Python?
Show answer
How do you connect Python to a SQL database?
Show answer
Explain Matplotlib vs Seaborn.
Show answer
What is the difference between melt and pivot?
Show answer
What does apply do in pandas and why can it be slow?
Show answer
Write pandas code to calculate monthly revenue from an orders DataFrame.
Show answer
Write pandas code for a pivot table of sales by region and category with sum and count.
Show answer
What is method chaining in pandas and why is it useful?
Show answer
Write pandas code to compute month-on-month percentage change and cumulative sales for each store.
Show answer
Your pandas script shows SettingWithCopyWarning and a new column does not update. What is happening and how do you fix it?
Show answer
What is broadcasting in NumPy?
Show answer
Write a Python function that reads all Excel files in a folder and combines them into one DataFrame.
Show answer
Write pandas code to find the top 2 products by revenue in each region.
Show answer
Your scheduled Python report failed silently and nobody noticed for a week. How do you make it reliable?
Show answer
Write pandas code to convert daily sales into weekly totals, showing zero for days with no sales.
Show answer
How would you automate a weekly report with Python?
Show answer
Your pandas script takes 40 minutes on 10 million rows. How do you speed it up?
Show answer
Write Python code to fit a simple linear regression of sales on ad spend.
Show answer
When would you choose Polars or DuckDB over pandas?
Show answer
What is the difference between WHERE and HAVING?
Show answer
INNER JOIN vs LEFT JOIN — with an example.
Show answer
Find the second highest salary in SQL.
Show answer
What is a primary key vs a foreign key?
Show answer
What is the difference between DELETE, TRUNCATE and DROP?
Show answer
Explain the types of SQL joins.
Show answer
What do COALESCE and NULLIF do in SQL?
Show answer
What is the difference between a fact table and a dimension table?
Show answer
What is the difference between COUNT(*), COUNT(column) and COUNT(DISTINCT column)?
Show answer
Write SQL to count orders by week and by day of week.
Show answer
What is the difference between a primary key and a unique constraint?
Show answer
A report filters WHERE order_date = '2026-03-31' and misses almost all orders from that day. Why?
Show answer
RANK vs DENSE_RANK vs ROW_NUMBER?
Show answer
How do you calculate a running total?
Show answer
Difference between UNION and UNION ALL?
Show answer
What is a window function?
Show answer
Explain GROUP BY with an example.
Show answer
What is a self join and when is it used?
Show answer
What are indexes and when can they hurt?
Show answer
Write SQL for a running total of sales by date.
Show answer
What is normalisation?
Show answer
What is the difference between a clustered and a non-clustered index?
Show answer
What is a CTE and when would you use one?
Show answer
What is a CTE and why use it?
Show answer
What does CASE WHEN do?
Show answer
What is the difference between a view and a materialised view?
Show answer
How do you calculate a rolling average?
Show answer
How are NULLs handled in SQL?
Show answer
Difference between a CTE, a subquery and a temp table?
Show answer
How do you find duplicate rows in a table?
Show answer
How would you find customers who never placed an order?
Show answer
What is the logical order in which SQL executes a SELECT query?
Show answer
Write SQL using LAG to compare each month's revenue with the previous month.
Show answer
Write SQL to show each category's percentage share of total revenue.
Show answer
Your NOT IN query unexpectedly returns zero rows. Why might that happen, and how do EXISTS and IN differ?
Show answer
What is a correlated subquery?
Show answer
After joining orders to payments, your revenue total doubles. What went wrong?
Show answer
How do you pivot rows into columns in SQL, for example sales by quarter as columns?
Show answer
Tell me about a time a query you wrote produced wrong results.
Show answer
What is a transaction and what do the ACID properties mean?
Show answer
What is the difference between a data warehouse, a data lake and a lakehouse?
Show answer
Write SQL to find the median order value overall and per city.
Show answer
Many reporting queries in your team use SELECT DISTINCT to remove duplicate rows. What is the risk?
Show answer
Write SQL to find the number of days between each customer's consecutive orders and their average gap.
Show answer
How would you calculate retention using SQL?
Show answer
How do you optimise a slow SQL query?
Show answer
Find customers who ordered in January but not in February.
Show answer
Write SQL to find the top 3 products by revenue within each category.
Show answer
What is a query execution plan and how do you read it?
Show answer
What is a slowly changing dimension? Explain Type 1 and Type 2.
Show answer
Write SQL to find users who logged in on at least 3 consecutive days.
Show answer
What is descriptive vs inferential statistics?
Show answer
What is the difference between population and sample?
Show answer
Mean vs median vs mode — when do you use which?
Show answer
What are variance and standard deviation?
Show answer
What is a z-score and how is it used?
Show answer
Why does correlation not imply causation? Give a business example.
Show answer
What is a percentile and what is the interquartile range?
Show answer
What is the normal distribution and the 68-95-99.7 rule?
Show answer
What is regression to the mean? Give a business example.
Show answer
How do you decide the sample size for a survey?
Show answer
What is the difference between mean and median for reporting salaries?
Show answer
Sales dropped 20% last month. How will you analyse it?
Show answer
How do you detect and handle skewed data?
Show answer
Explain correlation vs regression.
Show answer
How would you investigate a sudden 20% drop in daily sales?
Show answer
What is statistical significance vs practical significance?
Show answer
What is cohort analysis?
Show answer
What is hypothesis testing in simple words?
Show answer
What is a p-value, explained simply?
Show answer
What are Type I and Type II errors?
Show answer
What is a confidence interval?
Show answer
What is the Central Limit Theorem and why does it matter for analysts?
Show answer
Checkout conversion fell from 3.2% to 2.6% the week after an app release. How do you investigate?
Show answer
Tell me about a time you used data to challenge an assumption.
Show answer
When do you use a chi-square test?
Show answer
What is the difference between a t-test and a z-test?
Show answer
Estimate how many cups of tea are sold in a city of 1 crore people in a day.
Show answer
What is sampling bias? Name common types.
Show answer
Average delivery time improved by 4 minutes, but customer complaints about late deliveries went up. How do you investigate?
Show answer
How would you segment customers?
Show answer
A marketing campaign shows more sales. How do you prove it worked?
Show answer
Explain funnel analysis.
Show answer
How would you design an A/B test for a new checkout button?
Show answer
What is Simpson's paradox? Give an example.
Show answer
A retail chain asks you which of its 120 stores it should close. How do you approach it?
Show answer
How do you calculate a simple customer lifetime value?
Show answer
An A/B test shows a 2% lift with p = 0.04, but it only ran for 3 days. Would you ship it?
Show answer
What is Tableau and what are its main products?
Show answer
What is the difference between dimensions and measures in Tableau?
Show answer
What is the difference between discrete and continuous fields in Tableau?
Show answer
What is the difference between a live connection and an extract in Tableau?
Show answer
How do you create a dual-axis chart in Tableau, for example sales bars with a profit margin line?
Show answer
Write a Tableau calculated field for profit ratio and a profit category.
Show answer
What is Tableau Prep used for?
Show answer
What is a story in Tableau?
Show answer
How do you handle null values in Tableau calculations?
Show answer
Your Tableau map shows a large number of unknown locations. How do you fix it?
Show answer
What is the difference between relationships, joins and data blending in Tableau?
Show answer
Write a Tableau calculation to find each customer's first purchase date and flag new versus repeat orders.
Show answer
What are table calculations in Tableau?
Show answer
What are parameters in Tableau and how do you use them?
Show answer
What is the difference between sets and groups in Tableau?
Show answer
Your Top 10 products filter in Tableau ignores the category filter. Why, and how do you fix it?
Show answer
What types of dashboard actions does Tableau offer?
Show answer
Write a Tableau table calculation for year-over-year sales growth.
Show answer
How do you let users choose Top N customers with a parameter in Tableau?
Show answer
Tell me about a time you migrated or rebuilt reports in a new BI tool.
Show answer
Tell me about a time you had to prioritise several dashboard requests at once.
Show answer
A stakeholder wants a 40-column crosstab in Tableau that looks exactly like their Excel sheet. How do you handle it?
Show answer
What is the difference between extract filters and data source filters in Tableau?
Show answer
Why would you publish a Tableau data source separately instead of embedding it in each workbook?
Show answer
Write a Tableau calculated field that keeps only sales from the last 30 days.
Show answer
Tell me about a time a stakeholder rejected your first dashboard design.
Show answer
Explain FIXED, INCLUDE and EXCLUDE LOD expressions in Tableau.
Show answer
What is the order of operations in Tableau and why does it matter?
Show answer
A Tableau dashboard takes 30 seconds to load. How do you make it faster?
Show answer
How do you implement row-level security in Tableau?
Show answer
Your Tableau numbers change unexpectedly when a filter is applied to a view that uses a FIXED LOD. Why?
Show answer
Tableau or Power BI: how would you decide which one a team should use?
Show answer
What is data cleaning and why does it take so much of an analyst's time?
Show answer
Numbers in an Excel column are stored as text and SUM returns zero. How do you fix it?
Show answer
Write pandas code to trim whitespace and lower-case every text column in a DataFrame.
Show answer
What is data profiling?
Show answer
How do you unpivot a wide monthly sales sheet into a long table in Power Query?
Show answer
What is tidy data?
Show answer
How do you split a full name column into first and last name in Excel?
Show answer
Pin codes in your CSV lost their leading zeros after opening in Excel. Why and how do you prevent it?
Show answer
How do you handle a dataset with 30% missing values in a key column?
Show answer
How do you clean messy text data in Excel?
Show answer
What are the main dimensions of data quality?
Show answer
Write pandas code to standardise inconsistent city names such as 'delhi ', 'New Delhi' and 'DELHI'.
Show answer
When would you drop missing values, and when would you impute with mean or median?
Show answer
A file has dates in mixed formats, some dd/mm/yyyy and some mm/dd/yyyy. How do you handle it?
Show answer
Write SQL to flag rows that fail basic validation rules in a customer table.
Show answer
What is the difference between an outlier and a data error?
Show answer
What steps would you apply in Power Query to clean a messy system export?
Show answer
An inner join between orders and customers returns fewer orders than the orders table has. What could be wrong?
Show answer
How should you document data cleaning decisions?
Show answer
Write Python code to extract valid 10-digit Indian mobile numbers from a messy text column.
Show answer
Customer names in your file show strange characters like 'é' instead of accented letters. What is wrong and how do you fix it?
Show answer
Tell me about a time you found a serious data quality issue.
Show answer
Your sales data contains negative quantities. What do you do with them?
Show answer
Write pandas code to fill missing values in a column with the median of each group.
Show answer
What is referential integrity and how do orphan records appear in analytics data?
Show answer
Your event logs store timestamps in UTC, but the business reports daily sales in IST, and late-night orders land on the wrong day. How do you fix it?
Show answer
What are MCAR, MAR and MNAR missing data?
Show answer
The customer table has near-duplicates like 'Rahul Sharma, 98xxxx1234' and 'Rahul Sharma, +91 98xxxx1234'. How do you deduplicate?
Show answer
You loaded a month of sales into the warehouse. How do you check the load is complete and correct?
Show answer
Sales data from different countries mixes currencies and some weights are in grams while others are in kilograms. How do you handle it?
Show answer
The column names in a monthly vendor file keep changing. How do you make your cleaning pipeline robust?
Show answer
Where should data cleaning happen: Excel, SQL, Python or Power Query?
Show answer
How can you automate data quality checks in a reporting pipeline?
Show answer
What is the difference between a metric and a KPI?
Show answer
What is a north star metric?
Show answer
What are strategic, operational and analytical dashboards?
Show answer
How should you lay out a dashboard page?
Show answer
What are vanity metrics?
Show answer
How do you show actual versus target on a dashboard?
Show answer
What is RAG status and how should thresholds be set?
Show answer
Tell me about a time you were at risk of missing a reporting deadline.
Show answer
A KPI on the leadership dashboard jumps 35% overnight. Before anyone celebrates, what do you check?
Show answer
How do you calculate month-over-month growth?
Show answer
What is the difference between a dashboard and a report?
Show answer
Which KPIs would you track for an e-commerce app?
Show answer
How do you define and choose KPIs?
Show answer
What are leading and lagging indicators? Give examples.
Show answer
A stakeholder wants 20 more visuals added to an already crowded dashboard page. How do you respond?
Show answer
Which KPIs would you include in an HR attrition dashboard?
Show answer
What KPIs would you track for a customer support call centre?
Show answer
You launched a dashboard a month ago and usage logs show almost nobody opens it. What do you do?
Show answer
Tell me about a time you had to say no to a stakeholder's request.
Show answer
Write a DAX measure for a KPI card showing achievement against target and a colour for conditional formatting.
Show answer
A manager asks for a dashboard that refreshes every minute. How do you decide the right refresh frequency?
Show answer
How do you make a dashboard accessible, for example for colour-blind users?
Show answer
What questions do you ask a stakeholder before building a dashboard?
Show answer
Tell me about a time a dashboard you built changed a business decision.
Show answer
Why do ratio metrics need extra care on a dashboard compared with count metrics?
Show answer
Tell me about a time you defined a new metric for a team.
Show answer
Tell me about a time you retired or consolidated reports that nobody used.
Show answer
Design a dashboard for CXOs — what principles do you follow?
Show answer
How would you design a sales dashboard for executives?
Show answer
How do you make sure a metric like active customer means the same thing across all teams?
Show answer
The finance dashboard and the sales dashboard show different revenue for last month. How do you resolve it?
Show answer
Write SQL to calculate monthly customer churn rate.
Show answer
What is a KPI tree and how does it help analysis?
Show answer
Business teams have built hundreds of their own reports, each with its own revenue logic. How do you balance self-service with governed dashboards?
Show answer
Write SQL to calculate daily active users and the DAU/MAU stickiness ratio.
Show answer
How do you choose the right chart?
Show answer
What is data storytelling?
Show answer
What is a good structure for a data story?
Show answer
A stakeholder asks for a pie chart of 12 product categories. When is a pie chart acceptable, and what would you suggest?
Show answer
What are pre-attentive attributes and how do you use them in charts?
Show answer
How do you declutter a chart?
Show answer
How can a chart mislead even when the numbers are correct?
Show answer
Tell me about a time you worked with messy data under a tight deadline.
Show answer
Why do you want to work as a data analyst?
Show answer
How do you present insights to non-technical stakeholders?
Show answer
What is an action title and why should you use one?
Show answer
During a review, an executive asks a question about your numbers that you cannot answer on the spot. What do you do?
Show answer
How would you present the same churn analysis to the CEO and to the customer support team?
Show answer
How would you write a short email summarising an analysis for a manager?
Show answer
Your findings deck has 30 slides and you have 10 minutes with leadership. How do you cut it down?
Show answer
Tell me about a time your analysis was challenged in a meeting.
Show answer
Tell me about a time you found a mistake in a report after it had already been shared.
Show answer
Tell me about a time you disagreed with your manager about how to measure something.
Show answer
You must present to the sales team that they missed their quarterly target by 18%. How do you handle it?
Show answer
Tell me about a time you had to present findings when the data was incomplete.
Show answer
Your analysis shows that a flagship initiative championed by leadership is not working. How do you present it?
Show answer
What is the pyramid principle and how does it apply to presenting analysis?
Show answer
Leadership wants a single revenue number for next quarter, but your forecast is uncertain. How do you present it?
Show answer
A senior stakeholder insists the data supports their conclusion, but your analysis does not. How do you handle it?
Show answer
Describe a time you influenced a decision without having formal authority.
Show answer
Tell me about a time you mentored or guided a junior analyst.
Show answer
What is dimensional modelling?
Show answer
What is a snowflake schema and when would you choose it over a star schema?
Show answer
What is the difference between a surrogate key and a natural key?
Show answer
What is a degenerate dimension?
Show answer
What is the difference between ETL and ELT?
Show answer
What is the difference between OLTP and OLAP systems?
Show answer
Write a CREATE TABLE statement for a sales fact table linked to date, product and store dimensions.
Show answer
What is a data mart?
Show answer
What is the grain of a fact table and why should you decide it first?
Show answer
What are additive, semi-additive and non-additive facts?
Show answer
What is a conformed dimension?
Show answer
What is a role-playing dimension?
Show answer
Write SQL to generate a simple date dimension for 2026.
Show answer
Orders arrive in the warehouse with customer IDs that do not exist yet in the customer dimension. What do you do?
Show answer
A query on a 2-billion-row fact table in a cloud warehouse scans the whole table even when you filter one week. How do you fix it?
Show answer
What is columnar storage and why do analytical warehouses use it?
Show answer
What is the medallion architecture (bronze, silver, gold)?
Show answer
A junior analyst wants to load one huge flat table with every column into Power BI instead of a star schema. How do you advise them?
Show answer
Tell me about a time you designed or improved a data model.
Show answer
What is a junk dimension?
Show answer
What is a factless fact table? Give an example.
Show answer
What are transaction, periodic snapshot and accumulating snapshot fact tables?
Show answer
What is an enterprise bus matrix?
Show answer
Write SQL to get each order's customer city as it was on the order date, using an SCD Type 2 customer dimension.
Show answer
What is a bridge table and when do you need one?
Show answer
Write SQL to incrementally load new and changed products into a dimension using MERGE.
Show answer
Leadership wants sales by store manager, but managers move between stores every few months. How would you model it?
Show answer
Actual sales are at order-line level but targets are set per region per month. How do you model them together?
Show answer
What is an A/B test and why is random assignment so important?
Show answer
How do you write a good hypothesis for an experiment?
Show answer
What are primary metrics and guardrail metrics in an A/B test?
Show answer
What are novelty and primacy effects in experiments?
Show answer
Write SQL to calculate users, conversions and conversion rate for each test variant.
Show answer
When would you use a one-tailed test instead of a two-tailed test?
Show answer
What is a holdout group and why do teams keep one?
Show answer
What is the difference between an A/B test, an A/B/n test and a multivariate test?
Show answer
Your A/B test ends with no significant difference. How do you report it?
Show answer
What are statistical power and minimum detectable effect (MDE)?
Show answer
Write Python code to calculate the sample size per group for a conversion test with a 4% baseline and a 10% relative lift.
Show answer
What is the unit of randomisation in an experiment, and how do you choose it?
Show answer
What is an A/A test and why would you run one?
Show answer
Write Python code to test whether conversion differs between control and treatment.
Show answer
Your test increased conversion rate by 3% but average order value dropped by 5%. What do you recommend?
Show answer
On day 4 of a planned 14-day test, the product manager wants to stop because the dashboard shows treatment winning. What do you say?
Show answer
Tell me about a time an experiment result went against what the team expected.
Show answer
Marketing wants to A/B test two email subject lines on a list of 2,000 subscribers. What do you advise?
Show answer
What is the peeking problem in A/B testing?
Show answer
Your 50/50 test has 52,400 users in control and 47,600 in treatment. What does this tell you?
Show answer
Why is testing many metrics or many variants at once a problem, and how do you handle it?
Show answer
Why are A/B tests tricky in two-sided marketplaces such as ride-hailing or food delivery?
Show answer
An A/B test is flat overall but significant for mobile users in Tier 2 cities. Do you ship it only for that segment?
Show answer
What is the difference between frequentist and Bayesian A/B testing?
Show answer
What is CUPED and how does it speed up experiments?
Show answer
How do you measure impact when a proper A/B test is not possible?
Show answer
Write Python code for a simple difference-in-differences estimate of a store pilot.
Show answer
Write Python code to bootstrap a 95% confidence interval for the difference in revenue per user between two groups.
Show answer
What is the difference between users, sessions and events in Google Analytics 4?
Show answer
What is the difference between bounce rate and engagement rate in GA4?
Show answer
What are UTM parameters and why do they matter?
Show answer
What do CTR, CPC, CPA and ROAS mean in digital marketing?
Show answer
Write a UTM-tagged URL for a paid Instagram campaign promoting a summer sale, and give two naming rules.
Show answer
Write SQL to calculate sessions, orders and conversion rate by traffic source.
Show answer
Write Excel formulas to calculate ROAS and CPA for each campaign and flag campaigns below a ROAS target.
Show answer
A campaign landing page gets heavy traffic but very few sign-ups. How would you diagnose it?
Show answer
Explain the common marketing attribution models.
Show answer
Write SQL to find the first-touch and last-touch channel for every user who converted.
Show answer
Write Python code to extract UTM source, medium and campaign from a column of landing page URLs.
Show answer
Write SQL to calculate open rate and click-through rate for each email campaign.
Show answer
Write pandas code to calculate customer acquisition cost and payback period in months for each channel.
Show answer
Organic search traffic fell 40% overnight. How do you investigate?
Show answer
Traffic suddenly doubled from one city, with near-zero engagement time and no conversions. What is happening and what do you do?
Show answer
Analytics shows 1,820 purchases last month but the order database shows 2,150. Which is right, and how do you explain the gap?
Show answer
Site conversion rate rose from 2.0% to 2.4%, but total revenue stayed flat. What would you check?
Show answer
Email open rates suddenly jumped from 22% to 45% without any campaign change. Should you celebrate?
Show answer
Tell me about a time you worked with a marketing team to improve a campaign using data.
Show answer
Tell me about a time tracking broke and you had to fix the reporting.
Show answer
What is the difference between marketing mix modelling and multi-touch attribution?
Show answer
What is incrementality testing in marketing?
Show answer
How do cookie restrictions, consent rules and server-side tagging affect web analytics data in 2026?
Show answer
Write SQL to group raw page events into sessions using a 30-minute inactivity rule.
Show answer
After a website migration, the share of direct traffic jumped from 15% to 45%. What could cause it?
Show answer
Brand keyword ads show a ROAS of 15, and the team wants to double the budget. How do you respond?
Show answer
The CMO asks which marketing channel should lose 20% of its budget. How do you approach it?
Show answer
Describe a time you explained the limits of attribution data to a senior stakeholder.
Show answer
Frequently asked questions
What is asked in a data analyst interview in India?
Most processes have three to four rounds. A screening test or live round on SQL and Excel, a technical round on a BI tool such as Power BI or Tableau along with Python and statistics basics, a case study or project discussion, and an HR or managerial round. Freshers face more fundamentals and aptitude, while experienced candidates get deeper questions on data modelling, KPI design and stakeholder management.
Is SQL or Python more important for data analyst interviews?
SQL is more important for most data analyst roles in India, because almost every company tests it and analysts use it daily to pull data. Python is a strong advantage and is expected in product companies and analytics teams that automate reports or do deeper analysis. A good plan is to become very comfortable with SQL first, then learn pandas well enough to clean, analyse and visualise data.
Should I learn Power BI or Tableau for data analyst jobs?
Power BI appears in more Indian job postings, especially in companies using Microsoft tools, and it has a free desktop version, so it is a safe first choice. Tableau is popular in consulting, IT services and some global teams. The concepts transfer well: data modelling, calculations, filters and dashboard design. Learn one deeply with a portfolio project, and understand the other well enough to discuss it confidently.
Can a fresher without experience get a data analyst job?
Yes. Many companies hire freshers as data analysts, MIS analysts or analyst interns. Recruiters look for strong Excel and SQL, one BI tool, basic statistics and two or three genuine projects using real-world data, such as sales, HR or public datasets, explained clearly with business impact. Internships, a clean portfolio on a public profile and practice with interview-style SQL problems greatly improve your chances.
What kind of projects should I show in a data analyst interview?
Show projects that answer a business question end to end: data cleaning, analysis in SQL or Python, a dashboard, and clear recommendations. Good examples are a sales performance dashboard, customer churn or cohort analysis, HR attrition analysis, or an A/B test evaluation. Be ready to explain the data source, cleaning decisions, KPI definitions, one surprising insight and what you would do differently. Depth beats having many shallow projects.
How should I prepare for the case study round?
Practise structuring open questions before jumping to numbers. Clarify the goal and definitions, break the problem into drivers such as traffic, conversion and order value, list hypotheses, decide what data would test each, and end with a recommendation. Practise common cases like a sudden sales drop, choosing KPIs for a product, evaluating a campaign and guesstimates. Think aloud, state assumptions and sanity-check your final numbers.