Дарьи пынзарь 2012 видео

Developing and Managing a BI Semantic Model in Microsoft SQL Server

2012

DBI305

Julie Strauss Senior Program Manager Lead Microsoft Corporation

Agenda

Demos

Demos

Demos

Demos

Demos

Demos

Demos

Demos

Demos

Demos

Analysis Services Momentum

Large ecosystem "Wide availability of skills is among the top reasons customers select Microsoft over competing vendors.” Source: Gartner Magic Quadrant for BI Platforms, 2011

Analysis Services with SQL Server 2012

Introducing the BI Semantic Model

Analysis Services Vision

The BI Semantic Model

One Semantic Model for BI

Three Investment Areas for Analysis Services in SQL Server 2012

For reporting, analytics, scorecards, dashboards For all users – Personal BI, Team BI, Organizational BI One model for client tools, two ways to build it – tabular and multidimensional

Version 2 of PowerPivot for Excel IT Pro Toolset for BI Professionals SQL Server Management Studio for IT Professionals

Seamless Transition of the BI Semantic Model Across BI Spectrum

Personal BI

Team BI

Corporate BI

Empowered

Aligned

PowerPivot for Excel

PowerPivot for SharePoint

Analysis Services

Our Context BI Solution created by power user. Context is for a small team & it’s managed on a server.

The Org’s Context BI Solution created by IT, Established corporate context & is reusable, scalable and backed up.

My Context BI solution created by user. Context is only for user & exists as document.

Corporate BI Advantages

Partitions, Direct Query

Scalability

SSMS, AMO, PowerShell, SSIS Packages

Manageability

Row level security

Security

Integrated source control, Team Build, Deployment wizard

Development Tools

Design Tools

Personal Team Corporate

PowerPivot for Excel

BI Development Studio

Feels like Visual Studio

Feels like Excel

One file, Save to SharePoint

Optimized for BI Pros

It’s a project (business case, budget, dates)

Rapid response to business problems

Larger data volumes

Teams building BI solutions

Solutions live for weeks or months

Deployment scripts, versions

Optimized for Excel power user

Source Control, TFS

demo

Managing and Building Tabular Projects

New BI Semantic Model Features

Optimized Usability Diagram Measure grid Various usability enhancements Reporting Properties

Richer Models KPIs Descriptions Persisted formatting Advanced sorting Distinct count Drillthrough Perspectives Hierarchies Multiple relationships Parent child

All features available in both PowerPivot and BIDS

New Pro Features

Transition Across the BI Spectrum Restore of PowerPivot models in SSMS Import of PowerPivot models into BIDS projects New Tabular Projects in BIDS DirectQuery Security Deployment Data management: Partitioning Management of Tabular Databases in SSMS

Features specific to SSDT and SSMS

Summary

Partitions

Descriptions

KPI’s

Drag ‘n Drop Relationship

Diagram

Reporting Properties

Measure Grid

Persisted formatting

Distinct Count

Date Table

Drill Through

KPI’s

Multiple Relationships

Advanced Sort

Hierarchies

Related Content

Breakout Sessions: Enriching Your BI Semantic Tabular Models with DAX Optimizing Your BI Semantic Model for Performance and Scale BISM: Multidimensional vs. Tabular Speaker(s)

Product Demo Stations: Breakthrough Insights

Find Me Later at the Expo Hall…

Track Resources

Resources

Complete an evaluation on CommNet and enter to win

Please Complete an Evaluation Your feedback is important

Multiple ways to Evaluate Sessions

Be eligible to win great daily prizes and the grand prize of a $5,000 Travel Voucher!

© 2012 Microsoft Corporation

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