Introduction to Power BI (PL-900)

Power BI connects to ______ existing data sources.

900+

Business Intelligence

A collaborative activity that involves the use of data to inform business decisions.

Dataset

A collection of data that you import or connect to.

Power BI

A collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights.

Power BI Desktop

A free application for connecting to, transforming, and visualizing data.

Power BI Pro License

A license required for most users of Power BI who need to create, view, or share content.

My Workspace

A personal workspace in Power BI that allows the user to work with their own content, with access restricted to only the user.

Dashboard

A single canvas that contains zero or more tiles and widgets. Each tile displays a single visualization that was created from a dataset and pinned to the dashboard. Entire report pages can also be pinned to a dashboard as a single tile.

One Source of Truth

A single version of the truth about an organization's data that can be used consistently across the organization.

Visual

A type of filter that applies to a single visual on a report page. You only see visual level filters if you have selected a visual on the report canvas.

Report

A type of filter that applies to all pages in the report.

Page

A type of filter that applies to all the visuals on the current report page.

Visualizations

Also called visuals, these are graphical representations of data that can be used to better understand and communicate insights.

Workspace

An environment where you collaborate with your colleagues to create and share content, such as dashboards, reports, and datasets.

Microsoft and community members have contributed Power BI visuals for public benefit, and publish them to the ______.

AppSource

_________ is the place for apps, add-ins, and extensions for your Microsoft software. __________ connects millions of users of products such as Microsoft 365, Azure, Dynamics 365, Cortana, and Power BI, to solutions that help them get work done more efficiently and insightfully than before.

AppSource

_______ Power BI visuals are visuals in AppSource that meet certain specified code requirements that the Microsoft Power BI team has tested and approved. The tests are designed to check that the visual doesn't access external services or resources.

Certified

A single dataset can be part of many workspaces, and when you open a workspace, the associated datasets are listed under the ________ tab.

Datasets

Standardized Datasets

Datasets that have been structured in a consistent way so that they can be easily shared and reused across an organization.

Power BI consists of a Microsoft Windows desktop application called Power BI ______.

Desktop

If you have edit permissions, you can view the report in _______ view.

Editing

Power BI template apps

Enable Power BI partners to build Power BI apps with little or no coding and deploy them to any Power BI customer.

Data Modelers

Experts who design and create data models that structure data in a way that makes it easy to analyze and use.

Reports are the data collections that Power BI uses to create its visuals. (T/F)

False

Relationship

In Power BI Desktop, a link between two or more tables that contain related data, enabling users to run queries for related data across multiple tables.

Power BI visuals on AppSource have been tested and approved by ______.

Microsoft

Template apps are submitted to the Partner center to become publicly available in the Power BI Apps marketplace and on ______.

Microsoft AppSource

Most users who work on business intelligence projects use

Power BI Desktop to create reports, and then use the Power BI service to share their reports with others.

_______ is required for most users of Power BI who need to create, view, or share content.

Power BI Pro License

Out-of-the-box content

Prebuilt content that is ready to use without any modifications or customizations.

Consumers with access to apps do not necessarily need _______ licenses.

Pro

The people who have a report shared to them can explore and interact with the report in _______ view.

Reading

There are two modes to view and interact with reports:

Reading view and Editing view.

When you open a workspace, the associated reports are listed under the ________ tab. Each listed report represents one or more pages of visualizations based on only one of the underlying datasets.

Reports

Power BI allows you to create reports from scratch, import them with dashboards shared by colleagues, or create them when you connect to datasets from Excel, Power BI Desktop, databases, and ________ applications.

SaaS

Power BI Datasets

Shared datasets that can be used to build accurate reports in Power BI.

Workspaces

Shared spaces in Power BI used for collaborating and sharing content with colleagues, including dashboards, reports, and datasets. All workspace members, with one exception, need Power BI Pro licenses.

______ make it easy to filter all the visuals on the page at once.

Slicers

_______ provide cues to ways you can filter the results in the visuals on a report page.

Slicers

Data view

The area in Power BI Desktop that allows you to view all of the available data in your report, check data types, and validate data.

Model view

The area in Power BI Desktop that allows you to visually set the relationship between tables or elements.

Ribbon

The area in Power BI Desktop that displays common tasks related to reports and visualizations.

Fields pane

The area in Power BI Desktop where query elements and filters can be dragged onto the Report view or dragged to the Filters area of the Visualizations pane.

Report view/canvas

The area in Power BI Desktop where visualizations are created and arranged.

Visualizations pane

The area in Power BI Desktop where you can change visualizations, customize colors or axes, apply filters, drag fields, and more.

Pages tab

The area in Power BI Desktop where you can select or add a report page.

