> For the complete documentation index, see [llms.txt](https://kb.bevica.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.bevica.com/documentation/reporting-and-analytics/reporting_in_bevica_-_overview.md). # Reporting & Analytics in Bevica Bevica gives you many ways to analyse and understand the data you enter and process. Built-in analytics and reporting help you track performance and review activity across the business. Business Central includes reporting and analytics tools for both simple and complex processes. This page outlines the main areas and links to more detail. For a quick guide, see [Use Reports In Your Daily Work (Quick Guide)](#use-reports-in-your-daily-work-quick-guide). {% hint style="warning" %} **Prerequisites** Access to Bevica. Access to Power BI (optional). {% endhint %} ### Reporting Overview It can help to think about analytics by user type and the different reporting needs each role has. ![Diagram showing reporting personas and their analytics needs](/files/Eh4ksWTBP0DVwiCVKhTS) {% embed url="" %} ### Use Reports In Your Daily Work (Quick Guide) Use the following tools as part of your daily routine to monitor performance, spot trends, and stay in control of your work. * List Pages * Export to Excel / Edit in Excel * Data Analysis Mode * Templated Reports * Connecting Excel to Bevica (Web Services & OData) * Role Centres, KPIs / Charts * Finance Reports and Dimensions * Inventory and Sales Reporting These are covered in more detail here: [Use Reports In Your Daily Work (Quick Guide)](/documentation/reporting-and-analytics/reporting_in_bevica_-_overview/quick_guide_-_reporting_in_bevica.md) ### Power BI It is easy to get insights from your Business Central data with Power BI — Microsoft’s data visualisation platform. Power BI retrieves Business Central data so you can build dashboards and reports from it. It gives you a flexible alternative to reports built in Business Central. You can drill down, customise visuals, and merge data from different companies or external sources. Some Power BI reports can also be embedded in Business Central and viewed without leaving the system. More complex dashboards are often easier to work with in the Power BI website. {% embed url="" %} #### Business Central Power BI Business Central SaaS includes a suite of standard Power BI reports. These cover: * Finance * Sales * Purchasing * Inventory * Inventory Valuation * Projects * Manufacturing {% embed url="" %} Learn how to install the standard Power BI reports: [Install Power BI apps for Business Central](https://learn.microsoft.com/en-us/dynamics365/business-central/across-powerbi-install-business-central-apps) {% hint style="info" %} These reports do not include Bevica data. They are based on standard Business Central data and features. A Power BI Pro licence is required to access these reports. {% endhint %} Power BI reports can also be made available within Bevica on the Role Centre and selected list pages, including **Customers**, **Items**, **Jobs**, **Sales Orders**, and **Vendors**. #### Bevica Power BI Bevica has a Power BI extension with a suite of Finance, Sales, Inventory, and Purchasing reports that include Bevica-specific data. See [Bevica Power BI reporting](/roadmap/bevica-roadmap/bevica-extensions.md#bevica-power-bi-reporting). ### Microsoft Fabric Microsoft Fabric is an end-to-end analytics solution with capabilities for data movement, data lakes, data engineering, data integration, data science, real-time analytics, and business intelligence. It is backed by a shared platform for data security, governance, and compliance. For customers with more advanced data science or business intelligence scenarios that require richer data engineering or data integration, Microsoft Fabric is an option. See [Fine Wine Reporting for Fabric / SQL](/documentation/reporting-and-analytics/reporting_in_bevica_-_overview/reporting-for-fabric-sql.md) ### External Business Intelligence Bevica can export data in several ways. This lets external solutions use your data for reporting and insight. {% embed url="" %} ### Technical Resources | Area | Description | Help link | | ----------------------- | --------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------ | | Table & field Schema | Displays all tables and their fields with properties. Open page: **Table Schema** | [Bevica Database Schema](/documentation/guides/reference/bevica_database_schema.md) | | Report Writing Overview | Report and document layout overview | [Report and document layouts overview](https://learn.microsoft.com/en-gb/dynamics365/business-central/ui-manage-report-layouts) | | Report Design Overview | How to design Excel, Word, RDL layout reports within Bevica | [Report Design Overview](https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-design-overview) | ### Functional Resources | Area | Description | Help link | | -------------------------------------------------- | ---------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- | | Reporting overview - Finance | List of reports for this functional area | [Financial reports](https://learn.microsoft.com/en-gb/dynamics365/business-central/reports-available-reports#financial-reports) | | Reporting overview - AR | List of reports for this functional area | [Accounts receivable reports](https://learn.microsoft.com/en-gb/dynamics365/business-central/reports-available-reports#accounts-receivable-reports) | | Reporting overview - AP | List of reports for this functional area | [Accounts payable reports](https://learn.microsoft.com/en-gb/dynamics365/business-central/reports-available-reports#accounts-payable-reports) | | Reporting overview - Sustainability | List of reports for this functional area | [Sustainability reports](https://learn.microsoft.com/en-gb/dynamics365/business-central/reports-available-reports#sustainability-reports) | | Reporting overview - Sales | List of reports for this functional area | [Sales reports](https://learn.microsoft.com/en-gb/dynamics365/business-central/reports-available-reports#sales-reports) | | Reporting overview - Purchasing | List of reports for this functional area | [Purchasing reports and analytical tasks](https://learn.microsoft.com/en-gb/dynamics365/business-central/purchase-reports) | | Reporting overview - Inventory & Warehousing | List of reports for this functional area | [Inventory and warehouse reports](https://learn.microsoft.com/en-gb/dynamics365/business-central/reports-available-reports#inventory-and-warehouse-reports) | | Reporting overview - Fixed Assets | List of reports for this functional area | [Fixed assets reports](https://learn.microsoft.com/en-gb/dynamics365/business-central/reports-available-reports#fixed-assets-reports) | | Reporting overview - Relationship Management (CRM) | List of reports for this functional area | [Relationship management reports in Business Central](https://learn.microsoft.com/en-us/dynamics365/business-central/marketing-reports) | | Reporting overview - Assembly | List of reports for this functional area | [Assembly reports](https://learn.microsoft.com/en-gb/dynamics365/business-central/reports-available-reports#assembly-reports) | | Reporting overview - Production | List of reports for this functional area | [Production Reports and Analytics in Business Central](https://learn.microsoft.com/en-gb/dynamics365/business-central/production-reports) | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://kb.bevica.com/documentation/reporting-and-analytics/reporting_in_bevica_-_overview.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.