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
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
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
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
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?
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
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
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
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,
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.
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.
c. Customizable dashboards
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-
b. Excel reports in Power BI service can be shared via Content packs like oth
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
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!