Year-Over-Year (Power BI Report)

APPLIES TO: Generally available in Business Central 2024 release wave 2 (version 25.1).

The Year-Over-Year report helps business leaders analyze purchasing performance and track spending trends over time. By comparing purchase amounts in the current year with amounts from the previous year, this report provides valuable insights into the efficiency and effectiveness of purchasing activities.

In addition to identifying trends and changes, the report helps leaders make informed decisions about future purchasing strategies. It's an important indicator of growth and spending patterns, providing an overview of the money you spend to make products and generate revenues.

Together with year-over-year financial figures, the report gives a comprehensive view of an organization's financial health. Tracking these figures helps leaders make informed decisions about resource allocation, budgeting, and forecasting.

Use the report

The report is intended for business leaders and managers.

COOs ensure that the purchasing department operates efficiently and effectively. One of the key metrics you monitor is the year-over-year growth in purchases. This report lets you quickly explore purchase trends over time, and identify areas of concern. For example, you might notice that purchases are increasing rapidly in a particular item category. You can use this information to discuss how to manage costs with the head of purchasing.

Purchasing managers ensure that the company sources goods at the best price without compromising quality. Use this report to track purchasing trends across different categories and identify areas where you can save. For example, you might notice a rapid increase in purchases of a category of products. With this information in mind, you can work with the manufacturing team to identify whether to change item planning or supplier selection to optimize product cost and quality.

Data used in the report

The report uses data from the following tables in Business Central:

• Value Entry
• Purchase Line
• Item
• Item Category

Try the report

Try the report here: Year-Over-Year

See also

Track KPIs with Power BI metrics
Power BI Purchasing app
Ad hoc analysis of purchasing data
Built-in purchasing reports
Purchasing analytics overview
Purchasing overview