Transcript Excel 2007 - UTK-EECS

Mystery and Suspense?
Dan Fay
Technical Computing
Microsoft
eScience @ Microsoft
Using existing products and
technologies for scientific
research
Dan Fay
Technical Computing
Microsoft
Can “Here and Now” technologies
reduce Time to Insight?
Can “Business” Tools and techniques for
dealing with
Be used in scientific research to raise the bar
and allow researchers to be scientists and
not computer scientists.
The Problem for the e-Scientist
Experiments &
Instruments
Other Archives
Literature
questions
facts
facts
?
answers
Simulations
Data ingest

Data Query and Visualization
tools
Managing a petabyte

Support/training
Common schema

Performance
How to organize it?

Execute queries in a minute
How to reorganize it?

Batch (big) query scheduling
How to coexist & cooperate with others?
Computational
Modeling
Persistent
Distributed
Data
Workflow,
Data Mining
& Algorithms
Interpretation
& Insight
Real-world
Data
Computational
Modeling
Persistent
Distributed
Data
Workflow,
Data Mining
& Algorithms
Interpretation
& Insight
Real-world
Data
Persistent
Distributed
Storage
Visual
Programming
Distributed
Computation
Interoperability
& Legacy
Support via
Web Services
Searching &
Visualization
Live
Documents
Reputation
& Influence
Faster Time to Insight
Better integration to existing Windows infrastructure
Integrated and familiar development environment
Research
Integrate


Data acquisition from
source systems and
integration
Data transformation
and synthesis
Analyze


Data enrichment,
with business logic,
hierarchical views
Data discovery via
data mining
Report


Data presentation
and distribution
Data access for
the masses
Comparison of soil moisture
Water Content at 5 cm
0.6
0.5
Water Content at 20 cm
0.4
Vaira
0.6
0.3
0.5
0.2
0.1
y = 0.4712x
R2 = 0.7039
0.0
0.0
0.1
0.2
0.3
0.4
0.5
0.6
Vaira
0.4
0.3
0.2
Tonzi
y = 0.5854x
0.1
Thanks to
Gretchen Miller – UC Berkeley
& Catharine Van Ingen (MSR)
R2 = 0.9163
0.0
0.0
0.1
0.2
0.3
Tonzi
0.4
0.5
0.6
Other applications
Temperature at North American Sites
Average Tempmerature in oC
30
20
10
`
0
-10
20
30
40
50
Latitude
60
70
80
xl-caBIG Smart Client
How to give scientists a graphical interface
for accessing cancer Biomedical
Informatics Grid (caBIG) data-services.
http://xl-cabig-client.sourceforge.net/
PI - Katarzyna Macura
Johns Hopkins
caBIG In Vivo Imaging Workspace Subject
Matter Expert
xl-caBIG Smart Client
Reproducible Research
Document
Broad Institute
Infusion Development
SharePoint Products and Technologies
Microsoft Office SharePoint Server 2007
Server-based Excel
spreadsheets and data
visualization, Report
Center, BI Web Parts,
KPIs/Dashboards
Docs/tasks/calendars, blogs,
wikis, e-mail integration,
project management “lite”,
Outlook integration,
offline docs/lists
Business
Intelligence
Rich and Web
forms based frontends, LOB
actions, enterprise
SSO
Business
Forms
Platform
Services
Workspaces, Mgmt,
Security, Storage,
Topology, Site Model
Content
Management
Integrated document
management, records
management, and Web
content management with
policies and workflow
Collaboration
Portal
Enterprise Portal
template, Site
Directory, My
Sites, social
networking,
privacy control
Search
Enterprise scalability,
contextual relevance, rich
people and business
data search
Excel Services
Overview
Browser
Excel 2007
Design and
author
Publish
Spreadsheets
High quality web rending
Zero-footprint
Interactive: Set parameters,
sort, filter, explore
Limit to browser access
View and
Interact
Export/Snapshot into Excel
Programmatic Access
SharePoint platform and Excel services
Spreadsheets stored in
document libraries
Spreadsheet calculation and rendering
External data retrieval and caching
100% calculation fidelity
Excel 2007
Open in Excel for rich
exploration and analysis
Open snapshots
Custom
applications
Set values, perform calculations, get
updated values via web services
Retrieve full workbook file
Development
Data
Workflow
Collaboration
Publications
.NET & Visual Studio
F#
Iron Python
SQL Sever
SQL Server analysis
Services
Windows Workflow
SharePoint Server 2007
Knowledge Network
Instant Messenger
ConferenceXP
Academic Live, Onfolio, etc
…
Questions?
Can these tools/technologies provide
value/insight to scientists?
What’s missing?
Ie. on HPC, analysis, etc?
How best to test/integrate these
technologies?
Resources
Microsoft eScience Workshop at JHU
Oct 15-17 – www.mscs06.net
Windows HP
www.windowshpc.net
Data mining
www.sqlserverdatamining.com/
Develop without Borders Challenge
www.developwithoutborders.com
Technical Computing Blogs
http://blogs.msdn.com/dan_fay &
http://blogs.msdn.com/eScience
© 2006 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.