DEVELOPING STRATEGIC REPORTS FOR NATIONAL CO-OPERATIVE OF MALAYSIA (ANGKASA) USING DATA WAREHOUSE AND DECISION TREE MODEL

Managing an organization requires access to information in order to monitor activities and assess performance. Business Intelligence (BI) solutions provide organizations with timley, itegrated information that is crucial to the understanding of their business. Data Warehouse (DW) technology is one of the important strategic management approaches for decision making in an organizations. The BI combines architectures, tools, databases, analytical tools, and methodologies to enable the implementation of interactive information in generating analytical reports. Strategic reports, which influence the enduring way of the whole company, are typically used by top managers. These kinds of decisions are repeatedly complex and the outcomes unsure, because existing information is habitually incomplete. Managers at this point must normally depend on history experiences and their instincts when making strategic decisions. DW is a technology allows integrating and transforming enterprise data for strategic decision making. Furthermore, Decision Tree (DT) is a decision support tool that uses a tree-like graphof decisions and their possible consequences, including chance event outcomes, resource costs, and utility. The organization, which is, responsible to manage people activities need strategic decisions making. This paper will be focused how to design and develop Strategic Reports using DW and DT Model for National Co-operative Organization of Malaysia (ANGKASA) called DSRNCO, as a case study. This system has been evaluated through the system user feedback by using Computer System Usability Questionnaire (CSUQ), which measures system usability and user satisfaction.

[1]  Robert Wrembel,et al.  Data Warehouses And Olap: Concepts, Architectures And Solutions , 2006 .

[2]  James R. Lewis,et al.  IBM computer usability satisfaction questionnaires: Psychometric evaluation and instructions for use , 1995, Int. J. Hum. Comput. Interact..

[3]  Juan Trujillo,et al.  A UML 2.0 profile to design Association Rule mining models in the multidimensional conceptual modeling of data warehouses , 2007, Data Knowl. Eng..

[4]  Albert K. W. Yeung,et al.  Spatial Data Sharing, Data Warehousing and Database Federation , 2007 .

[5]  Christian Huemer,et al.  B2B Integration - Aligning ebXML and Ontology Approaches , 2002, EurAsia-ICT.

[6]  Alberto Abelló,et al.  Online Analytical Processing , 2011, Encyclopedia of Cryptography and Security.

[7]  C. Olszak,et al.  Informing Science InSITE - "Where Parallels Intersect" June 2003 Paper Accepted as a Short Paper , 2003 .

[8]  Zhiqiu Huang,et al.  A quality evaluation approach for OLAP metadata of multidimensional OLAP data , 2010, 2010 2nd IEEE International Conference on Information Management and Engineering.

[9]  Norshuhada Shiratuddin,et al.  Conceptual Design Model Using Operational Data Store (CoDMODS) for Developing Business Intelligence Applications , 2011 .

[10]  Xingsen Li,et al.  A Systematic Information Collection Method for Business Intelligence , 2009, 2009 International Conference on Electronic Commerce and Business Intelligence.

[11]  Daniel Balaceanu,et al.  Components of a Business Intelligence software solution , 2007 .

[12]  Michael Lisin,et al.  Microsoft SQL Server 2005 Reporting Services (SQL Server Series) , 2006 .

[13]  Philip S. Yu,et al.  Graph OLAP: Towards Online Analytical Processing on Graphs , 2008, 2008 Eighth IEEE International Conference on Data Mining.

[14]  Joseph M. Firestone Enterprise Information Portals and Knowledge Management , 2002 .

[15]  Esteban Zimányi,et al.  Hierarchies in a multidimensional model: From conceptual modeling to logical representation , 2006, Data Knowl. Eng..

[16]  Beate List,et al.  Developing Requirements for Data Warehouse Systems with Use Cases , 2001 .

[17]  Sebastián Ventura,et al.  Educational data mining: A survey from 1995 to 2005 , 2007, Expert Syst. Appl..

[18]  O. Folorunso,et al.  Data mining for business intelligence in distribution chain analytics , 2010 .

