1 / 14

SQL Server Analysis Services 2012

SQL Server Analysis Services 2012. BI Semantic Model BISM. Agenda. BI Semantic Model BI in an Organization Data Model Data Access Business Logic Client Tools Feature Comparison. BI in an Organization. Team BI. Personal BI. Organizational BI. Analysis Services.

kiara
Download Presentation

SQL Server Analysis Services 2012

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. SQL Server Analysis Services 2012 BI Semantic Model BISM

  2. Agenda • BI Semantic Model • BI in an Organization • Data Model • Data Access • Business Logic • Client Tools • Feature Comparison

  3. BI in an Organization Team BI Personal BI Organizational BI Analysis Services PowerPivot for SharePoint PowerPivot for Excel

  4. BI Semantic Model (BISM) • A semantic layer is a business representation of corporate data that helps end users access data autonomously using common business terms. • http://en.wikipedia.org/wiki/Semantic_layer • BISM is the term used by Microsoft to refer to both Multi-dimensional and Tabular models in SQL Server Analysis Services

  5. BISM 3rd Party applications Reporting Services Excel PowerPivot SharePoint Insights BI Semantic Model Data Model Multi- dimensional Tabular Business Logic MDX DAX Data Access Direct Query ROLAP xVelocity MOLAP Databases LOB Applications Files OData Feeds Cloud Services

  6. Data Model Multi-dimensional Tabular xVelocity Column Store In-Memory Analytics High Compression • OLAP Engine • Aggregation • Caching C1 C2 C3 C4 C5 C6

  7. Data Access Multi-dimensional Tabular Cached Direct Query • MOLAP • ROLAP • HOLAP

  8. Business Logic Multi-dimensional Tabular DAX – Data Analysis Expressions Expression Based Similar to Excel Formulas • MDX – Multi-dimensional Expressions • Calculated Members • Named Sets • Scope Assignments Different, but conceptually the same!!!

  9. Client Tools Multi-dimensional Tabular Reporting Services Excel Reporting Services Excel PowerPivot PowerPivot Power View

  10. Demo

  11. Feature Comparison http://www.prologika.com/Books/0976635356/Resources/sample_chapters.pdf

  12. Wrap-Up

  13. Contact Information Dave DuVarney dduvarney@duvarneyconsulting.com Mobile: 608-320-4691

  14. Resources • http://www.prologika.com/Books/0976635356/Resources/sample_chapters.pdf • http://blogs.msdn.com/b/analysisservices/archive/2011/05/16/analysis-services-vision-amp-roadmap-update.aspx • http://blogs.technet.com/b/dataplatforminsider/archive/2010/11/12/analysis-services-roadmap-for-sql-server-denali-and-beyond.aspx • http://www.sqlchick.com/entries/2012/3/4/decisions-powerpivot-ssas-tabular-or-ssas-multidimensional-m.html • http://blogs.msdn.com/b/cathyk/archive/2011/10/27/when-to-choose-tabular-models-over-powerpivot-models.aspx • http://sqlblog.com/blogs/marco_russo/archive/2010/11/15/the-microsoft-bi-roadmap-bids-udm-and-beyond.aspx • http://msdn.microsoft.com/en-us/library/gg471575(v=SQL.110).aspx

More Related