Contoso Retail processes and distributes food to supermarkets and other small-to-medium sized companies. Generous credit terms based on relationships instead of data analytics has put the company in financial difficulty. They have challenges identifying customers’ payment behaviors and notifying customers when they are behind on invoice payments. The accounting department uses manual processes to identify delinquent accounts making the accounts receivable (AR) management time consuming. Also, lenders and have capped CFD’s line of credit and increased the interest rate until they can lower their AR balance and be able to predict near term future cash flow.
June 2023
- SAP Specialists
- SAP Global Black Belts
- Azure Specialists
- App Specialists
- Data and AI Specialists
In this workshop, you will learn how to architect an extendable deployment of SAP on Azure. Throughout the whiteboard design session, you will look at the planning process for ingesting data from SAP and non-SAP sources. You will determine how to integrate data and AI solutions to present data and identify trends that can be presented to executives from the SAP HANA database.
At the end of workshop, you will have the knowledge necessary to build a data pipeline that will ingest SAP and Cosmos DB data into a common data warehouse. You will be able analyze AR and sales data to deliver a 360-degree view of customers’ accounts.
The primary goal for this system is to extract SAP data into a single dashboard for use in self-service reporting.
In this whiteboard design session, you will learn how to design a solution to allow customers to pull data from multiple data sources, provide analytics, and automate repetitive tasks.
Continue to the Whiteboard design session documents folder.
In this hands-on lab you will extract (historical) Sales Orders from SAP S/4 HANA and historical payments from a non-SAP system, in this case Cosmos DB using Azure Synapse Analytics pipelines. You will visualize the extracted Sales Orders and invoice data with Power BI. Next, you will unleash the power of data using Azure Machine Learning to train a model to predict incoming cash flow. You will learn to implement dashboards and alerting using Power BI and Power Automate. Finally, you will add the ability to update data in SAP based on insights gained from the prediction model.
Continue to the Hands-on lab documents folder.
- SAP HANA
- Data transformation and engineering
- Power BI
- Power Automate
- Machine Learning
- Azure Automated ML
- Azure Synapse Analytics
- MCW
- Power BI
- Power Automate
- Azure Synapse Analytics
- SAP on Azure
- Azure Cloud Adoption Framework
- Azure Well-architected Framework
- Azure Migration Program - AMP
We welcome feedback and comments from Microsoft SMEs & learning partners who deliver MCWs.
Having trouble?
- Please submit an issue with a detailed description of the problem.
- Do not submit pull requests. Our content authors will make all changes and submit pull requests for approval.
If you are planning to present a workshop, review and test the materials early! We recommend at least two weeks prior.