---
id: video/rAaUiKByyEE
type: video
title: "What's New: Sales Analytics (2025 release wave 2)"
summary: "Sales analytics changes in Business Central 2025 release wave 2: updated PowerBI app for sales with a forecasting report, support for resource and G/L account sales, an open source PBIX, a Sales by project report, and seven analytical reports modernized with Word and Excel layouts (four deprecated)."
tier: official
language: en
tags:
  - sales forecasting
  - powerbi app
  - analytical reports
  - excel layouts
  - open source
  - sales by project
  - data analysis
  - help documentation
  - interactive reporting
system: sales
review:
  state: reviewed
  by: opus
  at: "2026-10-07T22:54:07.198Z"
  flags: []
generated:
  at: "2026-10-07T22:54:07.243Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 5ca7bca4e3be84fc4a6172396c7dccc2b5e8752838607eb54c4d06a70ecc3c0c
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=rAaUiKByyEE&t=83s
    title: "What's New: Sales Analytics (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 83
    quote: In this wave, we are completing the modernization of existing reports in Business Central and also updating the PowerBI app
  - kind: video
    url: https://www.youtube.com/watch?v=rAaUiKByyEE&t=132s
    title: "What's New: Sales Analytics (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 132
    quote: updating the data model and reports uh with other types of sales than selling items. So you can also in business central sell gines
  - kind: video
    url: https://www.youtube.com/watch?v=rAaUiKByyEE&t=144s
    title: "What's New: Sales Analytics (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 144
    quote: we have uh made the the model and the reports in a quality where we believe now we can open source this.
  - kind: video
    url: https://www.youtube.com/watch?v=rAaUiKByyEE&t=182s
    title: "What's New: Sales Analytics (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 182
    quote: This is a statistical model. This is AI but like classic AI or machine learning. Um so not generative AI.
  - kind: video
    url: https://www.youtube.com/watch?v=rAaUiKByyEE&t=415s
    title: "What's New: Sales Analytics (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 415
    quote: Note that this only works in the version 27 in the one we release here in October. Doesn't work for sales for the sales
  - kind: video
    url: https://www.youtube.com/watch?v=rAaUiKByyEE&t=510s
    title: "What's New: Sales Analytics (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 510
    quote: now you actually have a fully interactive way of analyzing that report data set.
  - kind: video
    url: https://www.youtube.com/watch?v=rAaUiKByyEE&t=614s
    title: "What's New: Sales Analytics (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 614
    quote: We reuse those descriptions both in a new advanced tellme and also in uh in the co-pilot chat.
  - kind: video
    url: https://www.youtube.com/watch?v=rAaUiKByyEE&t=652s
    title: "What's New: Sales Analytics (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 652
    quote: We actually modernized all the analytical reports uh that exist in business central updating I think it's seven of those and deprecating four.
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: rAaUiKByyEE
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=rAaUiKByyEE
published_at: "2025-10-01T00:00:00Z"
duration_s: 866
captions: full
audience:
  - functional consultant
  - developer
  - administrator
  - partner
chapters:
  - t: 0
    title: Introduction and business priorities
  - t: 83
    title: Wave 2 sales analytics achievements
  - t: 159
    title: PowerBI sales forecasting demo
  - t: 337
    title: Sales by project report and open source
  - t: 415
    title: Modernized analytical reports and layouts
  - t: 586
    title: In-client help and documentation improvements
  - t: 696
    title: Resources and closing remarks
features:
  - name: Updated PowerBI app for sales
    status: unclear
    t: 83
    verified: false
    status_source: video
  - name: Sales forecasting in PowerBI
    status: unclear
    t: 172
    verified: false
    status_source: video
  - name: Support for non-item sales types
    status: unclear
    t: 132
    verified: false
    status_source: video
  - name: Open source PowerBI sales app
    status: unclear
    t: 403
    verified: false
    status_source: video
  - name: Sales by project report
    status: unclear
    t: 351
    verified: false
    status_source: video
  - name: Excel layouts for analytical reports
    status: unclear
    t: 441
    verified: false
    status_source: video
  - name: Word layouts for analytical reports
    status: unclear
    t: 441
    verified: false
    status_source: video
  - name: In-client teaching tips for reports
    status: unclear
    t: 586
    verified: false
    status_source: video
  - name: Tell me and Copilot integration for reports
    status: unclear
    t: 600
    verified: false
    status_source: video
  - name: Modernized analytical reports
    status: unclear
    t: 441
    verified: false
    status_source: video
  - name: Customer item sales report
    status: unclear
    t: 482
    verified: false
    status_source: video
