Bi all the way part ii analysis services
Download
1 / 23

BI All the way Part II - Analysis Services - PowerPoint PPT Presentation


  • 69 Views
  • Uploaded on

BI All the way Part II - Analysis Services. Gal Gubesi CEO, Microsoft Regional Director for BI [email protected] Microsoft Business Intelligence. Microsoft Business Intelligence. Agenda. Unified Dimensional Model. Dimensions. Key Performance Indicators. Real-time with Proactive Caching.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'BI All the way Part II - Analysis Services' - ted


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Bi all the way part ii analysis services l.jpg

BI All the wayPart II - Analysis Services

Gal Gubesi

CEO, Microsoft Regional Director for BI

[email protected]




Agenda l.jpg
Agenda

Unified Dimensional Model

Dimensions

Key Performance Indicators

Real-time with Proactive Caching

Perspectives

Translations

Closure


Udm unified dimensional model l.jpg

UDM

UDM - Unified Dimensional Model

  • The UDM acts as a bridge between the users and their data

  • Combines the best of traditional OLAP:

    • Performance

    • Rich calculations

    • End-user model

  • With the best of traditional Relational based reporting

    • Real time & Detail level data

    • Complex schema

    • Simplified management


Slide6 l.jpg

Basic Dimensional Model

Data Source

View

Customer

ID (PK)

Name

Age

Storage/Caching Policies

Order

Order# (PK)

CustomerID

DueDate

Calculations

End-user model

UDM

UDM

Scope(Customer.Country.USA, *);

Sales = 2;

End Scope;


Udm role of the data source view l.jpg
UDM - Role of the Data Source View

  • Relational schema on which the cubes and dimensions are built

  • Allows schema to be annotated

    • Relationships

    • Primary Keys

    • Named Calculations

    • Named Queries

  • Presents a unified view of the underlying data source(s)



Udm multiple data sources l.jpg

Quota

CustomerID

Quantity

Customer

ID

Name

Quota

CustomerID

Quantity

Customer

ID

Name

UDM - Multiple Data Sources

  • DSV can contain tables drawn from multiple heterogeneous data source

DSV

  • ‘Primary’ data source must be SQL Server

  • AS will issue OPENROWSET queries


Dimensions l.jpg

Customer

Sales

Dimensions

  • Regular


Dimensions11 l.jpg

Customer

Sales

Dimensions

Sold To

  • Regular

  • Role Playing

Purchased From

  • Implemented in storage engine

  • Dimensions stored once, but used multiple times in different roles

  • Conserves disk, reduces processing times


Dimensions12 l.jpg

Customer

Trans.

Account

Customer / Account

Dimensions

  • Regular

  • Role Playing

  • Many-to-Many

  • Complex analytics when dimensions not directly related to fact table

  • Facts roll up as “Distinct Sum”

  • Expands the application of the dimension model beyond the star schema


Slide13 l.jpg
KPIs

  • Stands for “Key Performance Indicators”

  • Calculate Value, Goal, Status, Trend, Weight, Gauge

  • Accessible from client application

  • Icons can be modified


Slide14 l.jpg
KPIs

  • Create KPI’s instantly

  • Images transmitted using Binary XML

  • BSM Integrated


Proactive caching l.jpg

New data,

New dimension members

Auto

process

Processing

Changing Data

How often,

When?

Show old

data? Stall?

Triggering, Timing

Routing

Proactive caching

Proactive

Caching


Proactive caching16 l.jpg

Cache

SQL

SQL

MDX

UDM

User

RDBMS

Analysis Services

Proactive caching


Proactive caching17 l.jpg

Cache

SQL

SQL

MDX

UDM

User

RDBMS

Analysis Services

Proactive caching


Proactive caching18 l.jpg

Cache

Cache

SQL

SQL

MDX

UDM

User

RDBMS

Analysis Services

Proactive caching

Data updated


Perspectives l.jpg
Perspectives

  • Cubes can be complex for users to explore

  • Use perspectives to reduce complexity

  • Information reflects analytical needs

  • Not a security mechanism


Translations l.jpg
Translations

  • SSAS is multi-lingual using translations

  • Multi-lingual for data & meta-data.

  • For example:

    • Product dimension name

    • Product name itself

    • Measure name

    • Etc.


Closure l.jpg
Closure

  • Better flexibility

  • Shorter development cycle

  • BI for everyone…

    … analysis services is just part of it


New york new york l.jpg

איך ממלאים משוב?

ב - email בסוף כל יום

ב -Beat Center

מה מקבלים?

חולצת Feel The Beat

השתתפות בהגרלת כרטיסי טיסה

מכשירי i-mate ועוד...(לממלאים משוב לכל יום)

New York! New York!


Slide23 l.jpg

Gal Gubesi

CEO, Microsoft Regional Director for BI

[email protected]


ad