1 / 9

BI Semantic Model SSAS Tabular Mode

BI Semantic Model SSAS Tabular Mode. Ray Johnson – MPS Partners, Director, Business Intelligence. Agenda. BI Semantic Model – SSAS Tabular Mode . Overview BI Semantic Model SSAS Tabular vs. Multi Dimensional Demo Questions. Overview. Traditional IT focused OLAP solutions.

adina
Download Presentation

BI Semantic Model SSAS Tabular Mode

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 Semantic ModelSSAS Tabular Mode Ray Johnson – MPS Partners, Director, Business Intelligence

  2. Agenda BI Semantic Model – SSAS Tabular Mode • Overview • BI Semantic Model • SSAS Tabular vs. Multi Dimensional • Demo • Questions

  3. Overview Traditional IT focused OLAP solutions • SSAS (Multi-Dimensional Mode) • Supports OLAP and data mining • UDM (Unified Dimensional Model) • MDX (Multi-Dimensional Expressions) • IT developed solutions • Complex

  4. Scalable Insight with BI Semantic Model Single, model for BI applications to provide a consistent view of data CLIENT TOOLS Analysis, Reports, Scorecards, Dashboards, Custom Apps • BI Semantic Model • Enables a wide spectrum of capabilities – from dashboards and scorecards to reports and analytics. • Enhance productivity with design aids and best practices. New Tabular mode: • Enable faster iteration and reduce complexity in design. • In-memory column store technology CAPABILITIES BI SEMANTIC MODEL • Data model • Business logic and queries DATA SOURCES Databases, LOB Applications, Odata Feeds, Spreadsheets, Text Files • Data access

  5. SSAS Tabular Mode Power User/IT focused OLAP solutions • SQL Server 2012 • Supports OLAP • BISM (Business Intelligence Semantic Model) • DAX (Data Analysis Expressions) • IT/Power User managed solutions • Excel like expressions

  6. Scalable Insight with BI Semantic Model Single, model for BI applications to provide a consistent view of data • Abstraction Layer • Faster to develop solutions and easier to maintain • Hybrid Model – Power of OLAP with a relational view • Familiar Excel like language (DAX) • Shorter learning curve • Excellent choice for departmental solutions • Address Issues of PowerPivotMarts Benefits

  7. Multi-dimensional vs. Tabular Mode Feature Comparison

  8. Demo BI Semantic Model

  9. © 2011 Microsoft Corporation. All rights reserved. Micsoft, 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 Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related