การพัฒนาคลังข้อมูลนักศึกษาระดับปริญญาตรีสำหรับคณะวิทยาศาสตร์ มหาวิทยาลัยเชียงใหม่

Abstract

In this independent Study is about studying and developing analysis, designing, extraction, transformation and loading the student’s data to Undergraduate Student Data Warehouse Development for Faculty of Science, Chiang Mai University. The way of study is to reform the disrupted data from operational database in many periods of times to the new set of data that can use freely and also respond the various requirements of Management Information System by using the Extraction, Transformation and Loading Data to Undergraduate Student Data Warehouse Development for Faculty of Science, Chiang Mai University. This process will be designed and developed by using Microsoft SQL Server Integration Service 2013. This tool is a part of Microsoft SQL Server 2012 that used in storing data of the new data warehouse. The results of design and development, Undergraduate Student Data Warehouse Development for Faculty of Science, Chiang Mai University is collected by using analysis, designing, extract, transform and load will collect from various sources and be more accurate.