Accenture Interview Questions, Process, and Tips

It consisted of verbal , logical and some quantitative reasoning.

Easy to moderate questions.
Try to solve as quick as possible

Q1. Explain your best project ?
Ans. 
Developed a mobile app for tracking daily water intake and hydration levels.
• Researched user needs and preferences for a user-friendly interface

• Collaborated with a team of developers to design and implement the app

• Conducted user testing to gather feedback for improvements
Answered by AI
Add your answer
Q2. What challenges you faced?
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. How soon you can join
Add your answer

Dabba software, waste of time, time pass interview

Q1. What are the different data connection modes in Power BI ?
Ans. 
Power BI offers three main data connection modes: Import, DirectQuery, and Live Connection.
• Import mode: Data is imported into Power BI and stored in a local data model.

• DirectQuery mode: Queries are sent directly to the data source in real-time.

• Live Connection mode: Power BI connects directly to the data source without importing data.

• Each mode has its own advantages and limitations based on data size, refresh requiremen
Answered by AI
Add your answer
Q2. What are the different cardinalities in Power BI?
Ans. 
Cardinalities in Power BI refer to the relationships between tables, such as one-to-one, one-to-many, and many-to-many.
• One-to-One: Each record in one table is related to only one record in another table.

• One-to-Many: Each record in one table can be related to multiple records in another table.

• Many-to-Many: Multiple records in one table can be related to multiple records in another table.

• Cardinalities help define how dat...read more
Answered by AI
Add your answer
Q3. What is the difference between Calculated column and a Measure?
Ans. 
Calculated column is a static value calculated for each row, while a Measure is a dynamic value calculated based on filters and context.
• Calculated column is stored in the data model, while Measure is calculated on the fly.

• Calculated column is row-level calculation, while Measure is aggregate calculation.

• Calculated column is used for static values, while Measure is used for dynamic values.

• Example: Calculated column can ...read more
Answered by AI
Add your answer
Q4. What is the usage of DAX functions - FILTER, SUMMARIZE, SUM, SUMX, CALENDAR?
Ans. 
DAX functions like FILTER, SUMMARIZE, SUM, SUMX, CALENDAR are used for data manipulation and calculations in Power BI.
• FILTER function is used to retrieve a subset of data based on specified criteria.

• SUMMARIZE function is used to group data and calculate aggregate values.

• SUM function is used to calculate the sum of values in a column or table.

• SUMX function is used to iterate over a table and perform calculations for eac...read more
Answered by AI
Add your answer
Q5. What are the different approaches for creating tables in Power BI?
Ans. 
There are multiple approaches for creating tables in Power BI, including importing data, entering data manually, and using DAX functions.
• Importing data from external sources such as Excel, SQL Server, or online services like Salesforce

• Entering data manually by typing directly into Power BI's data view

• Using DAX functions to create calculated tables based on existing data
Answered by AI
Add your answer
Q6. What are the different types of data sources you have used in Power BI?
Ans. 
Various data sources used in Power BI include databases, online services, files, and other sources.
• Databases (SQL Server, MySQL, Oracle)

• Online services (Salesforce, Google Analytics)

• Files (Excel, CSV)

• Web sources (HTML, JSON)

• Other sources (SharePoint, Azure)

• APIs (REST, OData)
Answered by AI
Add your answer
Q7. What are bookmarks in Power BI and how to restrict the filters from affecting the visual data while using bookmarks?
Ans. 
Bookmarks in Power BI are used to save the current state of a report page, including filters, slicers, and visuals.
• Bookmarks allow users to save specific views of a report page for easy navigation.

• To restrict filters from affecting visual data when using bookmarks, you can use the 'Edit interactions' feature to control how visuals interact with each other.

• By setting the interactions between visuals to 'None' for certai...read more
Answered by AI
Add your answer

Q1. Which cloud you have worked on
Ans. 
I have worked on AWS, Azure, and Google Cloud Platform.
• Worked extensively on AWS services such as EC2, S3, RDS, and Lambda

• Experience with Azure services like Virtual Machines, Blob Storage, and Azure Functions

• Familiar with Google Cloud Platform services including Compute Engine, Cloud Storage, and Cloud Functions
Answered by AI
Add your answer
Q2. Which automation tools you have worked
Ans. 
I have worked with automation tools such as Ansible, Terraform, and Jenkins.
• Ansible

• Terraform

• Jenkins
Answered by AI
Add your answer