Moder Solutions Business Analyst Interview Questions and Answers

Q1. Questions based on the understanding of joins in sql
Add your answer
Q2. Convert row to columns using sql
Ans. 
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
Answered by AI
Add your answer

Q1. Result of different sql joins
Ans. 
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
Answered by AI
Add your answer

Q1. Joins, case when
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them. Case when is a conditional statement used to perform different actions based on different conditions.
• Joins are used to retrieve data from multiple tables based on a related column

• Case when is used to perform different actions based on different conditions in SQL queries

• Example: SELECT * FROM table1 JOIN table2 ON table1.id = ...read more
Answered by AI
Add your answer

Q1. Joins, SQL query execution
Add your answer
Q2. Simple Sals Question - SQL
Add your answer

Q1. Explain your projects
Add your answer

Q1. Tell me about yourself
Ans. 
I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.
• Experienced in gathering and analyzing business requirements

• Skilled in creating detailed reports and presentations

• Proficient in using data visualization tools like Tableau

• Strong communication and interpersonal skills

• Certified in Agile methodologies
Answered by AI
Add your answer
Q2. What is your day 2 day activities
Ans. 
As a Business Analyst, my day-to-day activities involve gathering and analyzing data, creating reports, identifying business trends, and collaborating with stakeholders.
• Conducting meetings with stakeholders to gather requirements

• Analyzing data to identify trends and insights

• Creating reports and presentations to communicate findings

• Collaborating with cross-functional teams to implement solutions

• Monitoring and evaluating
Answered by AI
Add your answer
Q3. How many applications have been made
Ans. 
The number of applications made is confidential and not publicly disclosed.
• The exact number of applications made is not publicly available.

• The company may choose to keep this information confidential for competitive reasons.

• It is important to respect the company's decision to not disclose this information.
Answered by AI
Add your answer

Q1. CTC discussion present and expectations
Add your answer
Q2. When can you 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

Aptitude tests + 3 Rounds