Power BI for Business Central: Finance Pack

This offering delivers the financial data model, dashboards, and Excel template for all the companies in one Dynamics 365 Business Central or Dynamics NAV database. The Financial Data Model covers General Ledger, Accounts Payable and Accounts Receivable.

Agenda

Implementation Planning

• Software Requirements Review
• Dynamics 365 Business Central / Dynamics NAV System Review
• Server and Credentials

Deployment

• Installations
• Apply the PBIX file
• Publishing and data refreshing
• Analyze in Excel

Deliverables

• The Comprehensive Financial Optimizer dashboard provides quick access to business metrics that are key to monitoring profitability and liquidity. The “what-if” analysis parameters allows the modelling of the probable outcomes by changing the sales and cost of goods sold.
• The Income Statement dashboard provides the Budget vs. Actual report and the consolidated income statement, and supplements it with trend analysis.
• The Accounts Receivable dashboard provides key metrics combined with other information to improve the order to cash cycle time. No more manually consolidating multiple aged trial balances.
• The Accounts Payable dashboard provides key metrics enabling managers to monitor the effectiveness of accounts payable workflows, and the insights on how a vendor or group is performing across all your entities.
• The Revenue & Profitability dashboard enables organizations to drive change in the management of revenue and profitability, analysis of growth drivers and increase speed to insight.
• The Operating Expenses dashboard provides insight to expense cost drivers and results, increases the productivity through use of mobile, improves management of planned vs. actual operating expenses.
• The Excel Template includes Trial Balance, Income Statement, Balance Sheet, KPIs, Aged Accounts Receivable and Aged Accounts Payable.