Case Study

Assignment

• The data environment to promote DX using ICT is underdeveloped
• Each system is divided into silos and has different code systems.
• It is essential to build a data utilization platform that will serve as a hub for company-wide standards.

Installed products/solutions

"Informatica MDM" Master data management by
Wing Arc 1st Building a BI environment using “Dr.Sum” and “MotionBoard”

Project background

There is an urgent need to create an environment for data utilization that can meet the demands of various departments and branch offices.

NISHIMATSU CONSTRUCTION, which has a long history and tradition of over 140 years since its establishment in 1874 (Meiji 7), leverages its advanced technological capabilities to provide safe and secure services ranging from the construction of roads, dams, and public facilities to urban redevelopment. The company has widely contributed to the development of social infrastructure and the creation of a comfortable environment.
The environment surrounding the construction industry is changing significantly, and there are concerns that it will be affected by a decline in the working-age population and reductions in construction investment in the future. In order to respond appropriately to these social changes and grow sustainably, NISHIMATSU CONSTRUCTION itself needs to adapt to the new era.

"Nishimatsu-Vision 2027" depicts the future we want to achieve. With the vision of becoming a comprehensive company that creates new value, the company aims to expand its business domain and evolve its construction business, providing technology and services that meet the diversifying needs of its customers. We have positioned the current period (as of 2019) as a "period of building the foundation for becoming a company with comprehensive capabilities," and are in the process of implementing various growth strategies in order to steadily realize our vision under the "Medium-term Management Plan 2020." be. The core of the ICT plan was to develop a data utilization infrastructure.

Each system is in a separated silo state, and the code systems are also disparate, and in order to collect and use this data cross-sectionally, it is necessary to create a separate program each time, which is a tedious process. It took a lot of time. In order to solve this problem, NISHIMATSU CONSTRUCTION wanted to build a data utilization platform that would serve as a company-wide standard hub.

Background of introduction

Unified management of three types of master data related to "employees", "clients" and "construction"

The company already had a variety of systems in place, including sales management, customer management, quotation management, construction management, and personnel management. Based on advice received from a data management consulting company, NISHIMATSU CONSTRUCTION narrowed down three types of master data related to "employees," "clients," and "construction" in the first phase of data integration. By flexibly comparing these data, it becomes possible to analyze which subcontractors and employees were involved in what type of construction work and how much profit they generated, which was the most requested feature within the company.

NISHIMATSU CONSTRUCTION, which started implementing master data management (MDM), compared solutions from several companies and ultimately selected Informatica MDM, which was proposed by B-EN-G.

In addition to MDM, to build a data utilization platform, we have already introduced WingArc 1st's "Dr.Sum," which serves as a data warehouse, and "MotionBoard," which visualizes data on a dashboard as its front. The deciding factor in choosing B-EN-G as a partner was that they could be entrusted with the entire system construction, including the use of BI, which they had previously been using.

System image of data utilization platform

Effects of introduction

Data utilization platform becomes an engine that accelerates DX initiatives

NISHIMATSU CONSTRUCTION and B-EN-G teamed up to build a data utilization platform project in October 2019, and after about four months of requirements definition, design and development began in February 2020. Trials began in August of the same year, and production began in November.

The effects of the introduction are listed below.

• Centralize master data by leveraging Informatica MDM name aggregation functionality
• You can now view the data you are interested in while changing the combination on MotionBoard.
• Internal motivation for data utilization has greatly improved, increasing momentum for promoting DX

Future outlook

In conjunction with stricter control of access privileges, further expand the use of data utilization infrastructure

Although full-scale operation has started, the scope of the data utilization platform is currently only available to a limited number of users, such as the corporate planning department and human resources strategy department at the head office, the planning departments within each business division, and the general affairs department. . The biggest challenge for the future is to expand this to a wider range of departments and branches. In addition to introducing a system to strictly control access privileges to various data items, it is necessary to increase literacy regarding data utilization throughout the company by providing detailed explanations to users in each department.

In addition, the current three types of master data are not sufficient for the data to be integrated into the data utilization platform, and there is a desire to be able to use data stored in many internal business systems. It's increasing. Furthermore, in order to conduct full-scale marketing analysis, it is necessary to utilize not only internal data but also various external data.

We look forward to various proposals from B-EN-G to promote NISHIMATSU CONSTRUCTION's DX in the future.

*Organization names, positions, numerical data, etc. in the article are as of the time of the interview. It may have changed by the time you view it. note that.