1 / 23

BI All the way Part II - Analysis Services

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

ted
Télécharger la présentation

BI All the way Part II - Analysis Services

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BI All the wayPart II - Analysis Services Gal Gubesi CEO, Microsoft Regional Director for BI gal@prognosys.com

  2. Microsoft Business Intelligence

  3. Microsoft Business Intelligence

  4. Agenda Unified Dimensional Model Dimensions Key Performance Indicators Real-time with Proactive Caching Perspectives Translations Closure

  5. 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

  6. 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;

  7. 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)

  8. UDM - Role of the Data Source View

  9. 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

  10. Customer Sales Dimensions • Regular

  11. 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

  12. 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

  13. KPIs • Stands for “Key Performance Indicators” • Calculate Value, Goal, Status, Trend, Weight, Gauge • Accessible from client application • Icons can be modified

  14. KPIs • Create KPI’s instantly • Images transmitted using Binary XML • BSM Integrated

  15. New data, New dimension members Auto process Processing Changing Data How often, When? Show old data? Stall? Triggering, Timing Routing Proactive caching Proactive Caching

  16. Cache SQL SQL MDX UDM User RDBMS Analysis Services Proactive caching

  17. Cache SQL SQL MDX UDM User RDBMS Analysis Services Proactive caching

  18. Cache Cache SQL SQL MDX UDM User RDBMS Analysis Services Proactive caching Data updated

  19. Perspectives • Cubes can be complex for users to explore • Use perspectives to reduce complexity • Information reflects analytical needs • Not a security mechanism

  20. Translations • SSAS is multi-lingual using translations • Multi-lingual for data & meta-data. • For example: • Product dimension name • Product name itself • Measure name • Etc.

  21. Closure • Better flexibility • Shorter development cycle • BI for everyone… … analysis services is just part of it

  22. איך ממלאים משוב? ב - email בסוף כל יום ב -Beat Center מה מקבלים? חולצת Feel The Beat השתתפות בהגרלת כרטיסי טיסה מכשירי i-mate ועוד...(לממלאים משוב לכל יום) New York! New York!

  23. Gal Gubesi CEO, Microsoft Regional Director for BI gal@prognosys.com

More Related