Sales analytics
Businesses capture lots of data during daily activities that supports business intelligence (BI) for sales managers:
- Opportunities
- Sales quotes
- Sales orders
- Sales invoices
Business Central provides features to help you gather, analyze, and share your organization's sales data:
- Ad-hoc analysis on lists
- Ad-hoc analysis of data in Excel (using Open in Excel)
- Built-in sales analytics tools
- Built-in sales reports
Each of these features has its advantages and disadvantages, depending on the type of data analysis and the role of the user. To learn more, go to Analytics, business intelligence, and reporting overview.
This article introduces how you can use these analytical features to gain sales insights.
Analytics needs in sales
When you think about the analytics needs in sales management, it might help to use a persona-based model that describes different analytics needs at a high-level.
People in different roles have different needs when it comes to data, and they use the data in different ways. For example, people in asset management and finance interact with data differently than people in sales.
| Role | Data aggregation | Typical ways to consume data |
|---|---|---|
| CCO / CFO / CEO | Performance data | KPIs Dashboards Financial reports |
| Sales Manager | Trends, summaries | Built-in managerial reports Ad-hoc analysis |
| Account Manager / Sales Person | Detailed data | Built-in operational reports On-screen task data |
Using Power BI to monitor sales KPIs
A key performance indicator (KPI) is a measurable value that shows how effectively you’re meeting your goals. In sales, people often use the following KPIs to monitor their sales organization's performance:
- Gross Profit
- Gross Profit Margin
- Sales by period
- Sales vs. budget
- Number of new customers
- Period-over-Period Sales Amount Growth
- Sales by item/customer/location/sales person
These sales KPIs, and more, are available in the Power BI Sales app for Business Central. To learn more, go to Power BI sales app.
The following table describes the reports in the Power BI Sales app and how you can use them.
| To... | Open in Business Central (CTRL+select) | Learn more |
|---|---|---|
| Analyze high level information on sales activities. Identify sales figures for quantity or amounts from both posted and unposted documents. | [Sales Overview](../ https://businesscentral.dynamics.com?page=36998) | About Sales Overview |
| Analyze sales by weekday over different periods. The heat maps highlight the days on which you sell the most, which helps you identify patterns in your sales. | Daily Sales | About Daily Sales |
| Analyze sales trends by smoothing out spikes and drops using the 30 Day Moving Averages report. | Moving Average | About Moving Average |
| Analyze the aggregated sales over a rolling 12-month period. Use this analysis as an alternative to a Year-to-Date report. | Moving Annual Total | About Moving Annual Total |
| Compare sales in one period with the same period in a prior year, quarter, or month. | Period-Over-Period Growth | About Period-Over-Period Growth |
| Analyze accumulating sales for a desired period. | Month-To-Date | About Month-To-Date |
| Analyze sales by item and view key sales metrics as a percentage of total sales. | Sales by Item | About Sales by Item |
| Analyze sales by customer and view key metrics. Metrics include sales amount, sales quantity, cost amount, gross profit, gross profit margin, and the sales amount as a percent of total sales. | Sales by Customer | About Sales by Customer |
| Analyze sales by salesperson and view key metrics. Metrics include sales amount, sales quantity, cost amount, gross profit, gross profit margin, and the sales amount as a percent of total sales. | Sales by Salesperson | About Sales by Salesperson |
| Analyze sales by location and view key metrics. Metrics include sales amount, sales quantity, cost amount, gross profit, gross profit margin, and the sales amount as a percent of total sales. | Sales by Location | About Sales by Location |
| Analyze item sales budgets against actual sales. View target variances for both sales amounts and sales quantity. | Actual vs. Budget | About Actual vs. Budget |
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.
Use financial reporting to produce financial statements and KPIs related to sales
The Financial Reporting feature gives you insights into the financial data shown on your chart of accounts (COA). You can set up financial reports to analyze figures in general ledger (G/L) accounts, and compare general ledger entries with budget entries. Specifically for sales management, you can set up financial reports on the general ledger (G/L) accounts that you use to track sales postings.
Dimensions play an important role in business intelligence. A dimension is data that you add to an entry as a parameter. Dimensions let you group entries that have similar characteristics, such as customers, regions, products, and salesperson. Among other purposes, use dimensions when you define analysis views and create financial reports. To learn more, go to Work with Dimensions.
To learn more about financial reports, go to Prepare Financial Reports with Financial Data and Account Categories.
Finance reporting across business units or legal entities related to sales
Some organizations use Business Central in multiple business units or legal entities. Others use Business Central in subsidiaries that report to parent organizations. Business Central gives accountants tools that help them transfer general ledger entries from two or more companies (subsidiaries) into a consolidated company. Specifically for sales management, you might want to consolidate general ledger entries for your sales accounts to be able to track sales KPIs across business units or legal entities.
To learn more, go to Company consolidation.
Ad-hoc analysis of sales data
Sometimes, you just need to check whether the numbers add up correctly, or quickly confirm a figure. The following features are great for ad-hoc analyses:
- Data analysis on ledger list pages
- Open in Excel
The Data Analysis feature lets you open almost any list page, such as General Ledger Entries, Customer Ledger Entries, Item Ledger Entries, or Posted Invoices, enter analysis mode, and then group, filter, and pivot data as you see fit.
Similarly, you can use the Open in Excel action to open a list page, optionally filter the list to a subset of the data, and then use Excel to work with the data. For example, by using features such as Analyze Data, What-If Analysis, or Forecast Sheet.
Tip
If you configure OneDrive for system features, the Excel workbook opens in your browser.
To learn more about how to do ad-hoc analysis on sales data, go to Ad hoc analysis of sales data.
Built-in reports for sales
Business Central includes several built-in reports, tracing functions, and tools to help sales organizations report on their data.
To get an overview of available reports, choose All reports on the top pane of your Home page. This action opens the Role Explorer, which is filtered to the features in the Report & Analysis option. To learn more, go to Finding Reports with the Role Explorer.
The built-in reports come in two flavors:
- Designed for print (pdf).
- Designed for analysis in Excel.
To learn more about reports that are relevant for sales, go to Built-in sales reports.
On-screen sales analytics
Business Central has several pages that give you sales overviews and tasks to do. Here are some examples to get you started:
- Open the Sales Quotes list
- Open the Sales Orders list
- Open the Posted Sales Invoices list
- Open the Sales Return Orders list
- Calculate order promising dates
- Calculate delivery dates for sales orders
- Track packages
- View the Availability of Items
- Blanket sales order status
- View unposted and posted blanket sales order lines
Show sales-related general ledger entries and balances from the Chart of Accounts page
The Chart of Accounts page shows all general ledger accounts with aggregated numbers posted to the general ledger. From this page, you can do things like:
- View reports that show general ledger entries and balances.
- Review a list of posting groups for that account.
- View separate debit and credit balances for a single account.
Specifically for sales, you can create a view that only shows the accounts you use for posting sales entries.
To learn more, go to Understand the Chart of Accounts.
Analyze data by dimensions (related to sales)
Dimensions are values that categorize entries so you can track and analyze them on documents, such as sales orders. Dimensions can, for example, indicate the project or department an entry came from.
So, instead of setting up separate general ledger accounts for each department or location, you can use dimensions as a basis for analysis and avoid having to create a complicated chart of accounts structure.
To learn more, go to Analyze Data by Dimensions.
See also
Company consolidation
Power BI sales app
Prepare Financial Reports with Financial Data and Account Categories
Handling finance reporting across business units or legal entities
Ad hoc analysis of sales data
Built-in sales reports
Understand the Chart of Accounts
Analyze Data by Dimensions
Analytics, business intelligence, and reporting overview
Work with Business Central