![Page 1: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/1.jpg)
Donald Farmer
Microsoft Corporation
![Page 2: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/2.jpg)
Empowered
IT
Mission Critical Platform
Cloud Desktop & Mobile Server & Datacenter
Pervasive
Insight Dynamic
Development
![Page 3: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/3.jpg)
The Information Platform
![Page 4: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/4.jpg)
The Information Platform
IT Insight Development
![Page 5: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/5.jpg)
The Information Platform
IT Insight Development
Cloud Desktop & Mobile Server & Datacenter
![Page 6: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/6.jpg)
The Information Platform
IT Insight Development
Cloud Desktop & Mobile Server & Datacenter
![Page 7: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/7.jpg)
![Page 8: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/8.jpg)
Managed Self-Service BI
Master Data Services
StreamInsight
Multi-server management
Virtualization & Live Migration
![Page 9: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/9.jpg)
• Increased rules and laws about data
•Service-oriented architectures
•High quality master data is needed
•Someone must create, own, and maintain
this master data
Manage your data as an asset
![Page 10: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/10.jpg)
Master Data Services
Merge/Match
Versioning
Workflow Approval
Role Security
Hierarchy Mgmt
Purchasing
DB Asset Mgmt ERP CRM HR Doc
![Page 11: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/11.jpg)
Tomorrow
Multi-server management Today
Control server sprawl with 1 to many management
![Page 12: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/12.jpg)
Tomorrow
Multi-server management Today
Manage capacity through policies
Control server sprawl with 1 to many management
![Page 13: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/13.jpg)
Tomorrow
Multi-server management Today
Manage capacity through policies
Control server sprawl with 1 to many management
Single unit of deployment
![Page 14: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/14.jpg)
100+ TB DW
Highly scalable appliances
Seamlessly BI Integration
![Page 15: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/15.jpg)
Parallel Data Warehouse
![Page 16: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/16.jpg)
High Scale Data Warehouse
Scalable Data Warehouse & Data Marts
Reports Analysis
SQL Server DBMS
SQL Server Integration Services
Custom
OLTP
Build a scalable Data Warehouse at the lowest cost
16
![Page 17: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/17.jpg)
Scalable RDBMS
Consistent, familiar model & tools
Self-managed, highly available
![Page 18: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/18.jpg)
New Insight
with
Microsoft Business Intelligence
![Page 19: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/19.jpg)
Gartner BI Platforms Magic Quadrant, 2010
![Page 20: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/20.jpg)
Gartner BI Platforms Magic Quadrant, 2010
![Page 21: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/21.jpg)
“Microsoft is the only
megavendor above
average for both
capabilities and ease of
use.”
Gartner BI Platforms User Survey, 2010
![Page 22: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/22.jpg)
Personal Standardized
Business Intelligence patterns
![Page 23: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/23.jpg)
![Page 24: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/24.jpg)
![Page 25: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/25.jpg)
![Page 26: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/26.jpg)
![Page 27: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/27.jpg)
Personal Team Standardized
Business Intelligence patterns
![Page 28: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/28.jpg)
Personal Team Standardized
Flexible Formal
Business Intelligence patterns
![Page 29: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/29.jpg)
Managed Self Service
![Page 30: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/30.jpg)
PowerPivot PowerPivot add-in
for Excel
PowerPivot add-in
for SharePoint
![Page 31: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/31.jpg)
Managed Self Service BI
![Page 32: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/32.jpg)
Managed Self Service BI
![Page 33: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/33.jpg)
Mediterranean Shipping Company
22 TB of data on SQL Server 2008
External data sources (US Customs)
33 million rows
1.7GB compressed
Built in 3 hours
![Page 34: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/34.jpg)
Bank of New Zealand (BNZ)
Manual month-end reconciliations
Complex mapping between GL & P&L
Data from multiple sources e.g. SAP
Large data sets – 2m rows / month
Slicers for easy navigation
![Page 35: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/35.jpg)
![Page 36: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/36.jpg)
SQL Server 2008 R2
Released!
![Page 37: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/37.jpg)
UPGRADE TO SQL SERVER 2008
LEARN MORE ABOUT SQL SERVER 2008 R2
http://www.microsoft.com/sqlserver/2008/en/us/how-to-
buy.aspx
http://www.microsoft.com/sqlserver
![Page 38: Donald Farmer Microsoft Corporationdownload.microsoft.com/download/9/7/4/974BF9A0-C922-4E01... · 2018-10-16 · Managed Self-Service BI Master Data Services StreamInsight Multi-server](https://reader036.vdocuments.us/reader036/viewer/2022070721/5ee21c54ad6a402d666cbb86/html5/thumbnails/38.jpg)
© 2010 Microsoft Corporation. All rights reserved. Microsoft, Azure, SQL Server, 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.