Abstract
The objective of this project is to innovate a business intelligent tool for smallmedium sized enterprises (SMEs) to enhance their decisions quality and identify the rooms for continuous improvement. . In particular, this tool is designed for the procurement function which aims to achieve justintime strategy. The project was worked with Tung Fat Ho Building Material Ltd (TFH), which is one of the leading ironmongery suppliers in Hong Kong, to collect the large amount of data from their enterprise resource planning (ERP) system. The business intelligent tool consists of two parts. The first part is composed of the database software, Microsoft Access, to transform the unstructured data among various unstructured reports to become structured data in the relational dataset. The second part of business intelligent tool is developed in the spreadsheet software, Microsoft Excel, serving as an analytical platform to shows different levels of key performance indicators a dashboard. The project aims to develop business intelligent tools which are comparable to the large enterprises operations but also are affordable in smallmedium sized enterprises.
The objective of this project is to innovate a business intelligent tool for smallmedium sized enterprises (SMEs) to enhance their decisions quality and identify the rooms for continuous improvement. . In particular, this tool is designed for the procurement function which aims to achieve justintime strategy. The project was worked with Tung Fat Ho Building Material Ltd (TFH), which is one of the leading ironmongery suppliers in Hong Kong, to collect the large amount of data from their enterprise resource planning (ERP) system. The business intelligent tool consists of two parts. The first part is composed of the database software, Microsoft Access, to transform the unstructured data among various unstructured reports to become structured data in the relational dataset. The second part of business intelligent tool is developed in the spreadsheet software, Microsoft Excel, serving as an analytical platform to shows different levels of key performance indicators a dashboard. The project aims to develop business intelligent tools which are comparable to the large enterprises operations but also are affordable in smallmedium sized enterprises.
