Abstract
Business Intelligence (BI) refers to skills, processes, technologies, applications and practices used to support decision making. BI technologies provide historical, current, and predictive views of business operations which are normally used to analyze business data. Online Analytical Processing (OLAP) is one of the common BI approaches in quickly answering multidimensional analytical queries for analytical purpose. In this paper, we have proposed OLAP technique to be implemented in Academic area. Through this technique, UniSZA students’ academic pattern behaviors can be analyzed. A set of data from students’ examination results in relational DB is extracted into multi-dimensional model to support OLAP query processing. The results are grouped into several subject areas. Then, the analysis to recognize students’ academic pattern behaviors is conducted. From the analysis, the groups of students who have the excellent skills or vice versa can be identified. It also optimizes the time dimension to perform current and historical data analysis. The weaknesses and strengths of the student can also be obtained. Finally, students’ future potential areas can be predicted for the next level of educations.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Angela, B., Cattaneo, F., Ceri, S., Fuggetta, A., ParaBoschi, S.: Designing Data Marts for Data Warehouse. Journal of ACM Transactions on Software Engineering and Methodology 10(4), 452–483 (2001)
Cognos: The Right Architecture for Business Intelligence. Cognos Inc., Burlington (2008)
Merceron, A., Yacef, K.: Interestingness Measures for Association Rules in Educational Data. In: 1st International Conference on Educational Data Mining (EDM 2008), Montreal, Canada (2008)
Romero, C., Ventura, S.: Educational Data Mining: A Survey from 1995 to 2005. Expert Systems with Applications 33(1), 135–146 (2007)
Zorrilla, M., Garcia, D., Alvarez, E.: A Decision Support System to Improve e-Learning Environments. In: Proceedings of the 2010 EDBT/ICDT Workshops (2010), doi:10.1145/1754239.1754252
Merceron, A., Yacef, K.: Educational Data Mining: A Case Study. In: Proceedings of Artificial Intelligence in Education (AIED 2005). IOS Press, Amsterdam (2005)
Talavera, L., Gaudioso, E.: Mining Student Data to Characterize Similar Behavior Groups in Unstructured Collaboration Spaces, In Workshop on artificial intelligence in CSCL. In: 16th European Conference on Artificial Intelligence Workshop on Artificial Intelligence in CSCL, pp. 17–23 (2004)
Hung, J., Zhang, K.: Revealing Online Learning Behaviors and Activity Patterns and Making Predictions with Data Mining Techniques in Online Teaching. Journal of Online Learning and Teaching 8(4), 426–436 (2008)
Romero, C., Ventura, S., Espejo, P.G., Hervas, C.: Data Mining Algorithms to Classify Students. In: International Conference on Educational Data Mining, Canada (2008)
Jason, O., Kannan, W.K., Asirvadam, S., Data Mining, V.S.: Warehousing Approaches on School Smart System: A Conceptual Framework. In: Proceedings of Knowledge Management International Conference, pp. 20–24 (2008)
Kimball, R., Caserta, J.: The Data Warehouse ETL Toolkit. Wiley and Sons, New York (2004)
Angela, B., Cattaneo, F., Ceri, S., Fuggetta, A., ParaBoschi, S.: Designing Data Marts for Data Warehouse. Journal of ACM Transactions on Software Engineering and Methodology 10(4), 452–483 (2001)
Batini, C., Cappielo, C., Francalanci, C., Maurino, A.: Methodologies for Data Quality Assessment and Improvement. ACM Computing Surveys 41(3), Article 16, 1–52 (2009)
Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Reichart, D., Venkatrao, M., Pellow, F., Pirahesh, H.: Data cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Subtotals. Data Min. Knowl. Discov. 1(1), 29–53 (1997)
Klosgen, W., Zytkow, J.: Handbook of Data Mining and Knowledge Discovery. Oxford University Press, New York (2002)
Aziz, A.A., Saman, M.Y.M., Hamzah, M.P.: Using Metadata Analysis and Base Analysis Techniques in DQ Framework for DW. American Journal of Economics and Business Administration 3(1), 112–119 (2011)
Talend Open Studio (TOS), http://www.talend.com
Open source start-up upgrades data integration software, http://www.networkworld.com/news/2007/042407-talend-data-integration.html
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Abdul Aziz, A., Wan Idris, W.M.R. (2011). Online Analytical Processing Technique in Personalizing Student Academic Pattern Behavior for UniSZA Students’ Results. In: Ariwa, E., El-Qawasmeh, E. (eds) Digital Enterprise and Information Systems. DEIS 2011. Communications in Computer and Information Science, vol 194. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-22603-8_51
Download citation
DOI: https://doi.org/10.1007/978-3-642-22603-8_51
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-22602-1
Online ISBN: 978-3-642-22603-8
eBook Packages: Computer ScienceComputer Science (R0)