Preparing Your SAP Analytics Roadmap - PwC

Transcription

Preparing yourSAP AnalyticsRoadmapTorsten Hübsch12th February 20201

Agenda15:30Introduction15:45Building common ground16:15Analytics questions and SAP’s answers17:00Coffee break17:30Journey to your SAP Analytics solution18:00PwC supporting your journey18:15Networking drinkPwCYour SAP Analytics Roadmap2

Building common groundThe world is changing.From data warehouse to analytics to data intelligence.Data-centric enterprise.Scope for today: How to get there?

Analytics is the#1 technology expected tohelp businesses differentiatefrom their competition.Source: Gartner, Mastering the New Job of the CIO

Converging trends that challenge businesses to transformdata and analytics into a powerful strategic tool1Global big data volumesin zettabytes3Businesses want tomonetise dataData volumes to rise to 100 zettabytes by2025, necessitating the use of big datatechnologies for organization to managetheir data, such that it can deliver fastinsights and actions for business.By 2020, 90 percent of large enterprises willgenerate revenue from data-as-a-service,selling raw data, derived metrics, insights,and recommendations – up from nearly 50percent in 2017.2Businesses becoming analyticsdriven organizations4Analytics ecosystemsare transformingBusinesses driven by analytics will see 430 billion in productivity benefits overtheir competition not using data, by 2020,according to the International Institute forAnalytics.Analytics vendors (DI, BI, appliance,databases, big data, analytics) arepositioning them differently and are aligningthemselves with the analytics agenda oftheir customers.

Analytics TransformationIntuitive business insightsCost-focusedSiloed decision makingPreData-driven business insightsand intuitionValue-focusedCollaborative decision makingPost

2010Analytics throughout the yearsApache SparkMicrosoft Azure20111960Decision supportsystems198819701997Data lakesBusinessIntelligence2012202xDeep learningData-CentricRevolutionData warehousesOLAPRelational databasesby 20s200319681985Tableau2017MicrosoftExcel2005Data fabricHadoop20182006Graph technologiesAmazon EC220192008Cognitive, augmentedand embeddedintelligenceSPSS1976SAS1993RGCPPwC7

SAP BW throughout the years1972SAP R/21998BW 1.2OLAP vs OLTP2004BW 7.2BW 3.5Net weaver core,Broadcasting,PlanningMainframePre 200020082000 - 20052006 - 2010199220022006SAP R/3BW 3.0BW rovementPwCBOBJBPC20122018LumiraAnalysisfor officeSAP S/4HANA2011 - 20152011BW 7.3BW on HANAIntelligent ERPSAP Cloud Platform2016 - 20202016BW/4HANASACNative HANA2019SAP DataWarehouseCloudPost 20202025“X”/4HANAIntelligent Suite8

Where are we with BW/4HANA?DWH in the cloudPast years of BW and HANASACLeonardoxW/4HANABWDWHVORABOBJ (Webi, A4O, Lumira)SAP BW 7.XEnd of support(BW on) HANAAny database2012PwC201320142015.20259

What are your main questions?Which technology to use? How to be future proof?How to manage database growth?How to improve analytics experience within the company?How to access/combine structured and unstructured data?How to be more agile in analytics?How to cover the needs of the various users types?How to improve the usage of self service?How to ensure on time data availability and quality?PwC10

How does SAP answer these questions?From a data storage PoVFrom a data integration PoVFrom a data analytics PoVFor budget and forecastingPwC11

Data storageSAP BW/4HANA1.0- The next generation warehouse- Builds on the innovations ofSAP BW powered by SAP HANA- Leaves behind the legacy of SAPBW on any DB- Data Tiering Optimization (DTO) tomanage hot, warm and cold datatiers2016PwCSAP BW/4HANA1.0 SP04- Enhanced DTO options toreduce TCO- Enhanced master data loads- Tight integration with SAP DataHub- Analytical Engine improvements2017SAP BW/4HANA1.0 SP08SAP BW/4HANA2.0- Unified UI for all SAPBW/4HANA modeling aspects(DTP and TransformationEditor)- SAP BW/4HANA Web Cockpitas single entry point formonitoring and administration- New storage options for DTO- SAP’s vision for a modernpackaged data warehousingsolution- Simplified in every aspect ofdata warehousing- Smart integration of all businessapplications and modern datasources2018201912

