slide1 l.
Skip this Video
Loading SlideShow in 5 Seconds..
Will Thompson Technical Specialist PowerPoint Presentation
Download Presentation
Will Thompson Technical Specialist

Loading in 2 Seconds...

play fullscreen
1 / 36

Will Thompson Technical Specialist - PowerPoint PPT Presentation

  • Uploaded on

Will Thompson Technical Specialist. Data Platform Vision. Services. Enterprise Data Platform. Reporting. Integration. Analysis. Sync. Dynamic Development. Query. Search. FILE. RDBMS. OLAP. XML. Platform For All Data. Mobile and Desktop. Cloud Storage. Datacenter .

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Will Thompson Technical Specialist' - archer

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
data platform vision
Data Platform Vision


Enterprise Data Platform





Dynamic Development







Platform For All Data

Mobile and




Pervasive Insight

“Enabling customers of all sizes to derive value from ALL data, birth through archival”



End Users


IT Efficiency

Scale with Confidence

  • Lower management cost
  • Enhance IT Governance
  • Enable real-time insight
  • Improve resource utilization
  • Reduce $ cost/TB
  • Predictable performance
  • HW flexibility & choice
  • Reduce deployment risk
  • Reduce dependence on IT
  • Greater re-use of insights
  • Lower training time & cost
  • Faster time to decision


End Users


IT Efficiency

Scale with Confidence

  • App deployment meta-data
  • Multi-server management
  • Master Data Services
  • Complex Event Processing
  • Support for up to 256 cores
  • MPP Support for 100TB+ DW(Massively Parallel Processing)
  • Appliance-like DW on industry standard HW
  • Hub & Spoke Architecture
  • Multi-Temperature
  • Excel based In-mem Analytics
  • Self Service Reporting
  • Re-usable report parts
  • End user app. management
  • SharePoint Publishing & Hosting
pervasive insight challenges
Pervasive Insight Challenges
  • End User
  • Empowerment
  • Business Application Insight
  • Data Scale, Quality & Compliance

Empowering end users to gain insights from information…

Reduce end user dependency on IT

Provide intuitive and easy to use tools

Share & access information anywhere

…customized and in the context of their business applications…

Insight into ‘line of business’ app information

BI in the context of business applications

BI assets that can be customized and changed

…on growing volumes of data from diverse sources and systems.

Support growing volumes of data

Support heterogeneous applications and sources

Maintain data quality, integrity and security

use standard excel formulas
Use Standard Excel Formulas

… plus some others


Reporting Services


  • Users need to have access to information when and where they need it
  • Training users on multiple BI tools is inefficient and costly
  • Need to combine data across multiple sources for a more accurate view

Reporting Services and Report Builder 3.0

  • Easy Access to relational and multi-dimensional data
  • Productive reporting with familiar Microsoft Office interface with the ability to render to multiple formats including Excel, Word, PDF, XML, etc.
  • Presentation quality reports with rich visualisations
  • Support for multiple data sources within a single report

“Our analysts can do anything with Excel, so integrating Excel as a front end for our BI infrastructure is extremely popular. It makes it easier to explore the huge wealth of data we have in our 17-terabyte data warehouse” - Dan Zerfas, Vice President of Software Development

stewardship portal
Stewardship Portal
  • Master Data Management
  • Model Management
  • Model Documentation
master data platform
Master Data Platform
  • Any domain
    • Not just “canned” domains
    • New domains or unique requirements
  • Model deployment capability
    • Enables partners to define prebuilt content (both the model definition and the data)
  • API enables partners to quickly build custom Master Data applications
    • Domain specific user interfaces
    • Application integrations
complex event processing streaminsight
Complex Event Processing - StreamInsight


CEP is the continuous, incremental processing of event streams from many sources based on declarative query/pattern specifications with minimal latency


output stream

input stream


scenarios for event processing


Scenarios for Event Processing

Relational Database Applications

CEP Target Scenarios

Operational Analytics Applications, e.g., Logistics, etc.

Data Warehousing Applications

Web Analytics Applications

Manufacturing Applications

Financial trading Applications

Monitoring Applications

Aggregate Data Rate (Events/sec.)

example cep scenarios
Example CEP Scenarios
  • Manufacturing:
  • Sensor on plant floor
  • React through device controllers
  • Aggregated data
  • 10,000 events/sec
  • Power, Utilities:
  • Energy consumption
  • Outages
  • Smart grids
  • 100,000 events/sec
  • Web Analytics:
  • Click-stream data
  • Online customer behavior
  • Page layout
  • 100,000 events /sec
  • Financial Services:
  • Stock & news feeds
  • Algorithmic trading
  • Patterns over time
  • Super-low latency
  • 100,000 events /sec

Asset Instrumentation for Data Acquisition, Subscriptions to Data Feeds

Data Stream

Data Stream

Visual trend-line and KPI monitoring

Batch & product management

Automated anomaly detection

Real-time customer segmentation

Algorithmic trading

Proactive condition-based maintenance

Stream Data Store & Archive

Asset Specs & Parameters

Event Processing Engine

  • Threshold queries
  • Event correlation from multiple sources
  • Pattern queries



PerformancePoint Services

in SharePoint 2010

  • Deep Integration with SharePoint
    • Enterprise Deployment & Management
    • Single Security Model and Administration
  • Incremental Improvements
    • Scorecards
      • Dynamic hierarchies with navigation
      • KPIs on columns
      • Multiple Actual Values
      • Variance
      • Calculated Metrics
      • Filter Hierarchies
  • New Features
    • Decomposition Tree
    • KPI Details Report
    • Pie Charts
    • Analytic Report Value filtering
    • Analysis Services Conditional Formatting

Excel 2010

  • PivotTable Write-Back
    • Support for Analysis Services Write-Back directly from PivotTables
    • Complete Object Model Support
  • Slicers
    • Create visual-interactive analytics
  • Named Sets
    • Define and re-use sets of members
    • Improved PivotTable layout control
  • Formatting and Interactivity
    • Format and navigate data
  • Excel Services
    • SharePoint Excel Services integration
roadmap summary
Roadmap Summary

Accelerating delivery of incremental value and innovation

  • Available Now
    • SQL Server 2008
    • Fast Track Data Warehouse Reference Architectures
    • SharePoint Server 2007 / PerformancePoint Server 2007
  • Coming in H1 Calendar Year 2010
    • Final packaging and pricing TBD
    • SQL Server 2008 R2
      • Self Service Analysis (PowerPivot) & Reporting
      • Application & Multi-Server Management
      • Master Data Services
      • Low Latency Complex Event Processing
      • Support for up to 256 cores
    • SQL Server 2008 R2 Parallel Data Warehouse Edition
    • SharePoint 2010, including PerformancePoint Services

Preliminary Information Subject to Change

  • 39

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