How Do I: Analyze List Pages and Data Using Analysis Mode in Business Central

Introduction

List pages in Dynamics 365 Business Central are central to daily operational work: customers, vendors, items, ledger entries, and documents.
What is often overlooked is that these same list pages can also be used for ad-hoc data analysis, without exporting data, running reports, or switching tools.

With Data Analysis (Analysis Mode), Business Central allows users to analyze, group, pivot, and summarize list data directly inside the application.
This post explains what Analysis Mode is, how it works, how it fits into the broader reporting and analytics landscape, and how it can reduce or even replace the need for many traditional reports.

What Is Data Analysis (Analysis Mode)?

Data Analysis, also referred to as Analysis Mode, is a built-in feature that lets users explore list data interactively by:

Grouping data by one or more fields
Applying aggregations such as Sum, Count, Average, Min, and Max
Pivoting rows into columns
Applying filters independently from the list page
Creating, saving, and sharing multiple analysis views

All of this happens without modifying the page, writing AL code, or exporting data.

Microsoft documentation:
https://learn.microsoft.com/en-us/dynamics365/business-central/analysis-mode

Analysis Mode in the Business Central Analytics Landscape

Analysis Mode is part of Business Central’s broader analytics and reporting ecosystem, which includes:

Structured Financial Reports
KPIs and role center dashboards
Built-in and external Power BI integrations
Excel-based analysis
Ad-hoc analysis using list pages and Analysis Mode

Analysis Mode sits between operational lists and formal reporting.

It is designed for fast exploration and decision-making, not for predefined layouts or distribution-ready output, which is exactly why it often replaces reports that were previously used only for ad-hoc insight.

Analytics overview:
https://aka.ms/bcreporting

Analysis Mode as Part of Ad-Hoc Data Analysis

Microsoft defines ad-hoc data analysis as exploring data in ways that standard reports do not cover, often to answer immediate or evolving business questions.

Ad-hoc analysis techniques in Business Central include:

Sorting, searching, and filtering list data
Saving and personalizing list views
Exporting list data to Excel
Analyzing list data directly using Analysis Mode
Analyzing report datasets in Excel or XML

Analysis Mode is unique because it keeps the analysis inside Business Central, close to the operational context.

In practice, this means that many questions that were previously answered by running a report can now be answered directly on list data.

Microsoft overview:
https://learn.microsoft.com/en-us/dynamics365/business-central/reports-adhoc-analysis

Here’s an animated gif from: BCTech/samples/AnalyzeData at master · microsoft/BCTech:

Prerequisites and Permissions

Permissions

To use Analysis Mode, users must have permission to do so:

Permission set must include DATA ANALYSIS – EXEC
Or access to system object 9640 – Allow Data Analysis mode

This allows administrators to control who can perform analytical exploration beyond basic filtering.

Feature Availability

In 2023 release wave 2 and later, Analysis Mode is generally available and enabled by default
In earlier versions, it may require enabling via Feature Management

Opening Data Analysis from a List Page

You start Analysis Mode directly from a supported list page.

Steps:

Open a list page, for example Customer Ledger Entries
Select Analyze from the action bar
The page opens in Analysis Mode

This replaces the classic “run a report, get a PDF” workflow with interactive self-service analysis, often eliminating the need to run a report at all.

Understanding the Analysis Mode Interface

Analysis Mode introduces a structured interface optimized for exploration.

Key UI Elements

Data Area
Displays rows and aggregated values
Summary Bar
Always visible at the bottom, showing row count and statistics such as Sum, Count, Min, Max, and Average
Columns Pane
Used to add fields, define aggregations, grouping, and pivoting
Filters Pane
Filters applied only to the active analysis tab
Tabs
Multiple analysis tabs can be created, renamed, copied, deleted, and shared

Users can drag and drop columns, pin them left or right, mark cells for quick fact checking, and copy data directly to Excel or PowerPoint.

Selecting Columns and Aggregations

In Analysis Mode, users design the analysis themselves.

Aggregation Options

For numeric fields:

Sum
Count
Average
Min
Max

Multiple aggregations can be combined across different fields.

Example:
Analyze total customer balances by posting group while counting ledger entries.

Grouping and Pivoting Data

Grouping

Group data by one or more fields
Reorder grouping levels dynamically

