Qlik Products

Integrated Planning

The simple explanation is that integrated planning aligns departments. It creates an environment where your forecasts and budgets from your Revenue, Sales, Production, HR & Staffing Models use drivers that automatically tie together to make-up your PNL, Balance Sheet and Cashflow with simplicity and automation.

For example, your sales manager enters forecasts for products and services in the Sales Model. The forecast can be fully driver-based so that instead of entering a dollar value you can set up business rules so that the forecast is entered in any unit of measure, such as tonnes, hours, FTE, or anything you like. Once the forecast is complete, Jedox then translates the forecast to a dollar value using business rules defined by you and breaks it down into the appropriate GL accounts. The sales forecast can automatically update the PNL, Balance Sheet, and Cashflow in one simple step. Business rules define how the different cost or profit centres roll up to the company total. This happens automatically and on-the-fly without manual intervention. There can be rules set in place that require each cost centre manager (or likewise) to have to be approved before it is allowed to be pushed into the PNL and to roll-up into the Forecast at the top level.

Integrated planning aligns departments. It improves compliance and controls around the planning process. Integrated planning links financial targets to operational drivers − the activities that each department actually does day-to-day. Users compare actuals with plan, and drill-down below the KPIs to understand ‘why’ it is happening.

Every department has a small number of advanced Excel users; these users can easily become Jedox ‘Power Users’ as the look and feel of Jedox Web and it’s Excel Add-on mirror how end-users operate Jedox. You want to empower these people. Because departmental processes can change rapidly, your planning platform must allow business users to securely access their own data and define KPIs quickly and easily on their own.

Combining performance monitoring with integrated planning means you can rapidly take action. Planning is not rigid. You need self-service modeling to customize planning rules and adjust to respond to growth and change. Jedox allows organisations to create multiple versions and scenarios to better help organisations quickly change their “plan” as unexpected situations may arise. A prime example of this would be the current unprecedented pandemic and its interruption to a vast majority of businesses. Our customers were able to generate many different versions and “what-if” scenarios based on what the effects will be on the business across production and sales, staffing adjustments, etc. This enabled them to prepare for possible forecast changes as they navigate through possible financial planning impacts on the business in the coming months and/or years to come.

Jedox is a collaborative platform for enterprise planning, data analytics, and reporting. This helps align all departments and divisions to your corporate strategy and objectives. With Jedox, you can link financial targets to operational drivers and other day-to-day activities in each department. Business users can compare actual performance to plan data and drill down to the details to see ‘why’ it is happening. By combining performance monitoring with integrated business planning, your company stays agile and ready for action.

* Improved collaboration across the teams and entities in your organisation

*More accurate forecasts and what-if analytics

*Faster insights to all stakeholders to align operational planning with strategic goals

*Better, data-driven decisions based on high-level and detailed plan and actuals

*Simpler planning that saves time and eliminates manual reconciliation

*Greater process visibility and transparency that strengthens risk management

*Single version of the truth backed by transparent methodologies and processes

*Predictive analytics and planning (e.g. predictive revenue analysis), including integration of “R” language for statistical computing

Value Added Products

Software Components

Jedox Enterprise Performance Management software is one unified platform and all components are developed by Jedox. The platform teams up the powerful Jedox In-Memory Database with intuitive user interfaces for planning, analytics, and reporting and components for self-service data integration and preparation. Innovative GPU technology boosts performance to support complex organizations and large user numbers. Click on the software components below to find out how Jedox can help drive your corporate performance management through insightful dashbaords and first-class bugeting, planning and forecasting.

Jedox is ISO/IEC 27000 certified for information security management and maintains enterprise-class security standards such as user authentification with single sign-on (SSO) and SSL encryption.

Jedox Overview

Excel is still the most widely used tool for planning, analytics and reporting. This is no surprise as spreadsheets do offer great flexibility but at great cost due to the limited automation, security and control. Jedox removes the risks from Excel-based business processes while building on your existing Excel know-how. Convert your spreadsheets to an enterprise-class solution with a fast in-memory database, controlled access, workflows, seamless data integration and rich capabilities for analytics and reporting capabilities.

Jedox features intuitive modeling and prototyping that speed-up your solution development and demonstrate tangible value early on. The agile deployment methodology guarantees flexibility during the software implementation. After the project is finished, business users are empowered to modify, develop and scale out the solution on their own without IT support or external help. The multi-dimensional, in-memory database from Jedox grows and adapts to your changing business needs. Add new planning applications, new users and more performance quickly at any time.

Pre-built Models

Jedox

Planning, budgeting and forecasting are three key pillars of Interprise Performance Management (EPM). The purpose of planning, budgeting and forecasting is to translate strategy into execution via long-term or mid-term plans as well as short-term budgets and forecasts.

Planning

Controlling uses planning to determine how the company’s goals are to be achieved. In addition, it ensures that the overall planning and the sub-plans of all individual business areas are consistent and free of contradictions. A top-down planning approach defines the strategic goals of the business and high-level activities required to achieve them.

Budgeting

Budgeting is when controlling translates planning into financial values. A budget is a goal-oriented plan formulated in terms of value. Within the plan, a certain time period with a certain degree of commitment is predefined. A budget allocates resources aligned to meet strategic goals and targets.

Forecasting

A forecast tracks the expected performance of the business so that timely decisions can be made to respond to shortfalls against targets or maximize opportunities. Forecasting goes beyond standard forecasts because controlling uses both financial and non-financial information as well as simulation and scenario considerations.

Planning, budgeting and forecasting processes are typically managed by financial controllers or the financial planning & analysis (FP&A) function in the office of the CFO. Orchestrated by finance, PB&F involves multiple operational business functions such as sales, HR and supply chain to ensure that strategic objectives are met and financial targets are reached.