An architecture for ad-hoc and collaborative business intelligence

Author(s):  
Henrike Berthold ◽  
Philipp Rösch ◽  
Stefan Zöller ◽  
Felix Wortmann ◽  
Alessio Carenini ◽  
...  
Keyword(s):  
Author(s):  
Brian Stokes

Background with rationaleBusiness Intelligence (BI) software applications collect and process large amounts of data from one or more sources, and for a variety of purposes. These can include generating operational or sales reports, developing dashboards and data visualisations, and for ad-hoc analysis and querying of enterprise databases. Main AimBusiness Intelligence (BI) software applications collect and process large amounts of data from one or more sources, and for a variety of purposes. These can include generating operational or sales reports, developing dashboards and data visualisations, and for ad-hoc analysis and querying of enterprise databases. Methods/ApproachIn deciding to develop a series of dashboards to visually represent data stored in its MLM, the TDLU identified routine requests for these data and critically examined existing techniques for extracting data from its MLM. Traditionally Structured Query Language (SQL) queries were developed and used for a single purpose. By critically analysing limitations with this approach, the TDLU identified the power of BI tools and ease of use for both technical and non-technical staff. ResultsImplementing a BI tool is enabling quick and accurate production of a comprehensive array of information. Such information assists with cohort size estimation, producing data for routine and ad-hoc reporting, identifying data quality issues, and to answer questions from prospective users of linked data services including instantly producing estimates of links stored across disparate datasets. Conclusion BI tools are not traditionally considered integral to the operations of data linkage units. However, the TDLU has successfully applied the use of a BI tool to enable a rich set of data locked in its MLM to be quickly made available in multiple, easy to use formats and by technical and non-technical staff.


2013 ◽  
Vol 4 (4) ◽  
pp. 61-92 ◽  
Author(s):  
Rajendra M. Sonar

Business Intelligence (BI) includes many tools, techniques and technologies. BI processes often involve team of human decision makers and end-users to extract, explore and analyse the data. The results, decisions or models after analysis need to be implemented into operational systems. There can be considerable time delay between business events happening and action taken thus loosing opportunities. Intelligent techniques such as rule-based reasoning and case-based reasoning have been used extensively to address wide range of intelligent tasks including personalisation and recommendation. Some BI tasks can be modelled, automated and delivered through services rather than done on ad-hoc basis. The authors represent a service based approach to BI where a service corresponds to a well defined analytical functionality implemented using intelligent technique(s), filtering techniques or hybrids of them accessing only relevant data from database specifically modelled and designed for such tasks. The authors discuss an application of the approach for a value-added service in mobile domain.


2021 ◽  
Vol 18 (1) ◽  
pp. 1-23
Author(s):  
Sridevi S. ◽  
Karpagam G. R. ◽  
Vinoth Kumar B. ◽  
Uma Maheswari J.

The blockchain is an incorruptible digital ledger of economic transactions that can be programmed to record not just financial transactions but virtually everything of value. Blockchain technology makes breakthroughs in business intelligence in many areas such as banking sector, finance, judiciary, commerce, and information technology. Web service compositions have a revolutionary impact on business intelligence by enabling loose coupling, data consolidation from diverse sources, consolidation of information under a single roof, easing ad-hoc querying and reporting. The objective of current work is to investigate the applicability of blockchain for the semantic web service composition process. The paper focuses on design of conceptual architecture and the algorithm for QoS-aware semantic web service composition (SWSC) using blockchain.


2013 ◽  
Vol 60 (2) ◽  
pp. 249-257
Author(s):  
Daniel Homocianu ◽  
Dinu Airinei

Abstract This article shows most of the E -connotations when approaching the Business Intelligence (BI) field not just as methodology but also as practical implementations meant to serve as a support for organizational decisions. In the last part of the paper the focus is moved to nowadays technological possibilities and trends related to Business Intelligence. Some aspects as the specificity of BI applications, their promises, the problem of real-time response and some other limitations and resolved issues related to their capability to respond to ad-hoc organizational changes by changing their behaviour and feed-back are taken into consideration.