Pivot Mode and Date Hierarchies

Pivot Mode converts row-based data into a pivot-style layout.
All date fields automatically expose a Year, Quarter, Month hierarchy, enabling fast time-based analysis.

Adding Fields from Related Tables

Analysis Mode allows adding fields from related tables, even if they are not visible on the original list page.

Examples:

Group Customer Ledger Entries by Customer Posting Group
Include Credit Limit from the Customer table
Analyze inventory movements by item category or vendor

This dramatically increases the analytical power of standard list pages.

Filtering Data During Analysis

Filters in Analysis Mode apply only to the active analysis tab.

You can filter by:

Dates
Dimensions
Posting groups
Document types
Any available field

This allows experimentation without affecting the original operational view.

Examples by Functional Area

Microsoft provides scenario-based guidance showing how Analysis Mode can replace many classic reports.

Finance

DIY Income Statement
Total Assets overview
Vendor balance to date
Top N customers or vendors by balance or purchase amount

Sales

Customer order summaries
Sales by ship-to country
Salesperson bonus overviews

Inventory

Returned goods by quarter and item
Movements between locations
Input and output by month
Identifying “old” stock based on custom definitions

Compliance and Audit

Who changed what, and when
Data changes by table and field
Installed apps by publisher
License overview by user

Reference overview:
https://learn.microsoft.com/en-us/dynamics365/business-central/reports-adhoc-analysis

Developer Perspective: Analyze Data and Queries

For developers and technical consultants, Analysis Mode is also relevant:

Analysis can run on Query objects, not just list pages
Developers can design queries and pages that are analysis-friendly
Microsoft provides reference scenarios and samples in the BCTech repository

Developer resources:
https://github.com/microsoft/BCTech/tree/master/samples/AnalyzeData
https://aka.ms/bctech

Limitations and Performance Considerations

Analysis Mode is optimized for interactive exploration:

There is no fixed hard limit on dataset size
When analyzing more than 100,000 rows, the platform automatically switches to a more efficient loading mechanism
Performance depends on filters, grouping complexity, and table size

It is not intended to replace Power BI or complex, multi-source reporting.
Understanding these boundaries helps clarify when Analysis Mode is the right replacement for a report, and when a classic report is still the better option.

When to Use Data Analysis (and When Not)

Analysis Mode is most effective when it replaces reports that exist mainly to answer ad-hoc or exploratory questions.

Use Analysis Mode when:

You need immediate insights
You want to replace static reports with interactive analysis
You want to stay inside Business Central

Use Excel or Power BI when:

You need complex calculations
You combine multiple data sources
You build reusable dashboards

How Do I: Replace Reports with Analysis Mode on List Pages in Business Central

With that context in mind, let’s look more concretely at how Analysis Mode can replace many traditional reports in day-to-day scenarios.

Traditional reports in Business Central are designed for consistency and distribution.
They work well when the question is known in advance and the layout is fixed.

Analysis Mode addresses a different need.

Instead of starting from a report definition, you start from the data itself and shape the analysis interactively.
For many operational and financial questions, this removes the need to run or create a report at all.

Typical Report Scenarios You Can Replace

Analysis Mode works especially well for scenarios such as:

Customer or vendor Top N overviews
Balance-to-date analyses
Period-based summaries, month, quarter, year
Inventory movements and stock ageing
Compliance and audit questions, who changed what, and when

Why Analysis Mode Is Often a Better Fit

Compared to classic reports, Analysis Mode offers:

Immediate results without running a report
Interactive grouping and pivoting instead of fixed layouts
The ability to iterate without rerunning or redesigning anything
Live data instead of static output
Saved analysis tabs for repeated use

This shifts reporting from a design-first approach to a question-first approach.

When Reports Still Make Sense

Analysis Mode does not replace all reporting.

Classic reports are still the right choice when:

A fixed layout is required
Output must be distributed or archived
Calculations are complex or highly specific
The same result must look identical every time

In practice, Analysis Mode reduces the number of reports users depend on, while reports remain for formal or recurring outputs.

Final Thoughts

Analysis Mode transforms list pages into powerful analytical tools.
It bridges the gap between operational data and formal reporting, enabling faster insights and better decisions.

If reports feel too rigid and Excel feels like overkill, Analysis Mode is often the missing middle ground.