Power BI

Question 1

Parts/elements of Power BI

Answer 1

1) Power BI Desktop - Microsoft windows desktop application (create)
2) Power BI Service - online SaaS (share)
3) Mobile Power BI Apps for Windows, iOS and Android. (consume)

Question 2

Building Blocks of Power BI

Answer 2

1) Visualizations / visual
2) Datasets
3) Reports
4) Dashboards
5) Tiles

Question 3

Views in Power BI Desktop

Answer 3

RDM

1) Report
2) Data
3) Model

Question 4

Datasets

Answer 4

1) Collection of data that Power BI uses to create its visualizations.
2) Can be single table or combination of different data sources, which you can filter and combine to provide a unique collection of data (dataset) for use in Power BI.
3) For example, you can create a dataset from three database fields, one website table, an Excel table, and online results of an email marketing campaign. That unique combination is still considered a single dataset, even though it was pulled together from many different sources.

Question 5

Report

Answer 5

1) collection of visualizations that appear together on one or more pages.
2) a report in Power BI is a collection of items that are related to each other.

Question 6

Dashboard

Answer 6

When you’re ready to share a single page from a report, or a collection of visualizations, you create a dashboard

Question 7

Tile

Answer 7

1) In Power BI, a tile is a single visualization on a report or a dashboard.
2) It’s the rectangular box that holds an individual visual
3) When you’re viewing, or consuming, a dashboard or report—which means you’re not the creator or owner, but the report or dashboard has been shared with you—you can interact with it, but you can’t change the size of the tiles or their arrangement.
4) After a visual has been pinned to a dashboard, it’s called a tile.
5) Can also pin tiles from one dashboard to another.

Question 8

App

Answer 8

1) is a collection of preset, ready-made visuals and reports that are shared with an entire organization.

Question 9

Make sure the data is formatted as table.

Answer 9

For Power BI to import data from your workbook, that data needs to be formatted as a table

Question 10

Power Query Editor

Answer 10

can help you shape and transform data so that it’s ready for your models and visualizations.
Uses M Language

Question 11

Append Queries

Answer 11

add data from a new table to an existing query.

Question 12

Merge Queries

Answer 12

Additional columns. Power BI pulls data that you select from multiple tables or various files into a single table.

Question 13

Measures

Answer 13

1) Measures are defined calculations on your data that are performed at the time of your query.
2) Measures are calculated as you interact with your reports and aren’t stored in your database.
3) From the Formula bar, you can enter the DAX expression that defines your measure.
4) Measures integrate seamlessly with slicers, segmenting your data on the fly, which means that you can define a measure once and then use it in many different visualizations

Question 14

Calculated tables

Answer 14

1) calculated tables provide intermediate calculations and data that you want stored as part of the model rather than as part of a query.
2) You can use calculated tables, for example, to cross join two tables.
3) After the new table has been created, you can use your calculated table as you would any other table in relationships, formulas, and reports.

Question 15

Slicer

Answer 15

is an “on-canvas” visual filter that allows report users to segment the data by a specific value

Question 16

Share reports

Answer 16

Anyone whom you share a dashboard with can see and interact with it exactly as you do. However, they have read-only access to the underlying reports, and they have no access to the underlying datasets.

Question 17

Share and Collaborate with Power BI

Answer 17

Power BI offers various ways of sharing and collaborating with colleagues on your dashboards, reports, and datasets including:

1) Publish your reports from Power BI Desktop to the Power BI service.
* Power BI packages your report and data, including visualizations, queries, and custom measures, and uploads them to the Power BI service.
2) Create Apps that package a dashboard, report, and dataset to send to your colleagues, who can use the content pack as a starting point and further enhance it.
3) Create Groups, which you can use as a security model to identify a subset of users who have access to dashboards, reports, and datasets that you create.
4) Publish to the web so that live reports can be embedded in a webpage.

Question 18

extension for Power BI Reports

Answer 18

.pbix

Question 19

Ways to share dashboard

Answer 19

1) email address
2) distribution list
3) security group
4) Microsoft 365 group
* you can also share a dashboard from the Power BI mobile apps.
* Use a security group, not a distribution group, to share with a group that includes people with external email addresses

Question 20

Power BI Alert

Answer 20

can be added to KPI, Gauge and card visuals.

Question 21

Security roles needed by user ‘Power Apps Checker’ for Solution checker

Answer 21

Export Customizations
Solution Checker
The application user for solution checker requires an access mode of ‘Non-Interactive’ or ‘Read-Write’

Question 22

2 options when you are updating the solutions that you’ll be deploying as managed solutions

Answer 22

Patch: A patch is a minor change or bug fix for a solution. (same major and minor number, a higher build or revision number than parent solution version number)
major.minor.build.revision
Clone: A clone is a new major version of the solution. Cloning a solution doesn’t create a copy of the solution; it rolls up all the patches in the solution and creates a new version of the solution ~(can only set major and minor numbers)