The Process of Data Tabulation Using Data Warehouse and OLAP Technology to Sales Analysis at Distributor Company
Recently, the needs of data processing into information have a very important role, especially in the highly competitive corporate world. Here, the role of technology is required to produce information that is fast, safe, and appropriate in assisting the company process while making decision. As the development of OLAP technology in Indonesia, the study took place at PT. Sinar Niaga Sejahtera in Ambarawa, Indonesia. It will be constructed with the Data Warehouse using a Star Schema and OLAP technology based on Website to complete the companys needs about the summary of the information which was generated to analyze the company\'s sales results. The processing data into information which is emphasized in this paper is to describe in details about the data processing that will help in the learning and develop an application to build a better OLAP system.
Keywords: OLAP, Data Warehouse, Data Processing, Summary Report.
Download Full-Text
ABOUT THE AUTHORS
Febrian Wahyu Christanto
a senior student at Magister of Technology and Information System, Faculty of Information and Technology at Satya Wacana Christian University Salatiga, Indonesia. Besides studying for his Magister to achieve M.Cs degree, he is also actively working on a software house “Data Frame” in Salatiga as software engineer. He got a bachelor’s degree with a major in computer network, Faculty of Information and Technology Satya Wacana Christian University Salatiga in 2010. Research specialization of Febrian Wahyu Christanto, S.Kom is in the field of computer networking and business intelligence.
Wiranto H. Utomo
a lecture at Faculty of Information and Technology at Satya Wacana Christian University Salatiga, Indonesia. He got a Master Degree in Computer Engineering at the Gajah Mada University, Yogyakarta Computer Science in 2002 and his Ph.D at Gajah Mada University in 2011. He has published in several journals including IJCSI, IJWA, MASAUM Journals, IJCA, and International Conference including IWAS of the ACM. Research specialization of Dr. Ir. Wiranto Herry Utomo, M.Kom. is in the field of SOA, java EE, web services, and software engineering.
Eko Sediyono
a lecturer and professor at Faculty of Information and Technology at Satya Wacana Christian University Salatiga, Indonesia and Diponegoro University Semarang, Indonesia. He got a Master Degree in Computer Science at Indonesian University in 1994 and his Ph.D at Computer Science Department at Indonesian University in 2006. Prof. Dr. Ir. Eko Sediyono, M.Kom. is a member of the IEEE with member number 41605422. His research speciality is in the field of statistic, compilation techniques, algorithms, and data structure.
Febrian Wahyu Christanto
a senior student at Magister of Technology and Information System, Faculty of Information and Technology at Satya Wacana Christian University Salatiga, Indonesia. Besides studying for his Magister to achieve M.Cs degree, he is also actively working on a software house “Data Frame” in Salatiga as software engineer. He got a bachelor’s degree with a major in computer network, Faculty of Information and Technology Satya Wacana Christian University Salatiga in 2010. Research specialization of Febrian Wahyu Christanto, S.Kom is in the field of computer networking and business intelligence.
Wiranto H. Utomo
a lecture at Faculty of Information and Technology at Satya Wacana Christian University Salatiga, Indonesia. He got a Master Degree in Computer Engineering at the Gajah Mada University, Yogyakarta Computer Science in 2002 and his Ph.D at Gajah Mada University in 2011. He has published in several journals including IJCSI, IJWA, MASAUM Journals, IJCA, and International Conference including IWAS of the ACM. Research specialization of Dr. Ir. Wiranto Herry Utomo, M.Kom. is in the field of SOA, java EE, web services, and software engineering.
Eko Sediyono
a lecturer and professor at Faculty of Information and Technology at Satya Wacana Christian University Salatiga, Indonesia and Diponegoro University Semarang, Indonesia. He got a Master Degree in Computer Science at Indonesian University in 1994 and his Ph.D at Computer Science Department at Indonesian University in 2006. Prof. Dr. Ir. Eko Sediyono, M.Kom. is a member of the IEEE with member number 41605422. His research speciality is in the field of statistic, compilation techniques, algorithms, and data structure.
