Database Reference
In-Depth Information
uu
Make sure column names are clear and understandable.
Go through
your data model and make sure the names are clear and legible. Now is
the time to make this easily understandable for your end users. These
names can be edited by either changing the properties of a column in the
properties pane of SQL Server Data Tools, or by right-clicking the column
header and selecting Rename.
uu
review formatting of data and ensure the data is clean.
You should
always spend some time reviewing the data in your model to make sure
it fits the profile you believe to be correct. Sometimes you won't know
and that's okay, but check for simple things such as ensuring that the
Description column does not contain Prices and other things like that.
uu
Add any images you might need for building cards or more-advanced
visualizations.
Review the previous section on Enhancing Your Power
View Report to see how to add images and other impressive interactivity
to your model so you can consume them in Power View.
ADDING METADATA For PoWEr VIEW
After the data model has been cleaned up, there are some additional items
that can be looked at to further enhance it when used with Power View. These
items include the default field set, table behavior settings, and categorizing
the data in your columns within your tables accordingly. This section discusses
these and provides an example from a Tabular Analysis Services project. In
a PowerPivot data model, these items are found in the Reporting Properties
section of the Advanced tab in the PowerPivot window.
Default Field Set
First there is the default field set. This setting on a table in your data model
provides you the ability to select one or more columns from your table (includ-
ing measures) and allows you to order them as you see fit. Now when a user
clicks on the table in the Power View Fields, all of the columns that were
defined in the default field set will be added to the canvas. This provides a
quick way to add multiple columns that are typically used for a particular
table in a report. Figure 6-11 shows an example of what the Default Field Set
dialog boxes looks like.
