Data Profiling and Data Quality Metric Measurement as a Proactive Input into the Operation of Business Intelligence Systems

Author(s):  
Scott Delaney

Business intelligence systems have reached business critical status within many companies. It is not uncommon for such systems to be central to the decision-making effectiveness of these enterprises. However, the processes used to load data into these systems often do not exhibit a level of robustness in line with their criticality to the organisation. The processes of loading business intelligence systems with data are subject to compromised execution, delays, or failures as a result of changes in the source system data. These ETL processes are not designed to recognise nor deal with such shifts in data shape. This chapter proposes the use of data profiling techniques as a means of early discovery of issues and changes within the source system data and examines how this knowledge can be applied to guard against reductions in the decision making capability and effectiveness of an organisation caused by interruptions to business intelligence system availability or compromised data quality. It does so by examining issues such as where profiling can be best be applied to get appropriate benefit and value, the techniques of establishing profiling, and the types of actions that may be taken once the results of profiling are available. The chapter describes components able to be drawn together to provide a system of control that can be applied around a business intelligence system to enhance the quality of organisational decision making through monitoring the characteristics of arriving data and taking action when values are materially different than those expected.

2016 ◽  
pp. 2171-2188
Author(s):  
Scott Delaney

Business intelligence systems have reached business critical status within many companies. It is not uncommon for such systems to be central to the decision-making effectiveness of these enterprises. However, the processes used to load data into these systems often do not exhibit a level of robustness in line with their criticality to the organisation. The processes of loading business intelligence systems with data are subject to compromised execution, delays, or failures as a result of changes in the source system data. These ETL processes are not designed to recognise nor deal with such shifts in data shape. This chapter proposes the use of data profiling techniques as a means of early discovery of issues and changes within the source system data and examines how this knowledge can be applied to guard against reductions in the decision making capability and effectiveness of an organisation caused by interruptions to business intelligence system availability or compromised data quality. It does so by examining issues such as where profiling can be best be applied to get appropriate benefit and value, the techniques of establishing profiling, and the types of actions that may be taken once the results of profiling are available. The chapter describes components able to be drawn together to provide a system of control that can be applied around a business intelligence system to enhance the quality of organisational decision making through monitoring the characteristics of arriving data and taking action when values are materially different than those expected.


2017 ◽  
Vol 1 (2) ◽  
Author(s):  
Abdul Hamid Arribathi ◽  
Maimunah Maimunah ◽  
Devi Nurfitriani

This study aims to determine the stages that must be implemented in building a Business Intelligence System structured and appropriate in building Business Intelligence Systems in an organization, and understand the important aspects that must be considered for investment development Business Intelligence System is increasing. Business must be based on the conditions and needs of the organization in achieving the desired goals. If these conditions occur, then the decision-making process will be better and more accurate. The purpose of this study is to determine the important aspects that must be understood and prepared in using the Business Intelligence System in an organization. The method used is the explanation as well as the research library of several books, articles and other literature.


Author(s):  
Lapo Mola ◽  
Cecilia Rossignoli ◽  
Andrea Carugati ◽  
Antonio Giangreco

This exploratory study analyses the effects of the technical and organisational characteristics of business intelligence systems (BIS) on knowledge sharing, collaboration, and decision-making processes. The authors conducted a two-phase multi-method investigation. First, we surveyed 30 enterprises using BIS on a regular basis; then, we engaged in an in-depth case study with one of the respondent companies. Our results show that, on average, the technical and organisational characteristics of the BIS are positively associated with an increase in knowledge sharing, leading to an improvement in internal collaboration that subsequently brings improvement in the quality of decision-making. This case study adds that the way the BIS is designed and appropriated in organisations is important in obtaining such results is. A BIS being designed so that it can be appropriated by the general employee base is key in obtaining the desired organizational impacts. This suggests some requirements for BIS design that we will discuss in terms of theoretical and managerial implications.


Author(s):  
Bashar Shahir Ahmed ◽  
Fadi Amroush ◽  
Mohammed Ben Maati

Today most of the businesses are in continuous search of sophisticated tools and techniques to progressively grow their business. And therefore, the use of intelligence systems has found its pace in the global market. The intelligence systems has mostly effected the E-CRM as it is the most critical and central part for the growth of the business. The E-CRM approaches have enhanced drastically with an integration of the business intelligence systems and organizations are now diligently striving for excellence by gaining benefit from these integrated systems. However, there are many organizations which lag behind in escalating their progress and growth as they have not yet understand how to improve the data quality by using business intelligence systems and therefore used it for decision making. Hence, the following research is conducted to study the implementation trends of Intelligence E-CRM in business process and how the business intelligence systems could help in improvising the data quality and the business processes.


Author(s):  
Bashar Shahir Ahmed ◽  
Fadi Amroush ◽  
Mohammed Ben Maati

