‹ Back to previous section Course home All page URLs

Data Analytics Interview Questions in Noida

Q: Which companies hire Data Analytics professionals in Noida?

Companies with large offices in Noida include Microsoft, Adobe, Oracle, Paytm, Barclays, HCLTech, Tech Mahindra, Hexaware, Coforge, Birlasoft. Use their company pages below to practise employer-specific sets.

Q: Are Data Analytics interviews in Noida different from other cities?

The questions depend more on the company than the city. Noida's mix of employers decides the style: Freshers often find their first role here, and many teams run hybrid work

Q: How do I find Data Analytics jobs in Noida?

Shortlist companies with Noida offices, keep your CV focused on Data Analytics projects, apply on company career pages and job portals with the Noida filter, and practise the questions on this page before each interview.

36 practice questions with answers for Data Analytics interviews in Noida.

Data Analytics jobs in Noida

Noida is a major IT and IT-services hub in Delhi NCR with large campuses of service companies, product firms and fast-growing start-ups along the Noida–Greater Noida Expressway. Freshers often find their first role here, and many teams run hybrid work.

Below are 36 questions that match the mix of service, product and domain employers hiring data analysts in Noida.

Solved for NoidaStart practicing

3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.

3 questions free Unlock the rest in seconds

Write pandas code to convert daily sales into weekly totals, showing zero for days with no sales.

Python for AnalysisMedium

Show answer

df['date'] = pd.to_datetime(df['date']) daily = (df.groupby('date')['sales'].sum() .asfreq('D', fill_value=0)) # adds missing days as 0 weekly = daily.resample('W-MON', label='left', closed='left').sum() print(weekly.head()) # W-MON with label/closed left gives weeks starting on Monday

Write SQL to calculate open rate and click-through rate for each email campaign.

Web & Marketing AnalyticsMedium

Show answer

SELECT s.campaign_id, COUNT(DISTINCT s.user_id) AS delivered, COUNT(DISTINCT o.user_id) AS opened, COUNT(DISTINCT c.user_id) AS clicked, ROUND(100.0 * COUNT(DISTINCT o.user_id) / COUNT(DISTINCT s.user_id), 1) AS open_rate, ROUND(100.0 * COUNT(DISTINCT c.user_id) / COUNT(DISTINCT s.user_id), 1) AS ctr FROM email_sends s LEFT JOIN email_opens o ON o.campaign_id = s.campaign_id AND o.user_id = s.user_id LEFT JOIN email_clicks c ON c.campaign_id = s.campaign_id AND c.user_id = s.user_id WHERE s.status = 'delivered' GROUP BY s.campaign_id;

What is a good structure for a data story?

Data StorytellingEasy

Show answer

A simple structure is context, conflict, resolution. Context sets up what the audience already knows, such as our target was 10 percent growth. Conflict shows the surprising finding or problem, such as growth is only 3 percent because repeat buyers dropped. Resolution gives the recommendation and expected impact. Another option is situation, complication, question, answer. Either way, the audience should know the main message within the first minute.

What is the difference between a dashboard and a report?

Dashboards and KPIsMedium

Show answer

A report is multi-page and interactive from one dataset; a dashboard is a single-page canvas of pinned tiles from many reports in the Service.

The CMO asks which marketing channel should lose 20% of its budget. How do you approach it?

Web & Marketing AnalyticsHard

Show answer

I would compare channels on incremental return, not last-click ROAS. Gather spend, attributed conversions under two models, customer quality such as repeat rate and margin, and any lift test or mix model results. Look at diminishing returns: the last rupee in a saturated channel is worth less than the average. Then recommend cutting where marginal return is lowest, ideally phased with a holdout to confirm the impact.

Mean vs median vs mode — when do you use which?

Statistics and Case StudiesEasy

Show answer

Mean for symmetric data without outliers, median for skewed data (salaries, house prices), mode for categories (the most common city).

What is the difference between a clustered and a non-clustered index?

SQLMedium

Show answer

A clustered index defines the physical order of rows (one per table); a non-clustered index is a separate structure with pointers to the rows.

What are pre-attentive attributes and how do you use them in charts?

Data StorytellingEasy

Show answer

Pre-attentive attributes are visual properties the brain notices in a fraction of a second before conscious thought, such as colour, size, position, length and bold weight. Use them to direct attention: make all bars grey and highlight only the declining region in a strong colour, or bold the one number that matters. Using too many highlights cancels the effect, so emphasise one or two things per chart.

