Making sense of business intelligence : proposing a socio-technical framework for improved decision making in not-for-profit organisations

The authors of this paper argue that human intuition alone cannot be relied upon for strategic decision making in today’s business environment and that quality data intelligence is an imperative. The proposed project described in this paper is research-in-progress, action design research (ADR), to implement an appropriate information systems (IS) enabling enhanced organisational decision making. ADR is a new research method that draws on action research and design research in an organisational setting. In phase 1 of the project, a sociotechnical ‘sense-making’ approach is used to gather and analyse information and decision needs in a not-for-profit (NFP) association, Connections ACT. In phase 2, requirements are designed and modelled to build a conceptual framework that guides NFPs in improving business performance and reporting capability. Phase 3 is the evaluative stage when the framework is reflected upon and refined, with intervention in the organisation’s processes as a promising outcome.

Data warehouse design and legal visualization – the applicability of H2 for reporting

The steady increase of regulations and its acceleration due to the financial crisis heavily affect the management of regulatory compliance. Regulations, such as Basel III and Solvency II particularly impact data warehouses and lead to many organizational and technical changes. From an IS perspective modeling techniques for data warehouse requirement elicitation help to manage conceptual requirements. From a legal perspective attempts to visualize regulatory requirements – so called legal visualization approaches – have been developed. This paper investigates whether a conceptual modeling technique for regulatory-driven data warehouse requirements is applicable for representing data warehouse requirements in a legal environment. Applying the modeling technique H2 for Reporting in three extensive modeling projects provides three contributions. First, evidence for the applicability of a modeling technique for regulatory-driven data warehouse requirements is given. Second, lessons learned for further modeling projects are provided. Third, a discussion towards a combined perspective of information modeling and legal visualization is presented.

Data warehouse e cruscotto direzionale per l'analisi del personale in un'azienda di servizi

Obiettivo della tesi è la progettazione e lo sviluppo di un sistema di BI e di relativa reportistica per un'azienda di servizi. Il tutto realizzato mediante la suite Microsoft Business Intelligence.

Enrichment of the Phenotypic and Genotypic Data Warehouse analysis using Question Answering systems to facilitate the decision making process in cereal breeding programs

Currently there are an overwhelming number of scientific publications in Life Sciences, especially in Genetics and Biotechnology. This huge amount of information is structured in corporate Data Warehouses (DW) or in Biological Databases (e.g. UniProt, RCSB Protein Data Bank, CEREALAB or GenBank), whose main drawback is its cost of updating that makes it obsolete easily. However, these Databases are the main tool for enterprises when they want to update their internal information, for example when a plant breeder enterprise needs to enrich its genetic information (internal structured Database) with recently discovered genes related to specific phenotypic traits (external unstructured data) in order to choose the desired parentals for breeding programs. In this paper, we propose to complement the internal information with external data from the Web using Question Answering (QA) techniques. We go a step further by providing a complete framework for integrating unstructured and structured information by combining traditional Databases and DW architectures with QA systems. The great advantage of our framework is that decision makers can compare instantaneously internal data with external data from competitors, thereby allowing taking quick strategic decisions based on richer data.

Towards a situation-awareness-driven design of operational business intelligence & analytics systems

With the swamping and timeliness of data in the organizational context, the decision maker’s choice of an appropriate decision alternative in a given situation is defied. In particular, operational actors are facing the challenge to meet business-critical decisions in a short time and at high frequency. The construct of Situation Awareness (SA) has been established in cognitive psychology as a valid basis for understanding the behavior and decision making of human beings in complex and dynamic systems. SA gives decision makers the possibility to make informed, time-critical decisions and thereby improve the performance of the respective business process. This research paper leverages SA as starting point for a design science project for Operational Business Intelligence and Analytics systems and suggests a first version of design principles.

Implementação de uma solução open source de Business Intelligence com metodologia Ágil

