Business Intelligence & Strategic Planning Modules
The integrated structure of the module enables the planned and actual figures to always be kept up to date and the companies can be managed in real time. Budget categories can be set up in different hierarchies for different business areas such as “Sales Budget”, “Production Budget”, “Purchasing Budget”, “Investment Budget”, “General Expense Budget”, “Personnel Budget” and “Financial Budget”. The successful integration with other modules makes the planning and reporting process more efficient.
Main features of the module are;
• Creation of sales budget based on material and material group.
• Describing the desired number of exchange rate scenarios and use them in budgets and reporting.
• Defining the beginning of the period and safety stock data and using the production budget.
• Operation of the production budget by defining different bill of materials and route alternatives.
• Including independent needs in the budget while making sales budget estimation.
• Monitoring of production, semi-product and activity budgets on material basis.
• Receiving the vendor and price information of the purchases of the budget, resulting from the operation of the production budget from the data previously defined in the system.
• Automatic creation of personnel budget data in the desired detail taking into account the data in the Human Resources Management module.
• The fixed assets planned in the investment budget are transferred to Asset Management module and used in reporting.
• The distribution of expenses over activities by the distribution schemes in the Cost Centers Accounting module infrastructure and the calculation of unit activity costs based on cost center after defining the expense budgets.
• Defining the approval and authorization mechanism of the budget.
• Transferring of all budget items to the account-level financial budget with posting keys and import templates.
• Budget cost in actual cost detail.
• Consolidation of budgets.
• Quick creation of the revised budget
• Real-time management of overdrawing during actual budget controls.
INTEGRATION
There are standard reports in the Budget Management module that allow various analyzes:
• Sales budget detailed analysis report
• Detailed analysis report of purchasing budget
• Expenditure budget detailed analysis report
• Investment budget detailed analysis report
• Personnel budget detailed analysis report
• Finance budget detailed analysis report
• Planned/Actual and budget-to-budget comparison for sales budget
• Planned/Actual and budget-to-budget comparison for purchase budget
• Planned/Actual and budget-to-budget comparison for expense budget
• Planned/Actual and budget-to-budget comparison for finance budget
• Summary capacity report
• Unit activity costs report
• Operation costs report
• Budget cash flow report
• Budget balance sheet and income statement
• Budget Cost report
INTEGRATION
For the planned sales figures in the Budget Management module, actual data or independent needs in the Sales Management module can be used. Production and purchase budget are generated through the Material Requirements Planning and indirectly through the BOM and Routing Management modules. Plan values created within the Budget Management can be taken into consideration in Material Requirements Planning module and can be used in related processes. The values in the credit application in the Finance Accounting module can be used within the budget module and the credit definition of the budget can be made. The development of fixed assets belonging to the investment budget can be monitored in the Asset Management module. If planned budgets for purchase and expense are exceeded, the system warns the users while performing transactions in Purchasing Management and other related modules. The personnel budget can be created by considering the data in the Human Resources Management module. Once the expense budgets have been defined, the distribution of expenditures on the activities through the distribution schemes in the Cost Centers Accounting module infrastructure, calculating the unit activity costs based on the cost center and thus, by the help of the Standard Cost Management module, calculating the budget cost in the actual cost detail can be provided. In addition, a structure that works integrated with the Business Process Management module can be established in order to manage the approval processes through the system. The plan data in the generated budgets can be compared with actual values through integration with the relevant modules and a report infrastructure can be created for deviation analyzes.
The components of the Budget Management module, which are fully integrated into the general system and have a structure in connection with other modules, ensure that calculations, reports, and transactions are performed quickly and accurately.
FEATURES OVERVIEW
• Creating a desired number of budgets
• Identifiable authorization and approval process
• Budget category in different hierarchies
• Use of multiple currencies in the budget
• General sales planning based on material groups
• Detailed sales planning based on customers / materials
• Budget entry based on departments
• Production planning in line with sales budget
• Using the Material Requirements Planning module to manage the production budget
• Identifying the sales, production, general expenses, investment, personnel, purchase, and finance budgets.
• Advanced and detailed reporting
• Comparison of planned figures by date range and months
• Creating budget revisions quickly with advanced parametric architecture
• Complete integration with all basic modules
• Detailed cost structure
• Limit overrun management in the processes related to the live budget controls
• Consolidation of budgets
Besides being a performance measurement system, Balanced Scorecard Management is also used as a management system for a strategic approach. This management system consists of four main perspectives: “Financial Perspective”, “Customer Perspective”, “Internal Process Perspective” and “Employee Perspective.” New alternatives can be defined in the module in addition to these perspectives.
Strategic goals are defined in the Balanced Scorecard Management module and targets are set based on these objectives. These objectives are converted to measurable performance indicators. Thus, performance indicators are used to implement strategies while showing the current state of the companies. These strategic goals are gathered under scorecards. It is also defined which coefficient is effective in determining the value of the report. Separate scale and operating period can be specified for each target. Results are automatically calculated by the system.
REPORTING
When the defined scorecards are run at the specified times, the results are shown both in the report and in the tree structure defined in the diagram.
INTEGRATION
Balanced Scorecard Management module is integrated with all the modules in the system, therefore, all system data can be used in the scorecard calculations.
FEATURES OVERVIEW
• Configurable module parameters
• Identifying new perspectives
• Flexible scale design
• Practical scale multiplexing
• Using data from each module in the system
The institutional risk management process, which is carried out in order to determine, measure and minimize the risk factors that may adversely affect the workability of an institution or an organization and the profitability of commercial establishments, can be managed in an effective way through this module, which is designed in accordance with international risk management standards.
Economic and technological developments have brought about complex business structures, where many activities are carried out in a long period of time with a large number of people and hierarchical organizational arrangements are constantly evolving. This situation has made the operations of the enterprises unobservable by simple control methods. COSO (The Committee of Sponsoring Organizations), which consists of five independent professional organizations in the USA, led to the transformation of internal control environment, risk assessment, control activities, information, communication and monitoring into a standardized structure in enterprises. The COSO internal control model is structured around the effectiveness and efficiency of business activities, the reliability of financial reports, and compliance with applicable laws and regulations. Then, with the ISO 31000 Risk Management System Standard, the risk management standards have been determined. ISO 31000 Risk Management System Standard recommends organizations to develop a framework that aims to integrate the risk management process with all management, strategy and planning, management, reporting process, policies, values and culture of the company.
Enterprise Risk Management (ERM) module has been created in compliance with these standards.
GENERAL OPERATION
There are four main risk groups in the Enterprise Risk Management module:
• Strategic
• Financial
• Operational
• Compatibility / Disaster
The following steps are taken to manage risks:
I. Identifying and specifying the risks and defining the group to which they belong. Companies determine their risks by taking internal audit processes into consideration. Appoints responsible and managers for the risks. Determines the risk measurement periods and how the measurement is carried out.
II. Evaluation of risks
The main risk assessment methods used are:
• Brainstorming
• Scenario analysis
• Profit / Cost analysis
• Reason tree analysis
• Error impact analysis
• Result / Probability matrix
III. Running the risks, sorting the risks according to the results and determining the risk control methods
Risk control methods used:
• Avoidance: The enterprise terminates the related activity
• Prevention: Reduce the likelihood of risks
• Protection: Reduce the impact of risks
• Distributing: Distribution of activities so that all operations of the business are not harmed by risk
• Transfer: Transfer of risks to third parties or institution
IV. Selection, implementation and monitoring of risks
• Configurable module parameters
• Identifying additional risk group
• Defining probability and effect scales
• Defining flexible measurement period
• Using data from each module in the system
REPORTING
When the risks defined in the module are run at specified times, the results are shown both graphically and as a report.
INTEGRATION
As the Enterprise Risk Management module is fully integrated into the system, it can use the information in any module of the system to measure risks.
FEATURES OVERVIEW
• Configurable module parameters
• Identifying additional risk group
• Defining probability and effect scales
• Defining flexible measurement period
• Using data from each module in the system
Business Intelligence (IQ) module provides the required data for the strategic decisions to be taken throughout the company, making the analyzes as fast as possible, evaluating the data in a multidimensional way and preparing it visually. In this process, it aims to minimize user intervention and to make reporting as automatically as possible. Developed in cooperation with Qlik, one of the world’s leading business intelligence firms, the Business Intelligence module provides an integrated business intelligence system for all its users in the system.
USE OF DATA RESOURCES
Business Intelligence module is a homogeneous structure that is fully integrated into the system. Without the need for a third-party ETL (Extract-Transform-Load) tool, ERP data is passed through the ETL process and transferred to the OLAP tables in the Data Warehouse Management module. Thus, data can be analyzed in a centralized manner and collected independently from the resources. As a result, decisions that are critical to enterprises can be given smartly and effectively.
MULTI-DIMENSIONAL VIEW ON DATA AND FLEXIBILITY
The module formats the company’s critical data in a standardized and structured way and provides the users with multi-dimensional capabilities for efficient analytical inquiry. Thanks to the OLAP tables created using the Data Warehouse Management module, data can be viewed multidimensional in horizontal and vertical axes in the Business Intelligence module. A multidimensional view at data gives flexibility to prepared reports and provides unlimited cross-reporting.
FAST INFORMATION TRANSMISSION
The module also provides the opportunity to view large volume data of commercial activities of companies from multidimensional horizontal and vertical axes. Visualization tools like Dashboard can be used in the module. Thus, decision-making processes of companies are supported easily and automatically.
EASY REPORTING
OLAP tables are designed to meet the requirements and automatically establish relationships between tables without the need to design OLAP cubes.
Association technology in the Business Intelligence module allows analysis in the way the human brain thinks and offers the user a highly flexible inquiry. As a result of keeping the data available in the association, the results of other analyzes that may be related at the same time may be reflected on the screens, apart from the questions asked. With the self-service feature, users can make changes to existing dashboard displays, analyzes or create new screens from scratch.
READY-TO-USE REPORTS
Analysis of data can be started instantly with ready-to-use reports as soon as the module is installed.
IN-MEMORY ANALYSIS
Business Intelligence module’s in-memory working technology keeps all the data set in the analysis in memory and reduces the time required to analysis into mere seconds to speed up the processes. In other words, it returns the result of the inquiry made by the user over the data set previously stored in memory before going to the source (database) of that data. Given the large data sets with millions of rows of data from data sources, such technology makes a big difference to the instant calculations that the user needs in terms of speed.
INTEGRATION
Business Intelligence module has perfect integration with all modules in the ERP system, especially with the Data Warehouse Management module. The dashboard and other reports prepared on the module can be accessed directly without the need for third-party applications. Through the developed bi-directional integration, Business Intelligence reports can be accessed via ERP modules, as well as using the links defined on Business Intelligence dashboards, and the details of an important situation or record can also be accessed with one-click through the ERP modules.
FEATURES OVERVIEW
• Summarization of variable OLAP tables
• Ready for instant analysis with ready-to-use reports as soon as the module is installed
• In-memory working technology
• Association technology
• Direct access to dashboards and reports
• Direct access to ERP records via Dashboards
• Multi-dimensional overview feature
• No limits in dimensions and groupings
• Unlimited cross-reporting capability
• Detailed or summarized overview
• Unlimited display of data
• Comparative overview feature
• Real-time evaluations
Module Group
Modules with Interaction
REFERENCES
