Transcript Dimension
This seminar is based on a number of sources including a few dozen of Microsoft-owned presentations, used with permission. Thank you: Michael Tejedor, Chris Volckerick, Tara Seppa, Morris Novello, Bryan Bredehoeft, Chris Dial, Donald Farmer, Sabrena McBride, Peter Sprague, and Diwakar Rajagopal. The information herein is for informational purposes only and represents the opinions and views of Project Botticelli and/or Rafal Lukawiecki. The material presented is not certain and may vary based on several factors. Microsoft makes no warranties, express, implied or statutory, as to the information in this presentation. Portions © 2011 Project Botticelli Ltd & entire material © 2011 Microsoft Corp unless noted otherwise. Some slides contain quotations from copyrighted materials by other authors, as individually attributed or as already covered by Microsoft Copyright ownerships. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Project Botticelli Ltd as of the date of this presentation. Because Project Botticelli & Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft and Project Botticelli cannot guarantee the accuracy of any information provided after the date of this presentation. Project Botticelli makes no warranties, express, implied or statutory, as to the information in this presentation. E&OE. • • • • Call Center Web Apps CRM SOA – Enterprise Service Bus Finance Inventory Data Warehouse HR ERP • • • • • • • HR Finance Inventory • • • • • • • ETL Basis of All BI • Fact • • • • • Dimension • • • • fact measure • 42 footballs sold dimensions John 20100115 Data Providers ODBC SQL Server SAP NetWeaver BI SQL Server Integration Services DB2 MySAP SQL Server Report Server Models Teradata XML SQL Server Data Mining Models SQL Server Analysis Services OLE DB Hyperion Essbase Oracle • • • • • • • • Potential for slower query performance in relational reporting No difference in performance in Analysis Services database measurements • • • • • • keys dimensions Reseller sales data by: •Product •Order Date •Reseller •Employee •Sales Territory Day Grain Sales quota data by: •Employee •Time Quarter Grain • • • • • • • • • • • • • SalesTerritoryKey update to 10 • • • Measures • Dimensions fact dimension • • • • • • • slicing dicing • • • • • • • • • • • Very Customers by Geography Country State City Customer Customers by Demographics Marital Gender Customer • • Analogous • • • fact Measure Group Dimension Sales Inventory Customers X Products X X Time X X Promotions X Warehouse Finance X X Department X Account X Scenario X 1. 2. 38 • • • 40 • • • • • © 2011 Microsoft Corporation & Project Botticelli Ltd. All rights reserved. The information herein is for informational purposes only and represents the opinions and views of Project Botticelli and/or Rafal Lukawiecki. The material presented is not certain and may vary based on several factors. Microsoft makes no warranties, express, implied or statutory, as to the information in this presentation. Portions © 2011 Project Botticelli Ltd & entire material © 2011 Microsoft Corp unless noted otherwise. Some slides contain quotations from copyrighted materials by other authors, as individually attributed or as already covered by Microsoft Copyright ownerships. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Project Botticelli Ltd as of the date of this presentation. Because Project Botticelli & Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft and Project Botticelli cannot guarantee the accuracy of any information provided after the date of this presentation. Project Botticelli makes no warranties, express, implied or statutory, as to the information in this presentation. E&OE.