What's New: Enhanced Power BI for Purchasing (2025 release wave 2)

Overview

The video walks through the updated Power BI app for purchasing, aimed at procurement managers who need to forecast procurement needs, analyze supplier quality and look at supply chain risk. It cites that 31% of customers said supply chain disruptions have affected their business.

The demo goes through the app page by page: purchase quantity by location, purchases by item category, Pareto analysis and vendor map, purchases by purchaser and warehouse, returns, quotes, key purchase influencers, vendor quality (single supplier risk) and forecasting. It closes with a landing page, documentation and community resources, and notes that the app code is being open sourced.

Key points

• The purchasing app has four new report pages and four updated pages. Update or install the app to get them.
• The purchases overview shows purchase quantity by location, including posted invoices and return orders, so warehouses with many returns stand out.
• Pareto analysis for vendors shows what share of purchase value comes from the top vendors, for example 80% from three vendors, which shows concentration risk.
• A world map of vendor locations shows geographic concentration. Purchases by purchaser can flag single purchaser risk.
• The vendor quality analysis report shows items with only one vendor, with the financial exposure for each item.
• Purchase returns by reason code (damages, defects, warranty) and the purchase quote overview show quality risk and unusual quoting behavior.
• Key purchase influencers is an AI-driven report with influencer and segmentation views for each document type, matching key sales influencers.

Features

Quotes

• 0:16 “31% of customers stated that supply chain disruptions have impacted their business”
• 0:55 “with the updated PowerBI app for purchasing, we are trying to help you as a procurement manager to uh forecast future uh procurement needs”
• 1:45 “we are also open sourcing the everything uh all the code for the PowerBI app for purchasing”
• 4:35 “80% of the value I buy across all vendors is supplied by vendor 1, two and three. that means that my like risk exposure”
• 6:17 “Maybe there’s a single purchaser risk in this company because we have some people working in procurement and then we have Jim”
• 10:39 “The next report also new is a symmetry for what we did for sales last semester. These are key purchase influencers.”
• 12:25 “This is one of my also one of my favorite new reports in the release. Uh here you have the single supplier risk on”
• 13:21 “Those with only one vendors mean that you are like you have to make sure that that particular one vendor can supply or can”
• 14:43 “The forecasting here is a classical data mining or machine learning. It is AI but it is old school AI. It’s a statistical model”
• 14:43 “The forecasting here is a classical data mining or machine learning. It is AI but it is old school AI.”
• 15:00 “We have chosen I think 3 months of the future to be predicted. We have chosen to show up or lower bounds.”
• 15:27 “You can change those seasonality settings and everything related to the forecast visual here by editing the the report and and kind of change”
• 16:35 “We have four new report pages, four updated pages in the purchasing app. Purchasing app was the one thing that got the most love”
• 17:04 “There’s a PowerBI um landing page for purchasing analytics and that landing page you can reach to from aka.ms/bc purchasing analytics.”