Daily Sales (Power BI Report)

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

The Daily Sales report gives a clear picture of your organization's sales activities over specific days. The report can showcase which days have a higher volume of sales. You can also view variations across different years, quarters, or months to identify trends over time.

Screenshot of the Daily Sales Power BI report

Use the report

This report helps executives and managers track daily sales metrics.

Executives can use the report to identify high performing days and ensure you're staying on track on a daily basis. For example, this analysis can help you make informed decisions in regards to staffing allocations per day.

As a sales manager, this report helps you identify which days are high performing and compare them against your sales people.

Key performance indicators

The report includes the following key performance indicators (KPI) and measures:

Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Data used in the report

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

  • Value Entry
  • Sales Line
  • Item

Try the report

Try the report here: Report name

Tip

If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.

See also

Track your business KPIs with Power BI metrics
Ad hoc analysis of sales data
Built-in sales reports
Sales analytics overview
Sales overview

Find free e-learning modules for Business Central here