Power BI Interview Questions and Answers

In this blog, we will learn most asked interview questions and answers as regards to Microsoft Power BI.

What is Power BI

Power BI is an analytical tool for visualizing data by creating reports, dashboards, charts, graphs, data modelling and so on to enable user interpretation of data. Data can be imported into and exported out of Power BI. You can integrate Power BI with other Microsoft solutions such as Azure data services, embed Power BI visuals into Power BI apps, enable peer-to-peer sharing, access image recognition and text analysis, create machine learning models and integrate with Azure machine learning.

1. Uses of Power BI

a. To build reports and Dashboards

b. Helps in data exploration

c. Integrates with other Microsoft solutions

d. Data exploration using natural language query

e. Building Power BI apps

2. What is Power Pivot Data Model?

Power BI data model is made up of data types, tables, columns and table relations. Power Data models are usually meant for holding data for business entities.

3. List important Power BI tools

a. Power BI Desktop – used by desktop computers

b. Power BI Service – basically a Software as a Service (SaaS) tool

c. Mobile Power BI apps – used for iOS and Android devices.

4. Power BI tool kits and functions

a. Power Map – creates geospatial representations of data

b. Power Query – enables discovery, and connectivity from other data     

    sources.

c. Power Pivot – A modelling tool

d. Power View – visualization/Presentation tool for creating charts, graphs,

maps and so on.

e. Power Q&A – Allows using natural language to access answers to questio

ns.

5. What is Dynamic Filtering

     Dynamic filtering deals with selecting a record from another sheet faster

     by filtering the sheet based on data you entered on the sheet.

6. How to perform Dynamic filtering in Power BI

a. After data set up, publish a detailed report to power BI

b. Publish to custom workspace

c. Create a filter link

d. Create a DAX calculated column

e. Public overview report

7. Most common used DAX functions.

a. SUM, MIN, MAX, COUNTROWS, DISTINCTCOUNT

b. IF, AND, OR, SWITCH

c. VALUES, ALL, FILTER, CALCULATE

d. UNION, INTERSECT, EXCEPT, NATURALINNERJOIN,

     NATURALLEFTOUTERJOIN, SUMMARIZECOLUMNS, ISEMPTY

e. ISBLANK, ISFILTERED, ISCROSSFILTERED

f. VAR(Variables)

g. GEOMEAN, MEDIAN, DATEDIFF

8. What are filters in Power BI?

       a. Visualization filter – applied directly on individual visualizations.

       Also applied on both data and calculation conditions used within a

       Visualization.

       b. Page-level-filter – applied on a particular page within a report.

       c. Report-level filter – applied to an entire report include every visualiza

tion and every page.

9. What is a DAX function

DAX (Data Analysis Expressions) function in Power BI is a formula language used to create formulas for Power BI that extend our data model.

It is a formula language used to compute calculated column and calculated field.

a. DAX cannot modify or insert data

b. DAX works on column values

c. Calculated and measured columns can be created with DAX but rows     

     cannot be calculated using DAX.

10. List Data types of DAX?

a. DateTime

b. String

c. Numeric

d. Decimal

e. Boolean

11. What are benefits of using variables in DAX

a. Variables make DAX expressions easy to interpret.

b. Variables when used in DAX improve performance

c. Variables simplify debugging

12. Advantage of using a variable in Power BI

       Variables create logical queries and usually used for multiple DAX

       Functions.

13. Distinguish between MAX and MAXA functions

       Max – for calculating numeric values

       MAXA – for non-numeric values

14. What is the difference between COUNT and COUNTD function?

       Count functions returns to count, excluding NULL values whereas

       CountD returns distinct vaues which exclude NULL values.

15. What is the use of MID function?

       MID function returns string character from the specified index posit

       ion.

16. List Marketplace where you can download Power BI Mobile apps.

       a. App store

       b. Window store       

c. Google play

17. Context style allowed by Power BI DAX

      a. Row and

      b. Filter

18. What is Self-Service Business Intelligence?

Power BI is a self-service business intelligence tool (SSBI). A self-service business intelligence tool allows technical and non-technical users work with data to create reports, analyze and visualize data.

19.  List Data types available in Power BI Get Data.

        a. File – Excel, Text/CSV, JSON, PDF, SharePoint

        b. Database – SQL Server Database, Access database, Oracle   

        database, SAP HANA database, MySQL, IBM, Teradata, Impala,

        Amazon redshift, Google, Big Query.

        c. Power BI – Power BI data sets, Power BI data flow.

        d. Azure – Azure SQL database, Azure blob storage, Azure Data Wa

        rehouse, Azure Data Lake, Azure HD Insight, Azure Cosmos DB, etc.

        e. Online Services – Google Analytics, Salesforce, Azure Devops, Dy

        namics 365, Facebook, Github, Quickbase etc.

        f. Other – Python script, ODBC, Spark, R script, OLE DB, Active directory,

Web etc.

20. What are the important components of Power BI?

a. Data Integration

b. Data Processing and

c. Data Presentation or Visualization

21. Explain Visualizations in Power BI.

Visualization is a visual representation of data. In Power BI data can be visualized in various ways such as Bar charts, Area chart, Column chart, Area chart, Stacked area chart, Ribbon chart, Waterfall chart, Scatter chart, Pie chart, Funnel chart, Tree map chart, Donut chart, Gauge chart, Cards, KPI, Slicer, Table, Matrix, R script visual, Python script visual.

22.  What are some differences in data modelling between Power BI Desktop and Power Pivot for Excel?

a. Power BI Desktop supports bi-directional cross filtering relationships, security, calculated tables and direct query options.

b. Power Pivot for Excel has single direction (one to many) relationships, calculated columns only and supports import mode only. Security roles can be defined in Power Pivot Excel.

23. Explain Reports in Power BI.

Reports in Power BI mean a multi-view of different kinds of visual representation of data. These visual representations can be in form of graphs, charts etc.

Power BI Dashboards, Reports etc.

24.  Explain Dashboards in Power BI.

Dashboards are called canvas and known as a single page visualization of data sets.

25. What is a Power BI Service?

A power BI service is a cloud-based SaaS platform that provide business intelligence services such as viewing/sharing dashboards and reports implemented on Power BI platform.

26. List key features and capabilities of Power BI.

a. Datasets

b. Reports

c. Customizable dashboards

d. Tiles

e. Get Data

f. Navigation pane

g. Ad Hoc reporting

h. Ad Hoc analysis

i. Q&A Question box

j. Help and Feedback buttons

k. Row level security

l. Trend Indicators

m. Mobile device compatibility

n. Interactive reports authoring

o. Online analytical processing (OLAP)

p. Complete reporting and data visualization tools

27. What is Power Query?

 Power query is a Power BI platform that enables discovery, connection and combination of data to meet data analysis needs.

28. Can SQL and Power Query/Query editor be used together?

Yes, A SQL statement can be defined as the source of a Power Query/M function for additional processing/logic.

29. Name ways Excel experience can be leveraged with Power BI

a. Excel workbook Power Pivot models can be imported to Power BI Deskto-

p models.

b. Excel reports in Power BI service can be shared via Content packs like oth

er reports.

c. Excel workbooks can be uploaded to Power BI and viewed in the browser

like Excel services.

d. Excel workbooks (model and tables) can be exported to service for PBI

report creation.

30. What is a Tile in Power BI?

    Tiles is an important feature of Power BI services that serves as a pictur

e of data that can be pinned to the dashboard.    

       

I believe with the questions and answers above, you will be prepared for any Power BI interview.

Wish you all the best!

      

Please follow and like us:

Leave a Reply

Your email address will not be published. Required fields are marked *