Deloitte Business Analyst Interview Questions, Process, and Tips

1 hour long test of quant, logical, aptitude and verbal english

Basic code which could be done in any language

Q1. What is left join, right join and inner join
Ans. 
Left join, right join, and inner join are types of SQL joins used to combine data from two or more tables based on a related column between them.
• Left join: Returns all records from the left table and the matched records from the right table. If there is no match, NULL values are returned for the right table.

• Right join: Returns all records from the right table and the matched records from the left table. If there is no ...read more
Answered by AI
Add your answer
Q2. How do nested queries/subqueries work
Ans. 
Nested queries/subqueries are queries within another query, allowing for more complex and specific data retrieval.
• Nested queries are enclosed within parentheses and can be used in SELECT, FROM, WHERE, and HAVING clauses.

• They can be used to filter results based on the output of another query, or to retrieve data from related tables.

• Nested queries can also be used to perform calculations or aggregate functions on the res...read more
Answered by AI
Add your answer

Q1. Guesstimate was based on resume and past experience. Guesstimate the number of hair salons in Delhi.
Add your answer

M&A Case - A US based pizza chain wants to expand to India. Evaluate and give recommendations. Had both qualitative section and a quantitative section.

Q1. What do you know about medical coding?
Add your answer

Aptitude and SQL questions

Q1. Ask guesstimate questions and questions related to my engineering domain.
Add your answer
Q2. How much paint require to paint an aeroplane
Ans. 
The amount of paint required to paint an airplane depends on the size and type of the aircraft.
• The amount of paint needed will vary based on the size of the airplane and whether it is a commercial or military aircraft.

• Factors such as the number of coats, type of paint, and design complexity will also impact the quantity of paint required.

• For example, a small private plane may require around 40-50 gallons of paint, whil...read more
Answered by AI
Add your answer

Quantitative aptitude test like CAT was conducted in time limit

Q1. Basic science questions were asked
Add your answer

Average Questions where asked for the test but time was a constraints.

Group discussion results depends on your performance

Q1. One-on-one round is more about being confident than knowing the answer.
Add your answer
Q2. What are the 4Ps of marketing?
Ans. 
The 4Ps of marketing are Product, Price, Place, and Promotion.
• Product: Refers to the actual goods or services being offered to the target market.

• Price: The amount customers are willing to pay for the product or service.

• Place: The distribution channels used to make the product available to customers.

• Promotion: The marketing activities used to communicate the benefits of the product and persuade customers to buy.
Answered by AI
View 1 more answer
Q3. What do you know about work life balance?
Add your answer

Q1. What are accounting standards
Ans. 
Accounting standards are guidelines and rules set by regulatory bodies to ensure consistency and transparency in financial reporting.
• Accounting standards dictate how financial transactions should be recorded, reported, and disclosed in financial statements.

• They help ensure that financial information is reliable, comparable, and relevant for decision-making.

• Examples of accounting standards include GAAP (Generally Accept...read more
Answered by AI
Add your answer
Q2. How would you manage a hectic situation
Add your answer
Q3. Justify your strength in real life scenario
Add your answer