JM&A Group Senior Power BI Developer Interview Questions and Answers

Q1. First round Output of table A 1 1 1 1 B 1 1 1 1 1 how you find it and its result 2. 3 ways to find max and second max in sql 3. Row level security on column 4. index in details
Ans. 
The question involves finding the output of a table, ways to find max and second max in SQL, row level security on column, and index in details.
• To find the output of the table, you need to analyze the pattern of the data and count the occurrences of each value for each letter.

• To find the max and second max in SQL, you can use the MAX() function with ORDER BY and LIMIT clauses, or use a subquery to find the second highe...read more
Answered by AI
Add your answer

Q1. Technical Background Evaluation
Add your answer
Q2. Role level technical questions
Add your answer

Q1. Azure Data Factory, Kusto Query, Azure SQL
Add your answer

Q1. Salary Discussion and notice period
Add your answer

Q1. Scenario based on filter table
Add your answer
Q2. Find rolling total without reset
Ans. 
Calculate rolling total without resetting at specified interval
• Use DAX formula with functions like CALCULATE, FILTER, and EARLIER

• Create a measure that calculates the running total based on the current and previous rows

• Consider using variables to store intermediate results for efficiency
Answered by AI
Add your answer
Q3. Shift one cell Down in table using dax
Ans. 
Use DAX function to shift one cell down in a table
• Use the LAG function in DAX to shift values down in a column

• Specify the number of rows to shift as a parameter in the LAG function

• Example: LAG([Column], 1) will shift values in 'Column' down by one row
Answered by AI
Add your answer

Q1. What are the components of Power bi
Ans. 
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.
Answered by AI
Add your answer
Q2. What is mean by DAX
Ans. 
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,
Answered by AI
Add your answer
Q3. What is mean by M language
Ans. 
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.
Answered by AI
Add your answer

It was a real-time scenario that they asked about.

Q1. Coding based on Collection
Add your answer
Q2. Delegation coding based
Add your answer

Q1. Difference Between direct query mode and import mode
Ans. 
Direct query mode connects to data source in real-time, while import mode loads data into Power BI for faster analysis.
• Direct query mode connects to data source in real-time, providing up-to-date data

• Import mode loads data into Power BI for faster analysis, but may not always reflect real-time changes

• Direct query mode is suitable for large datasets that require real-time updates

• Import mode is suitable for smaller datas
Answered by AI
Add your answer
Q2. Define powerBI in layman poin of view
Ans. 
PowerBI is a data visualization tool that helps users analyze and visualize data to make informed business decisions.
• PowerBI helps in creating interactive reports and dashboards

• It allows users to connect to various data sources like Excel, SQL databases, and cloud services

• Users can create custom visualizations and share insights with others

• PowerBI can be used for data exploration, data modeling, and data storytelling
Answered by AI
Add your answer

Q1. How the end user access the report
Ans. 
End users can access the report through Power BI Service, Power BI Mobile App, or embedded in other applications.
• End users can access the report through Power BI Service by logging in with their credentials

• End users can also access the report through Power BI Mobile App on their smartphones or tablets

• Reports can be embedded in other applications using Power BI Embedded feature
Answered by AI
Add your answer

Q1. Types of Joins in Power Query editor.
Ans. 
There are four types of joins in Power Query editor: Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join.
• Inner Join combines rows from two tables based on a matching column.

• Left Outer Join returns all rows from the left table and the matching rows from the right table.

• Right Outer Join returns all rows from the right table and the matching rows from the left table.

• Full Outer Join returns all rows from bot
Answered by AI
Add your answer
Q2. Types of transformations performed in Power QUERY EDITOR
Ans. 
Power Query Editor allows various transformations on data such as filtering, sorting, merging, splitting, and aggregating.
• Filtering: Removing rows based on certain criteria.

• Sorting: Arranging rows in a specific order.

• Merging: Combining multiple tables or queries into one.

• Splitting: Dividing a column into multiple columns.

• Aggregating: Calculating summary statistics like sum, average, count, etc.
Answered by AI
Add your answer