Redaguoti

Bendrinti naudojant


Analytics, business intelligence, and reporting overview

Small and mid-sized companies rely on built-in analytics and reporting capabilities they can use out-of-the-box to help keep track of their business. Business Central provides reports and analytics tools that cover basic and complex business processes for such organizations. You can also do ad-hoc analyses directly from your home page.

Analytics needs in organizations

When you think about analytics needs in organizations, it might help to use a mental model based on personas described on a high-level, and their different analytics needs.

Illustration of different personas for analytics

The model is based on the fact that different roles in an organization have different needs when it comes to data. The higher a role is placed in the organizational chart, the more aggregated data someone in the role needs to do their work.

Roles often have preferred ways to consume and analyze data, ways that reflect the level of data aggregation they need.

Illustration of how different personas have different analytics needs.

Use the following sections to learn more about ways to consume data from Business Central:

  • Financial Reports
  • KPIs and dashboards
  • Ad-hoc analysis
  • Reports

Using Financial Reports to produce financial statements and KPIs

The Financial Reports feature gives you insight into the financial data stored in 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.

Screenshot of a financial report.

Dimensions play an important role in business intelligence. A dimension is data that you can add to an entry as a parameter. Dimensions let you group entries that have similar characteristics. For example, groups of customers, regions, products, and salesperson. Groups make it easier to retrieve data for analysis. Among other purposes, you use dimensions when you define analysis views and create financial reports. Learn more at Work with Dimensions.

To learn more about financial statements and KPIs, go to Using Financial reporting to produce financial statements and KPIs.

Using key performance indicators to meet your business goals

A key performance indicator (KPI) is a measurable value that shows how effectively you’re meeting your goals. Think of KPIs as your company’s scorecard, a way to measure whether you’re delivering on your objectives.

Identifying and tracking KPIs lets you know whether your business is on the right path, or whether you should change course. When used properly, KPIs are powerful tools that help you:

  • Monitor company financial health.
  • Measure progress against strategic goals.
  • Spot problems early on.
  • Make timely adjustments to tactics.
  • Motivate team members.
  • Make better decisions, faster.

To learn more about KPIs, go to Using key performance indicators to meet your business goals

Ad-hoc data analysis

You might just want to check whether the numbers add up correctly, quickly confirm or debunk a hypothesis about the business, or maybe look for anomalies in your financial data. For ad-hoc analyses, you might not have a built-in report that helps answer your questions. For ad-hoc analyses, use these two features:

  • Data analysis on ledger list pages
  • Open in Excel

The Data analysis feature lets you open almost any list page, such as the General Ledger Entries or Customer Ledger Entries pages, enter analysis mode, and then group, filter, and pivot data as you see fit.

Example of how to do data analysis on the G/L entries page.

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.

Example of how to do data analysis on the G/L entries data using Excel.

Tip

If you configure OneDrive for system features, the Excel workbook opens in your browser by using Excel for the web.

To learn more about ad-how analyses, go to Ad hoc data analysis.

Reports

A report in Business Central gathers information based on a specified set of criteria. Reports organize and present the information in an easy-to-read format you can use in Excel, print, or save as a file.

As an example of an interactive report in Excel, the *Aged Accounts Receivable report lets you analyze what your customers owe you and when payments are due.

Example of the interactive aged accounts receivables report in Excel.

For aged accounts receivables, Business Central also includes a report designed for print. The ability to print is handy if you prefer to have the data in a .pdf file.

Example of the  aged accounts receivables report in pdf.

Business Central comes with more than 300 built-in reports that you can use to support your business processes with data-driven insights. To get a quick overview of all the reports that are available for your role, you can open the report explorer from the role center and all list pages and from Tell Me.

Example of how the report explorer shows all reports for a role.

To learn more about using the report explorer to see all built-in reports, go to Exploring reports per Role.

The following table lists articles about how to use built-in reports in Business Central.

To See
Learn how to use reports (bookmark, run, print, schedule, and change the layout). Use Reports in Daily Work
Learn about which built-in reports are available in Business Central. Report Overview
Use the Report Explorer to see all built-in reports. Exploring reports per Role

External business intelligence and reporting tools

If you prefer, you can use business intelligence tools that aren't embedded in Business Central. The following table provides links to guidance and ways to use external tools.

To See
Use Power BI with Business Central data Using Power BI with Business Central
Integrate external business intelligence tools with Business Central. External Business Intelligence Tools
Extract data to data warehouses or data lakes How to extract data to data warehouses or data lakes
Analyze Business Central data with Microsoft Fabric Introduction to Microsoft Fabric and Business Central
Read data from Business Central using APIs Business Central API v2.0

Analytics by functional area

The content in this general article is also available in special versions for many functional areas in Business Central.

If you work with... See
Finance Financial analytics
Sales Sales analytics
Purchasing Purchasing analytics
Fixed Assets Management Fixed assets analytics

See also

Using Financial reporting to produce financial statements and KPIs
Using key performance indicators (KPIs) to meet your business goals
Doing ad-hoc data analysis
Use reports in your daily work
Overview of built-in reports
Exploring reports per Role
Work with Business Central

Find free e-learning modules for Business Central here