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. 

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.

scholarly journals Business Intelligence Applications; sustaining Retail Businesses in Rivers State, Nigeria

2021 ◽  
Vol 04 (03) ◽  
Author(s):  
Patrick N Nwinyokpugi ◽  
Keyword(s):  
Data Mining ◽  
Performance Management ◽  
Data Warehouse ◽  
Data Visualization ◽  
Business Intelligence ◽  
Business Sustainability ◽  
Retail Business ◽  
Retail Outlets ◽  
Rivers State ◽  
Intelligence Application

The contemporary retail outlets are no more run by manual practices given the electronic nature of company to customers (C-C); customers to customers (C-C) transactions globally. The application of business intelligence has given an edge to retail outlets operation. This study therefore, strives to examine the relationship between business intelligence application and retail business sustainability in Rivers State, Nigeria. The study used descriptive research technique through the adoption of cross- sectional survey design. Nine judgmentally sampled retail outlets especially large scale malls & superstores were studied in Port Harcourt base on their inherent electronic driven operations. Using structured closed ended questionnaire, 45 census senior managers of these sampled retail outlets were studied. Data gathered were analysed using the Pearson Product Moment Correlation Coefficient (PPMCC) statistics and presented with the aid of SPSS version 20.0 for easy interpretation. The results of analysed data showed that, the dimensions of business intelligence application which included but not limited to customers’ performance management, data warehouse, data mining and advanced data visualization significantly correlated positively with the measures of retail business sustainability being profitability and customers’ patronage. The finding also showed a high moderating effect of organizational culture on business intelligence application and retail business sustainability in Rivers State, Nigeria. Relying on the empirical findings, the study concluded that business intelligence application has positive significant relationship with retail business sustainability. It is therefore recommended that, the dimensions of business intelligence: customers’ performance management, data warehouse, data mining & advance data visualization identified in this study should be utilized as it enhances retail business operational sustainability.

What Role is "Business Intelligence" Playing in Developing Countries? A Picture of Brazilian Companies

2010 ◽  
pp. 1846-1866
Author(s):  
Maira Petrini ◽  
Marlei Pozzebon
Keyword(s):  
Decision Making ◽  
Developing Countries ◽  
Business Intelligence ◽  
Information Needs ◽  
Business Processes ◽  
Developed Countries ◽  
It Use ◽  
Decision Making Processes ◽  
Technological Platform ◽  
Available Information

Constant technological innovation and increasing competitiveness make the management of information a considerable challenge, requiring decision-making processes built on reliable and timely information from internal and external sources. Although available information increases, this does not mean that people automatically derive value from it. After years of significant investment to establish a technological platform that supports all business processes and strengthens the operational structure’s efficiency, most organizations are supposed to have reached a point where the implementation of information technology (IT) solutions for strategic purposes becomes possible and necessary. This explains the emergence of “business intelligence” (BI); a response to information needs for decision-making through intensive IT use. This chapter looks at BI projects in developing countries – specifically, in Brazil. If the management of IT is a challenge for companies in developed countries, what can be said about organizations struggling in unstable contexts such as those often prevailing in developing countries?

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.

scholarly journals DataWarehouse Design Acceptance of Goods In PT Transmart Using Tools Pentaho and Tableu

2018 ◽  
Vol 1 (2) ◽  
Author(s):  
Syam Gunawan
Keyword(s):  
Data Warehouse ◽  
Business Intelligence ◽  
Design Method ◽  
Graphical Display ◽  
Central Park ◽  
Purchase Order ◽  
Analytical Processing ◽  
Points Of View ◽  
Existing Data ◽  
Analyze Data

The purpose of this research is to process the data of receipt of goods at PT Transmart Central Park, analyze the existing database in the information system of receipt of goods to get the necessary information and design the data warehouse to integrate the existing data so that obtained information to take a decision. Business Intelligence (BI) is one of information technology that can be solution to collect, store and analyze company data. Online Analytical Processing (OLAP) consists of a set of tools in use to help the process of analysis and comparison of data in the database. OLAP tools and methods help users analyze data in a data warehouse by providing a variety of dynamic graphical display data. The data warehouse design method is implemented by applying the 9 steps (Nine-Step Methodology) used by Ralph Kimball in designing the star scheme. The results achieved are data warehouse that provides the desired information and provide summary information in the form of tables and charts, can be compared between the purchase order data with receiving report is global, relevant, and integrated that can be seen from various points of view so useful for the leaders to make a decision.Keywords  : Bussinesn Intelligent,Datawarehouse,OlapNine-Step Methodology

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.

Commercial and Open Source Business Intelligence Platforms for Big Data Warehousing

