OSB India Business Analyst Interview Questions and Answers

Query to retrieve last month's data on the 1st of every month

• Use the DATEADD function to subtract a month from the current date

• Filter the results to only include data from the 1st of the month

• Example: SELECT * FROM table_name WHERE date_column = DATEADD(month, -1, DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0))

To increase sales, focus on improving customer experience, offering promotions, and expanding your reach.

• Improve customer experience by providing excellent service and addressing their needs

• Offer promotions such as discounts, free gifts, or loyalty programs to incentivize purchases

• Expand your reach through targeted marketing campaigns and partnerships with other businesses

• Analyze sales data to identify trends and adjus

Agile methodology is a project management approach that emphasizes flexibility, collaboration, and incremental progress.

• Focus on delivering working software in short iterations

• Embrace changing requirements

• Encourage frequent collaboration between team members

• Use feedback to continuously improve the product

• Common frameworks include Scrum and Kanban

User story for a shopping website

• As a user, I want to be able to add items to my cart

• As a user, I want to be able to view my cart and update quantities

• As a user, I want to be able to proceed to checkout and make a payment