Trade Statistics System (TSS)

MATRADE used to have 2 separate systems in generating trade reports. The systems took 13 hours to load Trade Data from SMK (Sistem Maklumat Kastam) and process report, but the output is often inaccurate as new trade codes can be introduced every month and the systems would therefore require vendor’s involvement in setting new codes in the systems. The systems also not capable of handling different currencies,  therefore some reports would need to be done manually on Excel. Weeks of effort would be required and taken up in generating the quarterly printed Trade handbook.

With Speedminer, data from SMK loaded with data cleansing to detect the errors in volume and pricing, as well as correctly identifying the company that perform the import and export. The cleansed SMK data is then merged with Trade data from Department of Statistics, Malaysia to produce integrated analysis and reports.

With Speedminer, the processing the report reduced to less than 3 hours despite higher data quality produced. Besides, reports are now generated in different currencies, denominations and can even  be filtered by different groups created by users. With the user-friendly Analyzer module, end users are empowered to generate ad-hoc reports and analysis through drag and drop, and are able to slice and dice the output to gain better insights and make smarter decisions. The self-service nature of the system usage thus free the IT staff from report writing to perform more critical task like ensuring data quality, and examines various alerts generated by the system.

Speedminer also automates the process of updating Trade Codes, thus bringing about a huge save  in time and cost. The Trade handbook is generated automatically and is  now made available on a monthly basis instead. All these improvements translate to higher productivity, better efficiency and morale among the staff, and faster response to queries on trade data.

Market Engagement System (MES)

For MES, Speedminer analyses the company information that import and export goods from/to Malaysia. The analysis developed in MES including Market Performance Analysis, Trade Promotion Program Overseas, and Trade Promotion. All of these analyses help MATRADE in terms of planning, preparation and monitoring trade promotion program activities, understanding the current market trend and to increase the opportunity for Malaysian Importer and Exporter in a particular industry and country.

Performance Management System (PMS)

PMS measures the performance (KPI) of the Trade Commission offices on their effort and involvement at various Trade Commission offices around the world on how they organize marketing activities and get foreign companies participating in the events. Previous implementation of PMS that uses spreadsheet involved much manual processes. Due to the significant amount of effort and time needed, the PMS reports could only be prepared quarterly. The new PMS using Speedminer loads data from MATRADE databases to calculate the KPIs. For other information that needs to be captured, the Web Application Framework (EliteSys) module was used to design web form for data entry by MATRADE officers around the world. Speedminer then generates and displays the performance analysis and report on the dashboard accessible by officers.  The entire system was successfully designed, developed and implemented within merely 3 months. Now, MATRADE is able to view their performances in a timelier manner and with less human error as compared to previous manual compilation. Management level users are able to view current performance on the fly without having to wait for reports to be manually prepared.