Today, most businesses are in continuous search of sophisticated tools and techniques to progressively grow their business. Therefore, the use of intelligence systems has found its pace in the global market. The intelligence systems has mostly affected the E-CRM as it is the most critical and central part for the growth of the business. The E-CRM approaches have enhanced drastically with an integration of the business intelligence systems and organizations are now diligently striving for excellence by gaining benefit from these integrated systems. However, there are many organizations that lag behind in escalating their progress and growth as they have not yet understand how to improve the data quality by using business intelligence systems and therefore used it for decision making. Hence, the following research is conducted to study the implementation trends of intelligence E-CRM in business process and how the business intelligence systems could help in improvising the data quality and the business processes.


2015 ◽  
Vol 11 (4) ◽  
pp. 1-25 ◽  
Author(s):  
Lapo Mola ◽  
Cecilia Rossignoli ◽  
Andrea Carugati ◽  
Antonio Giangreco

This exploratory study analyses the effects of the technical and organisational characteristics of business intelligence systems (BIS) on knowledge sharing, collaboration, and decision-making processes. The authors conducted a two-phase multi-method investigation. First, we surveyed 30 enterprises using BIS on a regular basis; then, we engaged in an in-depth case study with one of the respondent companies. Our results show that, on average, the technical and organisational characteristics of the BIS are positively associated with an increase in knowledge sharing, leading to an improvement in internal collaboration that subsequently brings improvement in the quality of decision-making. This case study adds that the way the BIS is designed and appropriated in organisations is important in obtaining such results is. A BIS being designed so that it can be appropriated by the general employee base is key in obtaining the desired organizational impacts. This suggests some requirements for BIS design that we will discuss in terms of theoretical and managerial implications.


2016 ◽  
Vol 16 (3) ◽  
pp. 219-229 ◽  
Author(s):  
Daniela Borissova ◽  
Ivan Mustakerov ◽  
Dilian Korsemov

Abstract In the paper a business intelligence tool based on group decision making is proposed. The group decision making uses a combinatorial optimization modeling technique. It takes into account weighted coefficients for evaluation criteria assigned by decision makers together with their scores for the alternatives in respect of these criteria. The proposed optimization model for group decision making considers also the knowledge level of the group members involved as decision makers. This optimization model is implemented in three-layer architecture of Web application for business intelligence by group decision making. Developed Web application is numerically tested for a representative problem for software choice considering six decision makers, three alternatives and 19 evaluation criteria. The obtained results show the practical applicability and effectiveness of the proposed approach.


Author(s):  
Aleš Popovič ◽  
Jurij Jaklič

The IS literature has long highlighted the positive impact of information provided by Business Intelligence Systems (BIS) on decision-making, particularly when organizations operate in highly competitive environments. The primary purpose of implementing BIS is to utilize diverse mechanisms to increase the levels of the two Information Quality (IQ) dimensions, namely information access quality and information content quality. While researchers have traditionally focused on assessing IQ criteria, they have largely ignored the mechanisms to boost IQ dimensions. Drawing on extant literature of BIS and IQ, the research sought to understand how, at its present level of development, BIS maturity affects IQ dimensions, as well as the role that business knowledge may exert in mobilizing this link. The authors test the hypotheses across 181 medium and large organizations. Interestingly, the data describe a more complex picture than might have been anticipated.


Author(s):  
Andrea Ko

Many organizations are struggling with a vast amount of data in order to gain valuable insights and get support in their decision-making process. Decision-making quality depends increasingly on information and the systems that deliver this information. These services are vulnerable and risky from security aspects, and they have to satisfy several requirements, like transparency, availability, accessibility, convenience, and compliance. IT environments are more and more complex and fragmented, which means additional security risks. Business intelligence solutions provide assistance in these complex business situations. Their main goal is to assist organizations to make better decisions. Better decisions means that these solutions support the management of risks, and they have a key role in raising revenue and in reducing cost. The objectives of this chapter are to give an overview of the business intelligence field and its future trends, to demonstrate the most important business intelligence solutions, meanwhile highlighting their risks, business continuity challenges, and IT audit issues. In spite of the fact that this chapter focuses on the business intelligence solutions and their specialities, risk management and the related IT audit approach can be applied for other categories of information systems. IT audit guidelines, best practices, and standards are presented as well, because they give effective tools in controlling process of business intelligence systems.


Author(s):  
Shah J. Miah

The Australian farm-based businesses can be benefited from specially designed applications for cost-effective operation while maximizing profits to survive in economic and environmental crises. For decision support, existing business intelligence systems (BIS) approaches scarcely deal with specific user's provisions to adjust changing situations in decision making, without extra technical exertions. In this chapter, the authors describe a conceptual framework of tailorable BIS solution that is based on case study findings in that the highlighted requirements are relevant to address changing situations through enhancing end user's engagement. The activities of end user's engagement supported through the use of tailorable features that reinforce a shift from the traditional BIS process to a new provision where business owners can actively involve in adjusting their features to their decision support.


Sign in / Sign up

Export Citation Format

Share Document