Power BI Desktop Interview Questions
1) what is Power BI Desktop?
2) what is Power Pivot, Power View, Power Map & Power Query?
3) What is self service BI?
4) What is Dax?
5) How you can implement the Security In PBI?
6) What Data Sources Can PowerBi Connect to?
7) What are the different types of filters in PBI?
8) what is Book marks and Sync Slicers?
9) What are the Most common dax function used
10)What is the Filter Function used and Calculate?
11)Sum, Sumx , Calcuate, Count , CountA, Calender, CalenderAuto,Min, Max, Groupby, Related,Summarize...
12)what is the differnce between Measure and columnn?
13)What is data model and Which model you can use?
14)Diff between
a)one-one
b)one-Many
c)Many-one
d)Many-Many
e)Single direction Filter
f)Both Direction Filter
15)Types of Dimensions what are those?
16)How to use measures as a Filter?
17)what are the Different Connections Types avaliable in PBI?
a)Explain Clearly
18)How to Add Two columns in PowerBI without dax?
19)How to unable the table to load data into model?
20)What is conditional Formatting?
A)How to Implement that?
21)I have a username "XYZ@abc.com" how to convert Two columns As XYZ and abc?
22)Which Language are used in M and What is the use of that?
23)Diff B/W Dax & M?
24)How to Remove Duplicate in your Data?
25)what is varabile in dax?
a)Benfits of using variable in Dax?
26)what is KPI?
a)how to Create KPIs in Power BI?
27)How to create Custom visuals in PowerBI?
28)How to create Custom Functions In Power BI?
29)What is X-velocity in-memory analytics engine used in Power Pivot?
a)What is Vertipaq?
30)can we have more than one active relationship in PBI?
a)If not Why?
31)what are the some common query Transformations in power Query?
32)what is PBIX and PBIT?
33)what is latest version of PBI Desktop and What are the new features Added in PBI desktop?
34)Diff B/W 2016 and Current PBI Desktop ?
35)What is parameter and Query Parameter?
36)which chart is suitable for your data and how to choose?
37)what is Running Total?
38)How to Impliment dynamic level security in pbi?
39)what is Trendline, MinLine, Maxline,Avg line?
40)What is hierarchy in PBI?
41)What is Drill Down and Drill Up and Drill through?
42)What is Bins And Grops?
Power BI Services Interview Questions
1)what is power BI service?
2)What is Gateway?
3)What are different types of gateways?
4)What are different types of Dashboard Sharing options?
5)what is contentpack?
6)what are different building blocks in PBI?
7)how to schedule refresh in PBI?
8)what is Cognitive Services in Power BI?
9)Diff B/W Desktop and Service?
10)what is NLQ in Power BI?
(Continue the exploration with Q&A (natural language querying))
11)How to create Dashboards in PowerBI Service?
12)How to cleanup workspace?
13)How to connect online sources through power BI?
14)How to integrate Machine learning with PowerBI?
15)What is new in Power BI Service?
16)what are general gateway issues?
17)what is Gateway Clustering?
18)how to Improve PBI Report Perfomance?
19)What is PBI Premium?
20)Diff b/w PBI And Premium?
21)What is Paginated Reports?
22)how to Monitor Premium capacity?
23)kinnd of data in PowerBI Services?
24)What are the diff Ways to Share your work in PowerBI?
25)Types of Refreshes in PBI?
26)How to Monitor usage metrics for Power BI dashboards and reports?
27)what are diff licencing in PBI?
28)how to make self service data preparation?
29)How to troubleshoot your Problem? with some examples?
30)what is Embedded Analytics?
31)what can I do with the PowerBI API?
32)how to push data into a Dataset?
33)what is Automation retention policy for real-time data?
34)How to Register APP with Azure AD?
35)what is Power BI Rest API's and Limitations?
36)what is Power BI report Server?
37)Diff b/w Report Server and Pro and premium?
39)How to configure Proxy setting for Gateway?
40)what is SSO (single sign On)?
41)How to Stop and Start PBI Gateways?
42)How to install Gateway and Merge Gateway?
43)Trouble shooting on onpremises gateway?
44)What is Power Bi Administration?
45)Administaration roles in O365?
46)How to Track service health?
47)how to close your PBI Account?
48)how to find users that have signed in?
49)What is Power BI Mobile?
50)How to Subscribe Your Report?
51)Can we refresh our Power BI reports once uploaded to cloud?
52)Is Power BI available on-premises?
53)What is Power BI Q&A?
54)What are the differences between a Power BI Dataset, a Report, and a Dashboard?
55)what are the Benifits of PBI Mobile Apps?
No comments:
Post a Comment