Celebal Technologies Power BI Developer Interview Questions, Process, and Tips

Q1. What is append in power query
Ans. 
Append in Power Query is used to combine multiple tables or queries into a single table or query.
• Append is used to stack tables on top of each other, adding rows from one table to the end of another.

• It is useful when you have multiple tables with the same structure and want to combine them into one.

• You can append tables from different data sources or within the same data source.

• For example, you can append sales data fr...read more
Answered by AI
Add your answer
Q2. What is merge in power query
Ans. 
Merge in Power Query combines multiple tables into one by matching rows based on specified columns.
• Merge is used to combine tables in Power Query

• You can merge based on one or more columns

• Different types of merges include inner, left outer, right outer, and full outer joins
Answered by AI
Add your answer

Q1. What is filter context
Ans. 
Filter context determines which rows of data are visible to calculations in DAX formulas.
• Filter context is dynamic and changes based on user interactions.

• It can be set by slicers, filters, or relationships between tables.

• Filter context is used to calculate results based on the current filter selections.

• It helps in determining which rows of data are included in calculations.
Answered by AI
Add your answer
Q2. What is summarize function
Ans. 
Summarize function is used in Power BI to aggregate data based on specified columns.
• Used to group data and perform aggregate functions like sum, count, average, etc.

• Can be used in DAX formulas to create calculated columns or measures.

• Example: SUMMARIZE('Table', 'Column1', 'Column2', SUM('Value'))
Answered by AI
Add your answer

Q1. Basics about power bi and dax
Add your answer

Aptitude consists of apti,reasoning, sql and power bi questions, some verbal questions too.

Q1. Power bi and sql questions
Add your answer

Q1. I did'nt cleared tr,so don't know about hr.
Add your answer