\\PwCData storageThe HANA database covers the performanceside in read and write access. Quicker response time in reporting Quicker loading processScalability The solution is available as well onpremise or in the cloud with then fullscalabilityBW package redesigned with new objecttypes Virtualisation layer SQL Scripts replace ABAP to improve theusage of the HANA capabilitiesRedesign of monitoring and administrationweb cockpit Easier follow up and integration of NativeHANA data process Integration SAP DataHubData tiering Optimized storage of the data accordingtheir usage (hot, warm, cold, ) Reduced database costsDWH in the cloud Full HANA scalable solution without BWcontent With an integrated framework13

Data integrationOpenness The native HANA part of BW4HANA canconnect to all types of data The DWH in the cloud is based on SQLdata management as well PwCVORA allows to connect to cloudproviders (AWS/GCP/Azure) and tointegrate with data lakes Hadoop interactive data analytics SAP Data Hub is a full integrator toolallowing read, transform and analyseany type of data. Furthermore, workflowdesign is possible.Agility Possibility to upload data and create theobjects based on the metadata from thesource system Allows for very quick PoC building Easy integration between the BW andNative HANA Virtual layer can be easily defined andreplacedAccessibility Via the HANA view, the data areaccessible by most of the reporting toolsSAP as well as by non-SAP tools14

Data analyticsBOBJ All BO solutions (Webi, Lumira, Crystal reports, ) are still under maintenance till 2026SAP Analytics Cloud Fully scalable solution Contains dashboarding as well as reporting and analysis tools Can connect to HANA views and use HANA power Can upload and use data in the cloud Integrates with most data sourcesSAP Leonardo (potentially move to SAP Cloud Platform) The data analysis tool for data scientists PwCPreconfigured packages for machine learning and big data analysis15

Budget and forecastingBPC The SAP Business Planning and Consolidation (SAP BPC) application delivers planning,budgeting, forecasting, and financial consolidation capabilities, so you can easily adjust plansand forecasts, speed up budget and closing cycles, and ensure compliance with financialreporting standards. On-premise or cloud deployment Integration of SAP and non-SAP data Real-time access to data in SAP S/4HANA Hybrid deployment with SAP Analytics CloudFuture of BPC is for the consolidation in S/4HANA (group reporting) and for planning in SAC.PwC16

Did we answer your questions?Which technology to use? How to befuture proof?With Vora and Native HANA, you can access alltypes of data and manage them in a complete andscalable environment on premise or in the cloud.Cfr. SAP’s Statement of Direction.How to improve analytics experiencewithin the company?How to be more agile in analytics?How to improve the usage ofself service?PwCSource: SAP17

Did we answer your questions?Which technology to use? How to befuture proof?How to improve analytics experiencewithin the company?How to be more agile in analytics? How to improve the usage ofself service?PwCSource: SAP SAC offers easy integration and generation ofstories which facilitates the user experience andadoption.Pre-configured solutions in Leonardo (SCP) willenable users to improve and speed up their datadiscovery processes.18

Did we answer your questions?Which technology to use? How to befuture proof?How to improve analytics experiencewithin the company?How to be more agile in analytics? How to improve the usage ofself service?PwCSource: SAP No need to create info objects to quickly integrate newdata.No need to load data. Just create a new virtualisationlayer.19

Did we answer your questions?Which technology to use? How to befuture proof?How to improve analytics experiencewithin the company?How to be more agile in analytics?How to improve the usage ofself service?PwCSource: SAPSAC allows users to create their own stories and toimport their own data, to easily combine SAP andnon-SAP data.20

Did we answer your questions? Data tiering ensures the most efficient usageof the database capabilities.The virtualisation reduces the datastore .The cloud solutions are fully scalable.How to managedatabase growth?How to access/combinestructured and unstructured data?How to cover the needs of thevarious users types?How to ensure on time dataavailability and quality?PwCSource: SAP21

Did we answer your questions?How to managedatabase growth?Vora, Leonardo, Data Hub and Native HANA allowto access and transform all types of data.How to access/combinestructured and unstructured data?How to cover the needs of thevarious users types?How to ensure on time dataavailability and quality?PwCSource: SAP22

Did we answer your questions?DataintelligenceAnalyticsHow to managedatabase growth?Internet ofthingsBig dataBlockchainHow to access/combinestructured and unstructured data?MachinelearningHow to cover the needs of thevarious users types? SAC and/or BOBJ cover the operational andmanagerial needs as well as dashboarding.Leonardo covers the need of data scientists.BPC answers the need of planning and forecastingon premise.PwCSource: SAPHow to ensure on time dataavailability and quality?23

