BUSINESS INTELLIGENCE IN A HEARTBEAT HP-Microsoft Business Decision Appliance

Stuart LongHP PreSales Solutions Architect

Shashank PawarMS SQL Server Technology Specialist

HP TECHNOLOGY@WORK 2011THE INSTANT-ON ENTERPRISE IS HERE

LET’S DO AMAZING

COMMERCIAL DRIVERS

Your Competitors are Faster

YOUR IT SOLUTION TODAY TAKES TOO LONG

Manually provisioned for

each application:

• Many people

• Many steps

• Many weeks

• Error prone

Business selectsapplication

Architecture review

Evaluation/POCPlace order

More meetings Move to test center

UnpackServer delivery Planning

meetings

Change control approvals Move to environment

Re-cable, move into production environment

User acceptance testing

Coordinate building process

Get purchase approvals

Weeks

4

ONLY 32% of service delivery projects are considered successful.

BUSINESS APPLICATION DELIVERY CHALLENGES

– Complexity – rapid technology evolution, global markets and increased competition

– Time – growing demand for IT to deliver solutions faster, with higher success ratio

– Risk – successful business service delivery needed to avoid lost opportunities, revenue,

customers

– Extensibility – ensuring today’s solutions (on premise) translate to future models (cloud)

Business users can’t access data easily for decision-making

BI CHALLENGE

I need to measure campaigns across

regions

I need to correlate market and

competitive data

I need a single view of our financial health

I need to model possible compensation scenarios

StrategyMarketing

IT overloaded with ad-hoc report requests

HRHR

IT

Multiple, independent data marts

Costly staffing

Isolated query & data mining tools

Storage sprawl Server sprawl

Elimination of separate data marts that do not share conformed dimensions which lead to different versions of the truth

DATA EXPLOSION = BI SPRAWL

Reduce costs and improve efficiency

HP TECHNOLOGY@WORK 2011THE INSTANT-ON ENTERPRISE IS HERE

LET’S DO AMAZING

BIEVOLUTION

THE EVOLUTION OF BI

Analysis Services

Reporting Services

Integration Services

Master Data Services

SharePointScorecards

Excel Workbooks/Se

rvices

PowerPivot Applications

SharePointSearch &

Dashboards

MICROSOFT BUSINESS INTELLIGENCE

Most widely deployed EIM & BI Platform

Most Broadly adopted Productivity &

Collaboration Tools

OdataFeeds

LOB Apps

StreamInsight

Data Mining

of data transferred in under minutes

vendor for the last

– BI Survey

VisualizationVisio

Services

HP TECHNOLOGY@WORK 2011THE INSTANT-ON ENTERPRISE IS HERE

LET’S DO AMAZING

THE SOLUTION

11

HP BUSINESS DECISION APPLIANCESELF SERVICE BI: OPTIMIZED FOR SQL SERVER 2008 AND SHAREPOINT 2010

Agile• Deploy in less than an hour

• Mid-market, enterprise workgroup and remote office

• Improved management capabilities: console, System Center pack, integrated servicing and support

Complete• All HW, SW and Support

included, installed, tested

• One step solution update

• Windows Server + SQL Server

+ SharePoint Server +

PowerPivot for SharePoint

Optimized• Share and refresh PowerPivot

workbooks (often containing

millions of rows and multiple

data sources) with ease

What is installed in the box?

HP BUSINESS DECISION APPLIANCE

SharePoint Server 2010 VL

SQL Server 2008 R2 VL

Windows Server OEM

HP hardware

Note: PowerPivot server components are installed and configured. These components have no cost to the customer.

0Effort to see proof of concept using demo data

100%Compatible with existing Microsoft environment

1,000Users supported with a single affordable appliance

Optimised for SQL Server 2008 R2 and SharePoint Server 2010

HP BUSINESS DECISION APPLIANCE

End-to-end, pre-configured stack quickly enables self-service BI for Excel power users

1Hour to install

HP TECHNOLOGY@WORK 2011THE INSTANT-ON ENTERPRISE IS HERE

LET’S DO AMAZING

BENEFITS

BDA BENEFITS– Provides integrated IT dashboard with usage visualization

– Reduces implementation risk and cost, saving 1-6 months• Simple to set up and configure• Easily installed by channel partner• Backed by software technical support

– One machine SharePoint farm with all needed software

– The only external software requirement - domain controller

– PowerPivot with SharePoint is primary workload• Sharing business reporting and analytics insights• Excel Services, Analysis Services capabilities enabled (Reporting Services installed but not configured)

– Appliance Home Page to help customers create and share workbooks quickly.

SIMPLIFIED APPROACH TO AUTOMATION

– Simplified install process• Automates installation of Windows Server 2008 Enterprise “R2”, SharePoint 2010 Enterprise, and SQL Server 2008 Enterprise “R2”

– Administration portal and System Center management packs improve appliance management

– Initial onboard back-up and recovery –enables basic appliance backup –Most customers will eventually leverage external back-up solutions.

– Restore image on disk returns appliance to factory state.

17

MANAGED SELF-SERVICE BUSINESS INTELLIGENCE WITH POWERPIVOT

PowerPivot for Excel PowerPivot for SharePoint

• Familiar Excel authoring environment

• Access even the largest data sets from

virtually any source

• Deeper business insight with the world’s

most popular B.I. tool

• Boost productivity across the entire organization

• Empower collaboration around PowerPivot

workbooks and SharePoint Reports

• Centralize and monitor BI and enterprise data

management

18

BALANCING IT AND END USER NEEDS

• Data Consistency & Quality

• Insight & Oversight

• Security & Compliance

IT Pro

• Access to good data

• Familiar & Agile Authoring Experience

• Sharing & Collaboration

End User

HP TECHNOLOGY@WORK 2011THE INSTANT-ON ENTERPRISE IS HERE

LET’S DO AMAZING

SUMMARY

TOMORROW’S BUSINESS

WILL BE BUILT ON

A CONVERGED

INFRASTRUCTURE

Power & cooling

Management software

Network

ServersStorage

Converged

Infrastructure

21

HP AND MICROSOFT:CONVERGED APPLICATION SOLUTIONSA NEW PORTFOLIO that converges applications and infrastructureto deliver business services as one solution

COMPLETE

OPTIMIZED

AGILE

NEXT STEPS

Visit: http://www.hp.com/solutions/microsoft/sqlbi

Engage: See the HP Rep at rear of clinic

Seek more: Request follow up via Eval Form

Re-Live: www.hp.com.au/taw11post

HP TECHNOLOGY@WORK 2011THE INSTANT-ON ENTERPRISE IS HERE

QUESTIONS?

HP TECHNOLOGY@WORK 2011THE INSTANT-ON ENTERPRISE IS HERE