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.

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 Mapping Student Data Using Data Warehouse for Promotion at Vocational High School of Z

2020 ◽  
Vol 3 (2) ◽  
pp. 55
Author(s):  
Khoirudin Eko Nurcahyo ◽  
Sucipto Sucipto ◽  
Arie Nugroho
Keyword(s):  
High School ◽  
Data Warehouse ◽  
Junior High School ◽  
Business Intelligence ◽  
Junior High ◽  
Vocational High School ◽  
Dimensional Modeling ◽  
Education Organization ◽  
Using Data ◽  
Analyze Data

<em>The purpose of this study is provide data warehouse modeling which make executive of school can analyze data easily, the problem is executive of school are analysis list registrant list difficulty, what the most and least registrant junior high school come from and the major which most and least registrant. This study do is because how important data management on education organization and how the data can be managed better. The study use descriptive quantitative method research and use 4 step data warehouse dimensional modeling by Kimball. On building data warehouse used ETL, data be extracted and transformed into data warehouse as dimension and fact. For next data be imported and be showed by web base business intelligence app. The result of this study is an web base business intelligence app which can show sum of registrant on gender, majors, junior high school graduate come from, recommendation and register year. Data warehouse is good at data analyzing for decision making, because data warehouse can show information quickly and accurate.</em>

scholarly journals Rancang Bangun Real-Time Business Intelligence Untuk Subjek Kegiatan Akademik pada Universitas Menggunakan Change Data Capture

2014 ◽  
Vol 5 (2) ◽  
Author(s):  
Stephanie Pamela Adithama
Keyword(s):  
Real Time ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Data Capture ◽  
Strategic Decision ◽  
Change Data Capture ◽  
Multiple Data ◽  
Academic Activities ◽  
Using Data ◽  
Unit Unit

Abstract. The running of academic activities in university continuously adds more data to the existing operational system. The data are not ready for the university strategic decision making, preparing reports for accreditation purposes and academic units. Real-time business intelligence application using data warehouse can become a solution for data analysis. The process of creating a data warehouse includes designing data warehouse, retrieving academic data from multiple data sources, extracting, transforming, loading (ETL) process, creating cube; and generating report. ETL processes are conducted by using a Pull Change Data Capture approach so that data changes during a certain period can be transferred in real-time. The higher the frequency of data change requests brings us closer to real-time and requires less time than loading all the data.Keywords: real-time, business intelligence, data warehouse, academic, change data capture Abstrak.  Kegiatan akademik di universitas berjalan terus menerus dan semakin menambah banyak data pada sistem operasional yang sudah ada. Data tersebut masih belum dapat dimanfaatkan oleh pihak universitas dalam pengambilan keputusan strategis, pembuatan laporan untuk keperluan akreditasi dan unit-unit akademik. Aplikasi real-time business intelligence menggunakan data warehouse menjadi solusi untuk analisa data. Proses pembuatan data warehouse meliputi perancangan data warehouse; pengambilan data akademik dari sumber data; proses extraction, transformation, loading (ETL); pembuatan cube; dan pembuatan laporan. Proses ETL dilakukan menggunakan pendekatan Change Data Capture Pull agar perubahan data selama periode tertentu dapat dipindahkan secara real-time. Semakin tinggi frekuensi permintaan perubahan data akan semakin mendekati real-time dan semakin membutuhkan waktu yang singkat dibandingkan dengan me-load semua data.Kata Kunci: real-time, business intelligence, data warehouse, akademik, change data capture

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 BUSINESS INTELLIGENCE MODELLING FOR GRADUATE ENTREPRENEUR PROGRAMME

2014 ◽  
Author(s):  
Muhamad Shahbani Abu Bakar ◽  
Azman Ta’a
Keyword(s):  
Business Intelligence ◽  
Information Needs ◽  
Accurate Information ◽  
Application Development ◽  
Meaningful Information ◽  
Rapid Application Development ◽  
Data Store ◽  
Using Data ◽  
Ministry Of Higher Education ◽  
Operational Data

Business Intelligence (BI), which is the process of collecting, analysing, and transforming data using Data Warehouse (DW) is seen as one of the growing approaches to provide meaningful information for the Malaysian Ministry of Higher Education (MOHE). MOHE is responsible for managing various activities to encourage graduate entrepreneurs to venture into businesses and ensure that the country has many successful entrepreneurs. Therefore, systematic and accurate information needs to be available for planning, implementing, and monitoring entrepreneurs’ performances. This paper proposes the modelling and designing of the graduate entrepreneur profi le system – Intelligent Profi le Analysis Graduate Entrepreneur (iPAGE) using the BI approach. Two main methodologies were used, namely the Requirements Centric Operational Data Store (ReCODS) and the Rapid Application Development (RAD) to model and design this system. The iPAGE was validated and evaluated by users, entrepreneurs’ personnel and DW experts. Indeed, the approach will be used to benchmark the development of an entrepreneurial information system in the future.  

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.

Sign in / Sign up

Export Citation Format

Share Document