International Journal of Engineering and Emerging Technology
Vol 5 No 2 (2020): July - December

Analysis Of Data Warehouse Design Using Powell Method

Hisyam Rahmawan Suharno (Universitas Udayana)
Nyoman Gunantara (Universitas Udayana)
Made Sudarma (Universitas Udayana)



Article Info

Publish Date
13 Dec 2020

Abstract

With the evolution in this digital era, many industrial organizations and companies have begun to move towards digitization to increase the company's business opportunities. Data is something that is very useful in a company's business. If the dataprocessed correctly can provide a variety of information needed by the company to continue to grow. Now Data also becomes digital and data processing have many techniques and can provide us with a decision support for the information generated by the data. The data processing is usually called Data Warehouse. In running a business, business owners must certainly analyze a number of things so that the business continues to run and grow, including one of which is a fabric business in Bali, namely CV Phalani Bali. CV Phalani Bali still needs a centralized system that integrates sales data from online stores and offline stores, therefore a data warehouse is needed that can help manage all these data and make it a new information needed by CV Phalani Bali. With the data warehouse, it can help the owner of CV Phalani Bali in reporting and historical information of the business they run. Helps manage historical data and provides strategic information to support evaluation and take decision analysis at the executive level. So one of the data warehouse design methods is used, is the Powell method. This Powell method focuses on the ETL (Extract, Transform, Load) process to become a data warehouse that is ready to be processed by OLAP (Online Analytical Processing). This Powell method will be assisted by Microsoft SQL Server Business Intelligence as a tool that will design and process the sales data into a data warehouse that will produce the information needed by CV Phalani Bali for analyze and make decisions to bring cv phalani bali even more advanced.

Copyrights © 2020






Journal Info

Abbrev

ijeet

Publisher

Subject

Civil Engineering, Building, Construction & Architecture Computer Science & IT Electrical & Electronics Engineering Mechanical Engineering

Description

International Journal of Engineering and Emerging Technology is the biannual official publication of the Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University. The journal is open to submission from scholars and experts in the wide areas of engineering, such as civil ...