PowerCentral - Financial & trade analytics for Dynamics 365 Business Central

Power up your Business Central data with flexible financial and trade reports

The PowerCentral solution provides you with dashboards and data cubes to analyse your financial, sales and inventory data stored in 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.

Explore your inventory and sales data:

• Track Sales budgets vs actual sales
• Explore your items sales, find the most profitable and effective segments of your business
• Examine your stock, find out what's being stored excessively and what's missing to improve performance

Create as many customized reports and formulas as you wish using Microsoft Excel connection to data, including:

• General ledger transactions
• General ledger budgets
• Customer ledger transactions
• Vendor ledger transactions
• Item ledger transactions
• Sales budgets
• Sales invoices and credit memos

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, Quantities, 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.

Installation

You can use PowerCentral for free in non-production BC environments after PowerCentral BC API Extension installation

Production environment requires license

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.