Real-time verification of payment practices and limiting the level of outstanding transactions are only a few of the processes which can be enhanced with the help of PowerDive application.
During the 3-day workshop we will implement a Proof of Concept of PowerDive - Preventing Payment Gridlock solution to help successfully manage your internal payment practices. You will also learn how to leverage Power Platform capabilities in order to:
• Calculate most critical financial KPIs and analyse their trend over time,
• Investigate the root causes of anomalies using drill down and drill through functionalities to a level of a single transaction line,
• Perform real-time identification and analysis of invoices at risk of late payment,
• Reduce invoice backlog through categorization of suppliers by their number and quality of invoices issued.
Workshop’s agenda:
DAY 1
1. Introduction: Get to know KPMG Data Intelligence Solutions, our experience and the team. (estimated time: 0.5h)
2. Presentation of the PowerDive - Preventing Payment Gridlock tool (3h):
• How it can benefit organization’s internal payment practices,
• BI reporting as a response to new regulatory requirements,
• Overview of the tool’s KPIs and metrics, their role in monitoring effectiveness of invoice processing,
• Demo and presentation of core Power BI functionalities.
3. Enhancing finance processes through automation – real life scenarios leveraging Power Platform capabilities (3h):
• Budgeting,
• Dunning process,
• Internal communication tools.
4. How to get started with Power Platform: flexible licensing schemes and cost estimation (1h)
5. QA Session (0.5h)
DAY 2 & 3
Implementation of a Proof of Concept from PowerDive - Preventing Payment Gridlock solution (16h):
• Preparation of the data sources (flat files and file exports from internal ERP systems),
• Extract, Transform, Load (ETL) steps, introduction to the Common Data Model
• Presentation of the finished report in the Power BI Service
• Mobile functionalities: presentation of the report on portable devices.