2019 ◽  
Vol 14 (27) ◽  
pp. 50-65
Author(s):  
Rikke Gaardboe ◽  
Tom Nyvang ◽  
Erling Jensen

Gennem de sidste 10-15 år har universitetssektoren i Danmark undergået en række reformer og forandringer. En konsekvens heraf er et behov for højere grad af styring, som blandt andet understøttes af Business Intelligence (BI). BI er et begreb, der beskriver teknologier, software og processer til at tilvejebringe og analysere data til brug for beslutningstagning. I denne artikel undersøges, hvordan universiteter kan opnå succes med BI, samt hvilken organisatorisk nytte teknologien har. Studiet viser, at jo højere systemkvalitet, des højere brugertilfredshed og mere brug af BI. Øget informationskvalitet påvirker brugertilfredsheden. Den individuelle nytte af BI påvirkes af brugertilfredshed og brug. Der opnås organisatorisk nytte ved at anvende BI til rapportering, til ad hoc-analyser samt til opfølgning på forløb. Til trods for at teknologien kan anvendes til learning analytics, er det ikke med det formål, teknologien er implementeret, men mere i relation til nøgletal for økonomisk rapportering og kvalitetsmålinger.


Author(s):  
Henrike Berthold ◽  
Philipp Rösch ◽  
Stefan Zöller ◽  
Felix Wortmann ◽  
Alessio Carenini ◽  
...  

The success of organizations and business networks depends on fast and well-founded decisions taken by the relevant people in their specific area of responsibility. To enable timely and well-founded decisions, it is often necessary to perform ad-hoc analyses in a collaborative manner involving domain experts, line-of-business managers, key suppliers, or customers. Current Business Intelligence (BI) solutions fail to meet the challenges of ad-hoc and collaborative decision support, thus slowing down and hurting organizations. To move towards ad-hoc and collaborative BI, we envision a highly scalable and flexible BI platform. The main building blocks of this platform are a flexible and efficient concept for the management of business context information, an intuitive and powerful methodology for the configuration of a BI system, a concept of an information self-service for business users over data sources within and across organizations, a collaborative decision making environment, and an architecture for the whole system that complements current BI systems.


2011 ◽  
pp. 136-256 ◽  
Author(s):  
Nikos Karayannidis ◽  
Aris Tsois ◽  
Timos Sellis

Star queries are the most prevalent kind of queries in data warehousing, OLAP and business intelligence applications. Thus, there is an imperative need for efficiently processing star queries. To this end, a new class of fact table organizations has emerged that exploits path-based surrogate keys in order to hierarchically cluster the fact table data of a star schema. In the context of these new organizations, star query processing changes radically. In this chapter, we present a complete abstract processing plan that captures all the necessary steps in evaluating such queries over hierarchically clustered fact tables. Furthermore, we realize the abstract operations in terms of physical operations over the CUBE File data structure. Finally we discuss star query optimization issues over the presented abstract plan.


Author(s):  
Matteo Golfarelli ◽  
Federica Mandreoli ◽  
Wilma Penzo ◽  
Stefano Rizzi ◽  
Elisa Turricchia

Cooperation is seen by companies as one of the major means for increasing flexibility and innovating. Business intelligence (BI) platforms are aimed at serving individual companies, and they cannot operate over networks of companies characterized by an organizational, lexical, and semantic heterogeneity. In this chapter we propose a framework, called Business Intelligence Network (BIN), for sharing BI functionalities over complex networks of companies that are chasing mutual advantages through the sharing of strategic information. A BIN is based on a network of peers, one for each company participating in the consortium. Peers are equipped with independent BI platforms that expose some querying functionalities aimed at sharing business information for the decision-making process. After proposing an architecture for a BIN, we outline the main research issues involved in its building and operating, and we focus on the definition of an ad hoc language for expressing semantic mappings between the multidimensional schemata owned by the different peers, aimed at enabling query reformulation over the network.


Sign in / Sign up

Export Citation Format

Share Document