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
Contour plowing: soil is plowed in curved rows that follow the shape of the land. This decreases wind and water damage to the land. Farmers keep soil in place by planting cover crops. ... Types Of Soil & particles Last...
SE PROP JAWA TENGAH DAN DI YOGYAKARTA ... Snowball Throwing Role Playing Coopertive Script Demontration Examples Non Examples Picture And Picture Namberet Heads Together Kepala Bernomor Struktor Jigsaw Problem Based Introduction (PBI) Artikulasi Mind Mapping Make - A- Match Think...
Bearing will have a press fit into the housing and a clearance fit to the shaft. No moving parts. Also called sleeve bearings, journal bearings and bushings. Plain bearing materials. Bronze-needs to be lubricated. Phosphor bronze-oil impregnated.
What's covered vs what's best for the individual? Increase in high deductible health plans . Combined medical and pharmacy deductibles. Shifts from flat co-pay to co-insurance. More health costs shifting to PWD - without distinguishing essential vs discretionary care. As...
The City of Vancouver and the Corporation of Delta are participants in Partners for Climate Change (PCP). LFG control and beneficial use is part of Vancouver's commitment to reduce corporate and community greenhouse gas emissions as envisioned in the PCP...
Arial Times New Roman Garamond Wingdings Custom Design ERL Differential Current System Status Peter Cameron with contributions from Michelle Wilinski and Christophe DeFrance (Bergoz) 17 Sep 07 Slide 2 Slide 3 Slide 4 Slide 5 Slide 6 Slide 7 Slide...
Ready to download the document? Go ahead and hit continue!