2019 ◽  
pp. 158-181 ◽  
Author(s):  
Jorge Bernardino ◽  
Joaquim Lapa ◽  
Ana Almeida
Keyword(s):  
Decision Making ◽  
Big Data ◽  
Decision Support ◽  
Comparative Analysis ◽  
Open Source ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Selection Process ◽  
Decision Making Processes ◽  
Big Data Warehouse

A big data warehouse enables the analysis of large amounts of information that typically comes from the organization's transactional systems (OLTP). However, today's data warehouse systems do not have the capacity to handle the massive amount of data that is currently produced. Business intelligence (BI) is a collection of decision support technologies that enable executives, managers, and analysts to make better and faster decisions. Organizations must make good use of business intelligence platforms to quickly acquire desirable information from the huge volume of data to reduce the time and increase the efficiency of decision-making processes. In this chapter, the authors present a comparative analysis of commercial and open source BI tools capabilities, in order to aid organizations in the selection process of the most suitable BI platform. They also evaluated and compared six major open source BI platforms: Actuate, Jaspersoft, Jedox/Palo, Pentaho, SpagoBI, and Vanilla; and six major commercial BI platforms: IBM Cognos, Microsoft BI, MicroStrategy, Oracle BI, SAP BI, and SAS BI & Analytics.

What Role is "Business Intelligence" Playing in Developing Countries? A Picture of Brazilian Companies

2009 ◽  
pp. 239-259 ◽  
Author(s):  
Maira Petrini ◽  
Marlei Pozzebon
Keyword(s):  
Decision Making ◽  
Developing Countries ◽  
Business Intelligence ◽  
Information Needs ◽  
Business Processes ◽  
Developed Countries ◽  
It Use ◽  
Decision Making Processes ◽  
Technological Platform ◽  
Available Information

Constant technological innovation and increasing competitiveness make the management of information a considerable challenge, requiring decision-making processes built on reliable and timely information from internal and external sources. Although available information increases, this does not mean that people automatically derive value from it. After years of significant investment to establish a technological platform that supports all business processes and strengthens the operational structure’s efficiency, most organizations are supposed to have reached a point where the implementation of information technology (IT) solutions for strategic purposes becomes possible and necessary. This explains the emergence of “business intelligence” (BI); a response to information needs for decision-making through intensive IT use. This chapter looks at BI projects in developing countries – specifically, in Brazil. If the management of IT is a challenge for companies in developed countries, what can be said about organizations struggling in unstable contexts such as those often prevailing in developing countries?

scholarly journals Business Intelligence Application For Campaign Magagement In The Retail Sector

2018 ◽  
Vol 1 (1) ◽  
pp. 8-25
Author(s):  
Erdal AKGÜL ◽  
Mutlu Tahsin ÜSTÜNDAĞ ◽  
Mustafa TANRIVERDİ
Keyword(s):  
Decision Making ◽  
Information Technology ◽  
Business Intelligence ◽  
Information Technologies ◽  
Retail Sector ◽  
Decision Making Processes ◽  
Sample Application ◽  
Intelligence Application

Access to and retain information has become easier with the emergence of information technology. All of the processes of analyzing the data of the enterprises by using information technologies and making them more meaningful and useful are called business intelligence. It will be very useful for enterprises to benefit from business intelligence solutions in marketing, campaigning and decision-making processes. In this study, business intelligence concept and the required infrastructure for benefiting from business intelligence applications were examined. According to the investigation, a sample application for retail sector was developed as well as how the businesses will benefit from business intelligence applications and its contributions to the applied sectors were emphasized.

scholarly journals Perancangan Data Warehouse Pada Software Laboratory Center

2010 ◽  
Vol 1 (2) ◽  
pp. 585
Author(s):  
Alvin Chandra
Keyword(s):  
Data Warehouse ◽  
System Analysis ◽  
Design Method ◽  
Global Information ◽  
Strategic Decisions ◽  
Design Data ◽  
Analysis And Design ◽  
Running System ◽  
Star Schema ◽  
Points Of View

The purpose of this study is to analyze the existing database on Software Laboratory Center to obtain necessary information and design data warehouse to integrate existing data to obtain some global information. The methods used are analysis and design method. The method of analysis is done by conducting surveys and analysis of the running system, analysis and identification the weaknesses of the running system, and troubleshooting analysis. And the data warehouse design method is done by applying the nine steps (Nine-Step Methodology) that used by Ralph Kimball's to design star schema. The result is data warehouse that provides some global information which global, relevant, and integrated which can be seen from various points of view that is useful for the leaders to make decisions. Separate data warehouse from operational databases that already exist required by Software Laboratory Center to assist leaders in making strategic decisions in a fast and precise way. 

Sign in / Sign up

Export Citation Format

Share Document