Do Users Go Both Ways?

2010 ◽  
Vol 1 (3) ◽  
pp. 15-33
Author(s):  
Hamid Nemati ◽  
Brad Earle ◽  
Satya Arekapudi ◽  
Sanjay Mamani
Keyword(s):  
Literature Review ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Information Needs ◽  
Project Team ◽  
Market Place ◽  
Tool Selection ◽  
Road Map ◽  
Perceived Values ◽  
User Groups

A challenging task for a data warehouse team is identifying users by their information needs and skills, and then providing the BI (Business Intelligence) tools that support each group to do their job effectively and efficiently. Recent studies have shown that the BI market place is saturated with a bewildering array of capabilities, functions and software suites. The current lack of consistent interpretation of Business Intelligence has created some confusion in the market place. This paper defines a framework to identify different user groups in an organization and map their needs and requirements to the different functionalities offered by different BI tool vendors. Through literature review, clear definitions of users were created and a set of BI tools that identifies functional needs was established. From that information, a questionnaire was developed that probed for the relationships between user types, tools, functions and other perceived values. Responses from 154 professionals were then used to develop a road map for the data warehouse project team in BI tool selection.

Do Users Go Both Ways?

2012 ◽  
pp. 209-227
Author(s):  
Hamid Nemati ◽  
Brad Earle ◽  
Satya Arekapudi ◽  
Sanjay Mamani
Keyword(s):  
Literature Review ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Information Needs ◽  
Project Team ◽  
Market Place ◽  
Tool Selection ◽  
Road Map ◽  
Perceived Values ◽  
User Groups

A challenging task for a data warehouse team is identifying users by their information needs and skills, and then providing the BI (Business Intelligence) tools that support each group to do their job effectively and efficiently. Recent studies have shown that the BI market place is saturated with a bewildering array of capabilities, functions and software suites. The current lack of consistent interpretation of Business Intelligence has created some confusion in the market place. This paper defines a framework to identify different user groups in an organization and map their needs and requirements to the different functionalities offered by different BI tool vendors. Through literature review, clear definitions of users were created and a set of BI tools that identifies functional needs was established. From that information, a questionnaire was developed that probed for the relationships between user types, tools, functions and other perceived values. Responses from 154 professionals were then used to develop a road map for the data warehouse project team in BI tool selection.

A survey on recent research in business intelligence

2014 ◽  
Vol 27 (6) ◽  
pp. 831-866 ◽  
Author(s):  
Martin Aruldoss ◽  
Miranda Lakshmi Travis ◽  
V. Prasanna Venkatesan
Keyword(s):  
Literature Review ◽  
Business Intelligence ◽  
Design Methodology ◽  
Information Needs ◽  
Theoretical Perspective ◽  
Security And Privacy ◽  
Ongoing Research ◽  
Content Type ◽  
Problems And Solutions ◽  
Comprehensive Survey

Purpose – Business intelligence (BI) has been applied in various domains to take better decisions and it provides different level of information to its stakeholders according to the information needs. The purpose of this paper is to present a literature review on recent works in BI. The two principal aims in this survey are to identify areas lacking in recent research, thereby offering potential opportunities for investigation. Design/methodology/approach – To simplify the study on BI literature, it is segregated into seven categories according to the usage. Each category of work is analyzed using parameters such as purpose, domain, problem identified, solution applied, benefit and outcome. Findings – The BI contribution in various domains, ongoing research in BI, the convergence of BI domains, problems and solutions, results of congregated domains, core problems and key solutions. It also outlines BI and its components composition, widely applied BI solutions such as algorithm-based, architecture-based and model-based solutions. Finally, it discusses BI implementation issues and outlines the security and privacy policies adopted in BI environment. Research limitations/implications – In this survey BI has been discussed in theoretical perspective whereas practical contribution has been given less attention. Originality/value – A comprehensive survey on BI which identifies areas lacking in recent research and providing potential opportunities for investigation.

scholarly journals Konsolidasi Data Warehouse untuk Aplikasi Business Intelligence

2012 ◽  
Vol 3 (2) ◽  
pp. 841
Author(s):  
Rudy Rudy
Keyword(s):  
Data Warehouse ◽  
Business Intelligence ◽  
Information Needs ◽  
Information Access ◽  
Business Strategies ◽  
Corporate Leaders ◽  
Corporate Strategies ◽  
Single Presentation ◽  
Distribution Company ◽  
Using Data

As the business competition is getting strong, corporate leaders need complete data that as a basis for determining future business strategies. Similarly with management of company "A", a pharmaceutical company which has three distribution companies. Each distribution company already has a data warehouse to generate reports for each of them. For business operational and corporate strategies, chairman PT "A" requires an integrated report, so analysis of data owned by the three distribution companies can be done in a full report to answer the problems faced by the managemet. Thus, data warehouse consilidation can be used as a solution for company "A". Methodology starts with analysis of information needs to be displayed on the application of business intelligence, data warehouse consolidation, ETL (extract, transform and load), data warehousing, OLAP and Dashboard. Using data warehouse consolidation, information access by management of company "A" can be done in a single presentation, which can display data comparison between the three distribution companies.

