PowerCentral for Microsoft Dynamics 365 Business Central

Financial managers and analysts love Excel — extend its capabilities with the powerful insights of Power BI to build comprehensive reports for Microsoft Dynamics 365 Business Central (BC)!

Microsoft
AppSource Certified

Visit Appsource

Book Demo

Product teaser

Power Central includes both pre-build set of financial dashboards and an analytical data cube for connecting with Microsoft Excel to create your own reports and explore your Business Central financial data

PowerCentral empowers you to:

Save up to 60% on financial data preparation and analysis
Create unlimited customized reports and formulas with just one click
Easily compile them into a comprehensive report within a familiar interface – Microsoft Excel
No need to use multiple Excel files or upload data to create comprehensive reports

PowerCentral Onepager

Download

PowerCentral Product teaser

With PowerCentral you can

1
Easily analyze your BC data using Microsoft Excel pivots
2
Build your own “live” reports using only Excel skills and combine them into reports packs
3
Share your reports with colleagues
4
Get up-to-date data by simply clicking the ‘Refresh’ button
5
Drill down to the figure to get transaction level details from Excel

Book Demo

How it works

Power BI pulls data from BC (or other sources), aggregates it using PowerCentral's data model and extensions, and connects to Excel. Excel then uses pivot tables and formulas to query and display the data in a familiar format.

PowerCentral reports and models

The Finance pack:
- Finance pack provides general ledger and budget analysis by any dimension or account
- Balance sheet, P&L by any dimension
- Budget vs actual
Settlements:
- Customer, Vendor settlements analysis by key counterparty attributes such as country, type, category, etc.
- Purchase, sales amounts
  VAT amounts
- Aged accounts receivables and payables, historical debt analysis
Inventory & Warehouse:
- Current stock enquiry Item turnover reports Inventory Aging Report
- Expiry date report Inventory transactions analysis by warehouses, items, lots, variants, etc

Implementation within a week

Our agile approach delivers your data into Power BI within 7 days or less, including workshops and training. We cover your reporting needs, customizations, and support in our implementation package.