[UPBEAT MUSIC PLAYING]
Welcome to MSPTDA video number 17.
Hey, we've got to talk about Power BI Online
and exactly what our dashboards, reports, workbooks and data
sets.
Now this is exactly what it looks like.
One, two, three, four items when we go to Power BI Online.
Now in the last video, number 16,
I used the word dashboard loosely.
And luckily our online teammates, Pa and Hachi,
said hey, dashboards has a very specific meaning when
we publish our Power BI report.
Now last video, we published from within the Power BI
desktop file and that brought us to powerbi.com.
Later, if you want to go back, you can go to powerbi.com
and it will ask you to sign in.
Or if you have an organization, you
can use your organization page.
I'm going to go ahead and sign in.
Then in the upper left-hand corner,
whichever Office 365 app you have open, you can click
and there's your list of apps.
If you don't see it, you say all apps.
I scroll down, and there I see Power BI.
Click.
We can see app.power.bi.com/home.
Over here, my workspace.
And if you click the drop down, you
should see the file that we posted during last video,
video number 16.
Now at powerbi.com, looking at what we published last video,
this is a dashboard.
But really we want to refer to it as a tab or a page.
So if I go over to the fiscal report page,
I have my set of visualizations.
Now to show you the four key areas,
I'm going to click on my workspace.
And there they are, dashboards, reports, workbooks,
and data sets.
Now dashboards, we'll see how to create this in just a moment.
Reports, these are all of your reports,
like our Power BI desktop file we published last video.
That's a list of all the reports in this workspace.
Workbooks, I've uploaded two Excel workbooks.
I'll show you how to upload an Excel
workbook in just a moment.
And then these are the various data
sets, either from an Excel data model or Power BI desktop data
model.
Now workspaces.
We're going to click and create app workspace.
We're going to name this MSPTDA.
You can decide whether it is public or private.
I'm going to say public.
Members can edit or only view.
I'm going to say edit.
Add workspace members.
Click add.
Now I can click save.
Over here, there's our new workspace.
Dashboards, reports, workbooks, data sets, and data flows.
Now we're going to upload the report from video 16
into this workspace.
If I click publish, it'll ask me what destination.
I'm going to say MSPTDA select.
Now I'm in the Excel Magic Trick 1366, which
really was how to use Power BI.
And I'm going to publish this.
I'm going to save it to the same workspace, and select.
Now this is the finished Power Pivot file
from video 15 in this class.
I've renamed it.
But here in Excel, we can actually publish and view
the data on each sheet.
File, down to publish.
And we have two options when we want to publish to Power BI.
The first option, upload your workbook to Power BI,
this will let you see the data on each sheet,
but does not import the actual data model.
This version, export workbook data to Power BI,
uploads the data model.
And then we can build reports using Power BI Online.
Now we'll do this one first.
Notice that's the correct location to load it.
I'm going to click upload.
I can see down here in Excel that's a strange place
to say the status.
And then up here, go to Power BI.
Now before I do that, I'm going to go back up
and publish this again a second time.
Now I'm going to click export, which
will export the data model.
So I'm going to click export down here.
It's working.
Now I'm going to finally click go to Power BI.
Now over here on the left, if I click the drop down,
I don't have a dashboard yet, but I have my two reports.
There's the uploaded workbook.
I can actually click on it.
And this is Excel Online, but I'm
allowed to interact with this tab named dashboard.
I click beginner.
And then here's our two data sets.
Now if I click on MSPTDA, there's
the dashboard, which we'll create in just a second.
There's our reports.
There's our workbook.
That's just the Excel file uploaded for us
to view in Excel Online.
The data sets, we have one, two from Power BI
and one from Excel.
And now we want to create a dashboard.
If I come over to reports, I'm selecting a particular Power BI
report.
I select a particular tab.
Then I go up to pin live page.
And this is where I can create a dashboard.
I'm going to say new dashboard, because I don't have any here.
We'll call this two-tab dashboard,
because we're going to have a different tab or page from two
different Power BI reports.
Click pin live.
And now I can see my dashboard over here.
There's a single item.
Now over to my other Power BI report.
I'm going to select a particular tab, pin to live page.
This time I want to say existing.
There it is.
Pin.
And now over here, this is cool.
I have a dashboard that I can interact with.
And I can scroll down and interact
with a completely different page or tab from a completely
different report.
Both of these pages are connected to two different data
sets.
So a dashboard over here in powerbi.com
is a place to pin pages or tabs.
And the dashboard can contain pages
from different reports or different data sets.
Now a couple other cool things here.
If we go over to data sets, this is our Excel file
that we created.
We can actually create a Power BI report.
So I'm going to click create report, and there it is.
My visualizations, my fields, my blank canvas.
Double click.
I called it Rev and Cost of Goods Sold.
Column.
Product.
And two measures, total revenue and total cost of goods sold.
Now I have one page, or one tab.
Now I could go to file, save, but I'm going to use Control S,
and we're going to name this.
And this creates a new report based on our Excel file.
Save.
And now under reports, look at that.
I have a report using Power BI but based on an Excel data set.
And then these two published reports.
So dashboards, a collection of tabs or pages
from various reports.
Here's our list of published reports.
There's our Excel workbook which we can view.
And there are our data sets.
All right, that's a little bit more about Power BI Online.
Our next video, video number 18, will
be about DAX iterators, DAX table functions,
and granularity.
And then video number 19 will be all
about the calculate function.
All right, we'll see you next video.