Hillstar logo web small

Planning, Budgeting & Forecasting in Power BI

Get off to a flying start with ready-made reports in Power BI.
Standaard Power BI voor Microsoft Dynamics NAV, AX D365 FO, BC en Exact Globe web

VISUAL PLANNER for POWER BI

Easily and quickly see what would happen to results if there were an adjustment in the number of orders within the sales reporting in Power BI. Or see how much you can still produce when fewer raw materials are available. With the addition of Power ON to Hillstar's standard BI environment and integration with Power BI, that capability is there.

You can now easily write back data to the Tabular model of BIRDS and quickly draw conclusions about future results in the event of deviating expectations. For example, Planning, Budgeting and Forecasting allows you to compare live actuals with budgets and adjust and present live budgets.

Functionalities of Power ON & Power BI

Planning, budgeting and forecasting is a broad concept. Below we have explained which functionalities you can expect.

Product and sales planning

With the Visual Planner integration in Power BI you have a robust set of features for the sales team. Model sales forecasts by SKU, customer, quantity, discount or price per unit. Users can adjust numbers with changes to previous year's sales and change targets at the highest level for easy, automated adjustment.

Balance sheet

Balance sheet projections are derived from the P&L with simple rules describing the relationship between accounts receivables/credits, cash, retained earnings and current liabilities. Other items such as assets and depreciation can be adjusted immediately to provide a full overview of operating performance and financing needs.

Cost of goods sold

Cost Of Goods Sold (COGS) calculations are derived from sales figures based on model calculations. Standard costs and theoretical material costs can be modeled with formulas, and are updated in the tabular model for easy reporting and gross profit analysis.

Cash flow

The Cash Flow section provides an Impact Analysis to analyse the impact of operations, investments and financing. This integration within Visual Planner provides a powerful insight into the effects or expected activities and the financing activities required to maintain a healthy organisation.

Sales, General & Administration

Business travel, IT expenses, office costs and legal fees are easy to add with comments from employees. The ‘Line Item Detail’ and comment function makes it easy to get a clear impression of these expenses.

Diversification, allocation and overhead

Taxes, depreciation and other variable expenses based on drivers are built into the model using advanced DAX modeling language.

Employees and onboarding

By uploading the schedules and for example wages, Visual Planner proposes a new ‘Employee Expense Budget’ or ‘Forecast Scenario’. By applying simple formulas such as ‘inc10%’ the wage of an employee will increase by 10%. The employment and withholding taxes are automatically transferred to the budget.

Forecasts

With virtually unlimited budget and forecast versions, Visual Planner enables the model to process an automated 12-month rolling forecast, with the ability to compare versions back in time to analyze what has changed.

Targeting

Visual Planner’s unique Goal Seeking feature integrates all key modules; product, employee, P&L, balance sheet and cash flow to set goals and analyze the impact on operations. This means that our customers analyze the impact on net profit by adjusting the quantities sold.

Would you like a personal demo?

We will be happy to show you and your colleagues how BIRDS works and explain immediately what benefits this brings to your organisation.
Plan a demo

Welcome at Hillstar

We give companies the ability to make better decisions based on data. We do this by using Microsoft technology and our turnkey BI solution BIRDS.
Contact us

Contact

Landjuweel 1
3905 PE Veenendaal
The Netherlands
Contact SupportContact Sales
Hillstar logo web small
FD Gazellen 2020 logo wit
Microsoft Gold partner logo wit
pencilmoonprinterexitfilm-playlocationcalendar-fulllaptopunlink