Write a DAX measure for cumulative sales from the start of the data to the selected date.

Power BIMedium

Show answer

Cumulative Sales = VAR maxDate = MAX('Date'[Date]) RETURN CALCULATE( [Total Sales], FILTER(ALL('Date'[Date]), 'Date'[Date] <= maxDate) ) -- for a running total that resets each year use TOTALYTD([Total Sales], 'Date'[Date])

What is the difference between relationships, joins and data blending in Tableau?

TableauMedium

Show answer

Relationships, the default logical layer, connect tables flexibly and Tableau decides join type and level per view, avoiding duplicated measures. Joins physically merge tables into one at a fixed level, which can duplicate rows if grains differ. Blending combines data from separate data sources at the view level using a primary and secondary source, aggregating the secondary first. Prefer relationships, use joins for specific row-level needs, and blending as a last resort.

A marketing campaign shows more sales. How do you prove it worked?

Statistics and Case StudiesHard

Show answer

Compare with a control group or use difference-in-differences, control for seasonality, and measure incremental sales against campaign cost.

Write a Tableau calculated field for profit ratio and a profit category.

TableauEasy

Show answer

// Profit Ratio (aggregate first, then divide) SUM([Profit]) / SUM([Sales]) // Profit Category IF SUM([Profit]) < 0 THEN 'Loss' ELSEIF [Profit Ratio] < 0.1 THEN 'Low margin' ELSE 'Healthy' END // avoid AVG([Profit]/[Sales]): it averages row ratios and gives a wrong total

Orders arrive in the warehouse with customer IDs that do not exist yet in the customer dimension. What do you do?

Data Modelling & WarehousingMedium

Show answer

These are late-arriving dimensions. Do not drop the orders, or revenue will be understated. Common practice is to insert a placeholder customer row with the natural key and 'Unknown' attributes, link the order to it, and update that row when full details arrive. Alternatively map to a single Unknown member with key -1. Also monitor how many such rows appear daily, because a spike usually means a broken feed.

What is the Central Limit Theorem and why does it matter for analysts?

Statistics and Case StudiesMedium

Show answer

The Central Limit Theorem says that the distribution of sample means approaches a normal distribution as sample size grows, usually from about 30 observations, even if the underlying data is skewed. This is why we can use z-tests, t-tests and confidence intervals for averages such as order value or session time. It does not make the raw data normal, and very heavy-tailed data may need larger samples.

How do you handle large CSV files that do not fit in memory in Python?

Python for AnalysisMedium

Show answer

Read in chunks with chunksize, load only needed columns, set efficient dtypes or switch to Dask, Polars or a database.

Explain row context and filter context.

Power BIMedium

Show answer

Row context evaluates one row at a time (calculated columns); filter context is the set of filters from slicers, visuals and relationships that a measure sees.

Write Python code to extract valid 10-digit Indian mobile numbers from a messy text column.

Data CleaningMedium

Show answer

import re pattern = re.compile(r'(?:\+?91[\s-]?|0)?([6-9]\d{9})') def get_mobile(text): if not isinstance(text, str): return None digits = re.sub(r'[\s()-]', '', text) m = pattern.search(digits) return m.group(1) if m else None df['mobile'] = df['contact'].apply(get_mobile)

An inner join between orders and customers returns fewer orders than the orders table has. What could be wrong?

Data CleaningMedium

Show answer

Orphan records are child rows whose foreign key has no matching parent, such as orders with a customer_id that does not exist in the customer table. They break joins silently: an inner join drops them and totals fall short. Find them with a LEFT JOIN from the child to the parent and filter where the parent key IS NULL. Then fix the source, add an Unknown member, or report them separately.

A manager asks for a dashboard that refreshes every minute. How do you decide the right refresh frequency?

Dashboards and KPIsMedium

Show answer

Match refresh to how quickly decisions are made. A monthly board pack needs daily refresh at most, while a warehouse dispatch board may need 15-minute or live updates. Faster refresh costs more in source load, licensing and complexity, and can show incomplete data. Ask how quickly someone will act on a change, check when upstream systems finish loading, and always display the last refreshed time on the dashboard.

Explain INDEX and MATCH together.

ExcelMedium

Show answer

MATCH finds the position of a value in a range and INDEX returns the item at that position, giving a flexible lookup that works left or right and survives column insertions.

What is referential integrity and how do orphan records appear in analytics data?

Data CleaningMedium

Show answer