Did we answer your questions?How to managedatabase growth?How to access/combinestructured and unstructured data? BW/4HANA and DWH in the cloud are based onHANA technology, ensuring quick dataload.The new LSA data model contains less levelsof storage, so less data to load.Both solutions have a framework allowing fullmonitoring of the ETL solution.PwCSource: SAPHow to cover the needs of thevarious users types?How to ensure on time dataavailability and quality?24

SAP’s Statement of Direction (2019)PwCSource: SAP25

SAP’s Statement of Direction (2019)PwCSource: SAP26

SAP’s Statement of Direction (2019)PwCSource: SAP27

Journey to your tailored SAP Analytics solutionWhich data storage solution do I need? S/4HANA (embedded analytics) BW/4HANA Native HANA DWH in the cloud How do I migrate?

Journey to your BWBad news: it’s only a ToC. You’ll have to write it yourself!All journeys are differentPoint of departureRoad signs & road blocks Big vs. small system/organization Organizational constraints High vs. low data volume Organizational culture Long vs. short SAP history Budget High vs. low maturity of analytics Available time & urgencyDestination Cfr. Answers to your questions. Number of comfort stops On-going projectsPwC29

Journey to your BWGood news: You are not the first! Tools SAP Readiness Check SAP Transformation Navigator Experiences from otherprojects (lessons learned)PwC30

Journey to your BWWhich storage solution to choose?Existing BW systems?NoDo you have aDWH solution?YesNoYesLimited datavolume(max 20% with respectto ERP)?SAP as mainsource?NoPwCNoNoYes“Keep it”YesConsider embeddedanalytics in S/4HANAYesYesNoConsider DWH inthe cloudMainlyoperationalreports?Is it future proof?Consider BW/4HANAConsider embeddedBW in S/4HANAMore parameters have to be taken intoaccount. This decision tree only givesa high-level, conceptual overview ofhow the correct storage solution needsbe assessed.31

Journey to BW/4HANAHow to move?Greenfield versus brownfieldWhich tools for reportingand data analysis?PwCDo we need to associate themove to S/4HANA withBW/4HANA or vice versa?32

How to move?Greenfield versus brownfieldEach of you is in a specific situation. We want here to list some considerations prior to taking a decision.The way forward will depend on the weight factor you give to these different points. PwCWhich version of BW are you in?How many dataflows do you have in your current system?How optimised is your current system?Is the governance in place?How performant is your current system?Is the performance similar for all areas?How many reports do you have?What type of reports do you have?Do you have only one technology in place?Do you have on-going projects or are you in run and maintain status?How happy are the end users?33

How to move?Which reporting tools to use? Currently no conversion exists from BOBJ to SAC reports but BEx queries can be converted in HANA views. SAC is the platform of the future. It will integrate dashboarding, reporting, budget and analytics in one tool. No magic move but good preparation work is needed.SAC: pre-configured dashboard and defined storiesKPIsDashboardingStructured detail dataManagerial reportingRaw dataPwCSAC ReportingLeonardoSAC Reporting for structured dataLeonardo for unstructured data34

How to move?Couple S/4HANA move with BW/4HANA?CONsPROsPwC Full HANA landscape Optimize your full reportinglandscape (operational onS/4HANA and managerial onBW/4HANA) Optimised storage Full ODP connectivity Two big projects at the sametime Need of same businessresources Change reports andconnectivity at the same time35

How to move?Couple S/4HANA move with BW/4HANA? - Quick fix migrationSAP ERPOLTPSAP BWBPCOLAPETL1SAP S/4HANAETL2Quick fixOLTP & OLAP(embedded analytics)PwC36

How to move?Couple S/4HANA move with BW/4HANA? - Possible landscape AImport/exportHANA liveSAP BW 7.xETLVORASAP S/4HANASAP ERPData lakePwCIot, AI37

How to move?Next steps for you Define your timing to answer the questions Tackle the why! or why not! Discover your peers, who are (about to)go on S/4HANA Subscribe to quarterly follow-upweb sessions (invites will be sent) feel free to reach out for support!PwC38

PwC supporting your journeyOur service offeringsOur delivery frameworkOur project met

The SAP Business Planning and Consolidation (SAP BPC) application delivers planning, budgeting, forecasting, and financial consolidation capabilities, so you can easily adjust plans and forecasts, speed up budget and closing cycles, and ensure compliance with financial reporting standards. On-premise or cloud deployment Integration of SAP and non-SAP data Real-time access to data in SAP S .