Deloitte Junior Data Analyst Interview Questions and Answers

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented Junior Engineer with a passion for problem-solving and continuous learning.
• Graduated with a degree in Engineering from XYZ University

• Completed internships at ABC Company, gaining hands-on experience in project management

• Proficient in CAD software and technical drawing
Answered by AI
Add your answer
Q2. Diagram of water treatment
Ans. 
Water treatment involves a series of processes to remove impurities and make water safe for consumption.
• Water treatment typically involves processes such as coagulation, sedimentation, filtration, and disinfection.

• Coagulation involves adding chemicals to water to make particles clump together for easier removal.

• Sedimentation allows the larger particles to settle at the bottom of a tank.

• Filtration involves passing water...read more
Answered by AI
Add your answer

Q1. Personal details
Add your answer
Q2. Why you want to join
Ans. 
I want to join because I am passionate about engineering and eager to learn and grow in a dynamic environment.
• Passionate about engineering

• Eager to learn and grow

• Excited about working in a dynamic environment
Answered by AI
Add your answer

POV on banning the cigarette

Q1. Tell me about your self
Add your answer
Q2. How did you know the company
Add your answer

Q1. Tell me about your self
Add your answer
Q2. Who is inspiration to you in your life
Add your answer

Q1. Case about peofitability and data analysis
Add your answer

Q1. Case about technology and behavioural questions
Add your answer

Basic aptitude test consisting questions of Logical reasoning, quant, and English

Q1. Guesstimate - How many red cars are purchased in Delhi?
Ans. 
It is estimated that around 20% of cars in Delhi are red, so approximately 1 out of every 5 cars is red.
• Consider the total number of cars in Delhi

• Estimate the percentage of cars that are red

• Calculate the number of red cars based on the percentage
Answered by AI
Add your answer

Q1. Guesstimate - Size of mattresses market in Delhi?
Ans. 
The size of the mattresses market in Delhi can be estimated by considering the population, average household size, and consumer preferences.
• Consider the population of Delhi and the average household size to estimate the number of households in need of mattresses

• Research the average spending on mattresses per household in Delhi

• Take into account the various types of mattresses available in the market and their respective...read more
Answered by AI
Add your answer

Q1. Strengths and weakness
Add your answer
Q2. Relocation? How would you manage travel?
Ans. 
I am open to relocation and willing to manage travel efficiently.
• I am flexible and willing to relocate for the right opportunity.

• I will plan ahead and research the best travel options available.

• I am comfortable with long commutes or temporary accommodations if needed.
Answered by AI
Add your answer

Basic accounting anf financial questions were asked

Q1. Xlookup, vlookup Pivot chart Excel
Add your answer
Q2. Accouting ratios DPO
Add your answer
Q3. Ebitda how to calculate and meaning
Ans. 
EBITDA stands for Earnings Before Interest, Taxes, Depreciation, and Amortization. It is a measure of a company's operating performance.
• Calculate EBITDA by adding back interest, taxes, depreciation, and amortization to net income.

• EBITDA is used to analyze and compare profitability between companies.

• It helps in assessing a company's ability to generate cash flow.

• EBITDA is commonly used in valuation and financial analysi...read more
Answered by AI
Add your answer

Q1. How do you handle big data?
Ans. 
I handle big data by utilizing advanced analytics tools and techniques to extract valuable insights.
• Utilize data visualization tools to identify patterns and trends

• Use machine learning algorithms to predict future outcomes

• Implement data cleaning and preprocessing techniques to ensure accuracy

• Collaborate with data engineers to optimize data storage and retrieval

• Stay updated on the latest advancements in big data technol
Answered by AI
Add your answer

Apptitude round mainly english