Referential integrity means every foreign key value points to an existing row in the parent table, for example every order's customer_id exists in customers. Orphan records break this rule. They appear when source systems load tables at different times, records are deleted without cascading, or IDs are formatted differently across systems. Detect them with a LEFT JOIN where the parent key is NULL, and decide whether to fix, map or flag them.

What do COALESCE and NULLIF do in SQL?

SQLEasy

Show answer

COALESCE returns the first non-null value from its arguments, for example COALESCE(phone, alt_phone, 'Not given') fills missing phone numbers. NULLIF(a, b) returns NULL when a equals b, otherwise a. Its classic use is avoiding division by zero: revenue / NULLIF(orders, 0) returns NULL instead of an error when orders is zero. Together they handle most null-related reporting problems cleanly.

How do you clean messy text data in Excel?

Data CleaningMedium

Show answer

Use TRIM, CLEAN, UPPER or PROPER, Text to Columns, Flash Fill, SUBSTITUTE, and Power Query for repeatable cleaning steps.

How do you calculate month-over-month growth?

Dashboards and KPIsMedium

Show answer

Aggregate revenue by month, use LAG(revenue) OVER (ORDER BY month), then (revenue - prev) / prev x 100.

Write pandas code to find the top 2 products by revenue in each region.

Python for AnalysisMedium

Show answer

top2 = ( df.groupby(['region', 'product'], as_index=False)['revenue'] .sum() .sort_values(['region', 'revenue'], ascending=[True, False]) .groupby('region') .head(2) ) print(top2)

Write Excel formulas to calculate ROAS and CPA for each campaign and flag campaigns below a ROAS target.

Web & Marketing AnalyticsEasy

Show answer

-- B = Spend, C = Conversions, D = Revenue, target ROAS in H1 E2 (ROAS): =IFERROR(D2/B2, 0) F2 (CPA): =IF(C2=0, "No conversions", B2/C2) G2 (Flag): =IF(E2<$H$1, "Below target", "OK") -- Copy down, then add conditional formatting on G to highlight 'Below target'

What is Power Pivot and the Excel Data Model?

ExcelMedium

Show answer

The Data Model is an in-memory columnar store inside Excel that holds several related tables, and Power Pivot is the interface to manage it. Instead of flattening data with VLOOKUPs, you load fact and dimension tables, create relationships and write DAX measures. It handles millions of rows that would not fit on a sheet, and PivotTables built on it can slice across tables. It is the same engine idea that Power BI uses.

Write pandas code to calculate customer acquisition cost and payback period in months for each channel.

Web & Marketing AnalyticsMedium

Show answer

# spend: channel, spend # customers: channel, customer_id, monthly_margin new_cust = customers.groupby('channel').agg( new_customers=('customer_id', 'nunique'), avg_margin=('monthly_margin', 'mean')) summary = spend.groupby('channel')['spend'].sum().to_frame().join(new_cust) summary['cac'] = summary['spend'] / summary['new_customers'] summary['payback_months'] = summary['cac'] / summary['avg_margin'] print(summary.round(1).sort_values('payback_months'))

What are absolute and relative cell references?

ExcelMedium

Show answer

Relative references change when copied (A1); absolute references stay fixed ($A$1); mixed references lock only the row or column (A$1 or $A1).

What are leading and lagging indicators? Give examples.

Dashboards and KPIsMedium

Show answer

Lagging indicators report outcomes that have already happened, such as monthly revenue, profit or churn; they are accurate but too late to change. Leading indicators move earlier and predict outcomes, such as qualified leads, demo bookings, cart additions or support ticket backlog. A sales dashboard should pair them: pipeline coverage today signals revenue next quarter. Leading indicators need validation that they really predict the lagging result.

A profit margin visual shows errors for products with zero sales. How do you fix it in DAX?

Power BIEasy

Show answer

DIVIDE(numerator, denominator, alternate) handles division by zero or blank safely and returns blank or the alternate value you supply, so visuals do not show errors or infinity. The / operator returns an error or infinity in those cases. For example, DIVIDE([Profit], [Sales]) shows blank for a product with no sales. Use / only when you are certain the denominator can never be zero, because it is marginally faster.

What are parameters in Tableau and how do you use them?

TableauMedium

Show answer

A parameter is a single user-controlled value, such as a number, date or string, that is independent of the data. On its own it does nothing; you reference it in calculations, filters, reference lines or bins. Common uses are a Top N selector, a what-if growth rate, or a measure switcher where a CASE statement picks Sales, Profit or Quantity based on the parameter. Parameter actions let users set it by clicking a mark.

