01
How do you handle large datasets in Excel?
Show answer
Use tables, Power Query, remove volatile functions, filter before calculating and move to Power Pivot or a database when rows reach the millions.
YASH Technologies Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About YASH Technologies hiring for Business Analytics roles
YASH Technologies is an IT services and consulting company with a strong focus on SAP implementation, cloud, application development and digital transformation. It has its headquarters in the United States and a large presence in India, especially in Indore where it has major delivery centres. In India it hires SAP consultants, developers, testers and data engineers for enterprise client projects across industries.
For Business Analytics roles, this YASH Technologies practice set focuses most on Requirements and Agile (10), Excel for Business Analysts (6), SQL for Business Analysis (5), Case Studies and Guesstimates (3). It has 15 easy, 23 medium, 2 hard questions, so you can start easy and work up to the harder ones.
- Company type
- IT services
- Headquarters
- East Moline, Illinois, USA
- Main India offices
- Indore, Pune, Hyderabad
YASH Technologies 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 YASH TechnologiesStart 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 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.
03
What is the 80/20 rule in business analysis?
Show answer
Pareto principle: about 80% of outcomes come from 20% of causes, such as most revenue from a few customers or most defects from a few issues.
04
What is scope creep and how do you control it?
Show answer
Uncontrolled growth of requirements. Control it with a clear scope statement, change control process, impact analysis and sponsor approval for additions.
05
Your monthly Excel report takes a full day of manual work. How would you automate it?
Show answer
Map the steps first: which files arrive, what cleaning is done and which outputs are needed. Move the import and cleaning into Power Query so a refresh replaces copy-paste. Base calculations on Excel Tables and PivotTables that update automatically, and keep a fixed template for the output. Use a small macro or Office Script only for the remaining formatting or emailing. Add checks such as row counts and totals so errors surface quickly.
06
What is UAT sign-off and who should give it?
Show answer
UAT sign-off is the formal acceptance by the business that the solution meets agreed requirements and is fit to go live, often with a list of known open defects and agreed workarounds. It should be given by the accountable business owner or product owner, not by the IT team or the BA. The BA prepares the evidence: test execution summary, defect status and traceability to requirements. Sign-off is recorded in writing, usually by email or in the test management tool.
07
What is a PESTEL analysis?
Show answer
PESTEL scans the external environment across Political, Economic, Social, Technological, Environmental and Legal factors. For an electric vehicle maker in India it would cover subsidies and policy, fuel prices and interest rates, consumer attitudes, battery technology, emission targets and safety regulations. It is useful in market entry and strategy cases to spot opportunities and risks beyond the company's control, and pairs well with SWOT.
08
What steps would you follow to create an AS-IS process map for a customer refund process?
Show answer
Define the scope: where the process starts, such as a refund request, and where it ends, such as money credited. Identify the roles involved and draw swimlanes. Interview and observe each role, capturing steps, decisions, systems used, handoffs and time taken. Draw the flow in BPMN, mark pain points like rework loops and waiting time, and add measures such as average refund time. Validate the map with the people who do the work.
09
What is a traceability matrix?
Show answer
A table linking each requirement to design, test cases and delivery status, ensuring nothing is missed and helping assess change impact.
10
What is the difference between capex and opex?
Show answer
Capex (capital expenditure) is spending on long-term assets that benefit several years, such as machinery, buildings or capitalised software development. It goes on the balance sheet and is expensed gradually through depreciation or amortisation. Opex (operating expenditure) covers day-to-day running costs such as salaries, rent and cloud subscriptions, and is expensed in the period it occurs. Moving from owned servers to cloud services shifts IT spending from capex to opex, which changes how budgets and business cases look.
11
What is a process flow and which tools do you use?
Show answer
A diagram of steps, decisions and owners in a process, made using BPMN or flowcharts in tools like Visio, Lucidchart or draw.io.
12
How do you find duplicate customers?
Show answer
SELECT email, COUNT(*) FROM customers GROUP BY email HAVING COUNT(*) > 1;
13
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.
14
What are window functions in SQL and how are they different from GROUP BY?
Show answer
A window function calculates across a set of related rows using OVER(), but it keeps every original row instead of collapsing them. GROUP BY returns one row per group. For example, SUM(amount) OVER (PARTITION BY region) shows each order next to its region total, which helps compute share of total, rankings, running totals and month-over-month change. Common window functions are ROW_NUMBER, RANK, LAG, LEAD and SUM.
15
How do you calculate monthly revenue growth in SQL?
Show answer
Aggregate revenue per month and use LAG(revenue) OVER (ORDER BY month) to compute (revenue - previous) / previous.
16
What are start, intermediate and end events in BPMN?
Show answer
Events are circles that show something happening. A start event (thin border) triggers the process, such as a form submitted or a timer firing on the first of the month. An intermediate event (double border) happens during the process, such as waiting for a payment message or a 48-hour timer. An end event (thick border) marks where a path finishes and can carry a result such as a message, an error or termination of all paths.
17
How do you handle changing requirements?
Show answer
Log the change, assess impact on scope, cost and timeline, get approval through change control or backlog grooming, and update documents and stakeholders.
18
Revenue grew 20 percent this quarter but the number of active customers stayed flat. How do you interpret it?
Show answer
Growth came from more value per customer, not more customers. Break revenue into customers times orders per customer times average order value to see which moved. It could be price increases, larger baskets, a shift to premium products or a few large accounts. Then check risks: is new customer acquisition stalling, is churn being masked, and is growth concentrated in a small segment that could leave?
19
Write an Excel formula for working days between two dates excluding weekends and holidays.
Show answer
// 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)
20
What is a user story and what makes it good?
Show answer
A short requirement written as 'As a user, I want X so that Y', backed by acceptance criteria. Good stories follow INVEST: independent, negotiable, valuable, estimable, small and testable.
21
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.
22
What is an event-based gateway and when would you use it?
Show answer
An event-based gateway is a decision point where the path is chosen by whichever event happens first, not by a data condition. It is followed by intermediate catching events such as a message or a timer. Example: after sending a quotation, either the customer's acceptance message arrives, or a 7-day timer fires and a reminder is sent. It models real waiting situations that an exclusive gateway cannot express correctly.
23
Which Excel functions do business analysts use daily?
Show answer
VLOOKUP or XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, text functions, PivotTables and charts.
24
What does the LTV to CAC ratio tell you and what is a healthy value?
Show answer
LTV to CAC compares the lifetime gross profit from a customer with the cost of acquiring them. A ratio around 3 to 1 is commonly treated as healthy. Below 1 means you lose money on every customer. Far above 5 may mean you are underinvesting in growth. Always compute LTV on gross margin, not revenue, and check it by channel, because blended averages hide loss-making channels.
25
A ride-hailing app's ride cancellation rate rose from 8 to 14 percent. How would you structure the problem?
Show answer
First split by who cancels: riders or drivers. For rider cancellations, check wait times, pickup accuracy, price surges and changes in ETA. For driver cancellations, check trip distance, payment mode, low fares, destination visibility and incentive changes. Then segment by city, time of day and area. Link to recent changes like a new pricing rule. Recommend fixes for the largest driver, such as better matching or adjusted incentives.
26
What is a self join? Give a business example.
Show answer
A self join joins a table to itself using two aliases, so you can compare rows within the same table. A classic business example is an employees table with a manager_id column: joining employees e to employees m on e.manager_id = m.employee_id lists each employee with their manager's name. Another example is finding customers who placed two orders on the same day by joining orders to orders on customer_id and date with different order IDs.
27
Tell me about a time you worked with stakeholders in a different time zone or culture.
Show answer
Situation: I worked on a reporting project where the business owners were in the UK and the development team was in Pune. Task: gather and confirm requirements without long delays. Action: I fixed a daily 30-minute overlap call, sent written summaries with decisions and open questions after each meeting, and used recorded walkthroughs of prototypes. I also learned that the UK team preferred direct written feedback. Result: we closed requirements in three weeks instead of the planned five.
28
What is a data table in Excel?
Show answer
A what-if tool that recalculates a formula for different inputs, for example loan payments across different rates and tenures.
29
What is the role of a BA in Scrum?
Show answer
They help the Product Owner refine the backlog, write stories and acceptance criteria, clarify details with developers and support testing and demos.
30
Which chart would you choose for trend, part-to-whole, comparison and distribution?
Show answer
For a trend over time use a line chart. For part-to-whole use a stacked bar or a 100 percent bar; a pie or donut only works with two to four slices. For comparing categories use a sorted horizontal bar chart. For distribution use a histogram or box plot. For correlation between two measures use a scatter plot. Choosing by the question being answered, not by looks, keeps dashboards readable.
31
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.
32
Tell me about a time you led or mentored a team of analysts.
Show answer
Situation: I led three junior analysts on a pricing review with a six-week deadline. Task: deliver quality work while developing them. Action: I split the work by workstream, set up short daily check-ins and a shared query library, reviewed their logic rather than rewriting it, and let each present their section to the client. Result: we delivered a week early, two juniors later handled client calls alone, and the review practice became standard in our team.
33
What is a balanced scorecard?
Show answer
A balanced scorecard is a strategic performance framework that tracks objectives and KPIs across four perspectives: financial (revenue growth, margin), customer (NPS, retention), internal processes (cycle time, defect rate) and learning and growth (training hours, employee engagement). The idea is that financial results are lagging, so leaders also need leading measures of what drives future performance. A strategy map links the objectives with cause-and-effect arrows from people to processes to customers to financial outcomes.
34
What is the difference between system testing, SIT and UAT?
Show answer
System testing is done by the QA team to verify that one system works against its functional and non-functional specifications. SIT (system integration testing) checks that connected systems exchange data correctly, such as CRM to billing to payment gateway. UAT (user acceptance testing) is done by business users to confirm the solution supports real business processes and is ready for go-live. UAT asks whether this is fit for our business, not just whether it matches the specification.
35
SQL: total revenue per month.
Show answer
SELECT DATE_TRUNC('month', order_date) AS month, SUM(amount) AS revenue
FROM orders GROUP BY 1 ORDER BY 1;
-- MySQL: DATE_FORMAT(order_date, '%Y-%m')
36
What is BPMN and why do business analysts use it?
Show answer
BPMN (Business Process Model and Notation) is a standard graphical notation, maintained by the OMG, for drawing business processes. Business analysts use it because business users, developers and process owners can all read the same diagram. It shows who does what, in which order, with which decisions and messages. A BPMN 2.0 model can also be executed by workflow engines, so the same diagram can move from analysis to automation with less rework.
37
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?
Show answer
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.
38
Write non-functional requirements for an online payment page.
Show answer
NFR-01 Performance: the payment page loads within 2 seconds for 95 percent of requests at 500 concurrent users. NFR-02 Availability: 99.9 percent monthly uptime outside planned maintenance. NFR-03 Security: card data is never stored by the application, and all traffic uses TLS 1.2 or higher. NFR-04 Compliance: the flow meets PCI DSS and RBI payment guidelines. NFR-05 Usability: works on mobile screens from 360 pixels wide. NFR-06 Audit: every transaction attempt is logged with a timestamp.
39
XLOOKUP vs VLOOKUP?
Show answer
XLOOKUP can look left or right, uses exact match by default, returns a custom value if nothing is found and doesn't break when columns move. VLOOKUP only looks right and needs a column number.
40
What techniques do you use to elicit requirements?
Show answer
Interviews, workshops, surveys, observation, document analysis, prototyping and brainstorming, chosen according to stakeholders and project stage.
Tips to crack the YASH Technologies Business Analytics interview
- Learn basic ERP and SAP concepts such as modules and business processes, since a large share of YASH work involves SAP.
- Revise programming basics, SQL and DBMS concepts, and be ready to write simple queries or code during the technical round.
- Show flexibility about technology and location, as freshers may be trained and placed on different stacks and projects.
- 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; YASH Technologies interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the YASH Technologies 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 YASH Technologies Business Analytics interview?
This practice set leans on Requirements and Agile (10), Excel for Business Analysts (6), SQL for Business Analysis (5), Case Studies and Guesstimates (3). Revise those first, then practise explaining one or two of your own projects end to end, because most YASH Technologies interviewers ask you to walk through real work.
Are these the exact questions asked at YASH Technologies?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like YASH Technologies's. They are not a leaked or verified list of past questions.
Where does YASH Technologies hire Business Analytics professionals in India?
YASH Technologies has large teams in Indore, Pune, Hyderabad. Openings and locations change often, so check the YASH Technologies careers page and filter by city and experience.
Business Analytics questions for similar companies
IT services
IBM
Business Analytics interview questions
Bengaluru, Pune, Hyderabad +2
View questionsIT services
HCLTech
Business Analytics interview questions
Noida, Chennai, Bengaluru +2
View questionsIT services
Quest Global
Business Analytics interview questions
Bengaluru, Thiruvananthapuram, Belagavi +1
View questionsIT services
EPAM Systems
Business Analytics interview questions
Hyderabad, Bengaluru, Pune +2
View questionsIT services
Cyient
Business Analytics interview questions
Hyderabad, Bengaluru, Noida
View questionsIT services
Persistent Systems
Business Analytics interview questions
Pune, Nagpur, Bengaluru +2
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