• No results found

Microsoft Business Intelligence solution. What makes Microsoft BI difference

N/A
N/A
Protected

Academic year: 2021

Share "Microsoft Business Intelligence solution. What makes Microsoft BI difference"

Copied!
30
0
0

Loading.... (view fulltext now)

Full text

(1)
(2)

Business Intelligence today

Microsoft Business Intelligence solution

What makes Microsoft BI difference

Case study and Demo

(3)

Market Share: All Software Markets, Worldwide, 2010 http://www.technologyreview.com/business/37650/?nlid=4534

$5,400.00

$5,600.00

$5,800.00

$6,000.00

$6,200.00

$6,400.00

$6,600.00

$6,800.00

2009

2010

Gartner BI Platform

Software Revenue

(in $Billions)

B u s i n e s s I n t e l l i g e n c e = O p p o r t u n i t y

BI &

Analytics

CIO Priorities: Data Analysis

Technologies BI/Performance Management

Top IT Invesment Plans

(4)

State of Business Intelligence

Agile BI Out of The Box, Forrester Research, Inc., April 22, 2010

32% of Excel users are

comfortable with using it for

“Advanced Analysis”

e.g., PivotTables

Only 28% of potential

BI users have any

meaningful access

31% of all BI initiatives

partially meet or don’t

meet the business goals

originally set

Knowledge workers spend

too much time looking for, not

enough time analyzing the

information.

Lines between producers

and consumers of

information have largely

disappeared.

Requirements change way

too fast for IT and traditional

technology to keep up.

– Excel Segmentation Research – BI Survey 9, BARC

– Business Intelligence Purchase Drivers and

Adoption Rates, Gartner

(5)

Trends in BI

IT Owned and Managed

Slow to Respond

Monolithic

Not Interactive

Business Owned, IT Managed

Agile and Flexible

Self-service

Collaborative

Unstructured Data Structured Data Structured & UnStructured Data

`

(6)

Trends in BI

Collaborative

Decision Making

access information

anywhere at any time

demanding self service

consumerization of IT

share and collaborate with

friends and colleagues

(7)

Business Intelligence today

Microsoft Business Intelligence solution

Microsoft BI differenciation

Case study and Demo

(8)

Agility Control

(9)

Collaborative Complete On Your Terms

(10)

● Familiar experiences for

rapid data exploration

and discovery with

Excel.

● Powerful data mash-up

capabilities for self-service

analysis with

PowerPivot.

● Easily accessible reports,

dashboards and rich data

visualization in

SharePoint.

(11)

Demo

(12)

Familiar Complete On Your Terms

(13)

● Find expertise & valuable information;

● Connect with colleagues;

● Engage in team discussions and

threaded conversations;

● Share & collaborate on documents;

… in SharePoint.

Better decisions through better collaboration

(14)

Familiar Collaborative On Your Terms

(15)
(16)

Familiar Collaborative Complete

(17)

HP Business Decision Appliance

HP Business Data Warehouse

SQL Server 2008 R2 Parallel Data

Warehouse

(18)

Deploy & Future Proof

Agility Control

Monitor & Manage

Connect & Provision

IT Professional

End-User

Share & Collaborate

Mash-up & Analyze

Find & Access

BI Agility with IT Control

(19)

Business Intelligence today

Microsoft Business Intelligence solution

Microsoft BI differenciation

Case study and Demo

(20)

[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.

23.9%

16.5%

13.8%

5.8%

1.2%

Microsoft SAP Oracle IBM SAS

2010 Megavendor Growth

(21)

More than 70% of Enterprises have

SharePoint.

Excel used by over 90% of information workers – Microsoft

Analysis

62% of SharePoint users use the product daily.

Fastest growing reporting platform

- BI Verdict

Most widely used BI Vendor

- InformationWeek

(22)
(23)

Across BI Spectrum

Team BI

Our Context

BI Solution created by power

user. Context is for a small

team & it’s managed on a

server.

Personal BI Corporate BI

My Context

BI solution created by user.

Context is only for user &

exists as document.

The Org’s Context

BI Solution created by IT,

Established corporate context &

is reusable, scalable and backed

up.

PowerPivot For Excel PowerPivot For SharePoint Analysis Services

Empowered Aligned

(24)

Business Intelligence today

Microsoft Business Intelligence solution

Microsoft BI differenciation

Case study and Demo

(25)

Super-tanker scale BI

22 Tb stored in SQL Server

396,907 transactions per minute

210 billion transaction per year

Mediterranean Shipping Company

(26)

– Andre Simha

Chief Information Officer, Mediterranean Shipping Company

The new tools in Office 2010 help everyone be more productive…

We work faster and smarter than the competition

Mediterranean Shipping Company

(27)

HIPPA compliant patient data

3.5m patient EMRs

High-performance reporting

Mission Critical Data

(28)

Administrators’ audit dashboard

20GB source data = 1.5MB workbook

Built in a week

Managed Self-Service BI

(29)

Customers Tell Our Story Best

Major BI

5.1 terabyte Credit Card DW, 5 Mil card holders

500+ unique reports, 1,500+ users, SSIS,

SSRS, SSAS

Catering Planning System used in 2,300 hotels

25% time savings in catering forecast generation

3terabyte retail data warehouse on HP

Superdome Uses SQL Server OLAP, SSIS, SSRS

(30)

References

Related documents

Students will learn how to create a data warehouse with Microsoft SQL Server with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate

10331 Introduction to Microsoft SQL Server 2008 R2 Master Data Services English. 10333 Introduction to Microsoft SQL Server 2008 R2 Parallel Data Warehouse

The HP Business Decision Appliance, designed jointly by Microsoft and HP, optimized for SQL Server 2008 and SharePoint Server 2010, supports this objective with

Offerings such as Netezza (another provider of analytic and data warehousing solutions), Vertica, Greenplum, ParAccel, and Microsoft SQL Server 2008 R2 Parallel Data

Direct Edge implemented a data warehouse and BI solution based on Microsoft SQL Server 2008 R2 Parallel Data Warehouse, which has given the company more visibility into its data.

• The dimensional modeling process and design spreadsheet Microsoft Data Warehouse/Business Intelligence System Architecture. • Common components of DW/BI

This overview shows most commonly used KPIs in receivables area, like Receivables Balance, Before Due and Overdue structure, Average Payment Terms, Late payments (Avg. Overdue),

Also, the Hitachi solution for a medium-sized Microsoft SQL Server data warehouse enables your enterprise to consolidate silos for enterprise-wide business intelligence and scale