DXC Technology Associate Business Analyst Interview Questions and Answers

Q1. Hierarchy of filters in tableau
Ans. 
In Tableau, the hierarchy of filters determines the order in which filters are applied to the data.
• Filters are applied in the order they appear in the Filter Shelf.

• Context filters are applied first, then dimension filters, and finally measure filters.

• Filters can be set to apply to all worksheets or only specific worksheets.

• Example: If a context filter is applied to a dimension, it will filter the data before any other
Answered by AI
Add your answer
Q2. What are Parameter actions
Ans. 
Parameter actions allow users to dynamically change parameter values in Tableau dashboards.
• Parameter actions enable users to interact with dashboard parameters by clicking on marks or selecting values.

• They can be used to filter data, highlight specific information, or drive calculations.

• For example, a user can click on a bar chart to update a parameter value and see corresponding changes in other visualizations.
Answered by AI
Add your answer
Q3. How to toggle between pages
Ans. 
To toggle between pages, use navigation buttons, links, or keyboard shortcuts.
• Use navigation buttons like 'Next' and 'Previous'

• Click on links or tabs to switch between pages

• Use keyboard shortcuts like Ctrl + Tab to toggle between open tabs
Answered by AI
Add your answer

Q1. Why did you choose Genpact
Ans. 
I chose Genpact for its reputation in the industry and opportunities for growth.
• Genpact has a strong reputation in the industry for providing innovative solutions to clients.

• The company offers a wide range of opportunities for career growth and development.

• I was impressed by Genpact's focus on continuous learning and development for its employees.
Answered by AI
Add your answer

Q1. Offer negotiation
Add your answer

Q1. Qstn related sql
Add your answer
Q2. Qstn related sqlw
Add your answer

Q1. Question related sql and case studies
Add your answer
Q2. Qstn related sql and case studies
Add your answer

Q1. Salary discussion
Add your answer

Q1. Question related sql and case studies
Add your answer
Q2. SQL and case studies
Add your answer

General aptitude test

Q1. Sql and tableu questions
Add your answer
Q2. What is view, advantage and disadvantages
Add your answer

Q1. How do you manage the requirements of stakeholders?
Ans. 
I manage stakeholder requirements through effective communication, collaboration, prioritization, and documentation.
• Regular communication with stakeholders to understand their needs and expectations

• Collaboration with stakeholders to gather and prioritize requirements

• Documenting requirements clearly and accurately to ensure alignment and traceability

• Using tools like requirement management software to track and manage re...read more
Answered by AI
Add your answer

Q1. What is the process for writing non-functional requirements?
Ans. 
The process for writing non-functional requirements involves identifying performance, security, usability, and other quality attributes.
• Identify the quality attributes that are important for the project

• Define specific criteria for each quality attribute

• Ensure that the requirements are measurable and testable

• Document the non-functional requirements in a clear and concise manner
Answered by AI
Add your answer

Q1. What is sectoral analysis
Ans. 
Sectoral analysis is the evaluation of specific industries or sectors within the economy to identify trends, opportunities, and risks.
• It involves examining the performance of companies within a particular sector.

• Helps in understanding the impact of economic factors, government policies, and market trends on a specific industry.

• Allows for comparison of different sectors to determine investment opportunities.

• Commonly use...read more
Answered by AI
Add your answer
Q2. What is SPS model
Ans. 
SPS model stands for Strategy, Process, and Systems model used in business analysis to align business goals with technology solutions.
• SPS model helps in identifying business strategies, processes, and systems to achieve organizational goals.

• It involves analyzing current strategies, processes, and systems, and recommending improvements.

• For example, in a retail company, the SPS model can be used to align the business str...read more
Answered by AI
Add your answer

Q1. Previous job role related work exp
Add your answer

Q1. User stories, Tableau related quest
Add your answer

Good and got time to keep my point

Q1. What is your weakness
Add your answer
Q2. How well you know python
Ans. 
I have a strong understanding of Python and have used it extensively in my previous projects.
• Proficient in Python programming language

• Experience in using Python for data analysis and visualization

• Familiar with popular Python libraries such as Pandas, NumPy, and Matplotlib

• Have developed scripts and automation tools using Python
Answered by AI
Add your answer

Q1. How many joins are in SQL?
Ans. 
The number of joins in SQL can vary depending on the complexity of the query.
• The number of joins in SQL can range from 0 (no joins) to multiple joins in a single query.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Joins are used to combine rows from two or more tables based on a related column between them.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
Answered by AI
Add your answer
Q2. Explain about difference left and inner join? And scenarios questions
Add your answer