Cohesive Reporting Strategy Achieved by SAP Customer Bruce Hinde and Robert MacLean Microsoft BI Conference June 2010 Simplement Inc SESSION CODE BIP02INT Required Slide BI Has Changed ID: 331238
Download Presentation The PPT/PDF document "Required Slide" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Required SlideSlide2
Cohesive Reporting Strategy Achieved by SAP Customer
Bruce Hinde and Robert MacLean
Microsoft BI Conference - June, 2010Simplement Inc.
SESSION CODE: BIP02-INT
Required SlideSlide3
BI Has
Changed
Key Take Aways
New Hardware has changed gameBusiness Value of Pervasive BIGlobal, web-based deploymentIn-Memory Analytics
Real Time Demands
Do It Yourself
–
Empowered Business Users
What we called Ad Hoc wasn’t really
Ability to create actionable information in time to make meaningful decisionsSlide4
Audience
Questions
Who is running SAP?
How many have NetWeaver/BI running (Business Warehouse)?How many have SharePoint®?Slide5
Big
Picture
Reporting Tools can be used by Business Users – not just IT
Need to spend more time WORKING with the data, not just GETTING the dataIT’s job is no smaller – just different … preparing, securing and delivering data to the businessSlide6
Overview
Customer profile - TIC Holdings/Kiewit
SAP Reporting Problems
Why Data Liberator™/ MSFT BI Stack? Provide Cohesive Reporting Strategy:Advantages – data brokeringAdvantages - reporting platformDemonstrations of TIC ReportsLiberator™ Road Map and DemosDiscussionSlide7
TIC Holdings is
…
Heavy construction company
A wholly-owned subsidiary of Kiewit CorporationIncludes international operations 8000+ employees 12 Modules of SAP since 2006Slide8
How TIC tried to solve its reporting needs
…
Reporting Tools - before cohesive strategy
Standard R3 Reports (limited)Custom ABAP Reports in R3R3 Function Modules / Report Generation and Presentation in Crystal ReportsSAP Business Warehouse (BW)Slide9
What happened without a cohesive SAP reporting
strategy
Prevailing Issues
Significant pent-up demand within the business for additional information access and reporting output SAP team overburdened - responsible for both transactional and reporting developmentBusiness users had very limited ability to produce their own reportsSlide10
What happened without a cohesive SAP reporting
strategy
Prevailing Issues (continued)
Limited ability to provide cross-functional report contentLimited ability to combine data from other systems with data from SAPUsers confounded by data that is delivered at different times, from different systems, for the same reporting periodSlide11
What happened without a cohesive SAP reporting
strategy
Prevailing Issues (continued)
New managerial reporting requirements to be met as part of the Kiewit organization (new corporate parent) Many new reports to produce, as effectively and as quickly as possibleLimited capacity of existing tools to meet demand… and layering BusinessObjects on top of system would not solve prevailing issues, and would carry unacceptable costsSlide12
Key Lessons
Learned
Both SAP R/3 and BW suffer from reporting limitations: cross-functional, multi-system, ad hoc reports, etc.
SAP team couldn’t satisfy all reporting demands across the organization“Garbage Out / Garbage In” is as important to keep in mind as the reverse …Great Reports = increased SAP footprint and acceptanceTo Overcome: Consulting overhead, time-to-market, and performance issues associated with traditional approachesSlide13
Traditional data access strategies can’t support Cohesive Reporting Strategy
Why the Data Liberator™ / MSFT BI Stack?
Only the Simplement Data Liberator™ supports brokering data for reporting and related BI purposes:Significantly reduces performance drag on the SAP transactional system relative to custom ABAP reports and BW extraction Replication, as opposed to extraction, provides real-time access to underlying data (versus, e.g., BW)Reveals data - immediately available to SQL’s native reporting toolsSlide14
Cohesive Reporting Strategy - … reporting
platform
Why the Data Liberator™ / MSFT BI Stack?
Together with the Data Liberator™, SQL Server® and the rest of the MSFT BI Stack provide distinct advantages:SQL Server development tools inherently more flexible, intuitive, and forgiving than their ABAP and BW counterparts
Data transformation in SQL Server enables
report development by
business users
PowerPivot – in-memory analytics for end users
Report outputs are more flexible (printing, formats, fonts, Excel Services, etc.)Slide15
Cohesive Reporting Strategy - … reporting
platform
Why the Data Liberator™ / MSFT BI Stack? (continued)
Report run times are vastly improvedSharePoint® - natural choice for delivery layer Multiple pieces of the solution contained in three key licenses: SQL Server
®
,
SharePoint
®
and
Office (
Excel
®
)Slide16
Cohesive Reporting Strategy – MSFT BI Stack, founded on SQL
Server
®Why the Data Liberator™ / MSFT BI Stack?
The SQL Data Warehouse can serve dual masters – transactional (SSRS) and analytic reporting (SSAS) Decreased reliance on Cubes thanks to PowerPivotEasy, native SharePoint®
integration
Start with SSRS for operational reports, move to analytics and enhanced reports
all as part of one cohesive strategySlide17
A New Way of
Working
How to Work with Liberated Data / MSFT BI Stack?
In Past – IT does end-to-end development of reportsNOW – IT Brokers Data - builds multi-purpose Data SourcesDatabase View – building blockReuseableCombinable
Understandable
LIMITED STORED PROCEDURES
NOW – Business Users empowered to use familiar tools
to build reports off Data SourcesSlide18
TIC’s Data Liberator / SQL Server Reporting Platform -
Status
Successful Strategy
Less cost than alternativesTIC SAP (IT) team members are Data BrokersBusiness users empowered - wrote the reports“Go-live” of TIC’s production platform took place in July 2009 - Huge win for both IT and businessSlide19
Sample Reports
Real World Samples
Review
Discuss How BuiltQuestions & AnswersSlide20
Liberator Conceptual Demo
Robert MacLean
Possibilities with "Liberated Data"DiagramsSAP Data in PowerPivot - familiar
SAP Data delivered to SharePoint® -
collaborative
Security & Governance –
managementSlide21Slide22
Simplement Data SimplificationSlide23
Wrap Up and
Q & A
Benefits of staying in MSFT stack
Added value of Simplement for data accessThe BI World is changing - new methods and approaches eliminate some traditional work and make self-service more viable Questions for Robert MacLean: info@simplement.us
Slide24
Discussion
questions for Robert MacLean: info@simplement.usSlide25
Track Resources
Required Slide
Track PMs
will supply the content for this slide, which will be inserted during the final scrub.
Resource 1
Resource 2
Resource 3
Resource 4Slide26
Resources
Required Slide
www.microsoft.com/teched
Sessions On-Demand & Community
Microsoft Certification & Training Resources
Resources for IT Professionals
Resources for Developers
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn
LearningSlide27
Related Content
Required Slide
Speakers,
please list the Breakout Sessions, Interactive Sessions, Labs and Demo Stations that are related to your session.
Save Millions and Get the Information You Want from SAP: Life Sciences Leader
Sysmex
Shows How
(
BIC208
)
Using Microsoft Office 2010 with
PowerPivot
to Analyze SAP BW Data
(
BIU303
)
Product Demo Available at Booth # 2045, or by request to
info@simplement.usSlide28
Complete an evaluation on
CommNet
and
enter to win!
Required SlideSlide29
©
2010 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.