Analyze SAP on Microsoft Azure and Advanced Analytics

Analyze SAP on Microsoft Azure and Advanced Analytics

Analyzing SAP on Microsoft Advanced Analytics Microsoft Global Black Belt Team (GBB) Jul 13 2018 1 A powerful new way to work with data Self-service business intelligence and analytics with Excel and the power of the cloud Collaborate in Power BI Analyze in Excel 1 Billion Office Users Discover Analyze 1 in 4 enterprise customers on Office 365 Visualize Share Question Mobility Q&A Scalable | Manageable | Trusted 2 Microsoft Analytics and Insights for SAP

Specialized Tools Spreadsheets 3 Connecting any user, in any business, anywhere, with their data Power BI Industry-leading SaaS service o 5 seconds to sign up, 5 minutes to WOW Large Power BI ecosystem o ISVs, SIs and partners creating unparalleled momentum Integrated across Microsoft products o Customers benefit from integration with other Microsoft products 4 Key benefits and differentiators of Power BI Pre-built dashboards and reports for popular SaaS solutions Real-time dashboard updates Secure, live connection to your data sources, on-premises and in the cloud Intuitive data exploration using natural language query Integrated with familiar Microsoft products and utilizes commitment for scale & availability in Azure Fast deployment, hybrid configuration, secure, and integrated with existing IT

systems. 5 Power BI Overview Data sources Power BI Power BI Service Cloud-based SaaS solutions e.g. Marketo, Salesforce, Quickbooks, Google Analytics, Content packs Natural language query Sharing & collaboration On-premises data e.g. Analysis Services, SQL Server Live dashboards Organizational content packs Corporate data sources or external data services Visualizations Azure services Azure SQL, Stream Analytics Reports

Excel and CSV files Workbook data, flat files Power BI Desktop files 01001 10101 Datasets Data from files, databases, Azure, and other sources Data refresh 6 Power BI Overview Power BI Power BI Service Data sources Cloud-based SaaS solutions e.g. Marketo, Salesforce, Quickbooks, Google Analytics, Content packs Natural language query Sharing & collaboration On-premises data e.g. Analysis Services, SQL Server Live dashboards

Organizational content packs Corporate data sources or external data services Visualizations Azure services Azure SQL, Stream Analytics Reports Excel and CSV files Workbook data, flat files 01001 10101 Power BI Desktop files Data from files, databases, Azure, and other sources Datasets Data refresh Power BI Desktop Prepare Explore Power BI Platform Report Share embed, extend, integrate 7

Power BI BI as a Service to Visualize HANA and BW HANA Calculation BW InfoCubes Report Designers can create reports/dashboards and publish to Cloud Views Mash up a variety of data sources e.g. HANA and BW Azure Active Directory Information Workers can securely access all reports/dashboards from a variety of devices BW HANA Analytic Views File Excel CSV XML Text JSON SharePoi nt Folder Database SQL Server

DirectQuer y for SQL Server Access SQL Server Analysis Services SAP HANA SAP Business Warehous e Oracle IBM DB2 MySQL PostgreSQL Sybase Teradata Azure SQL Database DirectQuer y for SQL Database SQL Data Warehouse Marketplac e HDInsight Blob Storage Table Storage HDInsight Spark Document DB

Data Lake Store BW MultiProviders Online Services MailChimp Salesforce Marketo appFigure QuickBooks s Online GitHub Smartsheet SparkPost SQL Sentry tyGraph Stripe Webtrends SweetIQ SharePoint Twilio Online Zendesk Exchange Spark Online Dynamics CRM Online Facebook Google Analytics Other Web SharePoint List OData Feed Hadoop

File (HDFS) Active Directory Microsoft Exchange ODBC R Script Blank Query 8 SAP HANA integration features https://powerbi.microsoft.com/en-us/blog/bring-your-sap-hana-data-to-life-with-microsoft-power-bi/ https://powerbi.microsoft.com/en-us/blog/power-bi-gateway-enterprise-now-supports-live-connections-to-analysis-services-and-sap-hana/ Specialized connector for SAP HANA ( using SAP ODBC driver) DSN less connection DirectQuery or Import options Support for HANA information models ( Analytic/Calc views) Direct SQL support for Row and Column Tables Optimized Navigation for HANA Models Improved Navigator experience (optional preview, column selection) Support for Variables and Input Parameters Direct Query performance optimizations 9 Information Views Feature

Calculation views used on top of analytic view and attribute views to perform complex calculations that cannot be achieved by the attribute or analytic views alone. Analytic views used for calculation and aggregation based on star schema or similar Attribute views used for all type of joins Calculatio n Views Analytic Views Transaction Table Master Table Attribute Views Master Table Master Table 10 Variables and Feature

