24-10-2016, 02:43 PM
Data Warehousing- Game changer in transforming the functionality of Conventional University Dashboard
1460837998-draft.docx (Size: 612.42 KB / Downloads: 6)
Abstract: Traditional University dashboard is a tool to display all the information about its day to day activities, updates and everything that students need to know. The tough job lies in managing large amount of data for a university with more number of students. This paper studies the proposed data warehouse technology to process large amounts of information without interfering with the operational data. The main works include identifying the needs of university's dashboard and then concentrates on designing data warehouse technology to be used in executive dashboard applications and then builds a dashboard that meets the specified requirements to analyze information resources. Developers from university’s information technology create a data warehouse to where all operational data and external data are transformed into it, thus utilizing a centralized data warehouse architecture. This paper applies data warehouse technology to BINUS University, Indonesia as it stands for largest number of students all over Indonesia. Data warehouse technology enables us to make high amounts of data processing not interfere with the ongoing operational process which results in better visualization. The performance of the dashboard created with data warehouse technology is compared to that of traditional dashboard to prove that it is efficient than the previous version.
I.INTRODUCTION
The University dashboard in any organization requires lot of information resources in the process of making their decisions to determine the future of their organization and its direction of decisions. The process of good decision making must be supported by the availability of information and the speed with which it can be accessed and the accuracy of the above process. If there are any errors in the above process of receiving information, that can lead to fatal impact to the process of decision making. This makes us understand that every organization needs to utilize the information and technology systems assistance in order to minimize the errors in the process of obtaining information and decision making. Presenting the information in visual form enables decision making process easy and this is highly desired by the leadership of the organization for the university dashboard. The challenge for building dashboard lies in managing the huge information available and sorting it for the process. This huge information should not interfere with the process of decision making which implies that the information should be available to both the process of receiving information and process of decision making. For the above, Data Warehouse helps us to manage the processing of information. Data Warehouse has equipped developers in their information system technology to build Dashboard application which helps the board of leadership to access the information in visual form. Visual display helps the decision makers to read and understand the information quickly.
A university has many advantages with this dashboard. Being competitive in education field and to win its place is main advantage. This project considers University with large number of students enough to study this application. Accessing the University for Interview for gathering data has to be considered. In the future, this project can be expanded to other universities. The long term goal of this research is to make a best dashboard application as well as increasing awareness among the administrators of the University, help them forecast the development of organization through this Executive Dashboard application. This research first identifies the need of BINUS University’s board of management and then designs Data Warehouse to be used in Executive dashboard application and then builds Executive dashboard facilitating BINUS University’s board of management to gain and analyze the information. Some more benefits include University gaining access to information in making decisions and improving the decision quality for itself. The main theme of this research is to design an executive dashboard that will help the board of management of University and implementing it.
II. DATA WAREHOUSE, BUISNESS INTELLIGENCE AND EXECUTIVE DASHBOARD
A) Data Warehouse
Dashboard is collection of that supports in decision making process that stores current and past data, which attracts managers of the organization.
B) Business Intelligence
Business Intelligence (BI) is a process that obtains large amounts of data, analyze them and presents reports that minimizes the essentiality of data for the process that allows management to make business actions day to day. BI serves as path to improve the performance of business by providing good support to the decision makers that enable the
Board of executives to take any decisions or actions based on the information they already have. BI can be divided into three sub parts, data storage, data capture, data access and analysis.
Key Performance Indicator (KPI) is an important measure for any organization. The end point of direction of decisions for any organization is KPI, in achieving the long run goals.
Conclusion and Recommendations:
From the obtained results, we can conclude that:
• The success determination factor for BINUS University is BINUS Scorecard as it belongs to the Key Performance Indicator. To monitor the success indicator of BINUS University, Executive Dashboard could serve as one of the tools that can be utilized for this time.
• The slow availability of information by the board of management is a problem currently and Executive dashboard application is the solution for the above problem.
• The amount of performance indicators that are used for the application are more in number, so therefore we have to go on classifying them based on the perspective.
• The implementation of Executive Dashboard has been implemented by highest board of management by BINUS University.
Recommendations that are offered for this application are:
• Due to constant changes in the performance indicators that are taken into consideration, the success indicator of BINUS University may be adjusted. Therefore, data warehouse adjustments has to be done always to meet the constant changes in the success indicator.
• The current executive dashboard application is not equipped with data mining. Therefore, further developments has to be made in this direction.
• There is a need for information system by BINUS University that serves to accommodate the entire external data that makes the data transformation tasks easier for Executive Dashboard application.
• Until here, there is still pending assessment towards the efficiency and effectiveness of the Executive Dashboard application.
The Executive dashboard helps to monitor the performance of University by considering success indicators for each university.