Capgemini Power BI Developer Interview Questions and Answers

Power BI components include Power Query, Power Pivot, Power View, Power Map, and Power Q&A.

• Power Query: Used for data extraction and transformation.

• Power Pivot: Used for data modeling and analysis.

• Power View: Used for interactive data visualization.

• Power Map: Used for geographical data visualization.

• Power Q&A: Allows users to ask questions in natural language and get answers from data.

M language is a powerful data transformation language used in Power Query in Power BI.

• M language is used to transform and clean data in Power BI.

• It is a functional language with a wide range of functions and operators.

• M language is case-sensitive and uses a step-by-step approach to data transformation.

• Examples of M language functions include Table.TransformColumns and List.Transform.

summarize is used to aggregate data at a specified level, while summarizetable is used to aggregate data across multiple tables.

• summarize is used with a single table, while summarizetable can be used with multiple tables

• summarize can only be used with columns from the specified table, while summarizetable can be used with columns from multiple tables

• summarize can be used to create new columns, while summarizetable is used to aggregate data

DAX stands for Data Analysis Expressions and is a formula language used in Power BI for creating custom calculations.

• DAX is used to create custom calculations in Power BI, similar to Excel formulas.

• It can be used to create calculated columns, measures, and calculated tables.

• DAX functions can be used to manipulate data, perform calculations, and create complex expressions.

• Examples of DAX functions include SUM, AVERAGE, CALCULATE, and RELATED.

Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources.

• Power Query is a data transformation tool in Power BI used to import, transform, and clean data before loading it into the data model.

• It allows users to connect to various data sources such as Excel, databases, web services, and more.

• Users can perform data cleansing, transformation, and shaping operations using a user-friendly interface....read more

PCF stands for PowerApps Component Framework, AI Builder is a tool in Power Platform for building AI models.

• PCF is a framework for building custom controls in PowerApps and Dynamics 365

• AI Builder is a tool that allows users to build AI models without needing coding skills

• AI Builder can be used for tasks like object detection, form processing, and prediction