Abstract
California School Boards Association (CSBA) requires a Business Intelligence System that can process the data provided by California Department of Education. Due to limited resources, CSBA cannot work with advanced data processing software organizations such as SAP or Oracle. The project’s goal is to structure a Business Intelligence foundation with Microsoft SQL technology. Sources of Data CSBA information technology department was the source of data. They have provided necessary technical environment and information for this project. The physical data that this project utilized is available at California Department of Education’s website. Conclusions Reached The needs of the organization always have the priority. A strong understanding of the business process will improve the effectiveness of the Business intelligence foundation. The master data in this project was complex, random and unorganized. The results of the project are applicable to CSBA. According to CSBA, this project reached its objective.