Ad-hoc data analysis

Sometimes you need to analyze data in Business Central in a way that the standard reports don't support. These analyses are often called "ad-hoc." The following table provides links to articles that can help you learn how to do ad-hoc analyses.

To	See
Learn how to analyze data by sorting, searching, and filtering it.	Sorting, Searching, and Filtering and Searching and Filtering FAQ
View and analyze data from a page in Microsoft Excel	View and Edit in Excel
View and analyze data from a report dataset in Excel	Analyzing Report Data with Excel and XML
Analyze list data directly from a page	Analyze list data using data analysis mode

Ad-hoc data analysis by functional area

The general content about ad-hoc data analysis is also available in special versions for many of the functional areas in Business Central.

If you work with...	See
Finance	Ad-hoc analysis on finance data
Fixed Assets	Ad-hoc analysis of fixed assets data
Sales	Ad-hoc analysis of sales data
Purchasing	Ad-hoc analysis of purchasing data
Inventory	Ad-hoc analysis of inventory data
Auditing	Ad-hoc analysis of change log data Analyze user status by license type

See also

Business Intelligence and Reporting Overview

Find free e-learning modules for Business Central here