Deloitte Data Analyst Interview Questions, Process, and Tips

Aptitude, Verbal, Logical Reasoning, Data Interpretation.

Basic Questions. Just a game of speed.

Result came after 2 days and After 5 days gap, interview was scheduled.

Q1. Tell me about yourself.
Ans. 
I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.
• Experienced in data analysis and interpretation

• Proficient in using statistical tools and programming languages like Python and R

• Skilled in data visualization and creating meaningful reports

• Strong problem-solving and critical thinking abilities

• Effective communication and presentation skills

• Example: I have worke...read more
Answered by AI
Add your answer
Q2. Question related to my internship and asked why are you into coding though you don't have the technical background .. 🙂 (I'm with Economics Degree)
Add your answer
Q3. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going ou...read more
Ans. 
Code to calculate number of people in a room at EOD given X enter and Y leave throughout the day.
• Create a variable to keep track of the current number of people in the room

• Increment the variable by X every time someone enters the room

• Decrement the variable by Y every time someone leaves the room

• Return the final value of the variable at the end of the day

• Example: If 10 people enter and 5 leave, there will be 5 people in
Answered by AI
View 10 more answers
Q4. How to find the minimum number from a given set of numbers ?
Ans. 
To find the minimum number from a set of numbers, compare each number with the others and select the smallest.
• Compare each number with the others in the set

• Select the smallest number as the minimum
Answered by AI
View 3 more answers
Q5. Questions related to CPP.
Add your answer
Q6. Why Deloitte and for this profile? As this profile requires coding .. How will you compete with CS guys? Why should I choose you with an opportunity cost of a CS guy? 👀
Add your answer

Q1. Tell me About Yourself
Add your answer
Q2. Project working and day to day activities I do
Add your answer
Q3. Rate Yourself In SQL out of 5
Add your answer
Q4. Sql 3 question based on windows function
Add your answer
Q5. Very basic python 2 Question
Add your answer
Q6. What You do on power bi in your work Explain with full details workflow
Add your answer

Q1. All 3 sql Questions very simple Round but they didn't provide any Data tables just tell this and that so it may get confusing I slove 2 out of three but rejected on this Round questions Are intermidate
Add your answer

Q1. Was Given two small tables and was asked the total no of rows returned for each kind of join.
Add your answer
Q2. In Tableau if the underlining table columns keep on changing than what can be done so that it wont affect on the view level.
Ans. 
Create calculated fields in Tableau to dynamically adjust to changing table columns.
• Use calculated fields to reference specific columns by name instead of position.

• Utilize parameters to allow users to select which columns to display.

• Consider using custom SQL queries to dynamically adjust to changing table structure.
Answered by AI
Add your answer
Q3. Row level security
Add your answer
Q4. Tell me about your project
Ans. 
Developed a predictive model to forecast customer churn for a telecommunications company.
• Utilized machine learning algorithms such as logistic regression and random forest

• Performed data preprocessing and feature engineering to improve model performance

• Collaborated with business stakeholders to understand key drivers of churn

• Achieved 85% accuracy in predicting customer churn
Answered by AI
Add your answer

It was medium and if you focus you should be able to complete that!

Q1. Heat map and tree map difference and what you did so far in Tableau!
Ans. 
Heat maps display data in colors on a grid, while tree maps show hierarchical data using nested rectangles.
• Heat maps use colors to represent data values on a grid, while tree maps use nested rectangles to display hierarchical data.

• In Tableau, I have created heat maps to visualize sales data across different regions, and tree maps to show the sales distribution by product categories.

• Heat maps are useful for identifying ...read more
Answered by AI
Add your answer
Q2. Tool tips use. Types of graph which can help in KPIs
Ans. 
Different types of graphs like bar charts, line graphs, and pie charts can help in visualizing KPIs effectively.
• Bar charts can be used to compare KPIs across different categories or time periods.

• Line graphs are useful for showing trends and changes in KPIs over time.

• Pie charts can display the proportion of each KPI relative to the total.

• Combination charts can be used to show multiple KPIs in a single graph for comparis
Answered by AI
Add your answer

Q1. Cultural fit question and scenario questions.
Add your answer

Q1. Tell me about yourself ?
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Experienced in analyzing large datasets to extract valuable insights

• Proficient in using tools like SQL, Python, and Tableau

• Strong communication skills to present findings to stakeholders
Answered by AI
Add your answer
Q2. Explain SQL order of execution
Ans. 
SQL order of execution determines the sequence in which the different clauses in a SQL query are processed.
• SQL order of execution: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

• FROM: Specifies the tables involved in the query.

• WHERE: Filters the rows based on specified conditions.

• GROUP BY: Groups the rows based on specified columns.

• HAVING: Filters the groups based on specified conditions.

• SELECT: Retrieves the columns ...read more
Answered by AI
Add your answer