01
What does a Business Analyst do?
Show answer
A BA bridges business and technology: gathers requirements, analyses data and processes, documents BRD/FRD and makes sure the final solution actually solves the business problem.
Cyient Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Cyient hiring for Business Analytics roles
Cyient is an Indian engineering and technology solutions company that started in geospatial services and now covers aerospace, rail, communications, medical and utilities engineering. It provides product design, embedded software, network engineering and data services to global manufacturers and operators. In India it hires freshers and experienced engineers for design, software, testing, GIS and analytics roles at its delivery centres.
For Business Analytics roles, this Cyient practice set focuses most on Requirements and Agile (6), Excel for Business Analysts (5), Business Metrics and KPIs (5), Case Studies and Guesstimates (4). It has 14 easy, 24 medium, 2 hard questions, so you can start easy and work up to the harder ones.
- Company type
- IT services
- Headquarters
- Hyderabad, India
- Main India offices
- Hyderabad, Bengaluru, Noida
Cyient Business Analytics interview process
- Online assessment (aptitude + technical MCQs)
- Technical interview
- Managerial round
- HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for CyientStart 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
02
What is the MECE principle in case interviews?
Show answer
MECE means Mutually Exclusive and Collectively Exhaustive. When you break a problem into parts, the parts should not overlap and together should cover every possibility. For example, profit splits into revenue and cost, and revenue into price times volume. A breakdown of customers into 'young' and 'students' is not MECE because they overlap. MECE structures prevent double counting and missed causes, which is what interviewers check.
03
How do you calculate cycle time, touch time and process efficiency? Give an example.
Show answer
Cycle time (lead time) is the total elapsed time from the start to the end of a case. Touch time is the time someone actually works on it. Process cycle efficiency is touch time divided by cycle time. Example: a refund takes 5 working days (40 working hours) end to end, but the agents spend only 2 hours in total working on it. Efficiency is 2 / 40 = 5 percent, so 95 percent of the time is waiting, and queues are the main target.
04
Write an Excel formula for month-to-date sales up to today.
Show answer
// Dates in Sales[Date], amounts in Sales[Amount]
=SUMIFS(Sales[Amount],
Sales[Date], ">=" & EOMONTH(TODAY(), -1) + 1,
Sales[Date], "<=" & TODAY())
// EOMONTH(TODAY(),-1)+1 gives the first day of the current month
05
What is a data dictionary and why does a business analyst maintain one?
Show answer
A data dictionary is a catalogue of data elements used in a system or report: field name, business definition, data type, length, allowed values, mandatory or optional, source system, owner and example values. A BA maintains it so business users, developers and testers use one definition, for example what counts as an active customer. It prevents mapping errors in integrations and migrations, speeds up testing and reduces disputes about why reports do not match.
06
Compare Import mode, DirectQuery and Live Connection in Power BI.
Show answer
Import copies data into the compressed in-memory model, giving the fastest visuals and full DAX, but data is only as fresh as the last refresh and size is limited. DirectQuery sends queries to the source at view time, so data is near real time but visuals are slower and some DAX is restricted. Live Connection points to an existing published semantic model or Analysis Services model without its own model. Composite models mix Import and DirectQuery.
07
A new onboarding flow increased sign-ups by 15 percent, but Day-7 retention fell. How do you analyse this?
Show answer
Check whether the extra sign-ups are lower-intent users who would naturally retain less. Compare Day-7 retention for comparable users in both versions and count retained users in absolute terms, not just rates. If the new flow skips a step that led users to the aha moment, retention per user may truly fall. The decision depends on whether total retained, valuable users went up or down.
08
What is the difference between a Tableau extract and a live connection?
Show answer
A live connection queries the source database every time the view changes, so data is current but speed depends on the database. An extract (.hyper file) is a compressed snapshot stored by Tableau that is fast to query and can be refreshed on a schedule, but it is only as fresh as the last refresh. Extracts suit large, slow or remote sources; live suits fast warehouses and real-time needs.
09
Gross margin fell from 38 percent to 34 percent in one quarter. How do you investigate?
Show answer
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.
10
What is Kano model in prioritisation?
Show answer
A model classifying features as basic, performance or delight attributes based on how they affect customer satisfaction, helping decide what to build first.
11
How do you evaluate a marketing campaign's ROI?
Show answer
ROI = (incremental profit - campaign cost) / campaign cost. Measure incremental sales using a control group or before-after comparison.
12
What is the difference between zero-based budgeting and incremental budgeting?
Show answer
Incremental budgeting takes last year's budget and adjusts it by a percentage, which is quick but carries forward old inefficiencies. Zero-based budgeting starts every cost line from zero, and each activity must be justified by its value each cycle. ZBB uncovers waste and suits cost-reduction programmes, but takes much more effort and can create friction. Many companies apply ZBB to discretionary costs such as marketing and travel and use incremental methods elsewhere.
13
What is cohort analysis and why is it useful?
Show answer
Cohort analysis groups users by a shared starting point, usually their sign-up or first purchase month, and tracks their behaviour over time, such as the percentage still active in month 1, 2 and 3. It separates the effect of growth from the effect of retention, so you can see whether newer cohorts retain better after a product change. It is typically shown as a triangle table or retention curves.
14
Write Given-When-Then acceptance criteria for applying a discount coupon at checkout.
Show answer
Given a cart of 1,200 rupees and a valid coupon SAVE10 with a minimum order of 1,000 rupees, when the user applies it, then 10 percent is deducted and the new total is shown. Given an expired coupon, when applied, then the message 'This coupon has expired' appears and the total is unchanged. Given a cart below the minimum, when applied, then the user is told how much more to add.
15
What are wireframes and why are they useful for a BA?
Show answer
Low-fidelity layouts of screens that help stakeholders visualise and agree on requirements before development starts.
16
What is the difference between churn rate and retention rate?
Show answer
Churn rate is the percentage of customers who leave in a period: customers lost divided by customers at the start. Retention rate is the percentage who stay, roughly 100 minus churn for the same cohort. If you start a month with 1,000 subscribers and 50 cancel, churn is 5 percent and retention 95 percent. Count new customers separately, otherwise growth hides churn. Revenue churn can differ from customer churn.
17
How do you use Excel's Scenario Manager?
Show answer
Define named scenarios such as best, base and worst with different input values and compare the outputs in a summary report.
18
A business head wants 25 charts on one dashboard page. How do you respond?
Show answer
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.
19
What is the time value of money?
Show answer
The time value of money means a rupee today is worth more than a rupee in the future, because today's rupee can be invested to earn a return and future money carries inflation and risk. Future cash is converted to present value using PV = FV / (1 + r)^n. At a 10 percent discount rate, 1,10,000 rupees received after one year is worth 1,00,000 rupees today. It is the basis of NPV, IRR, loan EMIs and valuation.
20
What does expectation management mean for a business analyst?
Show answer
It means making sure stakeholders know realistically what will be delivered, when, and with what limits, before they form their own assumptions. A BA confirms scope in writing, states assumptions and dependencies, shares estimates with ranges, and flags risks early. When something changes, they update stakeholders immediately with options. Most stakeholder conflict comes from surprises, not from bad news itself.
21
Guesstimate: how many smartphones are sold in India each year?
Show answer
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.
22
What is the difference between sequence flow and message flow in BPMN?
Show answer
A sequence flow is a solid arrow that shows the order of activities inside one pool, so it represents work controlled by one participant. A message flow is a dashed arrow with an open circle at its start and shows communication between two different pools, such as an order email from a customer to a seller. A common modelling mistake is drawing sequence flows across pools, which wrongly implies one party controls the other's work.
23
How is a product owner's role different from a business analyst's role?
Show answer
The product owner owns the product vision and the backlog order, makes final priority decisions and accepts completed work on behalf of the business. The business analyst works on understanding problems in depth: eliciting and analysing requirements, modelling processes and data, writing detailed stories and acceptance criteria and supporting the team and testers. In smaller teams one person may do both, but the PO decides what, while the BA clarifies how it should work.
24
What are the 4 Ps of marketing?
Show answer
Product, Price, Place and Promotion, the levers a business uses to bring an offering to market.
25
What is the difference between UNION and UNION ALL?
Show answer
Both stack the results of two queries with the same number and type of columns. UNION removes duplicate rows, which needs a sort or hash step and is slower. UNION ALL keeps every row and is faster. Use UNION ALL when combining data such as online and store sales where duplicates are genuine or impossible, and UNION only when you specifically need a distinct list, such as unique customer IDs from two sources.
26
What is funnel analysis?
Show answer
Funnel analysis measures how many users move through a sequence of steps towards a goal, such as visit, product view, add to cart, checkout and payment, and the conversion and drop-off at each step. It shows where the biggest leak is so the team can focus fixes there. Break funnels down by device, channel and new versus returning users, and define a time window for completing the steps.
27
What are process levels such as L0 to L4 in a process architecture?
Show answer
Process levels organise models from broad to detailed. L0 shows the value chain or main process areas, such as Order to Cash. L1 and L2 break these into process groups and end-to-end processes, such as Credit Management. L3 shows the detailed BPMN flow with roles and decisions. L4 covers work instructions or system steps. A level structure keeps hundreds of diagrams consistent, avoids duplicates and lets executives and operators each read the right depth.
28
Write Excel formulas to find the second-highest sales value and the name of the rep who achieved it.
Show answer
// second highest value
=LARGE(C2:C100, 2)
// rep name for that value
=INDEX(B2:B100, MATCH(LARGE(C2:C100, 2), C2:C100, 0))
// with ties, SORTBY gives a clean list:
=TAKE(SORTBY(B2:C100, C2:C100, -1), 2)
29
KPI vs metric?
Show answer
Every KPI is a metric, but a KPI is tied directly to a strategic goal (e.g. monthly churn). A metric can be any measurement (e.g. page views).
30
Tell me about a time you discovered a missed requirement late in a project.
Show answer
Situation: two weeks before go-live of a billing system, a finance user asked how GST credit notes would work, which we had not covered. Task: assess and recover. Action: I analysed the impact with developers, found a simple configuration path for most cases plus a manual step for rare ones, and presented both options with dates to the sponsor. Result: we went live on time with a documented workaround and delivered the full fix next sprint.
31
What is the debt-to-equity ratio and how do you interpret it?
Show answer
Debt-to-equity equals total borrowings divided by shareholders' equity. It shows how much the company relies on borrowed money versus owners' funds. A ratio of 0.5 means 50 paise of debt for every rupee of equity. Higher leverage can boost returns but raises interest burden and risk in downturns. Acceptable levels depend on the industry: utilities and infrastructure carry more debt than software firms. Always read it with interest coverage, which is EBIT divided by interest expense.
32
Describe how you would model an employee leave approval process in BPMN.
Show answer
Use one pool for the company with lanes for Employee, Manager and HR system. Start event: leave request submitted. Task: system checks leave balance. Exclusive gateway: balance sufficient? If no, end event that notifies the employee. If yes, user task: manager reviews. Add an interrupting timer boundary event of 3 days that escalates to the skip-level manager. Gateway: approved or rejected. Approved path updates the leave balance and calendar, then both paths notify the employee and end.
33
What are heatmaps and session recordings, and when would you use them alongside funnel analysis?
Show answer
Heatmaps aggregate where users click, move and scroll on a page, while session recordings replay individual user sessions. Funnel analysis tells you where users drop off, for example 40 percent leave on the address page; heatmaps and recordings help explain why, such as a hidden Continue button or a confusing pin code field. They are qualitative, so use them to form hypotheses and then validate fixes with an A/B test. Personal data must be masked in recordings.
34
What is the difference between defect severity and defect priority?
Show answer
Severity describes the impact of a defect on the system or business, such as critical when payments fail or low for a spelling mistake. Priority describes how urgently it must be fixed, which is a business decision. They can differ: a wrong company logo on the login page is low severity but high priority before a launch, while a crash in a rarely used year-end report may be high severity but lower priority if the report is months away.
35
What is the difference between revenue and profit?
Show answer
Revenue is total money from sales; profit is what remains after subtracting all costs and expenses.
36
How do you validate that a report's numbers are correct?
Show answer
Reconcile totals with source tables using SQL, check filters and joins for duplication, compare with prior periods and verify with business owners.
37
Why should you avoid bidirectional relationships in a Power BI model?
Show answer
Relationships normally filter one way, from the dimension (one side) to the fact (many side). Bidirectional filtering lets facts filter dimensions too, which can create ambiguous filter paths, unexpected totals and slower queries, especially with multiple fact tables. Prefer a clean star schema with single-direction filters, and when you need a reverse filter for one measure, use CROSSFILTER or TREATAS inside CALCULATE instead of changing the model globally.
38
How do you calculate the percentage contribution of each category?
Show answer
SUM(sales) per category divided by SUM(SUM(sales)) OVER () and multiplied by 100 gives each category's share of the total.
39
Tell me about a time you found an error in a spreadsheet just before it went to management.
Show answer
Situation: an hour before a quarterly review I noticed regional totals were higher than the company total. Task: find the issue without delaying the meeting. Action: I traced it to a SUMIFS range that stopped at row 5000 while new data went beyond it, plus one duplicated region. I fixed both, converted the data to an Excel Table, and added a check cell comparing totals. Result: the correct deck went out on time and the check became part of our template.
40
What do interviewers evaluate in a business case interview?
Show answer
They assess how you think, not just the final answer. Key areas are clarifying the problem before solving, building a clear and MECE structure, handling numbers accurately with sanity checks, using business sense to prioritise, adapting to new information, and ending with a crisp recommendation with risks and next steps. Thinking aloud and communicating clearly matter as much as getting the right number.
Tips to crack the Cyient Business Analytics interview
- Revise fundamentals of your engineering branch, since Cyient roles often mix domain engineering knowledge with software or data skills.
- Practise basic programming, SQL queries and simple aptitude problems, which commonly feature in the first screening stage.
- Learn about Cyient business units such as aerospace, rail and geospatial to explain which area interests you and why.
- 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; Cyient interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Cyient Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + technical MCQs); 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 Cyient Business Analytics interview?
This practice set leans on Requirements and Agile (6), Excel for Business Analysts (5), Business Metrics and KPIs (5), Case Studies and Guesstimates (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Cyient interviewers ask you to walk through real work.
Are these the exact questions asked at Cyient?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like Cyient's. They are not a leaked or verified list of past questions.
Where does Cyient hire Business Analytics professionals in India?
Cyient has large teams in Hyderabad, Bengaluru, Noida. Openings and locations change often, so check the Cyient careers page and filter by city and experience.
Business Analytics questions for similar companies
IT services
Sonata Software
Business Analytics interview questions
Bengaluru, Hyderabad
View questionsIT services
Genpact
Business Analytics interview questions
Gurugram, Hyderabad, Bengaluru +2
View questionsIT services
NTT DATA
Business Analytics interview questions
Bengaluru, Pune, Noida +2
View questionsIT services
Virtusa
Business Analytics interview questions
Hyderabad, Chennai, Bengaluru
View questionsIT services
HCLTech
Business Analytics interview questions
Noida, Chennai, Bengaluru +2
View questionsIT services
Mastek
Business Analytics interview questions
Mumbai, Pune
View questionsMore ways to practise
Company-wise Business Analytics questionsPackage-wise Business Analytics questionsExperience-wise Business Analytics questionsRole-wise Business Analytics questionsCity-wise Business Analytics questionsMost asked Business Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsBusiness Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsBusiness Analytics topic sheets