Common Situations…

2

Departments choosing best in class

solutions for their specific needs Lack of coordinated BI strategy across

the enterprise

Acquisitions of companies using

different BI tools

3-5 BI solutions in use in your company?

IT developing, deploying and maintaining multiple, disconnected tools?

IT and users growing skills in several BI technologies?

Discrepancies in numbers coming from different reporting tools?

Debates about which data metrics to use across multiple tools?

No single, consolidated view of information?

Need to reduce BI overhead?

Need to simplify training time and costs?

Need to find opportunities to reduce overall TCO?

“Office SharePoint Server 2007 BI tools are faster to learn and use than our other tools…. We can enable more

people to take advantage of BI due to the familiar interface.”

Rebecca Wilson, Project Leader, Productivity Management Group, Tyson Foods

Company profile: The second-largest food production company in the Fortune 500 and a member of the S&P 500.

The company employs 104,000 employees at more than 300 facilities around the world.

Business Challenge Solution Benefits

Implemented a portal solution

that delivers accurate, timely

data in proper context to

facilitate better decision making.

The portal provides a Microsoft

BI solution based on Microsoft

Office SharePoint Server, SQL

Server, and Office Excel.

• Improved collaboration

• Better business insight

• Improved organizational

efficiency

• Powerful solutions with

less development

• Reduced costs with collaboration

and BI

• Creating complex reports from

SAP data

• Simplifying report management

and distribution

Fast Facts

Total number of documents searched using Enterprise Search 250,000

“We can evaluate product mixes for our most important customers and know immediately whether a

marketing campaign is successful. Our sales team tracks month-to-date trends and opportunities. Vending

looks at machine throughput, while operational teams view performance to forecast for manufacturing. We’re

taking advantage of our Microsoft solution to make better decisions in nearly every part of the business..”

- Chris Witzgall, Vice President of IT, G&J Pepsi-Cola Bottlers

Company profile: A leading bottler and distributor of Pepsi and other beverages throughout Kentucky and Ohio. Operating four

manufacturing and 13 distribution facilities, the company is one of the largest Pepsi bottlers in the U.S.

Business Challenge Solution Benefits

Adopted a Microsoft Business

Intelligence (BI) solution based on

Microsoft SQL Server®, Office

SharePoint® Server, and Office

PerformancePoint™ Server.

• Rapid insight into

business performance

• Improved business agility

• Faster access to critical

sales figures

Fast Facts

Number of fields accessed from Master Customer Data file 50

Time taken to generate month-end data 24 hours

• Getting timely access to

enterprise-wide data and

moving beyond a solution

based on Microsoft® Office

Access to consolidate this data

for up-to-date reporting

• Consolidating data from five

disparate servers to a central

data warehouse

• Comprehensive and integrated BI and

performance management offering

• Agile products that adapt to how

you use information

• Built on a trusted IT backbone

Microsoft Business Intelligence Vision

7

Improving organizations by providing

business insights to all employees leading to

better, faster, more relevant decisions

Microsoft Business Intelligence Get the most out of the products you know

8

Data Infrastructure and BI Platform Analysis Services Reporting Services Integration Services Master Data Services Data Mining Data Warehousing

Business Collaboration Platform Dashboards & Scorecards Excel Services Web based forms & workflow Collaboration Search Content Management LOB data integration

Familiar User Experience Self-Service access & insight Data exploration & analysis Predictive analysis Data visualization Contextual visualization

Empower Your People

Enable IT Efficiency

Improve Organizational Effectiveness

• Cut cost and complexity by leveraging existing IT investments

• Scale-out to support BI for all users at a lower total cost of ownership (TCO)

• Increase productivity with familiar and intuitive development and management tools

• Increase team and organizational productivity through dashboards

• Improve visibility into key team and organizational objectives and metrics

• Increase business user efficiency with an integrated collaborative platform

• Increase individual productivity through familiar and intuitive tools

• Enable your end users to create their own BI solutions

• Improve end-user sharing and discovery of insights

Empowering the End User Introducing PowerPivot for Excel

• Enable users to perform self-service

analysis and intuitively build their

own BI solutions

• Allow users to interactively explore

and perform calculations on large

data sets

• Integrate data from multiple

sources

• Minimize dependence on IT support

Powerful Personal Analysis Tools Drive personal productivity and insight

Improved formatting and charts

Easier navigation with Slicers

Microsoft Confidential, Prototype Only

PowerPivot for Excel PowerPivot for SharePoint

Self-service Analytics Introducing PowerPivot

12

Self-service Reporting Empower end users to author reports

13

Report Builder 3.0 • Familiar Microsoft Office interface

• Intuitive report wizards and reusable report components

• Powerful query designer

• Flexible layout options with rich visualizations

• Can support all data sources, including SharePoint list or PowerPivot

Rich Visualizations Deliver more insight with geospatial mapping of BI data

• Mapping, routing, and custom shapes

• Integration with Bing Maps

• Visualize data within a single cell

• Dynamically segment and filter data

• Display data using interactive and dynamic PivotChart

Maps Sparklines and

Databars

Graphs

Choose the right graphic to illuminate answers and trends