A importância dos sistemas de data warehousing e business intelligence é cada vez mais pronunciada, no sentido de dotar as organizações com a capacidade de guardar, explorar e produzir informação de valor acrescido para os seus processos de tomada de decisão. Esta realidade é claramente aplicável aos sectores da administração pública portuguesa e, muito em particular, aos organismos com responsabilidades centrais no Ministério da Saúde. No caso dos Serviços Partilhados do Ministério da Saúde (SPMS), que tem como missão prover o SNS de sistemas centrais de business intelligence, o apelo dos seus clientes, para que possam contar com capacidades analíticas nos seus sistemas centrais, tem sido sentido de forma muito acentuada. Todavia, é notório que, tanto os custos, como a complexidade, de grande parte destes projetos têm representado uma séria ameaça à sua adoção e sucesso. Por um lado, a administração pública tem recebido um forte encorajamento para integrar e adotar soluções de natureza open source (modelo de licenciamento gratuito), para os seus projetos de sistemas de informação. Por outro lado, temos vindo a assistir a uma vaga de aceitação generalizada de novas metodologias de desenvolvimento de projetos informáticos, nomeadamente no que diz respeito às metodologias Agéis, que se assumem como mais flexíveis, menos formais e com maior grau de sucesso. No sentido de averiguar da aplicabilidade do open source e das metodologias Ágeis aos sistemas de business intelligence, este trabalho documenta a implementação de um projeto organizacional para a SPMS, com recurso a ferramentas open source de licenciamento gratuito e através de uma metodologia de desenvolvimento de natureza Ágil.

Sistema d'anàlisi financer: tresoreria amb eines Business Intelligence

El projecte tracte d' implementar una solució de Business Intelligence sota la plataforma Microsoft.Aquest projecte va destinat al Departament de Comptabilitat de l' Ajuntament de Cambrils, i està relacionat amb la funció del control de les despeses i els ingressos

A design for business intelligence service in demand driven supply chain management

This paper discusses the problems inherent within traditional supply chain management's forecast and inventory management processes arising when tackling demand driven supply chain. A demand driven supply chain management architecture developed by Orchestr8 Ltd., U.K. is described to demonstrate its advantages over traditional supply chain management. Within this architecture, a metrics reporting system is designed by adopting business intelligence technology that supports users for decision making and planning supply activities over supply chain health.

A brief review of recent research trends on applications of computational and statistical techniques in financial and business intelligence

Artificial neural networks and statistical techniques like decision trees, discriminant analysis, logistic regression and survival analysis play a crucial role in Business Intelligence. These predictive analytical tools exploit patterns found in historical data to make predictions about future events. In this paper we have shown some recent developments of a few of these techniques in financial and business intelligence applications like fraud detection, bankruptcy prediction and credit rating scoring.

Empirical investigation of critical success factors for implementing business intelligence systems in multiple engineering asset management organisations

Engineering asset management organisations (EAMOs) are increasingly motivated to implement business intelligence (BI) systems in response to dispersed information environments and compliance requirements. However, the implementation of a business intelligence (BI) system is a complex undertaking requiring considerable resources. Yet, so far, there are few defined critical success factors (CSFs) to which management can refer. Drawing on the CSFs framework derived from a previous Delphi study, a multiple-case design was used to examine how these CSFs could be implemented by five EAMOs. The case studies substantiate the construct and applicability of the CSFs framework. These CSFs are: committed management support and sponsorship, a clear vision and well-established business case, business-centric championship and balanced team composition, a business-driven and iterative develop ment approach, user-oriented change management, a business-driven, scalable and flexible technical framework, and sustainable data quality and integrity. More significantly, the study further reveals that those organisations which address the CSFs from a business orientation approach will be more likely to achieve better results.

A SOA-driven business intelligence architecture

A business intelligence architecture comprises of different unique components to collect, transform, analyze and present the structured and unstructured raw data in simple formats to assist decision makers in making timely decisions. The introduction of service-oriented architecture (SOA) enables reusable services which are accessible over a network on demand. However, there is still a lack of academic literatures on the business intelligence architecture with service-oriented concept. Based upon various references on BI architectures from major vendors, a novel BI architecture that is built on service-oriented concept is presented and described in this paper. The proposed service-oriented architecture enables enterprises to deploy a more agile, flexible, cheaper, reusable, reliable and responsive BI applications in supporting decision making process.

A maturity model of enterprise business intelligence

The implementation of an enterprise-level business intelligence initiative is a large-scale and complex undertaking, involving significant expenditure and multiple stakeholders over a lengthy period. It is therefore imperative to have systematic guidelines for business intelligence stakeholders in referring business intelligence maturity levels. Draw upon the prudent concepts of the Capability Maturity Model, this research proposes a multi-dimensional maturity model with distinct maturity levels for managing enterprise business intelligence initiatives. The maturity model, named Enterprise Business Intelligence Maturiy (EBIM), consists of five core maturity levels and four key dimensions, namely information quality, master data management, warehousing architecture, and analytics. It can be used to assist enterprises in benchmarking their business intelligence maturity level and identifying the critical areas to attain higher level of maturity.