Skip to content

Data Analysis and Management System

MATE-BI

Business intelligence system

Overview

Product Overview

MATE-BI (Business Intelligence) collects and analyses data from inside and outside the company so businesses can stay competitive as markets shift and operations grow.

Built on Microsoft Excel, a tool business users already know, it lets practitioners analyse the business themselves, and it delivers dashboard reports for executives who need the overall picture.

  1. A range of data sources

    • ERP
    • MES
    • Administrative data
    • Data from any other solution
    • Field Data

  2. Cloud Microsoft Power BI service

    Power BI

    Data Relation

  3. Using the Power BI service

    PC

    Mobile

Strengths

Highlights

  • Decision support

    Brings the information decisions depend on into a single view

  • Monitoring what matters

    Monitors the business metrics that matter most

  • Access control

    Screen access is controlled by user permission

  • Data visualisation

    Visualise data in a range of ways

  • Fast, easy access to data

    Reach multiple data sources quickly and easily

  • Analytics

    Analytics delivered through integration with ERP and MES

  • Microsoft Power BI

    Runs on the Microsoft Power BI engine

Features

Key Features

  • 01

    Easy to use

    An intuitive interface anyone can pick up

  • 02

    Statistical analysis

    Advanced statistical techniques for in-depth analysis

  • 03

    Cortana integration AI voice service

    Reach data quickly with AI voice commands

  • 04

    Visualisation

    Charts and graphs that make complex data intuitive

  • 05

    Real-time dashboards

    Real-time monitoring supports agile decisions

  • 06

    Scalability

    Connects to a range of data sources and scales with you

  • 07

    Quick Insight instant insight

    Automatic analysis surfaces business insight immediately

Workflow

Workflow Diagram

  1. 01Working from many types of data source
    • Excel and text files
    • Database data
    • Unstructured data via Hadoop
  2. 02Data modelling and operations
    • Defining data relationships
    • Creating fields
  3. 03Report design and formatdefined and built by the user
    • Charts and images
    • Analysis conditions
    • Report list types
  4. 04Changing report format and data
    • Charts and images
    • Analysis conditions
    • Report list types
  5. 05Publishing and sharing reports
    • Managing read, report and data-editing permissions

Benefits

Benefits

  • Optimised productivity and inventory

    Real-time analysis and dashboards optimise productivity and stock levels, cutting cost

  • Stronger data-driven insight

    Visualisation and statistical analysis deliver deeper business insight

  • A more efficient supply chain

    Integration across data sources gives real-time visibility of the whole supply chain, so issues get resolved fast

  • One source for the floor and the boardroom

    Operational and management data are combined into tailored reports for practitioners and executives alike

RPA

Process automation solution

Overview

Product Overview

RPA stands for Robotics Process Automation, one of the innovative software technologies that has come to the fore with the fourth industrial revolution and the rise of artificial intelligence.

It is a solution in which software carries out the structured, repetitive work people would otherwise do on a PC.

A range of interfaces AI, cloud services (APIs) and legacy UI-based systems
AI input

Documents, forms, invoices, images and more

API-based automation (DPA)

Cloud services and internal services that expose an API

UI-based automation (RPA)

Legacy web, Windows and terminal applications

Form recognition + OCR + digital documents

AI builder

Over 300 connectors, plus custom connectors
User interface automation
Power Automate Workflow designer and control centre

Strengths

Highlights

  • Easy to use

    A globally recognised, user-friendly UI puts automation within reach of non-technical users

  • Faster development

    Drag and drop from more than 300 actions to complete a process

  • Easy to maintain

    Four levels of exception handling make automation viable for any scenario

  • Processes run in parallel

    Run several processes on a single software robot to get the most from it

Features

Key Features

  • 01

    UI flows connector

    Adds RPA capability from within the Power Automate authoring tool

  • 02

    Recording mouse and keyboard input

    Records each step taken in desktop and web application UIs to build UI automation

  • 03

    New WinAutomation desktop authoring tool

    Builds RPA through the WinAutomation desktop authoring experience

Use Cases

Application Examples

