AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Deloitte
Compare
Filter interviews by
Deloitte Business Analyst Interview Questions and Answers
22 Interview questions
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...
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...
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
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 ...
What people are saying about Deloitte
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...
Nested queries/subqueries are queries within another query, allowing for more complex and specific data retrieval.
Nested queries are enclosed within parentheses and can be used in SELECT, FROM, WHERE, and HAVING clauses.
They can be used to filter results based on the output of another query, or to retrieve data from related tables.
Nested queries can also be used to perform calculations or aggregate functions on th...
Left join, right join, and inner join are types of SQL joins used to combine data from two or more tables based on a related column between them.
Left join: Returns all records from the left table and the matched records from the right table. If there is no match, NULL values are returned for the right table.
Right join: Returns all records from the right table and the matched records from the left table. If there i...
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 ...
LOD (Level of Detail) in Tableau is used to control the level of aggregation in visualizations.
LOD expressions allow you to compute values at different levels of detail in a visualization.
They can be used to create calculated fields that are independent of the visualization's level of detail.
Examples of LOD expressions include FIXED, INCLUDE, and EXCLUDE.
FIXED LOD expressions compute values using a specific dimens...
The amount of paint required to paint an airplane depends on the size and type of the aircraft.
The amount of paint needed will vary based on the size of the airplane and whether it is a commercial or military aircraft.
Factors such as the number of coats, type of paint, and design complexity will also impact the quantity of paint required.
For example, a small private plane may require around 40-50 gallons of paint,...
Deloitte Business Analyst Interview Experiences
65 interviews found
Anonymous
I appeared for an interview in Dec 2024, where I was asked the following questions.
- Q1. The questions were based on scenarios to understand Ba's work.
- Q2. Questions related to agile methodologies
- Q3. If you want can you join as scrum master
- Ans.
Yes, I can join as a Scrum Master, leveraging my skills in agile methodologies and team facilitation.
I have experience in agile project management, which is crucial for a Scrum Master role.
I can facilitate daily stand-ups, sprint planning, and retrospectives effectively.
For example, in my previous role, I led a team through a successful sprint cycle, improving delivery time by 20%.
I am certified in Scrum methodologies,...
Interview Preparation Tips
Tamizh Chelvam
(1 Question)
- Q1. Tell me about ba roles and responsibilities
- Ans.
Business Analysts bridge the gap between stakeholders and IT, ensuring project requirements align with business goals.
Requirements Gathering: Collaborate with stakeholders to identify and document business needs, such as conducting interviews or surveys.
Data Analysis: Analyze data trends to provide insights, like using Excel or SQL to interpret sales data for decision-making.
Process Improvement: Identify inefficiencies...
Selected
I appeared for an interview in Nov 2024, where I was asked the following questions.
- Q1. How do you implement Row-Level Security (RLS)?
- Ans.
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 POLICY' t...
- Q2. What are the components of a dashboard?
- Ans.
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).
Ale...
Krishna Priya
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. Difference between requirement gathering and elicitation
- Ans.
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 focused o...
- Q2. List some prioritisation techniques
- Ans.
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
live to eat
I applied via Referral
Mostly based on SQL power bi and statistics
They generally asked me about zomoto planning and how they're managing profits how can they make more profit
(2 Questions)
- Q1. Introduce yourself
- Ans.
I am a dedicated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.
Experienced in conducting market research and analyzing trends
Skilled in creating detailed reports and presentations for stakeholders
Proficient in using data visualization tools such as Tableau
Strong communication and interpersonal skills
Certified in Business Analysis (e.g. CBAP)
- Q2. Why you want to become business analyst
- Ans.
I want to become a business analyst because I enjoy problem-solving, data analysis, and helping organizations make informed decisions.
I have a strong analytical mindset and enjoy working with data to identify trends and insights.
I am passionate about helping businesses improve their processes and make strategic decisions based on data-driven insights.
I have excellent communication skills and enjoy collaborating with cr...
shalini mitra
(1 Question)
- Q1. Challenges faced in my previous jpb
- Ans.
In my previous job, I faced challenges related to communication, tight deadlines, and adapting to new technologies.
Communication barriers with team members and stakeholders
Meeting tight project deadlines while ensuring quality work
Adapting to new technologies and software systems
Handling conflicting priorities and changing project requirements
I applied via Campus Placement and was interviewed in Oct 2023. There were 2 interview rounds.
The 1st round was aptitude test it was tough
(5 Questions)
- Q1. One on one interview was good the interviewer was friendly and the question where mainly on JD and resume
- Q2. Tell me about your self
- Q3. Your strength weakness
- Q4. Based on your resume
- Q5. And regarding the job description
upsc aspirant
I applied via Naukri.com and was interviewed in Dec 2023. There were 2 interview rounds.
(1 Question)
- Q1. Tell me about yourself
(1 Question)
- Q1. Difference between BRD vs FRD
- Ans.
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 is mo...
(1 Question)
- Q1. Introduce yourself
- Ans.
I am a dedicated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Business Administration
I have experience in conducting market research and analyzing data to identify trends
I am proficient in using tools such as Excel, SQL, and Tableau for data analysis
I have excellent communication skills and can effectively communicate findings to stakeh...
Penugonda Hitesh Reddy
Basic aptitude questions
(1 Question)
- Q1. Asked me a guestimate and about projects
Deloitte Interview FAQs
The duration of Deloitte Business Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Deloitte Interviews By Designations
- Deloitte Consultant Interview Questions
- Deloitte Analyst Interview Questions
- Deloitte Senior Consultant Interview Questions
- Deloitte Assistant Manager Interview Questions
- Deloitte Associate Analyst Interview Questions
- Deloitte Tax Consultant Interview Questions
- Deloitte Business Analyst Interview Questions
- Deloitte Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 32 interview experiences
Difficulty level
Duration
Business Analyst Interview Questions from Similar Companies
Deloitte Business Analyst Reviews and Ratings
based on 204 reviews
Rating in categories
|
Consultant
39.7k
salaries
|  ₹10.1 L/yr - ₹21.4 L/yr |
|
Senior Consultant
24.6k
salaries
| ₹16.5 L/yr - ₹33.1 L/yr |
|
Analyst
16.5k
salaries
| ₹5 L/yr - ₹12 L/yr |
|
Assistant Manager
11.2k
salaries
| ₹12.1 L/yr - ₹22 L/yr |
|
Manager
7.9k
salaries
| ₹24.5 L/yr - ₹43.4 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
- Home >
- Interviews >
- Deloitte Interview Questions
