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 |
|---|---|
| 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 view | Save and personalize list views |
| View and analyze data from a page in Microsoft Excel | View and Edit in Excel |
| Analyze list data directly from a page | Analyze list data using data analysis mode |
| View and analyze data from a report dataset in Excel | Analyzing 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.
| If you work with... | See |
|---|---|
| Finance | Ad-hoc analysis on finance data |
| Fixed Assets | Ad-hoc analysis of fixed assets data |
| Sustainability | Ad-hoc analysis of sustainability 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 |