PowerCentral - Financial analytics for Dynamics 365 Business Central

Power up your Business Central data with flexible financial reports and advanced financial model:

PowerCentral solution provides you with dashboards and data cube for analysis in Microsoft Excel financial data of your Microsoft Dynamics 365 Business Central (cloud).

• Explore your financial data with predefined dashboards, including:
  • Financial overview: revenue, cost of goods and services, administrative expenses, profits
  • Trial balance and P&L reports by dimensions
  • Budget vs actual performance analysis by dimensions
  • Customer debt analysis by age, currency, and dimensions
  • Vendor settlements: liabilities analysis by vendors, invoices, age, etc.


• Create as many customized reports and formulas as you wish using Microsoft Excel connection to data, including:
  • General ledger transactions
  • Budgets
  • Customer ledger transactions
  • Vendor ledger transactions

  The model contains all dimensions you use in BC, multi company support, chart of accounts hierarchy and 20 more most useful attributes.
  The measures include Net Change, Balances, G/L quantity, records count and many other aggregations.
  You can Drill into it using dashboards or Excel to get all transactions that summed to the value you explore

  To view data with Microsoft Excel pivot tables just install the solution, select “Export” -> “Analyze in excel” and build your own pivot.
  Share Excel reports with colleagues

With PowerCentral you can:

• Easily analyze your BC data using Microsoft Excel pivots.
• Build your own “live” reports with only Excel knowledge.
• Do ad-hoc BC data analysis.
• Get startup report packs, adjust, customise and them with colleagues.
• Do ad-hoc BC data analysis.
• Easily see how the figure is calculated, by drilling down and getting transaction level details from Excel.

Solution cost

USD 10 per user per month (does not include Power BI license) for standard solution.
Your customized fields and reference data could be added to the model and dashboards by request.
Also you can order customizable and extensible copy of the PowerCentral model

Why N.Progression?

• We offer extensive multi-platform expertise in the complete Microsoft Dynamics 365, Power Platform and Azure.
• Our deep industry expertise based on 20 years of Microsoft experience and our industry-specific business process modeling and implementation methodology enable faster time to value and lower total cost of ownership.
• We offer exclusive add-on products featured on Microsoft AppSource, which help make migration faster and less risk.