Deloitte Business Analyst Interview Questions and Answers

Business Analysts assess business needs and provide data-driven solutions to improve processes and outcomes.

• Identify stakeholders and gather requirements through interviews and surveys.

• Analyze data to identify trends and areas for improvement, e.g., sales data analysis.

• Create process maps to visualize workflows and identify bottlenecks.

• Facilitate workshops to brainstorm solutions and prioritize initiatives.

• Develop...read more

A dashboard is a visual representation of key metrics and data, designed for quick insights and decision-making.

• Data Visualizations: Charts, graphs, and maps that represent data trends (e.g., bar charts for sales performance).

• Key Performance Indicators (KPIs): Metrics that indicate performance levels (e.g., revenue growth percentage).

• Filters and Controls: Options to customize data views (e.g., date range selectors...read more

Row-Level Security (RLS) restricts data access at the row level based on user roles and permissions.

• Define security policies using DAX or SQL to filter data based on user roles.

• Implement RLS in Power BI by creating roles and defining DAX filters for each role.

• Example: A sales manager can only see data for their region by applying a filter like 'Region = USERPRINCIPALNAME()'.

• In SQL Server, use 'CREATE SECURITY POLI...read more

Prioritisation techniques help in organizing tasks based on importance and urgency.

• MoSCoW method (Must have, Should have, Could have, Won't have)

• Eisenhower Matrix (Urgent vs Important)

• Weighted scoring model

• Kano model (Customer satisfaction vs functionality)

• Value vs Complexity matrix

Requirement gathering is the process of collecting and documenting requirements from stakeholders, while elicitation is the process of drawing out requirements from stakeholders.

• Requirement gathering involves collecting and documenting requirements from stakeholders.

• Elicitation involves drawing out requirements from stakeholders through interviews, workshops, and other techniques.

• Requirement gathering is more focu...read more

Inheritance is a concept in object-oriented programming where a class can inherit attributes and methods from another class.

• Allows for code reusability by creating a new class based on an existing class

• The new class (subclass) can access the attributes and methods of the existing class (superclass)

• Helps in creating a hierarchy of classes with shared characteristics

• Example: Class 'Car' can inherit from class 'Vehic...read more

Validation ensures the product meets the customer's requirements, while verification ensures the product is built correctly.

• Validation checks if the right product is being built, while verification checks if the product is being built right.

• Validation is subjective and involves evaluating the end product, while verification is objective and involves checking the product against specifications.

• Examples: Validating ...read more

BRD focuses on business requirements, while FRD focuses on functional requirements.

• BRD (Business Requirements Document) outlines the business objectives and goals that the project will achieve.

• FRD (Functional Requirements Document) details the specific functionalities and features that the system must have to meet the business requirements.

• BRD is more high-level and focuses on the 'what' of the project, while FRD ...read more