Parameters Variables are bound to columns and are used for filtering based on user Input Parameters are used to take input from user , process it and return dynamic data 11 Analytics - Industry Dashboards 12 Simplements Close Partnership with Microsoft Gold BI Partner, Silver Application Development Partner Only software solution with Microsoft-published Case Studies for SAP scenarios Albany International Aerospace The Charles Machine Works Manufacturing Sysmex Health Sciences Managed from Microsoft headquarters

Winner, 2014 Innovation Award Joint Presentations with MSFT at SAPPHIRE and SQL PASS Recognized go to solution for SAP interoperability Committed to partnership with Paris MTC 13 How Does it Work? Real-Time data using log-based replication SQL Server, Oracle or DB2 SAP Sources Selective Replication Only the Tables you need KEY The Common Business View No logon to SAP Extremely low impact on source system. Much lower than ETL SAP-Aware tools and logic 14 Integrate without Intrusion in Real-Time Data Source Get Data / Prep Data Deploy Visualize 2 SAP Key: (R/3 or ECC) PSFT, BAAN 100% Real-Time

Excel WorkbooksReporting Services Loaded PowerPivot / Tabular / Cubes Slice & Dice, Explore Reporting Services Simplement (Data Liberator) Data Liberator Engine running in SQL Server 1 Database (SQL, ORA, or DB2) Find / Get / Explore / Secure/ Organize for Reporting Use Business Logic Fact Views SharePoint Scorecards Self-Serve Data Sets SSIS (to load PowerPivot / Tab Cubes) SharePoint Search

& Dashboards SSRS (Dashboards & Real -Time reports) 15 Simplement Customers from SAP R/3 3.1h to ECC 6 Quick Facts Software company specialized in SAP data uses and simplification; targeted optional services Enterprise grade solutions Global Distributor Network Team with multiple certifications: Sales and Distribution Finance and Controlling Production Planning CONFIDENTIAL NOT FOR DISTRIBUTION OS/DB Migration SAP NetWeaver Basis MSCE SQL Server 16 Thank You 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, 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, 17 17

IoT Device & Cloud Patterns Storage Virtual Machine Document DB Presentation & Business Connectivity Storage SQL DB SQL ServerSAP HANA RTOS, Linux, Windows, Android, iOS Devices Smart vending machines Cold Path Analysis Health monitoring Worker Roles Environmental sensors Protocol Field Adaptatio Gateway n New devices and sensors Field Gateway

HDInsight Spark Machine Learning Website Mobile App Hot Path Analysis Event Hub Air conditioning and temperature control Data Factory Cloud Gateway Device Connectivity & Management Stream Analytics HDInsight Spark/ Storm Analytics & Operationalized Insights Notification HubBizTalk Services

Presentation & Business Connectivity 18 IoT Device & Cloud Patterns 3rd Party & OSS View Storage Presentation & Business Connectivity Virtual Machine RTOS, Linux, Windows, Android, iOS Devices Smart vending machines Cold Path Analysis Health monitoring Worker Roles Environmental sensors Air conditioning and temperature control New devices and sensors Protocol Field

Adaptatio Gateway n Field Gateway Nitrogen.IO Kafka RabbitMQ GNattMQ HiveMQ ActiveMQ IBM MessageSig ht On Azure VMs/On Premises Hot Path Analysis Cloud Gateway Device Connectivity & Management Website Mobile App Notification HubBizTalk Services Analytics & Operationalized Insights Presentation & Business

Connectivity 19 Power BI Office 365 NetWeaver Gateway Office 365 Business Suite BW Powered SQL Server by HANA SAP Frontend and Fiori Excel Business Objects BI Tablet/Mobile/PC Devices 20 SAP and Big Data on Microsoft Intelligent Cloud Retail/Vendors Lab Plant Market Manufacturing Data Transactions Master recipe

data Market data SAP/HANA SAP Business Suite, BW, S/4 HANA, Gateway, SMP Big Data Azure HDInsight Hortonworks or Cloudera Azure Event Hub *** HANA, SQL Server, Any DB *** Azure Machine Learning Azure Data Lake, Blob Storage Fiori Smart Phone, Tablet, PC General Manager, Brand Manager, Finance .. Surface Hub, SAP Management

Cockpit 21 SAP and Non-SAP - Structured and Unstructured All in Microsoft Azure Active Directory User Experience / Edge Business Transactions SAP Fiori Microsoft Office Mobile, BOT SAP S/4HANA SAP Business Suite Azure Active Directory Data warehouse / Datamart Intelligent Edge Cloud Gateway SAP BW/4HANA Azure SQL DataWarehouse Azure HDInsight Azure Machine Learning SAP Leonardo

Azure IaaS / PaaS SCP on Azure Azure IaaS HEC on Azure Azure IaaS / DBaaS HEC / SCP on Azure Advanced Analytics Microsoft Power BI Microsoft Surface Hub SAP BusinessObjects Azure BIaaS, IaaS 22

Recently Viewed Presentations