[MUSIC].
>> Module 1, Part 2, Power BI overview.
>> I'm Peter Myers, the course developer.
>> I'm Alon Baram, I'm a Senior Product Manager.
>> In this video, we'll introduce Power BI core concepts.
The core concepts we'll cover
include the Power BI service,
workspaces, datasets, reports, dashboards, and Q&A.
>> Power BI is a collection of software services,
apps, and connectors that work together.
The Power BI service, which is
app.powerbi.com, is the SaaS,
Software-as-a-Service, part of Power BI.
It allows you to create, share,
and consume business insights.
>> Now the Power BI workspace is
an important concept and it
acts as a container for Power BI content.
There are two types of workspaces:
the personal workspace and the workspace.
These workspaces store content types like dataflows,
datasets, workbooks, reports, and dashboards.
We'll introduce some of those content types shortly.
Workspace architecture has changed,
and it's important to understand that by default,
all workspaces are the new workspace experiences.
They're no longer based on Office 365 groups,
and new workspaces will be
required for certain types of embedding.
Creating, and publishing content
to non-personal workspaces requires
a Power BI Pro or Power BI Premium Per User license.
They are a recommended practice for production content.
>> Datasets are another Power BI concept.
Power BI datasets represent a source of
data ready for reporting and visualization.
A report is based on a single dataset,
and a dataset can be used by multiple reports.
Note that datasets will be discussed in
more detail when describing data permissions in Module 6.
>> Now there are two types of
reports supported by Power BI:
the Power BI report and the Power BI paginated report.
Let me now describe Power BI reports in more detail.
Power BI reports are optimized
for exploration and interactivity.
They present your data using
a comprehensive range of ultra-modern visuals,
and they're ideal for analytical reports,
enabling your report users to explore
data and discover relationships and patterns.
They can be developed in the Power BI service,
but preferably you develop them using the desktop tool,
Power BI Desktop, and they are
the most commonly embedded report type in apps.
You can refer to these reports
as interactive analytic reports.
Let's take a look at an example.
Here is the Regional Sales Analysis report
for the Tailspin Toys company.
It's a good example of an analytic report.
It supports filtering with slices across the top and
displays high-level summary values
and interactive visuals.
It's designed specifically to explore and
discover answers to a broad array of business questions.
Note that it can be multi-page,
but the dimensions of the page itself are fixed.
>> Let me now describe Power BI paginated reports:
Paginated reports are optimized for
printing or PDF generation.
They provide you with the ability to produce
highly formatted, pixel-perfect layouts.
They are based on SQL Server Reporting Services,
SSRS, and Report Definition Language (RDL) reports.
They're ideal for operational reports like
sales orders and are developed
using Power BI Report Builder.
>> For those that already have background with
SQL Server Reporting Services report design,
those skills can be directly applied to
developing Power BI paginated reports.
Now to contrast them with Power BI reports,
we often refer to them as pixel-perfect reports.
Let's take a look at an example.
This Sales Order report is designed
to list each line of a sales order.
There could be hundreds of order lines,
so a paginated report can overflow
those rows to multiple pages when necessary.
>> Let me now describe Power BI dashboards:
A Power BI dashboard is intended to monitor data,
displaying a collection of
up-to-date data in tiles on a single pane.
Typically tiles are pinned from
report visuals or Q&A responses.
>> The last core concept is Q&A:
You can use Q&A to explore data using
intuitive natural language capabilities,
and Power BI can respond with
answers as data visualizations.
The feature is available in
several places, on Power BI dashboards,
but also as a visual in Power BI reports.
Supported languages are English
and Spanish, which is in Preview.
The Q&A experience can also be embedded
in apps. Here's an example.
Here, you can see the report user
first selecting a suggested question.
Q&A responds with a data visualization,
and then to further explore the data,
an entirely new question can be
entered, and even modified.
In the next video, I'll commence
a series of demonstrations
setting up the environment ready
to embed Power BI content.