Free online consultation available. Please feel free to contact us.

DataMagic Technical Column Vol.19

(Introduction Cases) Our company's use cases

Introduction

We will introduce a real case where we have utilized the tips from the DataMagic technical column we have introduced so far. This time, we will introduce an example where we used DataMagic to create data for our sales management and maintenance management.

Background of system construction

At our company, the data used to create reports for HULFT sales performance analysis and maintenance management was huge and spread across multiple systems, so the person in charge of creating monthly reports to be submitted to corporate planning and sales representatives had to manually cleanse the data required for report creation using Excel, which meant it took up to 14 days to create the reports.In addition, in order to speed up decision-making on sales strategies and other matters, we decided to build a new sales analysis system, but centralizing the scattered sales data was a major issue.

Company name: Saison Technology, Project: Sales management/Maintenance management Background of considering DataMagic Cleansing the data required for reports was cumbersome, requiring manual work using Excel, and monthly tasks could take up to 14 days. In building a new sales analysis system, centralizing (aggregating) scattered sales data was a major issue. HULFT Centralized management of sales results and improved efficiency of conversion work, faster decision-making, and more efficient report creation.

Issues with the current system

In the current system, to create monthly reports, the person in charge of creating the reports had to use Excel macros to process input data such as order information and sales results from the core server, past sales results from the old sales management system, and maintenance management information from the division's dedicated server.In addition, the corporate planning and sales departments to which the monthly reports are provided frequently request the creation of individual data and reports, but because data creation is done manually, it takes time and is often impossible to respond to.

Overview of the new system

With the new system, DataMagic was used to cleanse data, add additional information, and perform proportional division calculations, reducing the time required to create monthly reports from 14 days to just 6 hours. This freed up the time required by the staff to also reduce the frequency of master data maintenance from once a year to once a month.

Summary: Key points and benefits of implementation

The reasons for deciding to use DataMagic and the benefits of its implementation are listed below.

Point 1. Reduced operational management burden: Non-programming makes corrections easy, and visualization of conversion logic makes it easy to take over when changing personnel. Point 2. High functionality and high performance: Affinity with HULFT, simple conversion functions, high-speed processing. Benefits of implementation: Reduced time required for monthly data processing and report creation (from 14 days to 6 hours), processing of annual order and sales data takes approximately 1 hour, significant improvement in frequency of master data maintenance from once a year to once a month, easier centralized management of fragmented corporate data, and a major contribution to on-site data utilization (business strategy, sales analysis, etc.).

This time, we introduced a case study of how our company uses DataMagic.

Please download DataMagic trial version and try it out.

  • The trial version is free to use for 60 days.
  • After you sign up for the trial version, you will receive 90 days of free technical support.

DataMagic Column List

Related Content

Return to column list