Buy Dideo Subscription
How you can realize comprehensive 3 way forecasting and planning? The Acterys forecasting engine utilizes Power BI and Excel as front ends to achieve this goal. Learn some generic methods and also what Acterys brings to the table. The approach that is used unifies data warehousing, data discovery and planning in one solution. This can lead to dramatic increases in process efficiency. Not just compared to typical excel only processes but even compared to specialized planning applications that typically only cover the planning aspect well and then create a lot of maintenance efforts to integrate data to a separate data warehouse or data discovery applications. At our clients this approach often shortens budgeting and forecasting cycles from weeks to a few days. By three way forecasting we are referring to the underlying financial logic that links Income statement , Balance sheet and cash flow. For example when you plan a sale, the balance sheet will be updated with the logic to change receivables and potentially also consider payment terms to convert receivable to cash. Finally the Cash flow statement will reflect the cash implications. Table of Contents: 00:00 - Introduction 02:08 - Integration with Power BI 04:07 - OPEX Planning 09:16 - Planning in Excel 12:06 - Copying of data 16:37 - HR Planning 19:32 - CAPEX Planning 21:17 - Cash Flow Planning 22:16 - Financing & Debt Planning 24:18 - Workflow & audit trail
