Top 30+ Power BI frequently asked Interview Questions in MNC'S

POWER BI INTERVIEW Q & A.

Power BI Interview Q&A

1- Define Power BI.

Answer:- A cloud-based data sharing environment, Power BI allows anyone to analyze and visualize data with greater efficiency, speed and understanding. Besides, it helps in connecting users to a wide range of data with the help of easy-to-operate dashboards, compelling visualizations, and interactive reports bringing data to life.

2- What are the building blocks of Power BI ?

Answer:- Power map, power view, power pivot, power query, power BI desktop.

3- What are the advantages of Power BI?

Answer:- Advantages of Power BI.

• Integrates well with the existing application
• It contains Rich and personalized Dashboards.
• Publishing of reports in a secured way
• Quick accessibility to data which means there is no memory and speed issue

 4-What is Power BI Service?

Answer:- Power BI Service is a cloud based analytic solution where it helps you to design reports, create dashboards and publish ,collaborate and share the reports with internal and external stakeholders power Bi service is a cloud based solution which is used to make reports ,visualization of data ,creating dashboards so that one can publish collaborate and share among the stake holders.

5-What are the different components in Power BI?

Answer:The different components we use in power bi are Power BI Service, Power Query, Power Pivot, Power View, Power Map, Data Management Gateway, Power BI Q&A, Data Catalog, Power map ,power view ,power pivot ,power query ,power BI desktop ,power Q & A.

6-What is power BI Desktop?

Answer: Power BI desktop is a free application which can be installed in your local files and can be used for visualzing and tranforming the data and making dashboards with it.

7-List out the Key Components in Power BI?

Answer:- There are different components in Power BI as listed below,

• Power BI Service
• Power Query,
• Power Pivot,
• Power View,
• Power Map,
• Data Management Gateway,
• Power BI Q&A,
• Data Catalog”

 8-Different Products in PowerBI family?

Answer:

• PowerBI Desktop
• PowerBI Service
• PowerBI Mobile Apps
• Onpremises Gateway
• PowerBI Report Server

9-What are the kind of Licences are available in PowerBI?

Answer:

• Power BI Free
• Power BI Pro
• PowerBI Premium

10-What are the data types in Power BI?

Answer:

1.Numeric(Decimal,Fixed Decimal,Whole)

2.Text

3.Date/Time

4.Boolean(true/false)

5.Binary

11- What is Vizualization in Power BI ?

Answer :- Visualization is a process of representing the data in pictorial form like graphs or tables or charts based on the requirements.

12- What are the Different types of filters available in Power BI ?

Answer:- Filters are broadly classified into three types based on their levels and they are as follows

• Visual level filter
• Report level filter
• Page level filter.

13- What are Tiles in Power BI?

Answer:- it is a feature of power BI services and can be said as a still of the data or snap shot of the data which can be pinned to the dashboard.

14- What is on-premise Gateway?
Answer:- In Power BI On premise gate way acts as a bridge which is used to transfer the data which is on premise (not on cloud ) in a safe and secure way .

 15-What is DAX?

Answer: Dax  (Data Analysis Expressions) is a Formulae expression language ,It can be used in different BI tools, This is the combination of multiple functions which will be helpful in data Analysis Calculations

16-What are the two ways to use power bi?

Answer:

• Power BI service
• Power BI desktop

17- What is Power BI service?

Answer: Power BI service is a cloud-based application which is hosted in com.

18 What is Power BI desktop?

Answer: Power BI desktop is a free – open source application which can be installed in your PC. The reports developed in power bi can be published to Power BI service.

19- What are the features of Power BI desktop?

Answer:

• Able to pull in data from variety of sources
• Create relationships between your data and enrich your data model
• Create and save your reports
• Upload and publish your reports.

20- In terms of Pricing, how can power BI be categorized?

Answer:

• Power BI (Free)
• Power BI Pro (Licensed)

21- What are the different types of refresh in Power BI?

Answer:

• Package Refresh
• Model/data Refresh
• Tile Refresh
• Visual Container Refresh

22- What are the different DAX Functions?

Answer: The different DAX functions are

•  1.Aggregation functions,
• Counting functions,
• Logical functions,
• Information functions,
• Text functions,
• Date functions”

23- What are the mostly used DAX Functions?

Answer: The mostly used aggregate DAX are MIN, MAX, AVG, COUNTROWS, DISTINCTCOUNT, for conditional DAX AND, OR, SWITCH are available others are ISBLANK, ISFILTERED, ISCROSSFILTERED, ALL, FILTER, CALCULATE, INTERSECT, EXCEPT, NATURAL INNER JOIN, NATURALLEFTEROUTERJOIN, SUMMARIZECOLUMNS, ISEMPTY,VAR, GEOMEAN, MEDIAN, DATEDIFF.”

24-What are the advantages of using variables in power bi?

Answer: Variables are used to create more logical Queries and can be used for multiple DAX functions.

25- How to Calculate MTD WTD and YTD in Power BI?

Answer: We can use DAX Formulas to find MTD, YTD and WTD  as given below  YTD_Sales = CALCULATE(Sum(Sales[Sales_Product]),YEAR(Sales[CreatedDate])=YEAR(TODAY())) ,MTD_Sales = CALCULATE(sum(Sales[Sales_Product]),MONTH(Sales[CreatedDate])=MONTH(TODAY())), WTD_Sales = CALCULATE(sum(Sales[Sales_Product]),WEEKNUM(Sales[CreatedDate])=WEEKNUM(TODAY()))

26- How to use calculate DAX Function?

Answer: Calculate function is mostly used in power BI from simple filters to Complex functions.

27- What is very unique in case of CALCULATE DAX Functions?

Answer: changes can only be made to filter context of measurer by using calculate DAX.

28-Can we have multiple active relationship in Power BI?

Answer: No, We cannot set up more than one active relationship in Power BI.

29-What are the kind of Licences are available in PowerBI?

Answer:

• Power BI Free
• Power BI Pro
• PowerBI Premium

30- What are the three main tabs in Reports development Window?

Answer:

• Relationship tab
• Datamodeling Tab
• Report Tab

31- How many default Graphs(Visualizations) in Power BI?

Answer: 26 Views

32- What are three Important Tasks in Creating Dashboards in PowerBI?

Answer: There are three main Important Steps involved in creating Dashboard

1.Make sure  the proper relationship between tables.

2.Data modeling according the requirement

3.Creating Reports with suitable Graphs which make sense

Thanks & Regards
Power Bi Community
Please comment to add more questions on to Blog.