What this article covers
- How the GRANDIT BI functions and general data output function differ
- The features of the BI functions
- What the general data output function can do
In this article, we introduce the BI features of GRANDIT.
As an ERP, GRANDIT stores many kinds of data. But data that is simply stored does not become an important resource for business. By using the extraction tools built into GRANDIT, you can turn stored data into analysis materials.
In this article, you will
- understand the standard BI features of GRANDIT
- see how BI features can help make your company's data visible
What are the BI and general data output features?
As data extraction tools, GRANDIT provides as standard a BI feature that helps with management analysis and a general data output feature that outputs data for various reports.
They are meant for different tasks and output data in different ways, so it is important to know the difference. Here are the features of each.
Features of the BI function
The BI function offers the following.
- Integration with SQL Server and Excel
- Extraction of analysis items
- Standard reports
Integration with SQL Server and Excel
Transaction data from the core system is stored in a data mart, and dashboards and indicator analysis reports needed by management are output from it.
The data in the data mart is denormalized, for example by joining multiple data sets and adding names for codes and categories. The data mart items are labeled in Japanese, so users can search, analyze, and extract data for their own purposes.
Extraction of analysis items
Items for management and sales analysis can be set freely for each master. You can set your own analysis items in the customer, supplier, product, department, and project masters.
Standard reports
For management analysis, report templates are provided for a dashboard and for overall strength, profitability, productivity, efficiency, and safety analysis. These let you carry out standard analyses.
The general data output function
The general data output function covers all business areas. It is not tied to a specific task and can extract and output general data stored in the database.
With this function, you can use the unified database in GRANDIT in real time, including customer, supplier, and account masters, sales, orders received, orders placed, purchases, billing, payments, expenses, journal entries, and monthly results.
The data is output as comma separated CSV files that open in Excel. For example, you can extract the information you need from the GRANDIT accounting database by setting search conditions and output it as a CSV file.
You can also extract data from the list screens of each business area and output it in a fixed Excel format.
Summary
In this article, we explained the BI and general data output features of GRANDIT.
As an ERP, GRANDIT can quickly provide the information that executives and managers on the ground need, based on data stored through daily business.
In today's uncertain business environment, it is not enough to store and manage data. Making the issues that the data reveals visible is in high demand.
GRANDIT can provide solutions to the various challenges our clients face. SYSLABO is a partner with the rights to customize and sell GRANDIT. If you are considering introducing an ERP, we welcome your questions and consultations. Please feel free to contact us.