Information Technology Usage: The Indian Experience

2004 ◽  
Vol 29 (1) ◽  
pp. 83-92 ◽  
Author(s):  
M P Gupta ◽  
Sanjay
Keyword(s):  
Decision Making ◽  
Information Technology ◽  
Supply Chain ◽  
Inventory Control ◽  
Business Intelligence ◽  
Business Strategy ◽  
Information Needs ◽  
Market Place ◽  
Business Executives ◽  
Strategy Transformation

This paper attempts to understand the current state of Information Technology (IT) usage in select Indian organizations based on a questionnaire survey of business executives and IS staff of select IT-savvy organizations. In recent years, rapid changes and developments in the IT domain have created new leaders in the market place. Corporates, the world over, are leveraging on these developments through efficient supply chain, inventory control, and business intelligence applications for gaining an edge over their competitors. The Information System (IS) developed by these organizations is non-replicable thus providing the differentiation. Though Indian companies are aware of concepts such as supply chain, inventory control, etc., the actual implementation of such concepts is not that widespread. Also, the IS function in India is yet to establish itself as a mainstream business function. It is in this context that this paper makes an effort to understand the importance of IT as a key driver for business strategy and recommend to the industry to adopt some of the best practices prevailing in organizations worldwide. The analysis of the responses indicates that there is a discrepancy between the opinions of business executives and IS staff regarding the adequacy of the current IT systems. This situation can be remedied by implementing some of the suggestions which are as follows: The business executives and the IS staff should be located in the same place to integrate IT into the mainstream of business. Business intelligence application needs to be included in the portfolio of applications for business use. The Indian industry needs to be stepped up to the ‘informate’ stage as it is still in the ‘automate’ stage. CIOs have to play an important role by linking IT to business strategy. Information needs of the executives are increasing and necessary steps for imple- menting data warehousing and OLAP solutions need to be taken. Supporting IS should be put in place to facilitate decision-making. Key performance indicators (KPIs) should be clearly identified and incorporated into the IS to monitor the health of the organization. These initiatives are expected to have the following implications: tighter integration of IT with business strategy transformation from the ‘informate mode’ to the ‘transformate’ mode implementation of newer business intelligence tools development of information-based decision-making culture better understanding of organization's KPIs by the IS staff.

scholarly journals Model Data Warehouse dan Business Intelligence untuk Meningkatkan Penjualan pada PT. S

2011 ◽  
Vol 2 (1) ◽  
pp. 418
Author(s):  
Rudy Rudy ◽  
Natalia Limantara
Keyword(s):  
Data Warehouse ◽  
Business Intelligence ◽  
Information Needs ◽  
Historical Data ◽  
Database System ◽  
Model Data ◽  
Strategic Decisions ◽  
Decision Making Processes ◽  
Points Of View ◽  
Intelligence Application

Today a lot of companies use information system in every business activity. Every transaction is stored electronically in the database transaction. The transactional database does not help much to assist the executives in making strategic decisions to improve the company competitiveness. The objective of this research is to analyze the operational database system and the information needed by the management to design a data warehouse model which fits the executive information needs in PT. S. The research method uses the Nine-Step Methodology data warehouse design by Ralph Kimball. The result is a data warehouse featuring business intelligence applications to display information of historical data in tables, graphs, pivot tables, and dashboards and has several points of view for the management. This research concludes that a data warehouse which combines multiple database transactions with business intelligence application can help executives to understand the reports in order to accelerate decision-making processes. 

Evolutionary Intelligent Data Warehousing Approach to Knowledge Discovery Systems: Dynamic Cubing

2019 ◽  
Vol 13 ◽  
Author(s):  
Harkiran Kaur ◽  
Kawaljeet Singh ◽  
Tejinder Kaur
Keyword(s):  
Knowledge Discovery ◽  
Data Warehouse ◽  
Business Intelligence ◽  
End Users ◽  
Processing Stage ◽  
Information Update ◽  
On Line ◽  
Analytical Processing ◽  
Warehouse Operations ◽  
Made In