objects_mentioned:
  - report sales forecasting
  - report sales by project
  - report customer item sales report
quotes:
  - t: 83
    text: In this wave, we are completing the modernization of existing reports in Business Central and also updating the PowerBI app
    check: exact
  - t: 132
    text: updating the data model and reports uh with other types of sales than selling items. So you can also in business central sell gines
    check: exact
  - t: 144
    text: we have uh made the the model and the reports in a quality where we believe now we can open source this.
    check: exact
  - t: 182
    text: This is a statistical model. This is AI but like classic AI or machine learning. Um so not generative AI.
    check: exact
  - t: 415
    text: Note that this only works in the version 27 in the one we release here in October. Doesn't work for sales for the sales
    check: exact
  - t: 510
    text: now you actually have a fully interactive way of analyzing that report data set.
    check: exact
  - t: 614
    text: We reuse those descriptions both in a new advanced tellme and also in uh in the co-pilot chat.
    check: exact
  - t: 652
    text: We actually modernized all the analytical reports uh that exist in business central updating I think it's seven of those and deprecating four.
    check: exact
---

# What's New: Sales Analytics (2025 release wave 2)

> Sales analytics changes in Business Central 2025 release wave 2: updated PowerBI app for sales with a forecasting report, support for resource and G/L account sales, an open source PBIX, a Sales by project report, and seven analytical reports modernized with Word and Excel layouts (four deprecated).

