Power BI Interview Questions and Answers
What you'll learn
- Understand what kind of Questions are asked in Power BI and how to answer the same.
- Covers Power BI questions around Calculated columns,Calculate measures , M Codes , Power Query, Parameters , Power BI gateway, visual level vs page level vs rep
- How to tackle Power BI Interview Questions around All vs All Except ,What IF , Grouping in power BI , Distinct vs Values.
- How to confidently answer questions around Sum vs Sumx , Query vs Direct Query
- Basic SQL Server knowledge.
UPDATE (Jan 2023): We're pleased to let you know that we have just published a new video on variables (DAX VAR) and power bi pivot and unpivot. This new year 2023 we are planning to add more videos in this course especially around advance DAX questions like Time Intelligence Questions, Dashboards and Row Level Security and many more.
So stay updated and please subscribe to this course.
Covers Calculated Columns, Measures, Power Query, Data Gateway & Parameters :-
Question 01 :- What are Calculated columns ?
Question 02 :- Where can calculated columns be created in Power BI?
Question 03 :- What are calculated measures in Power BI?
Question 04 :- Where can calculated measures be created in Power BI?
Question 05 :- Difference between Calculated Column and Measure in Power BI?
Question 06 :- What are M codes in power bi & Where Can You Write Power Query M Code?
Question 07 :- What are Parameters in Power BI?
Question 08 :- What is Power BI data gateway?
Question 09 :- Do we need data gateway for schedule refresh in Power BI?
Question 10 :- What is Query Folding in Power BI?
Question 11 :- What is the use of Split function in Power BI?
Question 12 :- Difference between visual level, page level and report level filters in Power BI?
Questions on ALL & ALL EXCEPT functions, Grouping , what if parameter, Distinct :-
Question 13:- Difference between ALL and ALL EXCEPT functions?
Question 14:- What is "What if" parameter in Power BI?
Question 15:- How to keep or remove specific rows in Power BI?
Question 16: What is grouping in power bi and how to use it?
Question 17:- Difference between Distinct and Values in Power BI?
Important questions on DAX, DAX Function, Power Query, Power BI Reports :-
Question 18:-What is DAX and most common DAX functions used?
Question 19:- What is Power Query?
Question 20:- What are different types of Filters in Power BI Reports?
Differentiating between sum vs sumx and Direct Query vs Import Query :-
Question 21 :- Difference between sum and sumx in power bi?
Question 22 :- Import Query vs Direct Query in power bi?
Append Query vs Merge Query and different types of Power BI Joins :-
Question 23 - Append Query VS Merge Query in Power BI ?
Question 24 - Types of Join and Types of Join kind in Power BI ?
LookupValue DAX function, Differentiate Datesbeteween VS DatesinPeriod in Power BI.
Question 25 - What is LookupValue DAX function in Power BI ?
Question 26- Understand Datesbetween vs DatesinPeriod ?
Crack Power BI Interview Questions on COUNTA, COUNTX, COUNTAX, Filter Top N.
Question 27 - COUNT, COUNTA, COUNTX, COUNTAX, COUNTBLANK, DISTINCTCOUNT, COUNTROWS ?
Question 28 - How to filter Top N in Power BI ?
Difference between USERELATIONSHIP and TREATAS, Bookmark in Power BI.
Question 29 :- Power BI USERELATIONSHIP VS TREATAS ?
Question 30:- What is Bookmark in Power BI?
Variables in Power BI and how Power Pivot and Unpivot differs from each other.
Question 31 - Variables in Power BI ?
Question 32 - Power Pivot VS Power Unpivot ?
Essential questions around Table Joins, Crossjoin and DAX RANX Function.
Question 33 - How to use the DAX RANKX function in Power BI?
Question 34 - Table Joins - Crossjoin, Union, Except & Intersect?
Explain how to use Calculate DAX Function ?
Question 35 :- How to use Calculate DAX Function in Power BI ?
RELATED VS RELATEDTABLE, DATEADD & PARALLELPERIOD Functions in DAX.
Question 36 :- What is the difference between Related and RelatedTable ?
Question 37 :- What is the use of DateAdd and ParallelismPeriod Functions?
Who this course is for:
- Power BI Developers who are looking for cracking interview.
Quest IT , brand name QuestPond started 15 years back with the one single goal of creating quality step by step IT programming related lessons for C#, MSBI, Power BI, SQL Server, Angular, ASP.NET MVC and a lot more.
The main goal of QuestPond is to create Step by Step lessons & Interview Question and Answer courses in a simplified manner for .NET freshers and Architects.