1Lattice 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

In this process, you are provided with an Excel file related to your job profile, and you must complete a test while sharing your screen with the interviewer.

Q1. What relevant questions would you ask based on your resume, and how do you believe you can add value to this company?
Add your answer
Q2. Why did you leave your last organization?
Add your answer

Q1. Difference between agile and waterfall?
Ans. 
Agile is iterative and flexible, while waterfall is sequential and rigid.
• Agile involves continuous feedback and adaptation, while waterfall follows a linear approach.

• Agile allows for changes to be made throughout the project, while waterfall requires detailed planning upfront.

• Agile is best suited for projects with evolving requirements, while waterfall is better for projects with well-defined requirements.

• Agile promote...read more
Answered by AI
Add your answer

Q1. User stories and acceptance criteria
Add your answer

Q1. Previous job role related work exp
Add your answer

Q1. User stories, Tableau related quest
Add your answer

Q1. Difference between brd and frd
Ans. 
BRD (Business Requirements Document) outlines high-level business requirements, while FRD (Functional Requirements Document) details specific functionalities.
• BRD focuses on business needs and goals, while FRD specifies how those needs will be met through system functionalities.

• BRD is more strategic and high-level, while FRD is more detailed and specific.

• BRD is typically created by business stakeholders, while FRD is cr...read more
Answered by AI
Add your answer
Q2. Why you left your previous organisation
Ans. 
Seeking new challenges and growth opportunities in a different industry.
• Desire for career advancement

• Interest in exploring new industries

• Seeking new challenges

• Relocation

• Company downsizing or restructuring
Answered by AI
Add your answer

Q1. Write user story
Ans. 
As a user, I want to be able to search for products by category so that I can easily find what I need.
• User should be able to select a category from a dropdown menu

• Search results should display products only from the selected category

• User should be able to filter search results further by price, brand, etc.
Answered by AI
Add your answer
Q2. What is agile and scrum
Ans. 
Agile is a project management methodology that focuses on flexibility and collaboration, while Scrum is a specific framework within Agile that emphasizes iterative development and teamwork.
• Agile is a project management approach that values adaptability, customer collaboration, and responding to change over following a strict plan.

• Scrum is a subset of Agile that uses specific roles (such as Scrum Master and Product Owne...read more
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer
Q2. How soon u can join
Ans. 
I can join within 2 weeks of receiving an offer.
• I can start within 2 weeks of receiving an offer.

• My current notice period is 2 weeks.

• I am available to start immediately.
Answered by AI
Add your answer