[Watch on YouTube](https://www.youtube.com/watch?v=rAaUiKByyEE) · Microsoft Dynamics 365 Business Central (YouTube) · 2025-10-01 · 14:26 · tier official · reviewed (checked by Opus)

## Overview

The session covers the completion of the analytical report modernization in Business Central and an updated PowerBI app for sales. The PowerBI data model and reports now cover sales of resources and G/L account lines as well as items, which matters for project-based sales. A forecasting report uses a statistical machine learning model, not generative AI, on historical transactions. It has parameters for seasonality, look-back period and confidence bounds that are set manually in the report visuals.

The PowerBI app for sales is now open source, so the PBIX file with report visuals and semantic models can be downloaded and customized. This only works with version 27 released in October, not with earlier versions of the app. A new Sales by project report is shown. Analytical reports gain Word layouts for printing and Excel layouts for interactive analysis, with the Customer item sales report as the example. Teaching tips and descriptions are added, and the descriptions are reused in Tell me and Copilot chat. Seven reports were updated and four legacy reports deprecated.

## Key points

- The PowerBI app for sales now supports selling resources and G/L account lines in addition to items, relevant for project sales.
- Sales forecasting in PowerBI is a statistical machine learning model, not generative AI. Seasonality, look-back period and confidence bounds are configured manually in the report visuals.
- The PowerBI app for sales is open source: the PBIX file can be downloaded and customized. It works only with version 27 released in October, not previous app versions.
- A new Sales by project report shows sales from projects, including resources and G/L account lines sold within project scope.
- Analytical reports now have Word layouts for printing and Excel layouts with multiple worksheets and pivot analysis, shown with the Customer item sales report.
- Seven analytical reports were updated and four legacy reports deprecated. Their function is covered by data analysis or the PowerBI app for sales.
- Report descriptions and teaching tips appear in the help pane and are reused in Tell me and Copilot chat.

## Chapters

- [0:00](https://www.youtube.com/watch?v=rAaUiKByyEE&t=0s) Introduction and business priorities
- [1:23](https://www.youtube.com/watch?v=rAaUiKByyEE&t=83s) Wave 2 sales analytics achievements
- [2:39](https://www.youtube.com/watch?v=rAaUiKByyEE&t=159s) PowerBI sales forecasting demo
- [5:37](https://www.youtube.com/watch?v=rAaUiKByyEE&t=337s) Sales by project report and open source
- [6:55](https://www.youtube.com/watch?v=rAaUiKByyEE&t=415s) Modernized analytical reports and layouts
- [9:46](https://www.youtube.com/watch?v=rAaUiKByyEE&t=586s) In-client help and documentation improvements
- [11:36](https://www.youtube.com/watch?v=rAaUiKByyEE&t=696s) Resources and closing remarks

## Features

| Feature | Status | At |
|---|---|---|
| Updated PowerBI app for sales | status not stated, demoed | [1:23](https://www.youtube.com/watch?v=rAaUiKByyEE&t=83s) |
| Sales forecasting in PowerBI | status not stated, demoed | [2:52](https://www.youtube.com/watch?v=rAaUiKByyEE&t=172s) |
| Support for non-item sales types | status not stated, demoed | [2:12](https://www.youtube.com/watch?v=rAaUiKByyEE&t=132s) |
| Open source PowerBI sales app | status not stated, demoed | [6:43](https://www.youtube.com/watch?v=rAaUiKByyEE&t=403s) |
| Sales by project report | status not stated, demoed | [5:51](https://www.youtube.com/watch?v=rAaUiKByyEE&t=351s) |
| Excel layouts for analytical reports | status not stated, demoed | [7:21](https://www.youtube.com/watch?v=rAaUiKByyEE&t=441s) |
| Word layouts for analytical reports | status not stated, demoed | [7:21](https://www.youtube.com/watch?v=rAaUiKByyEE&t=441s) |
| In-client teaching tips for reports | status not stated, demoed | [9:46](https://www.youtube.com/watch?v=rAaUiKByyEE&t=586s) |
| Tell me and Copilot integration for reports | status not stated | [10:00](https://www.youtube.com/watch?v=rAaUiKByyEE&t=600s) |
| Modernized analytical reports | status not stated, demoed | [7:21](https://www.youtube.com/watch?v=rAaUiKByyEE&t=441s) |
| Customer item sales report | status not stated, demoed | [8:02](https://www.youtube.com/watch?v=rAaUiKByyEE&t=482s) |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- report "sales forecasting" at [2:52](https://www.youtube.com/watch?v=rAaUiKByyEE&t=172s)
- report "sales by project" at [5:51](https://www.youtube.com/watch?v=rAaUiKByyEE&t=351s)
- report "customer item sales report" at [8:02](https://www.youtube.com/watch?v=rAaUiKByyEE&t=482s)

Not found in BC28-30: report "sales forecasting", report "sales by project", report "customer item sales report".

## Quotes

- [1:23](https://www.youtube.com/watch?v=rAaUiKByyEE&t=83s) "In this wave, we are completing the modernization of existing reports in Business Central and also updating the PowerBI app"
- [2:12](https://www.youtube.com/watch?v=rAaUiKByyEE&t=132s) "updating the data model and reports uh with other types of sales than selling items. So you can also in business central sell gines"
- [2:24](https://www.youtube.com/watch?v=rAaUiKByyEE&t=144s) "we have uh made the the model and the reports in a quality where we believe now we can open source this."
- [3:02](https://www.youtube.com/watch?v=rAaUiKByyEE&t=182s) "This is a statistical model. This is AI but like classic AI or machine learning. Um so not generative AI."
- [6:55](https://www.youtube.com/watch?v=rAaUiKByyEE&t=415s) "Note that this only works in the version 27 in the one we release here in October. Doesn't work for sales for the sales"
- [8:30](https://www.youtube.com/watch?v=rAaUiKByyEE&t=510s) "now you actually have a fully interactive way of analyzing that report data set."
- [10:14](https://www.youtube.com/watch?v=rAaUiKByyEE&t=614s) "We reuse those descriptions both in a new advanced tellme and also in uh in the co-pilot chat."
- [10:52](https://www.youtube.com/watch?v=rAaUiKByyEE&t=652s) "We actually modernized all the analytical reports uh that exist in business central updating I think it's seven of those and deprecating four."

## Disclaimers in the video

- [6:55](https://www.youtube.com/watch?v=rAaUiKByyEE&t=415s) not-in-this-release: this only works in the version 27 in the one we release here in October. Doesn't work for sales for the sales app for previous versions
- [11:08](https://www.youtube.com/watch?v=rAaUiKByyEE&t=668s) subject-to-change: These four reports are no longer needed. They are covered in other places of the product either with data analysis and or with a PowerBI app for sales.

Presenters (as heard): Unknown presenter.