Capgemini
Technobile Systems Interview Questions and Answers
Q1. What are the components of Power bi
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.
Q2. What is mean by M language
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.
Q3. Diff between summarize and summaruzetable
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
Q4. What is mean by DAX
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.
Q5. What is power query
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
Q6. Explain PCF, AI Builder
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
Q7. Explain AI Builder,
AI Builder is a Power Platform service that allows users to easily add AI capabilities to their applications.
AI Builder provides pre-built models for common AI scenarios such as object detection, text recognition, and prediction.
Users can also train custom models using their own data to meet specific business needs.
AI Builder integrates seamlessly with Power Apps and Power Automate to enable automation and decision-making based on AI insights.
More about working at Capgemini
Interview Process at Technobile Systems
Top Power BI Developer Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month