Improving Organizational Effectiveness Supporting business collaboration across the enterprise

15

15

Microsoft Confidential, Prototype Only

Share Insights Get a common view of organizational performance

Publish and share rich workbooks to SharePoint

Get access to unlimited data secured in SharePoint with PowerPivot

Refresh workbook data manually or automatically

Get the same rich fidelity with a Web browser, including Ribbon and Excel functions

―What we like about the 2007 Microsoft Office system products is the deep integration of desktop programs

with back-end data.”

- Randy Benz, Vice President and Chief Information Officer, Energizer Holdings

Case Study – Energizer Holdings

Company profile: A leading manufacturer of batteries, flashlights, and wet-shave products. The global company has made a significant

investment in Microsoft Office software for its 6,800 knowledge workers, who also use dozens of specialized line-of-

business (LOB) applications to do their jobs.

Business Challenge Solution Benefits

Deployed the 2007 Microsoft

Office system to 6,800

knowledge workers to take

advantage of SQL Server,

Microsoft Office, and

SharePoint.

• Ability to self-service

information needs

• More strategic use of IT staff

• Enhanced user productivity

• Enabling employees to have

easy access to LOB data from

their desktop productivity

applications

• Improving productivity

in everyday tasks

Fast Facts

Number of knowledge workers using Microsoft Office Solution 6,800

Discuss and Engage Enable team interaction with social media tools

Discuss and share insights with a rich

blogging experience

Locate useful information with content

rating and navigation with tag clouds

Relevant Search Find structured and unstructured data

Find reports, workbooks, and people seamlessly with relevance

Refine and filter to get what you want the first time

Increase visibility into key team and organizational

objectives with dashboards

Display business data in context

Enable continuous analysis and iterative decision making

with new chart types

See interdependencies with strategy maps

Track key metrics

21

Centralized

Visibility

Report and data usage

Application Performance

Database performance and utilization

21

High Performance

and Scalability

High scale data warehouse

High scale analytics and reporting

Application and multi-server

management

Integration and

Interoperability

Rich data connectivity

Enterprise data integration

Data alignment across multiple

systems

Increase IT Efficiency Administrative consistency expedites BI uptake

Consolidate disparate product investments

Master Data Data Warehouse

Analysis

Data Mining

ETL

Collaboration

Portal

Search

Enterprise Content Management

Scorecards and Dashboards

Reporting

Data Quality

New features: Query Optimizations, Resource Governance, Enhanced

Partitioning Performance

Scale-out to support BI for all users at a lower TCO

Easily manage the self-service environment

Provide user-driven application administration and monitoring

Simplify management of BI content using the PowerPivot Management Dashboard

Manage and facilitate access to secure organizational data

Familiar and intuitive development and management tools

Productivity Enhancing Designers

Integrated Development Environment

Dix Inc Dixie Dixie

(Salem)

Dixie Inc Aut_Dixie

Master Data Stewardship Matching

Versioning

Workflow

Role- Based Security

Hierarchy Mgmt

Business Rules

26

Integration and Interoperability Master Data Services (MDS) aligns data within and across systems

•

•

•

•

Microsoft Leads in BI

The Magic Quadrant is copyrighted January 29, 2010 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.

The Magic Quadrant graphic was published by Gartner, Inc., as part of a larger research note and should be evaluated in the context of the entire report. The Gartner report is available upon

request from Microsoft.

“Magic Quadrant for Business Intelligence

Platforms”, 29 January 2010 Rita L. Sallam,

Bill Hostmann, James Richardson, Andreas

Bitterer

Company profile: The second largest health maintenance organization (HMO) in the world. Clalit Health Services serves more than

3.8 million people, and supports 70 million customer interactions per year.

Business Challenge Solution Benefits

Upgraded the BI data warehouse

to SQL Server 2008 Enterprise

(64-bit) to take advantage of

SQL Server 2008 Analysis

Services and SQL Server 2008

Reporting Services—without

upgrading their hardware

infrastructure.

• Valued decision support

• Enhanced query performance

• Support for spatial data

• Performance protection with

Resource Governor

• Maximizing value from a

2.7-terabyte data warehouse

• Taking advantage of SQL

Server 2008 features to boost

query performance

• Protecting performance by

protecting resource allocation

Fast Facts

Total data stored in SQL Server 16 terabytes

Data in enterprise BI data warehouse 2.7 terabytes

Multidimensional data cubes 100

Analysis running ad-hoc queries 400

Users running OLAP queries 5,000

SQL Server data compression rate 50–60%

• Advisory Architecture & Planning

• Highly skilled App Plat consulting

• Enterprise Support for high availability, critical applications

• Proven adoption methodologies to reduce risk and increase velocity

Partners and ISVs • Line of business applications to fit your needs

• Global and local presence

• Trained, certified, and assisted by Microsoft

Training and Readiness • IT Pro communities to share latest trends

and innovation

• Online and classroom training

• Certification to ensure quality

Application Assessment Tool • Help you assess your business applications

• Propose technology solution plan to answer your business and IT requirements

www.microsoft.com/applicationplatform

www.bitscape.com

Ashish.bahuguna@bitscape.com