# Project analytics
Businesses capture lots of data during daily activities that supports business intelligence (BI) for project managers, such as:
 Cost performance for projects
 Completion rates for projects
 Financial data for projects
Business Central provides features to help you gather, analyze, and share your organization's project data:
 Power BI reports for projects
 Ad-hoc analysis on lists
 Ad-hoc analysis of data in Excel (using Open in Excel)
 Built-in project analytics tools
 Built-in project reports
Each of these features has its advantages and disadvantages, depending on the type of data analysis and the role of the user. See Analytics, business intelligence, and reporting overview<reports-bi-reporting>.
This article introduces how you can use these analytical features to gain insights into your projects.
## Analytics needs in projects
When you think about the analytics needs in project management, it might help to use a persona-based model that describes different analytics needs at a high level.
![Illustration of different personas for analytics]
People in different roles have different needs when it comes to data, and they use the data in different ways. For example, people in project management interact with data differently than people in finance.
![Illustration of how different personas have different analytics needs.]
Role|Data aggregation|Typical ways to consume data
COO / CFO / CEO|Performance data|KPIs, dashboards, financial reports
Project Manager|Trends, summaries|Built-in managerial reports, ad-hoc analysis
Project participant|Detailed data|Built-in operational reports, on-screen task data
## Use Power BI to monitor project KPIs
A key performance indicator (KPI) is a measurable value that shows how effectively you're meeting your goals. In project management, people often use the following KPIs to monitor project performance:
 % Complete
 % Invoiced
 Realization %
 Total Invoiced Profit
 Total Invoiced Profit Margin %
 Total Usage Cost
 Total Budget Cost
![Screenshot of the Projects Overview Power BI Report]
These KPIs (and more) are available for projects in the Project Power BI app for Business Central.
See Power BI Projects app<projects-powerbi-app>.
### Reports in the Power BI Projects app
The following table describes how you can use each report in the Power BI Projects app.
To...|Open in Business Central (CTRL+select)|Learn more
Get a high-level view of your organization's projects. View key metrics and track performance across them.|Project Overview<https://businesscentral.dynamics.com?page=37033>|About Projects Overview<projects-powerbi-project-overview>
View all projects and their tasks along with their costs and prices.|Project Tasks<https://businesscentral.dynamics.com?page=37034>|About Project Tasks<projects-powerbi-project-tasks>
Analyze the profit of each job and ensure you meet targets.|Project Profitability<https://businesscentral.dynamics.com?page=37035>|Project Profitability (Power BI Report)<projects-powerbi-project-profitability>
View project completion statistics.|Project Realization<https://businesscentral.dynamics.com?page=37036>|About Projects Realization<projects-powerbi-project-realization>
Track the performance of each project and how they track toward their budget.|Project Performance to Budget<https://businesscentral.dynamics.com?page=37037>|About Projects Performance to Budget<projects-powerbi-project-performance-to-budget>
View all sales entries for projects broken down by the sales line type.|Project Invoiced Sales by Type<https://businesscentral.dynamics.com?page=37038>|About Projects Invoiced Sales by Type<projects-powerbi-project-invoiced-sales-by-type>
Analyze key sales information on projects based on the customers you sell to the most.|Project Invoiced Sales by Customer<https://businesscentral.dynamics.com?page=37039>|About Projects Invoiced Sales by Customer<projects-powerbi-project-invoiced-sales-by-customer>
Analyze the schedules of each project task with a Gantt chart, detailing project tasks and their durations.|Project Timeline<https://businesscentral.dynamics.com?page=37106>|About Project Timeline<projects-powerbi-project-timeline>
> TIP
> You can easily track the KPIs that the Power BI reports display against your business objectives. See Track your business KPIs with Power BI metrics<track-kpis-with-power-bi-metrics>.
See Power BI Projects app<projects-powerbi-app>.
## Ad-hoc analysis of project data
Sometimes, you just need to check whether the numbers add up correctly, or quickly confirm a figure. The following features are great for ad-hoc analyses:
 Data analysis on ledger list pages
 Open in Excel
The Data Analysis feature lets you open almost any list page, such as Project Ledger Entries, enter analysis mode, and then group, filter, and pivot data as you see fit.
Similarly, you can use the Open in Excel action to open a list page, optionally filter the list to a subset of the data, and then use Excel to work with the data. For example, use features such as Analyze Data, What-If Analysis, or Forecast Sheet. For What-If Analysis or Forecast Sheet, use Excel for Windows.
> TIP
> If you configure OneDrive for system features, the Excel workbook opens in your browser.
## Built-in reports for projects
Business Central includes several built-in reports to help project organizations report on their data.
To get an overview of available reports, choose All Reports on your Home page. This action opens the Report Explorer, which is filtered to the features in the Report & Analysis option. Under the Project heading, choose Explore. See Finding Reports with the Role Explorer<ui-role-explorer>.
![Example of reports on the sales role center.]
See Built-in project reports<project-reports>.
## On-screen project analytics
Business Central has several pages that give you project overviews and tasks to do, such as:
 projects-how-monitor-progress-performance
## Related information
Power BI Projects app<projects-powerbi-app>
projects-how-monitor-progress-performance
Built-in Projects reports<project-reports>
Project management overview<projects-manage-projects>
Find free e-learning modules for Business Central here<https://learn.microsoft.com/training/dynamics365/business-central>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/projects-analytics-overview, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/projects-analytics-overview/