Power BI

a business analytics service by Microsoft that provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

Datasets

a collection of data that Power BI uses to create its visuals.

Dashboards

a combination of visuals from one or more reports.

When expert data modelers in your organization create and share optimized datasets, report creators can start with those datasets to build ________.

accurate reports

Power BI allows you to interact with and understand your data to influence ______.

all business systems

A workspace is a staging area and container for the content that will make up a Power BI _______.

app

Workspaces are also used for creating, publishing, and managing _______ for an organization.

apps

Power BI _______ are visuals in the AppSource that were additionally tested to check that the visual does not access external services or resources.

certified visuals

Power BI partners can build template apps with little or no ______.

coding

Power BI lets you turn your simple Microsoft Excel workbook or a collection of cloud-based and on-premises hybrid data warehouses into ______ insights.

coherent

Power BI Pro licenses are necessary for workspace members to _____ on dashboards, reports, and datasets.

collaborate

Workspaces are used to collaborate and share content with _______.

colleagues

Each listed dataset in the workspace represents a _________ which can come from different data sources, such as an Excel workbook on OneDrive, an on-premises SSAS tabular dataset, and/or a Salesforce dataset.

collection of data

An app is a collection of dashboards and reports built to deliver key metrics to the Power BI _______ in an organization.

consumers

Datasets added by one workspace member are available to the other workspace members with an admin, member, or ________ role.

contributor

The new Power BI template apps enable Power BI partners to build Power BI apps with little or no coding and deploy them to any Power BI ______.

customer

Workspaces can be used to collaborate on _______ and _______ in Power BI.

dashboards, reports

Workspaces are containers for _____, _____, _____, and _____ in Power BI.

dashboards, reports, datasets, and dataflows

The Data view in Power BI Desktop allows you to view all of your

data available in your report. This is an easy way to quickly check data types and validate data.

Datasets can also source data from ________.

dataflows

Each tile in a dashboard displays a single visualization that was created from a ______ and pinned to the dashboard.

dataset

Power BI enables you to share your insights with anyone or ______ you want.

everyone

Capacities are used to _____ and _____ Power BI content.

host and deliver

App consumers are able to _______ the apps but cannot edit them.

interact with

When you filter a visual like a bar chart, you are . . .

just changing the view of the data in that visual. You are not modifying the source data in any way.

Power BI enables you to connect to your data sources, clean, and ______ your data.

model

There are several different types of slicers:

numeric, categorical, and date.

Power BI lets you connect to and import all sorts of datasets and bring all of it together in ________ .

one place

Power BI is a Software as a Service (SaaS) solution, meaning it is available ______.

online

My Workspace is a _______ workspace in Power BI.

personal

Power BI has mobile apps that are available on ______ and tablets.

phones

The Model view in Power BI Desktop allows you to visually set the

relationship between tables or elements.

The Model view in Power BI Desktop allows you to visually set _____ between tables or elements.

relationships

The Pages tab in Power BI Desktop is where you would select or add a _____ page.

report

Filtering only applies to . . .

reports, not to dashboards.

Power BI online service is called the Power BI ______.

service

By default, workspaces are created on a _____ capacity.

shared

Shared capacities are _____ with other Microsoft customers.

shared

Dedicated capacities are fully committed to a _____ customer.

single

Business intelligence is a collaborative activity. It's important to establish _________________________ ;' Discovering and reusing those ______________ is key.

standardized datasets that can be the 'one source of truth; standardized datasets

Reports

the visuals that Power BI creates using the data in datasets.

A dashboard can contain zero or more ______ and widgets.

tiles

Why do people create dashboards? Here are just some of the reasons:

to see, in one glance, all the information needed to make decisions. to monitor the most-important information about your business. to ensure all colleagues are on the same page, viewing and using the same information. to monitor the health of a business or product or business unit or marketing campaign, etc. to create a personalized view of a larger dashboard and show all the metrics that matter to them.

There are _____ types of workspaces in Power BI.

two

You can visualize and discover important insights using Power BI without affecting the ______ source.

underlying

Once Power BI visuals from AppSource are imported, visuals may be _______ without any additional notice.

updated automatically

A Power BI report is one or more pages of _________.

visualizations

Each listed report in the Reports tab represents one or more pages of _______ based on only one of the underlying datasets.

visualizations

Visualizations in Power BI reports are also called ________.

visuals

Everyone with an admin, member, or contributor role can edit a report if it is in a _______.

workspace

Dashboards are combinations of visuals from one or more reports. (T/F)

True

Datasets are collections of data that Power BI uses to create its visuals. (T/F)

True

My workspace and workspaces are the two types of workspaces in Power BI. (T/F)

True