Deloitte Financial Planning and Analysis Analyst Interview Questions and Answers

Q1. Power BI Difference between ALL() and ALLSELECTED()
Ans. 
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
• ALL() removes all filters from the specified column or table.

• ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

• Example: ALL('Table') would remove all filters on the 'Table' in the query context.

• Example: ALLSELECTED('Column') would remove filte...read more
Answered by AI
Add your answer
Q2. Excel Difference between COUNT() and COUNTA()
Ans. 
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
• COUNT() counts only cells with numerical values.

• COUNTA() counts all non-empty cells, including text and errors.

• Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
Answered by AI
Add your answer

Q1. Resume based questions like explain the projects that you have done.
Add your answer
Q2. Sample dataset questions
Add your answer

It was a altitude test.

Q1. It was a technical inyerview.
Add your answer

Q1. This was 2nd thechnical interview.
Add your answer

Q1. Final hr round. Job relayed discussion
Add your answer

Q1. Basics of power bi and sql
Add your answer
Q2. What are joins and types of join
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one 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 JOIN...read more
Answered by AI
Add your answer
Q3. How to add date table in power bi
Ans. 
To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.
• Create a new table in Power BI with a list of dates

• Add columns for day, month, year, etc. for additional analysis

• Establish relationships between the date table and other tables in the data model
Answered by AI
Add your answer

Q1. Sql scenario based question on joins
Add your answer
Q2. Window function questions
Add your answer
Q3. Performance tuning
Add your answer
Q4. Power bi dax question
Add your answer

You have to pass aptitude test with minimum 75%.

Q1. What is the use of financial statements in business.
Ans. 
Financial statements are essential tools used by businesses to communicate their financial performance and position to stakeholders.
• Financial statements provide a snapshot of a company's financial health at a specific point in time.

• They help investors and creditors assess the company's profitability, liquidity, and overall financial stability.

• They are used by management to make informed decisions about the company's op...read more
Answered by AI
Add your answer
Q2. How do we calculate debt to equity ratio.
Ans. 
Debt to equity ratio is calculated by dividing total debt by total equity.
• Calculate total debt by adding short-term and long-term debt

• Calculate total equity by adding common stock, retained earnings, and additional paid-in capital

• Divide total debt by total equity to get the debt to equity ratio
Answered by AI
Add your answer

Q1. Personal Information.
Add your answer
Q2. Family Background.
Add your answer

Q1. All questions were industry specific
Add your answer

Q1. How do you calculate market size and share?
Ans. 
Market size is calculated by multiplying the total number of potential customers by the average price of the product. Market share is calculated by dividing a company's sales by the total market sales.
• Market size = Total number of potential customers x Average price of the product

• Market share = Company's sales / Total market sales

• Data sources for market size and share include surveys, industry reports, and sales data

• Ma...read more
Answered by AI
Add your answer
Q2. What is supplier scouting?
Ans. 
Supplier scouting is the process of identifying and evaluating potential suppliers for a company's procurement needs.
• It involves researching and analyzing potential suppliers' capabilities, quality, reliability, and pricing.

• Supplier scouting helps companies find the best suppliers to meet their specific needs and requirements.

• It can involve attending trade shows, networking events, and conducting site visits to evaluat...read more
Answered by AI
Add your answer

Smooth test, LR, DI and quant questions

Q1. Guesstimate based on your resume/extra curriculars
Ans. 
Guesstimate the impact of my resume/extra curriculars
• Analyze the relevant skills and experiences mentioned in the resume

• Consider the impact of extracurricular activities on personal development

• Evaluate the potential value I can bring to the role based on my background

• Assess the alignment between my qualifications and the job requirements
Answered by AI
Add your answer

Q1. Market entry or profitability case solving
Add your answer

Q1. Quality analyst roles and responsibilities
Add your answer
Q2. Knowledge on denial management
Add your answer