Power BI gets data from BC (or other sources), aggregates it using PowerCentral datamodel end extensions and provides connection to Excel. Excel uses Pivot tables and formulas to request aggregations from Power BI and present them to you in familiar format.
PowerCentral reports and models
The Finance pack
Finance pack provides general ledger and budgets analysis by any dimension or chart of accounts category account
Balance sheet
P&L by any dimension
Budget vs actual
Settlements
Customer, Vendor settlements analysis by key counterparty attributes like country, type, category, etc.:
Purchase, sales amounts
VAT amounts
Aged accounts receivables and payables
Historic debt analytics
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 implementation approach is agile. In 7 days or under we bring your data into Power BI, and conduct workshops and training. Your specific reporting requirements, and existing customizations and support will be included in our implementation package.