Tech Mahindra Power BI Developer Interview Questions and Answers

Power bi desktop in power bi service

Q1. What is power bi
Ans. 
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
• Power BI allows users to connect to various data sources and create interactive reports and dashboards.

• Users can easily share and collaborate on reports with others within the organization.

• It offers features like data modeling, data visualization, and data transformation.

• Power BI can be use...read more
Answered by AI
View 1 more answer
Q2. How creative a dashboard in power query
Ans. 
A creative dashboard in Power Query involves using unique visuals and interactive elements to present data in an engaging way.
• Utilize custom visuals to display data in a visually appealing manner

• Incorporate interactive elements such as slicers and filters for user-friendly navigation

• Use color coding and formatting to highlight important insights

• Include dynamic elements like tooltips and drill-down capabilities

• Experimen...read more
Answered by AI
View 1 more answer

Q1. Power bi desktop
Add your answer
Q2. Write the Dax query in data modeling
Ans. 
Write a DAX query in data modeling
• Use CALCULATE function to apply filters and context to calculations

• Use SUMX function to iterate over a table and perform calculations

• Use RELATED function to retrieve related values from other tables
Answered by AI
View 1 more answer

Q1. What is power pivot
Ans. 
Power Pivot is a data modeling tool in Excel that allows users to create relationships, calculations, and measures for analyzing large datasets.
• Power Pivot is an add-in for Excel that enables users to create data models and perform advanced data analysis.

• It allows users to import and combine data from multiple sources, create relationships between tables, and define calculations and measures.

• Users can create complex ca...read more
Answered by AI
Add your answer
Q2. Creation in dax
Ans. 
Creation in DAX refers to the process of generating new calculated columns or measures in Power BI using Data Analysis Expressions.
• Use DAX functions like CALCULATE, SUMX, AVERAGE, etc. to create new columns or measures

• Understand the data model and relationships to create accurate calculations

• Test the newly created calculations to ensure they are working correctly
Answered by AI
Add your answer

Q1. ROW LEVEL SECURITY
Add your answer
Q2. How to install Data Gateway in power bi
Ans. 
Data Gateway can be installed in Power BI by downloading and running the installer.
• Download the Data Gateway installer from the Power BI service

• Run the installer and follow the installation wizard

• Sign in with your Power BI account to register the gateway
Answered by AI
Add your answer

Q1. Introduction, about the Project , Complex Dax written in project
Add your answer

Q1. Explain your project and roles and responsibilities in your project
Add your answer
Q2. Role playing dimension and why do we use star schema.
Add your answer
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...read more
Answered by AI
Add your answer

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
Answered by AI
Add your answer
Q2. Related and lookup value function
Add your answer