Original subtitles

All right.

So if you'd just work through that section and notice that your screen looked quite a bit different

from mine that's OK.

Let's talk about what some of those differences look like since recording the course power buy has gone

through a number of updates that have changed the look and feel and functionality of the platform.

So the first thing you'll probably notice is a view like I'm showing here.

We've got this default light mode which is very bright and and airy and light compared to the default

dark mode when power b I was first released which had a lot of blacks and dark grays.

Now that was just a purely stylistic change.

So nothing really to talk about there but where we do see some additional differences is inside of that

relationship view which is now called the Model View.

So the first thing you've noticed I'm sure is the addition of these two new panes here called properties

and fields.

Now these aren't adding a lot of new tools or features to the platform they're just making existing

features a bit more accessible and user friendly.

So now I can select objects from my model either entire tables like so or individual fields either from

the model canvas or from the field list here on the right.

And as I do so I have access to different properties that I can customize right here like the name synonyms

description whether or not it's hidden from report view.

And I've got advanced features or properties that I'll walk there as well.

So table name speaks for itself synonyms these are automatically generated they don't really mean much

in the desktop environment but if we were to publish this file to power by service online they've got

some great features they're like natural language questions which allow users to actually type in questions

to retrieve information or insights from their model.

So instead of forcing users to type the name exactly as shown capital a W underscore calendar you can

use different variations with lower cases.

Spaces instead of underscores and power b I will recognize that you're referencing the same thing and

then down here in the advanced options.

Got storage mode either import direct query or dual.

Now this is a little bit outside the scope of this course but just in a nutshell give you a sense of

what the differences import means that you're grabbing data from your source and actually loading that

data into the power by environment direct query on the other hand is when you've got source data that's

typically stored in a database data warehouse or data lake I like access sequel Azure and you're asking

power be I to send queries to that source data to retrieve the data that you need as opposed to actually

storing the data here inside of power by.

So in this case we're using import because we're actually grabbing data from those CSB files and loading

them here into the system again a little bit outside the scope of the course but just wanted to cover

that quickly.

And same goes with individual fields here.

If you select one individual field you've got properties at the field level as well named synonyms description

display folder is something that's a little bit new.

It's purely for the sake of organization.

But if you've got fields that are related in some way and you want to organize or group them together

but they don't follow that hierarchy necessarily you can create a folder just to organize things a little

bit more clearly.

So to give you a quick example let's drill into product lookup you can follow along if you like.

I'm going to delete this in a minute so you don't have to.

But let's say we want to take the model name the product color product name and style for instance and

put those into one folder.

This is something that's new with this view that I couldn't do before which is going to select a field

hold control select the others description name style just kind of arbitrary but let's grab those five

and I've multi selected those and I can say let's throw those into a display folder called product detail

press enter.

Boom we've got that new folder right there inside of our product lookup table containing those five

fields and that change carries through the entire platform.

So jumping into the data view there's that folder is created let's go back to model and then getting

rid of it is just a simple right click delete for model it won't get rid of the component fields it

just gets rid of the folder containing them.

So nice little organizational feature right there.

Again you can hide multiple fields from view in one sweeping pass one go instead of right clicking each

field individually like we used to have to do and then you've got formatting options here as well so

data type data format actually select a numerical field as well like order quantity see order quantity

is a whole number can change that percentage or a thousand separator formatting.

Then you've got some advanced features as well like sort by column the data category which is great

for mapping so you can set things like region or postal code to help power by map those geospatial fields

more accurately and you can change the summarization mode as well so default to a Sun account and average

no summarization at all and you can do this for any field here in your model.

So those are the properties.

They're pretty straightforward.

I'd recommend kind of working through these getting comfortable with your options here.

And again these are the same tools that we've talked about and that we'll continue to talk about here

in the data view.

If you go to the modelling tab you've got field properties accessible right here in your toolbar as

well.

So again these aren't brand new features they're just making them a little bit more accessible and user

friendly.

Here inside of the model view now last thing that I want to quickly cover here is the fact that now

we have tabs available at the bottom of the screen which we didn't have before.

And by default you'll see this one tab called all tables which means you're viewing your entire model.

Now one common question is how do I make this bigger or smaller.

Sometimes you get to this view and you see something like this which is totally ridiculous it can't

even read what your table names or fields are.

They've put a little zoom bar it's kind of hidden but it's all the way down here on the right and you

can click the plus sign to make that view a bit bigger.

But getting back to the concept of tabs what these tabs allow you to do is create new views of your

model that basically contain subsets of the tables.

So if you've got a really complicated model with hundreds of tables and relationships and you want to

kind of zoom in on a specific component of your model to help users understand how it's built you can

create these different layouts.

And check this out if we want to create a layout containing our sales information we can grab that sales

table.

Just drag it right in the canvas there and then if we want to show which related tables are connected

to sales we don't have to drag those in we want to create new relationships.

Again just right click anywhere and say let's add the related tables boom with one click.

There you go it's pulled in calendar product territories and customer tables with those relationships

still intact.

So again we're looking at a subset of our all tables view which is the entire model.

We can go ahead and double click.

Call that something like sales and then check it out will do the same thing for returns.

Where we go.

W returns right click ad related tables pulls in product calendar and territories double click call

it returns and there you go.

So now we've created these very specific views to help users understand different slices or components

of our full model and then getting rid of those.

It's as simple as just clicking that little X and confirming.

So there you have it kind of a quick ten thousand foot view or tour of this new model tab.

Hopefully that helps.