1300
Part IX: Business Intelligence
■ (^) Data Model: The conceptual model that contains all the relationships between the
different data entities in the organization. It supports both multidimensional and
tabular data modeling.
■ Business Logic & Queries: Represents the intelligence or semantics in the model.
Calculations are embedded in the model using either MDX or DAX languages. Both
languages are supported and can be used to extend basic business logic.
■ (^) Data Access: Where source data is integrated. Multiple data sources are supported
natively including data coming from relational databases, fl at fi les, OData feeds,
and so on.
Figure 58-1 illustrates the three layers of the BI Semantic Model.
FIGURE 58-1
The three layers of the BI Semantic Model.
Third-party
applications
Reporting
Services Excel PowerPivot
SharePoint
Insights
Databases LOB Applications Files
Data model Tabular
MDX DAX
ROLAP MOLAP VertiPaq DirectQuery
Multi-
dimensional
Data access
Business logic
and queries
OData Feeds Cloud Services
BI Semantic Model
One of the objectives of the BI Semantic Model is to simplify development and querying.
The development environment of BI Semantic Models resembles tables displayed as
tabs related to one another and is the reason why it is sometimes called Tabular
models. Querying is simplifi ed because BI Semantic Models can be queried either by using
c58.indd 1300c58.indd 1300 7/31/2012 10:35:59 AM7/31/2012 10:35:59 AM
http://www.it-ebooks.info