Exam-900 Intro to Power BI_LP08

Name a few of the different types of visualizations available in Power BI.

1) Bar and column charts 2) Cards: Single or Multi row 3) KPIs 4) Maps: Basic maps 5) Pie charts 6) Q&A visuals 7) Tables

What are the steps to install a template app?

1) In the nav pane in the Power BI service, select Apps > Get apps. 2) In the Power BI apps marketplace that appears, select Template apps. All the template apps available in AppSource will be shown. Browse to find the template app you're looking for, or get a filtered selection by using the search box. 3) When you find the template app you're looking for, click it. The template app offer will display. Click GET IT NOW. 4) In the dialog box that appears, select Install (Github repository uasge. The app is installed, along with a workspace of the same name that has all the artifacts needed for further customization.

What are the four types of filters?

1) Report 2) Page 3) Visual 4) Drilltrough.

What are the five main areas of Power Desktop Report View?

1) Ribbon 2) Report view, or canvas 3) Pages tab 4) Visualizations pane 5) Fields pane

Name the four screen on Power Query Editor

1) Ribbon: In the ribbon, the active buttons enable you to interact with the data in the query. 2) Queries: On the left pane, queries (one for each table, or entity) are listed and available for selecting, viewing, and shaping. 3) Center pane: On the center pane, data from the selected query is displayed and available for shaping. 4) Query Settings: The Query Settings window lists the query's properties and applied steps.

List five reasons why people would want to create dashboards?

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

What's a report?

A Power BI report is one or more pages of visualizations such as line charts, maps, and treemaps.

What does a dashboard consist of?

A dashboard is a single canvas that contains zero or more tiles and widgets.

What's a dashboard in Power BI?

A dashboard is something you create in the Power BI service or something a colleague creates in the Power BI service and shares with you.

What's a dataset?

A dataset is a collection of data that you import or connect to. Power BI lets you connect to and import all sorts of datasets and bring all of it together in one place. Datasets can also source data from dataflows.

What's an app in Power BI?

An app is a collection of dashboards and reports built to deliver key metrics to the Power BI consumers in your organization. Apps are interactive, but consumers cannot edit them. App consumers, the colleagues who have access to the apps, do not necessarily need Pro licenses.

What does AppSource connect to?

AppSource 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.

What is AppSource?

AppSource is the place for apps, add-ins, and extensions for your Microsoft software.

What's are Bar and column charts?

Bar charts are the standard for looking at a specific value across different categories

What is the default view when you open a report?

By default, the report opens in Reading view. Just select Edit report to open it in Editing view (if you have the necessary permissions).

What should you be aware of when using Power BI visuals created using Microsoft SDKs?

By using Power BI visuals created with our SDK, you may be importing data from, or sending data to, third party or other services located outside of your Power BI tenant's geographic area, compliance boundary, or national cloud instance.

Explain Capacities. What are they and how do they work?

Capacities are a core Power BI concept representing a set of resources used to host and deliver your Power BI content. Capacities are either shared or dedicated. A shared capacity is shared with other Microsoft customers, while a dedicated capacity is fully committed to a single customer. Dedicated capacities require a subscription. By default, workspaces are created on a shared capacity.

What's are Cards: Single or Multi row?

Cards: Single or Multi row

What are Certified Power BI visuals?

Certified 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.

Explain filter data with Power BI

Data is the core of Power BI. As you explore reports, each visual draws its underlying data from sources that often contain far more data than you need. Power BI offers several ways to filter and highlight reports. Knowing how to filter data is the key to finding the right information.

Who can access data sources added by a workspace member?

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

Give a description or explain how datasets are associated with Power BI?

Datasets are associated with workspaces and a single dataset can be part of many workspaces. When you open a workspace, the associated datasets are listed under the Datasets tab.

What's a Drillthrough filter?

Drillthrough (filter) - Allows you to explore successively more detailed views within a single visual.

What does each dataset represents?

Each listed dataset represents a collection of data, for example, a dataset can contain data from an Excel workbook on OneDrive, an on-premises SSAS tabular dataset, and/or a Salesforce dataset.

What is a tile, how does it work and what's it's function?

Each tile pinned from a report or from Q&A displays a single visualization that was created from a dataset and pinned to the dashboard.

What's a Fields pane

Fields pane - Where query elements and filters can be dragged onto the Report view or dragged to the Filters area of the Visualizations pane.

Who can edit a report if it's in a workspace?

If a report is in a workspace, everyone with an admin, member, or contributor role can edit it. They have access to all the exploring, designing, building, and sharing capabilities of Editing view for that report. The people they share the report with can explore and interact with the report in Reading view.

what access and and privileges you have if a dashboard was shared with you? Also, what limitation?

If the dashboard was shared with you, you will be able to interact with the dashboard and any underlying reports but will not be able to save any changes.

