Sql server analysis services 2012
Download
1 / 14

SQL Server Analysis Services 2012 - PowerPoint PPT Presentation


  • 97 Views
  • Uploaded on

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.

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 'SQL Server Analysis Services 2012' - kiara


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
Sql server analysis services 2012

SQL Server Analysis Services 2012

BI Semantic Model

BISM


Agenda
Agenda

  • BI Semantic Model

  • BI in an Organization

  • Data Model

  • Data Access

  • Business Logic

  • Client Tools

  • Feature Comparison


Bi in an organization
BI in an Organization

Team BI

Personal BI

Organizational BI

Analysis Services

PowerPivot for SharePoint

PowerPivot for Excel


Bi semantic model bism
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


Sql server analysis services 2012
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


Data model
Data Model

Multi-dimensional

Tabular

xVelocity

Column Store

In-Memory Analytics

High Compression

  • OLAP Engine

    • Aggregation

    • Caching

C1

C2

C3

C4

C5

C6


Data access
Data Access

Multi-dimensional

Tabular

Cached

Direct Query

  • MOLAP

  • ROLAP

  • HOLAP


Business logic
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!!!


Client tools
Client Tools

Multi-dimensional

Tabular

Reporting

Services

Excel

Reporting

Services

Excel

PowerPivot

PowerPivot

Power View



Feature comparison
Feature Comparison

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



Contact information
Contact Information

Dave DuVarney

dduvarney@duvarneyconsulting.com

Mobile: 608-320-4691


Resources
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