Protium Finance Business Analyst Interview Questions and Answers

Use SQL pivot function to convert rows to columns

• Use the PIVOT function in SQL to convert rows into columns

• Specify the columns you want to pivot on and the values you want to display in the new columns

• Example: SELECT * FROM table_name PIVOT (MAX(value_column) FOR pivot_column IN (column1, column2, column3)) AS alias_name

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))

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

I volunteered to work overtime to complete a critical project ahead of schedule.

• Offered to work extra hours to meet project deadline

• Took on additional tasks to ensure project success

• Collaborated with team members to streamline processes and improve efficiency

SQL joins combine data from two or more tables based on a related column between them.

• Inner join returns rows that have matching values in both tables

• Left join returns all rows from the left table and the matched rows from the right table

• Right join returns all rows from the right table and the matched rows from the left table

• Full outer join returns all rows when there is a match in either left or right table