NielsenIQ Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About NielsenIQ hiring for Business Analytics roles
NielsenIQ is a global consumer intelligence company that measures retail sales, shopper behaviour and product performance for consumer goods manufacturers and retailers. It became a separate company from Nielsen and is now often branded as NIQ. In India it runs large operations and technology centres that hire data analysts, data scientists, software engineers and client service analysts.
For Business Analytics roles, this NielsenIQ practice set focuses most on Case Studies and Guesstimates (7), Excel for Business Analysts (6), Financial and Business Analysis (5), Business Metrics and KPIs (4). It has 5 easy, 31 medium, 4 hard questions, so you can start easy and work up to the harder ones.
Company type
Analytics
Headquarters
Chicago, USA
Main India offices
Vadodara, Chennai, Pune
NielsenIQ Business Analytics interview process
Online assessment (aptitude + Excel or SQL)
Technical interview
Managerial round
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for NielsenIQStart 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
01
What is horizontal and vertical analysis of financial statements?
Horizontal analysis compares line items across periods, showing growth, for example revenue up 18 percent year on year while employee costs grew 30 percent. Vertical analysis expresses each item as a percentage of a base within one period, such as each expense as a percentage of revenue, or each asset as a percentage of total assets. Together they show both trends and structure, and vertical analysis also makes companies of different size comparable.
02
A subscription app starts the month with 8,000 customers, gains 1,200 and loses 400. Calculate churn and net growth.
Churn rate uses customers at the start: 400 divided by 8,000 gives 5 percent. Ending customers are 8,000 plus 1,200 minus 400, which is 8,800. Net growth is 800 divided by 8,000, or 10 percent. Do not divide churned customers by the ending count, since new joiners who have not had a chance to churn would understate the churn rate.
03
Your AS-IS map of a loan approval process shows 14 handoffs between teams. How do you identify improvements?
First measure each handoff: waiting time, rework rate and volume, using system timestamps where possible. Then classify steps as value-adding, required for compliance or waste. Look for patterns: repeated approvals, information re-entered in two systems, work bouncing back for missing documents. Typical fixes are merging roles, adding a checklist at intake so applications arrive complete, parallelising checks and automating rule-based approvals. Quantify the expected reduction in cycle time for each option.
Correlation means two metrics move together; causation means one actually changes the other. Users who use the wishlist feature may retain better, but they may simply be more engaged users already. Acting on correlation alone can waste effort, such as forcing everyone into the wishlist. To establish causation, run an A/B test, or use quasi-experimental methods such as difference-in-differences when a test is not possible, and always check for confounders like user tenure or acquisition channel.
06
How would you forecast next quarter's sales in Excel?
Talk to them one-to-one to understand why they skip, such as timing, relevance or workload. Offer shorter reviews, asynchronous reviews with a clear deadline, or a delegate with decision rights. Record sign-offs at each stage in writing so late changes become formal change requests. Share early drafts and mock-ups, because people react better to something visible. Escalate to the sponsor if the pattern risks the timeline.
09
How would you estimate the market size for an electric scooter in India?
Compare against the baseline you measured before the change, using the same definitions: cycle time, first-time-right rate, cost per case, backlog and customer complaints. Pull data from system timestamps rather than surveys. Check that the gain is not explained by lower volumes or seasonality, ideally by comparing similar periods. Also check for side effects, such as faster processing but more rework downstream. Present the before-and-after with the business owner, and note where adoption is still incomplete.
11
A business head wants 25 charts on one dashboard page. How do you respond?
Ask what decisions they make weekly and which three to five KPIs drive them. Propose a summary page with those KPIs, trends and one breakdown, then drill-through or separate pages for detail. Show a quick mock-up of both versions so they see the clutter and the load time. Use bookmarks or a field parameter to let them switch views without adding charts. Agree on the layout before building.
12
Gross margin fell from 38 percent to 34 percent in one quarter. How do you investigate?
Break the change into drivers. Price: were discounts or promotions deeper? Mix: did sales shift towards lower-margin products, channels or regions? Cost: did raw material, freight or supplier prices rise, or did currency movements raise import costs? Also check one-offs like inventory write-offs and accounting reclassifications. Build a margin bridge showing how many percentage points each driver contributed, then take the biggest driver to the business owner with a specific action.
13
Write an Excel formula for working days between two dates excluding weekends and holidays.
// A2 = start, B2 = end, Holidays = named range of holiday dates
=NETWORKDAYS(A2, B2, Holidays)
// if the weekend is only Sunday (common in India)
=NETWORKDAYS.INTL(A2, B2, 11, Holidays)
14
Describe a BPMN model for a purchase order process where credit check and stock check happen at the same time.
Start event: purchase order received. Task: validate order details. A parallel gateway then splits into two paths: Finance lane runs Check customer credit, Warehouse lane runs Check stock. A second parallel gateway joins them, waiting for both to complete. An exclusive gateway then decides: credit OK and stock available goes to Confirm order and Schedule dispatch; otherwise go to Notify customer with reason. Using a parallel join here is correct because both results are always needed.
15
A food delivery company's orders fell 15%. How do you investigate?
Check data accuracy, then segment by city, restaurant, time and user type; look at supply, delivery time, pricing, competitors and seasonality before proposing fixes.
16
How would you analyse the declining sales of a retail store?
Start from the questions to answer: how many users discover it, use it and later buy saved items. Define events such as save_clicked, saved_item_viewed, saved_item_removed and saved_item_purchased, with properties like product ID, price, source screen and platform. Follow the existing naming convention, assign owners, review with developers, and test events in a staging build. Build the dashboard before launch so data is checked on day one.
19
Guesstimate: how many smartphones are sold in India each year?
Use a replacement plus new-buyer approach. India has about 144 crore people; assume around 60 crore active smartphone users. If people replace phones every 4 years on average, replacements are about 15 crore a year. Add first-time buyers, say 2 to 3 percent of the remaining adult population, roughly 1.5 crore. The estimate is about 16 to 17 crore phones a year, which is close to reported industry numbers of around 15 crore.
20
Leadership wants to automate an invoice approval process with RPA. What do you check in the process model before agreeing?
Check that the process is stable, rule-based and high volume, with structured digital inputs. Look at the variant rate: if half the cases are exceptions handled by judgement, a bot will fail often. Verify that the underlying systems and screens will not change soon. Fix the process first, because automating a broken flow only makes errors faster. Finally estimate hours saved against bot build and maintenance cost, and define how exceptions get routed to people.
21
Managers want to click a region on a summary report page and jump to a detail page for only that region. How do you build it in Power BI?
Use drill-through. Create a detail page, add the Region field to the page's drill-through filter well, and design visuals for orders, products and trends. Power BI adds a back button automatically. On the summary page, users right-click a region and choose Drill through. Keep all filters on so date selections carry over. For guided navigation, you can also add buttons with bookmarks, but drill-through is the cleanest way to pass the selected region.
Activation is the point at which a new user first experiences the product's core value, such as completing a first lesson, sending a first payment or creating a first project. The aha moment is the specific early action that strongly predicts long-term retention, found by comparing retained and churned users. Teams then design onboarding to get more new users to that action quickly and track the activation rate.
24
What is a spike in Agile and when would a business analyst request one?
A spike is a time-boxed story used for research or experimentation to reduce uncertainty, not to deliver a feature. Its output is knowledge, such as a recommendation or a prototype. A BA might request one when the team cannot estimate a story because an external API, a data source or a regulation is unclear, for example checking whether a payment gateway supports partial refunds. The time box, often one to three days, prevents open-ended investigation.
25
Write a SQL query to show cumulative revenue by month.
WITH monthly AS (
SELECT DATE_TRUNC('month', order_date) AS month,
SUM(amount) AS revenue
FROM orders
GROUP BY 1
)
SELECT month, revenue,
SUM(revenue) OVER (ORDER BY month) AS cumulative_revenue
FROM monthly
ORDER BY month;
-- add PARTITION BY EXTRACT(YEAR FROM month) to reset each year
Send an agenda with the goal and the decisions needed beforehand, along with any pre-read. Invite only people who contribute or decide. Start by restating the goal, keep to time, park off-topic issues and confirm decisions aloud. End by summarising actions with owners and dates. Send minutes within a day. A meeting without a clear decision or output usually could have been an email.
Run a benefits review against the original baseline and assumptions. Check whether savings depended on actions that did not happen, such as reducing manual roles, retiring the old system or full user adoption. Check whether the baseline or volumes changed. Separate delayed benefits from lost ones. Then produce a recovery plan with owners, for example decommissioning the legacy licence or driving adoption. Also feed the lessons into how future business cases estimate benefits.
Possible causes include falling sales against unchanged purchasing, poor demand forecasts, bulk buying for discounts, slow-moving or obsolete SKUs, or deliberate stock-building ahead of a festive season or expected price rise. Analyse by SKU, warehouse and age bucket to find where stock is stuck. Recommend clearing aged items, adjusting reorder points using recent demand, and reviewing supplier minimum order quantities. Also quantify the cash locked up and the carrying cost to show urgency.
A change request is a formal proposal to modify agreed scope, requirements, timeline or budget. In change control, the request is logged, the BA analyses impact on effort, cost, schedule, risk and other requirements, and a decision body such as the sponsor or change board approves, rejects or defers it. Approved changes update the requirements, plan and traceability. In Agile, most changes go through backlog reprioritisation instead.
It breaks a top metric into drivers: Revenue = Users × Conversion × AOV; Users = New + Returning, and so on. It shows which lever to pull and where a drop came from.
36
Users in a shared Excel tracker keep typing region names with different spellings. How do you stop this?
Use Data Validation with a List rule. Keep the allowed regions in a separate sheet as an Excel Table, name it, and set the validation source to that range so the dropdown grows when you add a region. Turn on an error alert so free text is rejected. Then clean existing entries once with Find and Replace or a mapping lookup. For stronger control, protect the sheet and unlock only the input cells, so the list cannot be edited by mistake.
-- late = delivered after the promised date
SELECT
city,
COUNT(*) AS total_orders,
SUM(CASE WHEN delivered_at > promised_at THEN 1 ELSE 0 END) AS late_orders,
ROUND(100.0 * SUM(CASE WHEN delivered_at > promised_at THEN 1 ELSE 0 END)
/ COUNT(*), 2) AS late_pct
FROM orders
WHERE status = 'DELIVERED'
GROUP BY city
ORDER BY late_pct DESC;
39
Guesstimate: how many weddings take place in India in a year?
Assume a population of about 144 crore and an average life expectancy of about 70 years, so roughly 2 crore people reach a typical marriage age each year. If about 95 percent of them marry at some point, that is around 1.9 crore people, or about 95 lakh weddings, since each wedding involves two people. A reasonable estimate is around 1 crore weddings per year, concentrated in the winter wedding season.
40
Write a SQL query that shows revenue, cost and gross margin percent by product category.
SELECT
p.category,
SUM(oi.quantity * oi.unit_price) AS revenue,
SUM(oi.quantity * p.unit_cost) AS cost,
ROUND(100.0 * (SUM(oi.quantity * oi.unit_price)
- SUM(oi.quantity * p.unit_cost))
/ NULLIF(SUM(oi.quantity * oi.unit_price), 0), 2) AS gross_margin_pct
FROM order_items oi
JOIN products p ON p.product_id = oi.product_id
GROUP BY p.category
ORDER BY gross_margin_pct DESC;
Tips to crack the NielsenIQ Business Analytics interview
Practise Excel functions like VLOOKUP, pivot tables and charts, plus basic SQL, which are common for analyst roles.
Learn retail measurement concepts such as market share, distribution and sales trends to discuss consumer goods data confidently.
Prepare examples showing attention to detail and data quality checks, since accuracy matters a lot in market measurement work.
Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
Practise the hard questions on this page aloud; NielsenIQ interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the NielsenIQ Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + Excel or SQL); Technical interview; Managerial round; HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.
Which topics should I prepare for the NielsenIQ Business Analytics interview?
This practice set leans on Case Studies and Guesstimates (7), Excel for Business Analysts (6), Financial and Business Analysis (5), Business Metrics and KPIs (4). Revise those first, then practise explaining one or two of your own projects end to end, because most NielsenIQ interviewers ask you to walk through real work.
Are these the exact questions asked at NielsenIQ?
No. These are curated practice questions that match the skills and difficulty usually tested in analytics interviews like NielsenIQ's. They are not a leaked or verified list of past questions.
Where does NielsenIQ hire Business Analytics professionals in India?
NielsenIQ has large teams in Vadodara, Chennai, Pune. Openings and locations change often, so check the NielsenIQ careers page and filter by city and experience.
Business Analytics questions for similar companies