Automatic distribution of salary contracts and reminder emails to those who have not signed

  • 01

    Create the salary contract form and compile the recipient list Excel (recipient list) · Word (template)

  • 02

    Generate Word files from the recipient list Power Automate

    List data is merged into the Word template to create a file per person, which is then emailed

  • 03

    Collect signatures and generate signed Word files Power Apps · Power Automate

  • 04

    Report signature collection status to the owner on a regular basis Power Automate

    Reminder emails go to anyone who has not signed

  1. Owner
  2. Bot
  3. Employee
01
02
03
04

Yes

No

01 · OwnerRegister the collection schedule

01 · OwnerUpload the Word document

01 · OwnerSelect the recipients

02 · BotStore the source Word document

02 · BotSave recipients to the database

02 · BotGenerate a Word file per recipient

02 · BotSend the emails

03 · EmployeeReview and sign

03 · BotSave the signature to the database

03 · BotCreate a signed document for each employee

04 · BotCheck daily until the deadline

04 · BotCollection complete?

04 · OwnerSend the completion email

04 · BotIdentify non-responders

04 · BotSend the emails

Collecting system usage logs and sending them to the Smart Factory project team

Collects system usage logs from more than 50 companies that have adopted smart factory systems and uploads them to the project team’s management site

Cloud · Smart Manufacturing Innovation Office https://www.smart-factory.kr · the collected CSV is uploaded
Company A1
  • MES Server Legacy Server
  • MES DB Legacy DB
  • Master data in Excel · log CSV files
  • Power Automate Desktop
Company A2
  • MES Server Legacy Server
  • MES DB Legacy DB
  • Master data in Excel · log CSV files
  • Power Automate Desktop
COMPUTERMATE collection server
  • Naver Cloud CM Lite MES · companies B1, B2, B3
  • Collection server
  • Master data in Excel · log CSV files
  • Power Automate Desktop

Automatic registration of corporate card vouchers

Before

Every user entered voucher details into ERP by hand, then printed the approval and the voucher and passed them to the management support team for ledger keeping

  1. Card used
  2. Voucher registration ERP accounting
  3. Approval ERP to groupware · management support collects the issued vouchers
  4. Card usage data ERP

After

RPA collects corporate card voucher data automatically and enters it into ERP.

  1. Card used
  2. Collected automatically by RPA
  3. Card usage data ERP

Benefits

Benefits

  • Better quality of work

    Human error disappears, accuracy rises and the quality of work improves

  • Focus on higher-value work

    Bots handle the simple, repetitive work so staff can concentrate on what adds value

  • Lower headcount and operating cost

    With bots taking on all the routine work, both labour and cost come down

MATE-DA

Manufacturing data acquisition system

Overview

Product Overview

MATE-DA (Data Acquisition) collects manufacturing data from sensors, PLCs and other sources in real time. Building on the OPC Server’s core tag capability, it processes and stores sensor data, equipment data, production results and alarm histories over OPC UA communication.

Strengths

Highlights

  • Collection of diverse data types

    Collects analog data such as temperature, pressure and flow together with digital I/O data from sensors, PLCs, DCS and other sources, so the entire process can be monitored in real time. This allows process control and maintenance to be optimised.

  • Real-time data synchronisation and storage

    Synchronises time across every automation system in the plant so data is collected and stored consistently. This improves interoperability between equipment and raises data accuracy, maximising operational efficiency.

  • Equipment status and energy consumption monitoring

    Monitors equipment operating status, energy usage and utility consumption in real time, supporting lower operating costs and optimal equipment operation. The result is better energy efficiency and more sustainable plant operations.

  • Data-driven process improvement

    Analyses the collected data to detect problems in the process early and provide ways to resolve them. Data analysis drives improvement across the whole process, from higher productivity and better quality to lower costs.

Features

Key Features

  • 01

    Data collection

    Real-time data collection (sensor data · equipment data · production results · error logs)

  • 02

    Monitoring

    Tag monitoring

Benefits

Benefits

  • Higher production efficiency

    Real-time data collection detects anomalies in the production process quickly, so teams can respond and raise productivity

  • Improved quality

    Collected data strengthens quality control, reducing defect rates and feeding process improvement

Considering an implementation?

Tell us about your shop floor and our team will review it and get back to you.