[19]  Fausto Giunchiglia,et al.  Tropos: An Agent-Oriented Software Development Methodology , 2004, Autonomous Agents and Multi-Agent Systems.

[20]  Fred R. McFadden,et al.  Data warehouse for EIS: some issues and impacts , 1996, Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences.

[21]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[22]  Jimmy Kijai,et al.  Data Warehousing and Decision Making in Higher Education in the United States , 2006 .

[23]  Sanaz Mostaghim,et al.  Intelligent Business Process Execution using Particle Swarm Optimization , 2010, Nature-Inspired Informatics for Intelligent Applications and Knowledge Discovery.

[24]  Surajit Chaudhuri,et al.  Database Technology for Decision Support Systems , 2001, Computer.

[25]  Mahdi Seify Importance of KPI in BI System, Case Study: Iranian Industries , 2010, 2010 Seventh International Conference on Information Technology: New Generations.

[26]  P Beynon-Davies,et al.  Rapid application development (RAD): an empirical review , 1999 .

[27]  Henk Sol,et al.  Expert Systems and Artificial Intelligence in Decision Support Systems , 1987 .

[28]  Dan-Ping Zhang A Data Warehouse Based on University Human Resource Management of Performance Evaluation , 2009, 2009 International Forum on Information Technology and Applications.

[29]  Zhaohui Tang,et al.  Data Mining with SQL Server 2005 , 2005 .

[30]  Qiang Guo,et al.  Method used to construct the marketing channel analysis system of a company of ShanDong branch of China Mobile based on data warehouse technology , 2010, 2010 International Conference on Educational and Information Technology.

[31]  Matteo Golfarelli,et al.  Beyond data warehousing: what's next in business intelligence? , 2004, DOLAP '04.

[32]  Changjiang Li,et al.  The Application Research of OLAP in College Decision Support System , 2010, 2010 Second International Conference on Multimedia and Information Technology.

[33]  Tony R. Sahama,et al.  A Data Warehouse Architecture for Clinical Data Warehousing , 2007, ACSW.

[34]  Mohamed Zairi,et al.  Effective process management through performance measurement , 1995 .

[35]  William R. King,et al.  Project Management Handbook , 1983 .

[36]  Svetlozar Nestorov,et al.  Ad-hoc association-rule mining within the data warehouse , 2003, 36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the.

[37]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[38]  Efraim Turban,et al.  Introduction to Information Technology , 2000 .

[39]  Kirk Haselden Microsoft SQL Server 2005 Integration Services (SQL Server Series) , 2006 .

[40]  Michael W. Hawkins,et al.  Data Warehousing: Architecture and Implementation , 1999 .

[41]  Kwok-wing Chau,et al.  Application of data warehouse and Decision Support System in construction management , 2003 .

[42]  John Wang,et al.  Encyclopedia of Data Warehousing and Mining , 2005 .

[43]  Feng Yu,et al.  The Research & Application of ETL Tool in Business Intelligence Project , 2009, 2009 International Forum on Information Technology and Applications.

[44]  Muhamad Shahbani Abu Bakar,et al.  Community and data integration approach using requirement centric operational data store model (ReCODS-model) for business intelligence applications , 2009, ICC 2009.

[45]  Song Bei,et al.  The research & application of Business Intelligence system in retail industry , 2008, 2008 IEEE International Conference on Automation and Logistics.

[46]  Hanumat G. Sastry A Novel Business Intelligence System Framework , 2010 .

[47]  Henk Sol,et al.  Expert systems and artificial intelligence in decision support systems : proceedings of the Second Mini Euroconference, Lunteren, The Netherlands, 17-20 November, 1985 , 1987 .

[48]  Gary Weiss Data Mining in the Telecommunications Industry , 2009, Encyclopedia of Data Warehousing and Mining.

[49]  Matteo Golfarelli From User Requirements to Conceptual Design in Warehouse Design: A Survey , 2010 .

[50]  Padhraic Smyth,et al.  Business applications of data mining , 2002, CACM.