The Cross-Analysis is another Business Intelligence tool that we discussed in the previous article (February 2011). This is not new in DCision ERP software, but it is a tool used more than ever that deserves to be known and used more.
The Cross-Analysis is a powerful tool for data analysis. It is dynamic because it is the user who chooses the presentation of the data and he can constantly change the presentation of the same data once extracted from the databases. This is quite a contrast to the regular reports and even export to Excel. A spreadsheet such as Excel has a cross-analysis feature called Pivot Tables. These require certain knowledge to be able to use them and are generally poorly integrated into management applications.
The DCision ERP software incorporates a powerful and easy-to-use analysis tool available in all applications. The user of DCision ERP has in fact several Cross-Analysis at his disposal in the Financial Management system (transactions to GL, analyzes of accounts payable sub-ledger and accounts receivable sub-ledger, projects and generic sub-ledgers), in the Operations Management system (planning , purchases, sales, MRP, lot / serial numbers, etc.) and in the membership Management system.
Use is simple: The user can access the Cross-Analysis of their choice from the « Analysis » menu. He then has the option of selecting one or more databases and the system extracts the data and presents them in the Cross-Analysis. Once the data has been extracted, the user can select the data they want to analyze and present them in countless ways. Once the desired presentation is obtained, it can be stored as a template so that it can be reused in future data extracts. Data can be printed and exported to Excel.
Here is an example of a sales Cross-Analysis prepared to present sales by customer and product category :
With the same Cross-Analysis, here are now the sales by representatives and by years:
Contact us to learn more about our solutions and this offer!