Microsoft
<<  Information About Microsoft May 2012 Security Bulletins Жени феофилактовой 2012 видео  >>
Developing and Managing a BI Semantic Model in Microsoft SQL Server
Developing and Managing a BI Semantic Model in Microsoft SQL Server
Agenda
Agenda
Analysis Services Momentum
Analysis Services Momentum
Analysis Services with SQL Server 2012
Analysis Services with SQL Server 2012
The BI Semantic Model
The BI Semantic Model
Seamless Transition of the BI Semantic Model Across BI Spectrum
Seamless Transition of the BI Semantic Model Across BI Spectrum
Corporate BI Advantages
Corporate BI Advantages
Design Tools
Design Tools
demo
demo
New BI Semantic Model Features
New BI Semantic Model Features
New Pro Features
New Pro Features
Summary
Summary
Related Content
Related Content
Track Resources
Track Resources
Resources
Resources
Complete an evaluation on CommNet and enter to win
Complete an evaluation on CommNet and enter to win
Please Complete an Evaluation Your feedback is important
Please Complete an Evaluation Your feedback is important
© 2012 Microsoft Corporation
© 2012 Microsoft Corporation
Developing and Managing a BI Semantic Model in Microsoft SQL Server
Developing and Managing a BI Semantic Model in Microsoft SQL Server

Презентация: «Дарьи пынзарь 2012 видео». Автор: Cyndi. Файл: «Дарьи пынзарь 2012 видео.pptx». Размер zip-архива: 2282 КБ.

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

содержание презентации «Дарьи пынзарь 2012 видео.pptx»
СлайдТекст
1 Developing and Managing a BI Semantic Model in Microsoft SQL Server

Developing and Managing a BI Semantic Model in Microsoft SQL Server

2012

DBI305

Julie Strauss Senior Program Manager Lead Microsoft Corporation

2 Agenda

Agenda

Demos

Demos

Demos

Demos

Demos

Demos

Demos

Demos

Demos

Demos

3 Analysis Services Momentum

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

4 Analysis Services with SQL Server 2012

Analysis Services with SQL Server 2012

Introducing the BI Semantic Model

Analysis Services Vision

5 The BI Semantic Model

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

6 Seamless Transition of the BI Semantic Model Across BI Spectrum

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.

7 Corporate BI Advantages

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

8 Design 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

9 demo

demo

Managing and Building Tabular Projects

10 New BI Semantic Model Features

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

11 New Pro Features

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

12 Summary

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

13 Related Content

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…

14 Track Resources

Track Resources

15 Resources

Resources

16 Complete an evaluation on CommNet and enter to win

Complete an evaluation on CommNet and enter to win

17 Please Complete an Evaluation Your feedback is important

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!

18 © 2012 Microsoft Corporation

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

19 Developing and Managing a BI Semantic Model in Microsoft SQL Server
«Дарьи пынзарь 2012 видео»
http://900igr.net/prezentacija/informatika/dari-pynzar-2012-video-235402.html
cсылка на страницу
Урок

Информатика

130 тем
Слайды
900igr.net > Презентации по информатике > Microsoft > Дарьи пынзарь 2012 видео