AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Accenture
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Accenture Power BI Developer Interview Questions, Process, and Tips
Top Accenture Power BI Developer Interview Questions and Answers
- Q1. Difference between row contex and example of dax function which allows row context.
- Q2. Different types of gateways?? When why and how we use ??
- Q3. Role playing dimension and why do we use star schema.
Accenture Power BI Developer Interview Experiences
7 interviews found
Anonymous
(2 Questions)
- Q1. Wat is cardinality
- Ans.
Cardinality refers to the uniqueness of values in a column or relationship.
Cardinality is the number of unique values in a column or relationship.
High cardinality means a column has many unique values, while low cardinality means few unique values.
For example, a column like 'Customer ID' may have high cardinality, while 'Gender' may have low cardinality.
- Q2. Challenges faced
(1 Question)
- Q1. Write SQL query
- Ans.
SQL query to retrieve data from a table
Use SELECT statement to specify columns to retrieve
Use FROM statement to specify the table to retrieve data from
Use WHERE statement to filter the data based on conditions
Skills evaluated in this interview
I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.
(2 Questions)
- Q1. About previous experience
- Q2. About previous project
Interview Preparation Tips
Saurabh Pal
(1 Question)
- Q1. What type of time intelligence function you have used
- Ans.
I have used DAX time intelligence functions like TOTALYTD, SAMEPERIODLASTYEAR, etc.
TOTALYTD function calculates the year-to-date total for a given expression
SAMEPERIODLASTYEAR function returns the value of the same period in the previous year
DATESYTD function returns a set of dates year-to-date based on the current context
What people are saying about Accenture
(1 Question)
- Q1. Difference between calculated column and measure
- Ans.
Calculated columns are static values calculated at the row level, while measures are dynamic values calculated at the aggregate level.
Calculated columns are stored in the data model and can be used in visuals directly.
Measures are calculated on the fly based on the context of the visualization or report.
Calculated columns are useful for creating new columns based on existing data, while measures are used for aggregatio
Accenture interview questions for designations
Selected
I appeared for an interview before Mar 2024.
(3 Questions)
- Q1. Explain your project and roles and responsibilities in your project
- Q2. Role playing dimension and why do we use star schema.
- Q3. Difference between row contex and example of dax function which allows row context.
- Ans.
Row context refers to the current row in a table during DAX calculations, allowing for row-specific evaluations.
Row context is established when a DAX formula is evaluated for each row in a table.
An example of a DAX function that allows row context is 'SUMX', which iterates over a table and evaluates an expression for each row.
In 'SUMX(Table, Expression)', 'Table' provides the row context for 'Expression'.
Another exampl...
(2 Questions)
- Q1. How do you apply RLS in your report?
- Ans.
RLS in Power BI restricts data access based on user roles, ensuring users see only relevant data.
Define roles in Power BI Desktop using DAX filters to restrict data visibility.
Example: Create a role 'Sales' with a filter like [Region] = USERNAME() to show data only for the user's region.
Publish the report to Power BI Service and assign users to the defined roles.
Test the roles in Power BI Desktop using the 'View as Rol
- Q2. Related and lookup value function
Get interview-ready with Top Accenture Interview Questions
(1 Question)
- Q1. Cardinality in power bi
- Ans.
Cardinality in Power BI refers to the uniqueness of values in a column or relationship.
Cardinality can be one-to-one, one-to-many, or many-to-many.
It helps determine how data should be modeled and relationships should be established.
For example, a one-to-many cardinality means one value in one table can be related to multiple values in another table.
(1 Question)
- Q1. Different types of gateways?? When why and how we use ??
- Ans.
There are three types of gateways in Power BI: On-premises data gateway, Personal gateway, and Power BI Gateway (Enterprise). Each serves a different purpose.
On-premises data gateway is used to connect on-premises data sources to Power BI service.
Personal gateway is used for individuals to refresh data from on-premises data sources.
Power BI Gateway (Enterprise) is used for organizations to manage data refresh for cloud...
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Aug 2022. There was 1 interview round.
(2 Questions)
- Q1. Connection modes in Power BI and how they work
- Ans.
Power BI has three connection modes: Import, DirectQuery, and Live Connection.
Import mode imports data into Power BI and creates a dataset.
DirectQuery mode connects to the data source and queries data in real-time.
Live Connection mode connects to a published dataset in Power BI Service.
Import mode is best for small to medium-sized datasets, while DirectQuery and Live Connection are better for large datasets.
DirectQuery...
- Q2. Row level security in Power BI
- Ans.
Row level security in Power BI allows restricting data access based on user roles and filters.
Row level security can be implemented using roles and filters in Power BI.
Roles can be created and assigned to users or groups to restrict access to specific data.
Filters can be applied to tables or columns to limit data visibility based on user roles.
Row level security can be tested using the View As Roles feature in Power BI...
Interview Preparation Tips
No need to worry, after my technical interview, i received a mail selected for HR interview and after 7 days of technical interview, received a call from Accenture person to fill the LOA form shared on my email ID by Accenture.
Should have hands-on experience in Power BI Desktop.
Knowledge about different things we can do in Power BI Service
Sum/Sumx, Dax/Calculated Columns, Performance analyzer in Power BI
Learn about Data Modeling in Power BI also
And SQL in Power BI also
Skills evaluated in this interview
Interview questions from similar companies
Gaurav Sharma
I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. Types of Security in Power BI?
- Ans.
Power BI provides various types of security to protect data and control access.
Row-level security allows restricting data access based on user roles or filters.
Data encryption ensures that data is securely stored and transmitted.
Azure Active Directory integration enables centralized user authentication and access control.
Power BI service provides access and sharing controls to manage permissions.
Data loss prevention po...
- Q2. How and where Gauge charts are used?
- Ans.
Gauge charts are used to visually represent a single value within a given range.
Gauge charts are commonly used in business dashboards to display key performance indicators (KPIs).
They provide a quick and intuitive way to assess the current status or progress towards a goal.
Gauge charts can be used to show metrics such as sales targets, customer satisfaction scores, or production efficiency.
They are effective in highlig...
- Q3. What is Gateway and Dataflow?
- Ans.
Gateway is a tool that allows Power BI to connect to on-premises data sources. Dataflow is a self-service data preparation tool in Power BI.
Gateway enables Power BI to securely access on-premises data sources.
Dataflow allows users to extract, transform, and load data from various sources into Power BI.
Gateway and Dataflow work together to enable data refresh and data preparation in Power BI.
Gateway can be used to conne...
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. All basic questions in first round and little technical in second round. The interview process is very friendly. No need to worry.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Feb 2021. There were 4 interview rounds.
(1 Question)
- Q1. Sql and os related questions,Java based
(4 Questions)
- Q1. What are your salary expectations?
- Q2. What is your family background?
- Q3. Where do you see yourself in 5 years?
- Q4. Tell me about yourself.
Interview Preparation Tips
Accenture Interview FAQs
Tell us how to improve this page.
Accenture Interviews By Designations
- Accenture Associate Software Engineer Interview Questions
- Accenture Application Developer Interview Questions
- Accenture Application Development Analyst Interview Questions
- Accenture Software Developer Interview Questions
- Accenture Software Engineer Interview Questions
- Accenture Analyst Interview Questions
- Accenture Application Development Associate Interview Questions
- Accenture Senior Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Power BI Developer Interview Questions
- Power Programmer Interview Questions
- Power Plant Engineer Interview Questions
- MSBI and Power BI Developer Interview Questions
- Power Apps Developer Interview Questions
- Backup Administrator Interview Questions
- Power Electronics Engineer Interview Questions
- Power Plant Manager Interview Questions
- Show more
Accenture Power BI Developer Interview Process
based on 12 interviews
2 Interview rounds
- Technical Round - 1
- Technical Round - 2
Power BI Developer Interview Questions from Similar Companies
Fast track your campus placements
Accenture Power BI Developer Reviews and Ratings
based on 28 reviews
Rating in categories
|
Application Development Analyst
39k
salaries
|  ₹3 L/yr - ₹12 L/yr |
|
Application Development - Senior Analyst
27.4k
salaries
| ₹7 L/yr - ₹20.2 L/yr |
|
Team Lead
24.8k
salaries
| ₹7.2 L/yr - ₹26 L/yr |
|
Senior Software Engineer
18.2k
salaries
| ₹6 L/yr - ₹20 L/yr |
|
Senior Analyst
17.8k
salaries
| ₹5.5 L/yr - ₹21 L/yr |
TCS
Cognizant
Capgemini
Infosys
- Home >
- Interviews >
- Accenture Interview Questions >
- Accenture Power BI Developer Interview Questions
