Sparkrock 365 logo
Sparkrock 365 logo
All Rights Reserved | Sparkrock © 2025

Search Results for

    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:

    • Sales Quantity
    • Sales Amount
    • Cost Amount
    • Gross Profit
    • Gross Profit Margin

    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

    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

    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

    All Rights Reserved | Sparkrock © 2025