1 / 29

Required Slide

Required Slide. Required Slide. SESSION CODE: BIP02-INT. Cohesive Reporting Strategy Achieved by SAP Customer. Bruce Hinde and Robert MacLean Microsoft BI Conference - June, 2010 Simplement Inc. BI Has Changed Key Take Aways. New Hardware has changed game Business Value of Pervasive BI

paul2
Download Presentation

Required Slide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Required Slide

  2. Required Slide SESSION CODE: BIP02-INT Cohesive Reporting Strategy Achieved by SAP Customer Bruce Hinde and Robert MacLean Microsoft BI Conference - June, 2010 Simplement Inc.

  3. BI Has ChangedKey Take Aways • New Hardware has changed game • Business Value of Pervasive BI • Global, web-based deployment • In-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 decisions

  4. Audience Questions • Who is running SAP? • How many have NetWeaver/BIrunning (Business Warehouse)? • How many have SharePoint®?

  5. 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 data • IT’s job is no smaller – just different … preparing, securing and delivering data to the business

  6. Overview • Customer profile - TIC Holdings/Kiewit • SAP Reporting Problems • Why Data Liberator™/ MSFT BI Stack? Provide Cohesive Reporting Strategy: • Advantages – data brokering • Advantages - reporting platform • Demonstrations of TIC Reports • Liberator™ Road Map and Demos • Discussion

  7. TIC Holdings is …Heavy construction company • A wholly-owned subsidiary of Kiewit Corporation • Includes international operations • 8000+ employees • 12 Modules of SAP since 2006

  8. How TIC tried to solve its reporting needs …Reporting Tools - before cohesive strategy • Standard R3 Reports (limited) • Custom ABAP Reports in R3 • R3 Function Modules / Report Generation and Presentation in Crystal Reports • SAP Business Warehouse (BW)

  9. What happened without a cohesive SAP reporting strategyPrevailing Issues • Significant pent-up demand within the business for additional information access and reporting output • SAP team overburdened - responsible for both transactional and reporting development • Business users had very limited ability to produce their own reports

  10. What happened without a cohesive SAP reporting strategyPrevailing Issues (continued) • Limited ability to provide cross-functional report content • Limited ability to combine data from other systems with data from SAP • Users confounded by data that is delivered at different times, from different systems, for the same reporting period

  11. What happened without a cohesive SAP reporting strategyPrevailing 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 possible • Limited capacity of existing tools to meet demand • … and layering BusinessObjects on top of system would not solve prevailing issues, and would carry unacceptable costs

  12. 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 acceptance • To Overcome: Consulting overhead, time-to-market, and performance issues associated with traditional approaches

  13. Traditional data access strategies can’t support Cohesive Reporting StrategyWhy 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 tools

  14. Cohesive Reporting Strategy - … reporting platformWhy 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.)

  15. Cohesive Reporting Strategy - … reporting platformWhy the Data Liberator™ / MSFT BI Stack? (continued) • Report run times are vastly improved • SharePoint®- natural choice for delivery layer • Multiple pieces of the solution contained in three key licenses: SQL Server®, SharePoint®and Office (Excel®)

  16. 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 PowerPivot • Easy, native SharePoint®integration • Start with SSRS for operational reports, move to analytics and enhanced reports • all as part of one cohesive strategy

  17. A New Way of WorkingHow to Work with Liberated Data / MSFT BI Stack? • In Past – IT does end-to-end development of reports • NOW – IT Brokers Data - builds multi-purpose Data Sources • Database View – building block • Reuseable • Combinable • Understandable • LIMITED STORED PROCEDURES • NOW – Business Users empowered to use familiar tools to build reports off Data Sources

  18. TIC’s Data Liberator / SQL Server Reporting Platform - StatusSuccessful Strategy • Less cost than alternatives • TIC SAP (IT) team members are Data Brokers • Business users empowered - wrote the reports • “Go-live” of TIC’s production platform took place in July 2009 - Huge win for both IT and business

  19. Sample Reports Real World Samples • Review • Discuss How Built • Questions & Answers

  20. Liberator Conceptual Demo Robert MacLean • Possibilities with "Liberated Data" • Diagrams • SAP Data in PowerPivot - familiar • SAP Data delivered to SharePoint® - collaborative • Security & Governance – management

  21. Simplement Data Simplification

  22. Wrap Up and  Q & A • Benefits of staying in MSFT stack • Added value of Simplement for data access • The 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

  23. Discussionquestions for Robert MacLean: info@simplement.us

  24. Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub. Track Resources • Resource 1 • Resource 2 • Resource 3 • Resource 4

  25. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

  26. Required Slide Speakers, please list the Breakout Sessions, Interactive Sessions, Labs and Demo Stations that are related to your session. Related Content • 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.us

  27. Required Slide Complete an evaluation on CommNet and enter to win!

  28. © 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.

More Related