1Digital Stack Business Analyst Interview Questions and Answers

Q1. Could you describe your past experience with data, your day-to-day work, and the technology stack you have used?
Ans. 
I have extensive experience working with data, utilizing various technologies in my day-to-day work.
• I have worked with SQL databases to extract and analyze data.

• I have used Excel and Tableau for data visualization and reporting.

• I have experience with Python and R for data manipulation and analysis.

• I have worked with ETL tools like Informatica for data integration.

• I have used JIRA and Confluence for project management a
Answered by AI
Add your answer

Q1. Questions on Aptitude to get to know your problem-solving approach - 2 questions
Add your answer
Q2. Guestimate Question
Add your answer

Q1. What are the different types of joins in SQL?
Ans. 
Different types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match 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 rows when there is a match in either table.
Answered by AI
Add your answer
Q2. What is the difference between a Union and an Outer join, and can you provide the syntax for both using two simple tables?
Ans. 
Union combines results from two tables, while Outer join combines matching rows and includes non-matching rows.
• Union combines all rows from both tables, removing duplicates

• Outer join combines matching rows and includes non-matching rows with NULL values

• Syntax for Union: SELECT * FROM table1 UNION SELECT * FROM table2

• Syntax for Outer join: SELECT * FROM table1 LEFT OUTER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer
Q3. I was provided with simple data in Excel and asked to generate the total sales of a product by date and month. (This can be approached by sumifs formula)
Add your answer
Q4. Can you explain how to solve the availability of products throughout the day for campaigns such as Blinkit(campaignid_1) and Zepto (campaignid_2)in Python, using only sorting and removing duplicates, witho...read more
Ans. 
Sort and remove duplicates to ensure availability of products for Blinkit and Zepto campaigns throughout the day in Python.
• Sort the products list for each campaign

• Remove duplicates from the sorted list

• Repeat the process for both Blinkit and Zepto campaigns
Answered by AI
Add your answer

Q1. First round was good. Interviewer was very polite and good and asked about basic MySQL and PowerBI.
Add your answer
Q2. Guesstimate questions
Add your answer

Q1. In second round. Interviewer was very rude and was full of attitude. He was thinking very high of himself. He even told to share screen as if I was cheating. Bad experience
Add your answer
Q2. Only business case interviews
Add your answer

Refer to GFG for Aptitude Prep. It is more than enough.

Q1. Guesstimates & Puzzles were asked. I don't remember it.
Add your answer
Q2. Be thorough with your resume.
Add your answer

Q1. Guesstimates & Excel functions were asked.
Add your answer
Q2. I had Python projects in my resume so libraries and project purpose and methodology was asked.
Add your answer