How do you select more than one field in a silcer?

If you want to select more than one field, hold the Ctrl key and click additional fields.

What if you're interested in creating a template app outside of your organization, what should you do?

If you're interested in creating template apps yourself for distribution outside your organization, see Create a template app in Power BI.

What do you build in Power BI Desktop? What view is it?

In Power BI Desktop, you will begin to build reports in the Report view.

What are KPIs?

KPIs are (Key Performance Indicators) Displays progress toward a measurable goal.

What are Maps: Basic maps

Maps are Used to associate both categorical and quantitative information with spatial locations.

What are AppSource Power BI visuals?

Microsoft and community members contribute Power BI visuals for public benefit, and publish them to the AppSource . You can download these visuals and add them to your Power BI reports. Microsoft has tested and approved these Power BI visuals for functionality and quality.

What type of user most likely would use Power BI desktop?

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.

What's my workspace?

My workspace is the personal workspace for any Power BI customer to work with your own content. Only you have access to your My workspace. You can share dashboards and reports from your My Workspace. If you want to collaborate on dashboards and reports, or create an app, then you want to work in a workspace.

Does filtering apply to dashboards?

No. Filtering only applies to reports, not to dashboards

Does filtering affect the source data?

No. 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.

What may happen after you import a visual from AppSource?

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

What's a Page filter?

Page (filter) - Applies to all the visuals on the current report page.

What's a Pages tab?

Pages tab - Located along the bottom of the page, this area is where you would select or add a report page.

What are pie charts

Pie charts show the relationship of parts to a whole.

What is Power BI desktop?

Power BI Desktop is a free application you install on your local computer that lets you connect to, transform, and visualize your data.

What security measures are implemented by Microsoft to ensure data is safe while using Power Bi certified visuals in AppSource?

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

What are the three primary elements of Power BI?

Power BI consists of a 1) Power BI Desktop a Windows desktop application, 2) an online SaaS (Software as a Service) service called the Power BI service, and 3) mobile Power BI apps that are available on phones and tablets.

How are datasets, reports, and dashboards in Power Bi created?

Power BI datasets, reports, and dashboards in Power Bi are created on capacities.

What is Power BI?

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights

What's a key benefit of using Power BI?

Power BI lets you easily connect to your data sources, clean, and model your data without affecting the underlying source, visualize (or discover) what's important, and share that with anyone or everyone you want.

What tool do you use to fix data that's in the wrong format?

Power Query Editor tool: It's possible your data might contain extra data or have data in the wrong format. Power BI Desktop includes the Power Query Editor tool, which can help you shape and transform data so that it's ready for your models and visualizations.

When you share a report, what access privilege do users have?

Read View: The people they share the report with can explore and interact with the report in Reading view.

What's a report filter?

Report (filter) - Applies to all pages in the report.

What's a Report view, or canvas?

Report view, or canvas - Where visualizations are created and arranged.

Give an example of using a report in Power BI. Explain

Reports. For example, when you connect to an Excel workbook that contains Power View sheets, Power BI creates a report based on those sheets. And when you connect to a SaaS application, Power BI imports a pre-built report.

What's a ribbon?

Ribbon - Displays common tasks that are associated with reports and visualizations.

What's Shared Datasets?

Shared datasets are datasets are considered 'one source of truth.' It's a standardized dataset. Your orgs expert data modelers in your organization create and share optimized datasets, report creators can start with those datasets to build accurate reports.

What's the purpose of slicers?

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

What are slicers?

Slicers provide cues to ways you can filter the results in the visuals on a report page. There are several different types of slicers

Where can you submit template apps? What happens after you submitted it?

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

What's a Data View? (underneath Report view, or canvas)

The Data view 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.

What's a filter pane, how does it work?

The Filters pane contains filters that were added to the report by the report designer. As a consumer, you can interact with the filters and save your changes but cannot add new filters.

What's a Model view (underneath Report view, or canvas)?

The Model view allows you to visually set the relationship between tables or elements. A relationship is where two or more tables are linked together because they contain related data. This enables users to run queries for related data across multiple tables.

What are additional tools provided on the Power Query editor ribbon to help transfer your data?

The Power Query Editor ribbon contains additional tools that can help you change the data type of columns, add scientific notation, or extract elements from dates, such as day of the week.

What are the three major building blocks of Power BI?

The major building blocks of Power BI are: datasets, reports, and dashboards.

What's a template app and what benefits and purpose does it provide?

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. As a Power BI partner, you create a set of out-of-the-box content for your customers and publish it yourself.

How many data sources supported?

There are many different data sources supported.

What ways can you add tiles to your dashboard?

There are many ways to add tiles to your dashboard; too many to be covered in this overview topic.

Name some of the different types of slicers

There are several different types of slicers: numeric, categorical, and date.

