Procurement and Spend Analytics

Introduction
In today’s data-driven landscape, leveraging financial analytics stands as a cornerstone for informed decision-making and strategic planning. As part of our initiative, we’ve implemented robust Procurement and Spend analytics using Microsoft Fabric, harnessing data from Oracle EBS (E-Business Suite) to empower businesses with actionable insights in Power BI.
Understanding Procurement and Spend Analytics
Procurement and spend analytics involve the systematic analysis of an organization’s purchasing and expenditure data to extract valuable insights, including Procurement Overall, which provides a comprehensive view of procurement activities and identifies efficiency improvements and cost reductions; Approval History for Purchase Orders and Purchase Requisitions, which tracks approval processes and identifies bottlenecks to streamline workflows; Invoice Spend Data, which details spending based on invoices to manage cash flow and negotiate better terms with suppliers; and Spending Snapshot, which offers a quick overview of current spending to make informed budget decisions and identify cost-saving opportunities.
Key Components of Our Solution
Data Sourcing from Oracle EBS: We’ve successfully extracted and processed crucial procurement data from Oracle E-Business Suite, ensuring accuracy and reliability.
Cloud-based Data Storage and Processing: Leveraging Microsoft Fabric’s scalable infrastructure, we’ve stored raw data in Azure Blob Storage and efficiently processed extensive volumes of procurement data. This provides us with a comprehensive data pipeline solution for ingesting, transforming, processing, scheduling, and delivering data into the Fabric Warehouse..
Analytics and Visualization: We have leveraged Power BI, now a part of the Microsoft Fabric family, to translate complex data into actionable insights.
Self Service: Extensive Power BI semantic layers and data models are built to facilitate self-service for users by ensuring all the required fields are available in the semantic model.
Security: Robust security setup controls the authentication and authorization, to ensure only authorized users can access the tool and the data.
Microsoft Fabric Reference Architecture

Data from the Oracle EBS are initially ingested into Azure Storage Blob. Following this, the data undergoes a series of transformations: first into the Bronze layer via copy activity in the data pipeline, then into the Silver layer schema, which is built on Fabric Warehouse and data is populated through the Dynamic stored procedure. The data is further cleansed and transformed to meet business requirements in the Gold layer, facilitated by Warehouse Stored Procedures. This project is based on Medallion architecture which is implemented using the Microsoft Fabric Warehouse.
This workflow, encompassing Bronze, Silver, and Gold layer scripts, runs automatically on a daily basis using Data pipeline schedules. Throughout this process, data is denormalized according to predefined data models and adheres to naming standards and conventions. Finally, Power BI accesses the Gold layer for reporting purposes, ensuring alignment with business needs.