Deloitte Data Analyst Interview Questions, Process, and Tips

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

Many questions on SQL and python programing and some questions on general aptitude

Q1. They asked about my projects which i mentioned in my cv
Add your answer
Q2. Sub query in Sql
Ans. 
A subquery in SQL is a query nested within another query to retrieve data from multiple tables.
• Subqueries can be used in SELECT, INSERT, UPDATE, and DELETE statements.

• They can be correlated or non-correlated.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);
Answered by AI
Add your answer
Q3. Some basic on c++ programming
Add your answer

Q1. I rejected because they have already selected people they want
Add your answer
Q2. I rejected me because i did not give proper answers
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