Ad hoc data analysis in Business Central

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.

ToSee
Analyze data on a list by sorting, searching, and filtering it.Sorting, Searching, and Filtering and Searching and Filtering FAQ
Save the settings you use frequently on a list as a viewSave and personalize list views
View and analyze data from a page in Microsoft ExcelView and Edit in Excel
Analyze list data directly from a pageAnalyze list data using data analysis mode
View and analyze data from a report dataset in ExcelAnalyze report data with Excel and XML

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.

Analytics overview

Find free e-learning modules for Business Central here