1. technology and computing

This seminar is based on a number of sources including a few
dozen of Microsoft-owned presentations, used with
permission. Thank you: Michael Tejedor, Chris Volckerick, Tara
Seppa, Morris Novello, Bryan Bredehoeft, Chris Dial, Donald
Farmer, Sabrena McBride, Peter Sprague, and Diwakar
Rajagopal.
The information herein is for informational purposes only and represents the opinions and views
of Project Botticelli and/or Rafal Lukawiecki. The material presented is not certain and may vary
based on several factors. Microsoft makes no warranties, express, implied or statutory, as to the
information in this presentation.
Portions © 2011 Project Botticelli Ltd & entire material © 2011 Microsoft Corp unless noted
otherwise. Some slides contain quotations from copyrighted materials by other authors, as
individually attributed or as already covered by Microsoft Copyright ownerships. 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 Project Botticelli Ltd as of the
date of this presentation. Because Project Botticelli & Microsoft must respond to changing
market conditions, it should not be interpreted to be a commitment on the part of Microsoft,
and Microsoft and Project Botticelli cannot guarantee the accuracy of any information provided
after the date of this presentation. Project Botticelli makes no warranties, express, implied or
statutory, as to the information in this presentation. E&OE.
Status and
Evolution
of BI
Balancing
Your
Needs
Microsoft
BI
Future
Only 28% of potential
BI users have any
meaningful access
Knowledge workers spend
too much time looking for,
not enough time analyzing
the information.
32% of Excel users are
comfortable with using it
for “Advanced Analysis”
e.g., PivotTables
31% of all BI initiatives
partially meet or don’t
meet the business
goals originally set
Lines between producers
and consumers of
information have largely
disappeared.
Requirements change way
too fast for IT and
traditional technology to
keep up.
Agile BI Out of The Box, Forrester Research, Inc., April 22, 2010
Evolution of BI
Traditional BI
Self-Service BI
Provision
Analysis
Reports Dashboards &
Scorecards
End Users
Data
Staging
ETL/Data
Quality
Analysis
Data
Cubes Warehouse
Specialized
Tools
Spreadsheets
Existing
Data
LOB
Applications Data Marts
Files
IT Pro
To But
provision
Rapidly
ITbusiness
hasHarvesting
breaking
been
reports,
Isisitbusy
outpacing
possible
dashboards
down
existing
keeping
the
to
ITdata,
balance
barriers
and
up& with
scorecards
End
cleaning
Control
of
the
Users
Control
growing
it and
are
to
with
meet
with
demanding
staging
Agility?
demand
Self-Service
EnditUser
for
…Agility
BI…
demand.
BI!…
Agility
Control
Evolution of BI
Traditional BI
Self-Service BI
Niche Startups
Delivering the next generation of BI Agility with IT Oversight
[Gartner, Inc., Magic Quadrant for Business Intelligence Platforms, Rita L. Sallam et al, January 27, 2011.
The Magic Quadrant is copyrighted 2011 by Gartner, Inc. and is reused with permission. The Magic Quadrant is a graphical representation of a marketplace at and for
a specific time period. It depicts Gartner's analysis of how certain vendors measure against criteria for that marketplace, as defined by Gartner. Gartner does not
endorse any vendor, product or service depicted in the Magic Quadrant, and does not advise technology users to select only those vendors placed in the "Leaders"
quadrant. The Magic Quadrant is intended solely as a research tool, and is not meant to be a specific guide to action. Gartner disclaims all warranties, express or
implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.
Empower End Users
Familiar and Flexible Tools
Find and Access
Leader in information access
technology
– Magic Quadrant for
Information Access Technology,
2009
Quickly search and
find information in
reports, dashboards,
and scorecards
Mash-up and
Analyze
Mash-up and analyze
data in the familiar
Excel environment
Share and
Socialize
Share and collaborate
for better decision
making
Familiar and Flexible Tools
Mediterranean Shipping Company
● Mash-up of data from
internal and external data
sources (U.S. Customs)
● 33M rows
● 1.7GB compressed
● Built-in 3 hours
The new tools in Office 2010 help everyone be more productive…
We work faster and smarter than the competition
– Andre Simha
Chief Information Officer, Mediterranean Shipping Company
13
Provision Access to Information
Built to be Mission Critical
Heterogeneous
Connectivity
Data Integration
and Data Quality
Data Staging
and Modeling
LOB Apps Teradata
of data
transferred
in under
minutes
vendor
for the last
– BI Survey
Connect to
data across your
heterogeneous
environment
Integrate data
and ensure data
quality across
your organization
Prepare data and
build models for
end-user access
Mediterranean Shipping Company
22 Tb stored in SQL Server
396,907 transactions per minute
Supertanker Scale BI
210 billion transaction per year
Built to be Mission Critical
Yahoo!
Events per Day
Data Load per Day
Files per Hour
Analysis Services Cube
…It has to be information at the speed of thought…we
were able to achieve less than 10 seconds of query time
against a 12TB Cube
18
CareGroup Healthcare System
HIPPA compliant patient data
3.5m patient EMRs
Mission critical data
High-performance reporting
CareGroup Healthcare System
Administrators’ audit dashboard
20GB source data = 1.5MB workbook
Accessible self-service BI
Built in a week
23
Striking A Balance
IT Professional
End-User
Connect & Provision
Find & Access
Monitor & Manage
Mash-up & Analyze
Deploy & Future Proof
Share & Collaborate
Control
Agility
Microsoft Business Intelligence
SharePoint
Search &
Dashboards
SharePoint
Scorecards
Analysis
Services
Integration
Services
Excel
Workbooks
Reporting
Services
Master Data
Services
PowerPivot
Applications
Most Broadly adopted
Productivity &
Collaboration Tools
Most widely deployed EIM
& BI Platform
LOB
Apps
Odata
Feeds
Build on What You Already Know
Most broadly adopted
productivity suite
Fastest growing
collaboration platform
Most popular DW, OLAP,
and reporting platform