Twinstar Inc. Business Analyst Interview Questions and Answers

Q1. What is rank in sql .. kind of scenario based
Ans. 
RANK in SQL assigns a unique rank to each row within a partition of a result set, based on specified criteria.
• RANK() function is used to assign a rank to each row within a partition of a result set.

• Rows with the same values receive the same rank, and the next rank is skipped. For example, if two rows are ranked 1, the next rank will be 3.

• Syntax: RANK() OVER (PARTITION BY column_name ORDER BY column_name).

• Example: SELEC...read more
Answered by AI
Add your answer
Q2. Examples of with/ sub query in sql
Ans. 
Using subqueries in SQL allows for more complex queries by nesting queries within other queries.
• Subquery in SELECT statement: SELECT column_name FROM table_name WHERE column_name = (SELECT column_name FROM table_name)

• Subquery in WHERE clause: SELECT column_name FROM table_name WHERE column_name IN (SELECT column_name FROM table_name)

• Subquery in FROM clause: SELECT column_name FROM (SELECT column_name FROM table_name) A...read more
Answered by AI
Add your answer

Q1. Tell about work experience
Add your answer
Q2. Details about skill set
Add your answer

General grammar questions for checking the english proficiency of the candidates

Q1. You'll have a direct one on one with the elad and they will enquire about yourself and your skills, especially they will check your communication skills
Add your answer
Q2. What is Adobe and Office 365
Ans. 
Adobe and Office 365 are software suites commonly used for various business purposes.
• Adobe is a software suite used for graphic design, video editing, and web development.

• Office 365 is a cloud-based suite of productivity applications including Word, Excel, PowerPoint, and Outlook.

• Both Adobe and Office 365 are widely used in businesses for creating, editing, and sharing documents and multimedia content.
Answered by AI
Add your answer
Q3. Communication skills test
Add your answer

Q1. Some Senario Based questions as it require to understand your business acumen and all
Add your answer
Q2. One Proposal making task is given
Add your answer

Q1. Questions regarding BA documentation and deliverables
Add your answer
Q2. Questions related to customer retention and loyalty bonuses.
Add your answer

Percentage,work and time

Q1. Email marketing html related questions
Add your answer

Q1. All questions were related to SQL and Context of the role
Add your answer
Q2. Joins, Unions and case scenario
Add your answer