Tell me about a time you found an error in someone else's spreadsheet.

ExcelEasy

Show answer

Situation: a teammate's incentive calculation sheet was about to go to payroll. Task: I was asked to review it. Action: I noticed totals did not match the sales extract, traced it to a SUM range that stopped at row 500 while data had grown to 640 rows, and told the teammate privately with the fix. Result: we converted the data to an Excel Table so ranges expand, and payouts went out correctly.

What is a date table in Power BI and why should you mark it as one?

Power BIEasy

Show answer

A date table has one row per day with no gaps, covering the full range of your data, plus columns like year, month, quarter and week. Marking it as a date table tells Power BI to use it for time intelligence functions such as TOTALYTD and SAMEPERIODLASTYEAR. Without it, those functions can give wrong results and auto date tables bloat the model. Relate it to every fact table's date column.

Tell me about a time you worked with a marketing team to improve a campaign using data.

Web & Marketing AnalyticsMedium

Show answer

Situation: a lead generation campaign had a high cost per lead and sales said leads were poor. Task: find what to change. Action: I joined ad data with CRM outcomes and found two audience segments produced most leads but almost no closed deals, while one smaller segment converted well. Result: we moved budget to that segment and changed the form questions; cost per qualified lead fell about 30% in six weeks.

Your Tableau map shows a large number of unknown locations. How do you fix it?

TableauEasy

Show answer

Click the unknown indicator at the bottom right of the map and choose Edit Locations. Usually Tableau cannot match names because of spelling variants, such as 'Bengaluru' versus 'Bangalore', or an ambiguous city that needs the state and country set. Make sure fields have the correct geographic role, add a country or state field to the view, clean names in the data source, or use latitude and longitude columns.

Companies with offices in Noida (22)

Product

Microsoft

Data Analytics interview questions

40 questions
5 rounds

Hyderabad, Bengaluru, Noida +2

Data Analytics Interview Questions in Noida

Data Analytics jobs in Noida

Write pandas code to convert daily sales into weekly totals, showing zero for days with no sales.

Write SQL to calculate open rate and click-through rate for each email campaign.

What is a good structure for a data story?

What is the difference between a dashboard and a report?

The CMO asks which marketing channel should lose 20% of its budget. How do you approach it?

Mean vs median vs mode — when do you use which?

What is the difference between a clustered and a non-clustered index?

What are pre-attentive attributes and how do you use them in charts?

Write a DAX measure for cumulative sales from the start of the data to the selected date.

What is the difference between relationships, joins and data blending in Tableau?

A marketing campaign shows more sales. How do you prove it worked?

Write a Tableau calculated field for profit ratio and a profit category.

Orders arrive in the warehouse with customer IDs that do not exist yet in the customer dimension. What do you do?

What is the Central Limit Theorem and why does it matter for analysts?

How do you handle large CSV files that do not fit in memory in Python?

Explain row context and filter context.

Write Python code to extract valid 10-digit Indian mobile numbers from a messy text column.

An inner join between orders and customers returns fewer orders than the orders table has. What could be wrong?

A manager asks for a dashboard that refreshes every minute. How do you decide the right refresh frequency?

Explain INDEX and MATCH together.

What is referential integrity and how do orphan records appear in analytics data?

What do COALESCE and NULLIF do in SQL?

How do you clean messy text data in Excel?

How do you calculate month-over-month growth?

Write pandas code to find the top 2 products by revenue in each region.

Write Excel formulas to calculate ROAS and CPA for each campaign and flag campaigns below a ROAS target.

What is Power Pivot and the Excel Data Model?

Write pandas code to calculate customer acquisition cost and payback period in months for each channel.

What are absolute and relative cell references?

What are leading and lagging indicators? Give examples.

A profit margin visual shows errors for products with zero sales. How do you fix it in DAX?

What are parameters in Tableau and how do you use them?

Tell me about a time you found an error in someone else's spreadsheet.

What is a date table in Power BI and why should you mark it as one?

Tell me about a time you worked with a marketing team to improve a campaign using data.

Your Tableau map shows a large number of unknown locations. How do you fix it?

Companies with offices in Noida (22)

Microsoft

Adobe

Oracle

Paytm

Barclays

HCLTech

Tech Mahindra

Hexaware

Coforge

Birlasoft

Publicis Sapient

GlobalLogic

NTT DATA

Genpact

EXL

Samsung

Cyient

Happiest Minds Technologies

Infogain

Pine Labs

Ericsson

Nokia

Frequently asked questions

Other cities

More ways to practise