What are the two modes to view and interact with reports?

There are two modes to view and interact with reports: Reading view and Editing view.

What re the two types of workspaces in Power BI?

There are two types of workspaces: My workspace and workspaces.

What is Power BI designed to do?

These three elements — Desktop, the service, and Mobile apps—are designed to let people create, share, and consume business insights in the way that serves them, or their role, most effectively.

What are datasets, reports, and dashboards in Power Bi organized into?

They are all organized into workspaces,

What's another way of describing a workspace?

Think of workspaces as staging areas and containers for the content that will make up a Power BI app.

How do you access the underlying report in Power BI?

To access an underlying report, select a dashboard tile (more on tiles later) that was pinned from a report. Keep in mind that not all tiles are pinned from reports, so you may have to click a few tiles to find a report.

What do you need to do if you want to be able to install a template app that is not listed on AppSource?

To be able to install a template app that is not listed on AppSource, you need to request the relevant permissions from your admin. See the Template app settings in Power BI admin portal for details.

How do you lanch Power Query Editor?

To begin, select Edit from the Navigator window to launch Power Query Editor. You can also launch Power Query Editor directly from Power BI Desktop by using the Transform Data button on the Home ribbon.

How would you consume these shared datasets?

To consume these shared datasets just choose Power BI datasets when creating your Power BI report.

How do you create a button?

To create a button in Power BI Desktop, on the Insert ribbon, select Buttons and a drop-down menu appears, where you can select the button you want from a collection of options, as shown in the following image.

what happens when you open a dashboard, what access and privileges do you have?

To open a dashboard, select it. When you open an app, you will be presented with a dashboard. If you own the dashboard, you will also have edit access to the underlying dataset(s) and reports.

How do you transfer data in Power BI?

Transfer data: On the center pane, right-clicking a column displays the available transformations. Examples of the available transformations include removing a column from the table, duplicating the column under a new name, or replacing values.

What's a button in Power BI?

Using buttons in Power BI lets you create reports that behave like apps, and thereby, create an engaging environment so users can hover, click, and further interact with Power BI content.

What's a Visual filter?

Visual (filter) - 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.

What's another name for visualizations?

Visualizations are also called visuals.

What's a Visualizations pane

Visualizations pane - Where you can change visualizations, customize colors or axes, apply filters, drag fields, and more.

What happens after you've completed your template app installation?

When the installation finishes successfully, a notification tells you that your new app is ready.

What happens the first time you launch Power BI Desktop?

When you launch Power BI Desktop for the first time, the Getting Started dialog box will appear, which provides useful links to forums, blogs, and introductory videos.

What happens when you open a report?

When you open a report, it opens in Reading view. If you have edit permissions, then you see Edit report in the upper-left corner, and you can view the report in Editing view.

Where are the associated dashboards located when upi open a workspace?

When you open a workspace, the associated dashboards are listed under the Dashboards tab.

When you open a workspace, where are the associated reports listed?

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

What happens when you open an app in Power BI?

When you open an app, you are presented with a dashboard.

What can you do with Power BI desktop?

With Power BI Desktop, you can connect to multiple different sources of data, and combine them (often called modeling) into a data model. This data model lets you build visuals, and collections of visuals you can share as reports, with other people inside your organization.

Explain what a workspace, what is it?

Workspaces are also the places where you create, publish, and manage apps for your organization.

What's a Workspace in Power BI?

Workspaces are containers for dashboards, reports, datasets, and dataflows in Power BI.

What' are workspaces?

Workspaces are used to collaborate and share content with colleagues. You can add colleagues to your workspaces and collaborate on dashboards, reports, and datasets. With one exception, all workspace members need Power BI Pro licenses.

Can an entire report pages be pinned to a dashboard as a single tile?

Yes. Entire report pages can also be pinned to a dashboard as a single tile.

What if you make a mistake, can you undo a step?

Yes. If you make a mistake, you can undo any step from the Applied Steps list.

Where can you add buttons?

You can add buttons to reports in Power BI Desktop and in the Power BI service. When you share your reports in the Power BI service, they provide an app-like experience for your users.

How does template apps help with customer, what can they do with it?

You can build template apps that allow your customers to connect within their own accounts. As domain experts, they can unlock the data in a way that is easy for their business users to consume.

How do you create and use reports?

You can create reports from scratch within Power BI, import them with dashboards that colleagues share with you, or Power BI can create them when you connect to datasets from Excel, Power BI Desktop, databases, and SaaS applications.

What's the benefit of an organization (org) using shared datasets?

Your organization can have consistent data for making decisions, and a healthy data culture.

What happens if you attempt to use an installation link for an app that isn't listed on AppSource?

if you attempt to use an installation link for an app that isn't listed on AppSource, a validation dialog box will ask you to confirm your choice.