Background: Numerous E – Migrants databases assist the migrants to locate their peers in various countries; hence contributing largely in communication of migrants, staying overseas. Presently, these traditional E – Migrants databases face the issues of non – scalability, difficult search mechanisms and burdensome information update routines. Furthermore, analysis of migrants’ profiles in these databases has remained unhandled till date and hence do not generate any knowledge. Objective: To design and develop an efficient and multidimensional knowledge discovery framework for E - Migrants databases. Method: In the proposed technique, results of complex calculations related to most probable On-Line Analytical Processing operations required by end users, are stored in the form of Decision Trees, at the pre- processing stage of data analysis. While browsing the Cube, these pre-computed results are called; thus offering Dynamic Cubing feature to end users at runtime. This data-tuning step reduces the query processing time and increases efficiency of required data warehouse operations. Results: Experiments conducted with Data Warehouse of around 1000 migrants’ profiles confirm the knowledge discovery power of this proposal. Using the proposed methodology, authors have designed a framework efficient enough to incorporate the amendments made in the E – Migrants Data Warehouse systems on regular intervals, which was totally missing in the traditional E – Migrants databases. Conclusion: The proposed methodology facilitate migrants to generate dynamic knowledge and visualize it in the form of dynamic cubes. Applying Business Intelligence mechanisms, blending it with tuned OLAP operations, the authors have managed to transform traditional datasets into intelligent migrants Data Warehouse.

Expand Excellence: Business Intelligence Tools for Drilling Data Analysis as Enhanced Efficiency Approach

2021 ◽  
Author(s):  
Farit Rakhmangulov ◽  
Andrey Garipov ◽  
Mikhail Chertenkov
Keyword(s):  
Programming Languages ◽  
Business Intelligence ◽  
Data Model ◽  
Information Needs ◽  
Horizontal Section ◽  
Report Generation ◽  
Suggested Approach ◽  
Drilling Data ◽  
Main Driver ◽  
Key Issues

Abstract The business intelligence tools allow you to work with databases containing historical drilling records. This gives a possibility to collect data into a single visualized shell, to see patterns, and, most importantly, to identify the main issues. A database among Yamal region projects was taken as an example. This process automation allows you to reduce the time for collecting information and makes it possible to conduct a more detailed and thoughtful analysis of project indicators. In turn, this results in making quick and effective decisions. At the initial stage, historical drilling data over three years was analyzed, namely information on more than 800 drilling runs. A model was formed from various sources in reliance on the database, and a visual working dashboard of the project was compiled. The dashboard allowed us to recognize the main issues that were plain to see. Awareness of plain-to-see issues gives the possibility to find out what information needs to be added to the data model in order to perform more thoughtful analysis. Collecting all the data in one place is not enough. In order to bring the data together, they were collated and visualized in the most explicit way. The bulk data collected in a single model allowed us to see the whole picture of what was happening on the project and to concentrate on solving the root problem. Major issues resulted in equipment failures due to vibrations in the horizontal section. A more detailed vibration analysis showed that the bit was the main driver of vibrations. Hence, the data on rock strength and bottom hole assembly (BHA) vibrations were added to the model for further analysis. However, the complete package of data does not guarantee success. It becomes problematic to see the patterns in some situations, since analogous wells are not always available. While business intelligence tools make it easy to manage filters and find analogy, that is only fair if you have enough offset data. Based on the analysis, the most efficient bit designs were selected and proposed. The updated range of bits allowed to increase ROP in the horizontal section and reduced failures due to vibrations, so the well construction cycle was shortened. These tools are accessible for technicians, which means there is no need-to-know programming languages. Suggested approach allows to accelerate decision-making and identification of key issues. In addition, existing tools give the possibility to monitor key performance indicators continuously within a single project as well as throughout the country. In contrast to the well-known program with tables, the main advantage is the automatic update of the already built data model. This fact speeds up the analytical process and report generation by times.

scholarly journals A first step towards service-dominant logic as a new approach to overcome challenges in business intelligence

2014 ◽  
Vol 17 (2) ◽  
pp. 220-231
Author(s):  
Pamela Clavier ◽  
Hugo Lotriet ◽  
Johan Van Loggerenberg
Keyword(s):  
Literature Review ◽  
South African ◽  
Business Intelligence ◽  
New Approach ◽  
High Expectations ◽  
Dominant Logic ◽  
Interpretive Case Study ◽  
Research Findings ◽  
Banking Institution

High expectations are set for Business Intelligence (BI), yet it fails to consistently deliver accordingly: there are numerous reports of BI challenges and failures. Existing approaches to address BI challenges are largely found to be ineffective, highlighting the need for a new approach. This paper examines how BI is perceived or understood and establishes that, firstly, BI is inherently grounded in Goods-Dominant (G-D) logic and secondly, that this can be linked to the challenges that are experienced within BI. A recommendation is made for a shift to Service-Dominant (S-D) logic as a new avenue of exploration to assist in overcoming BI’s prevailing challenges. Identifying the inherent G-D logic in BI provides the first step necessary in making this shift. Research findings are based on an interpretive case study of a South African Banking institution as well as a literature review.

Sign in / Sign up

Export Citation Format

Share Document