The Extremely High Performance DW and BI Solution
 
 

University of Technology Malaysia

University of Technology Malaysia is the largest engineering-based university located at the southern tip of peninsular Malaysia. The university is renowned for being at the forefront of engineering and their technological knowledge and expertise. Apart from that, UTM is in line with the aspirations of the country to be a fully developed and knowledge-rich nation by the year 2020.

The university has 2 campuses located at Johor and Kuala Lumpur respectively; there are also students that enrolled on distanced learning programmes as part-time students. Having produced more than 200,000 technical graduates and qualified professionals over the years, UTM has earned its place as Malaysia's Premier University in Engineering and Technology.

UTM has multiple systems with different data sources namely Oracle and MS SQL Server. Previously, their reports were stored and done either in MS excel or Access, and some reports are even prepared manually which ultimately leads to productivity loss and increase of unnecessary burden on the UTM Analyst. The methods of producing reports were also rigid and susceptible to errors and were made worst with the lack of transactional/historical data on their current system which prevents them from effectively leveraging their data for a more effective analysis. Besides that, it also leads to problems like timely access to information, mismatched between data sources and also difficulties in viewing the data as strategic resources.

Implemented in 2008, Speedminer data Warehouse and Business Performance Management allows randomly scattered data to be consolidated into one system. It then delivers the University information access solutions that present information workers in a single, unified way to get at the information they need no matter where it resides. Through this, it is dramatically easier to find the relevant information quickly, to use that information to drive intelligent decision making, and to instantly share knowledge that result across the University and beyond.

Speedminer will ultimately be implemented across the University from department administrator who simply need to look at the data to human resources, student administration, etc. Three main categories of information have been chosen to analyze during the initial stage of implementation, namely the analysis on staff's performance, University academic performance and the staff's related information. Each of this 3 group are being categorize into several fields that then allow us to facilitate a greater visibility into the University's performance, supporting stronger collaboration among departments and thus allowing a better enterprise wide decision making.

The data are also restricted to authorized individuals of UTM community, the access to the data does not require any formal programming skills, and the analysis and reporting can now be easily done with Speedminer user friendly ad hoc tool.

Even though Speedminer DW & BPM is still new to UTM, but with its usable and intelligent features, it managed to attain some positive quote from the users. According to Mr Aris from CICT, Centre of Information Communication Technology Department of UTM, Speed Analyzer has been doing him a great favor in generating reports that they no longer need to do it manually. Reports can now be generated with just some simple drag and drop dimension.

The Speedminer Implementation was very smooth and took us 1 month to complete the project. The solution comes with a personalized dashboard to track a variety of analysis and reports necessary to manage operations. Analysis like Student completion statistics, Graduates On Time by Session and by Course, CGA and CPA Analysis, Correlation for MUET with CPA are just a sampling of the items tracked to understand if the graduate and undergraduate schools are meeting projections.

Additionally, Speedminer has its unique features which uses technology without the need of building Cube, and Fact tables makes the installation in a day and the whole implementation include training within weeks.

It gives an intuitive and cost-effective way to enable all users to access and analyze information through familiar tools such as a Web browser. Now, the users can unlock data trapped in application silos into an integrated data warehouse and be informed in depth analysis, thus make long-range strategic planning across all operation functions and disciplines more accurately.