EMAIL: PASSWORD:
Front Office
UPT. PERPUSTAKAAN
Institut Teknologi Sepuluh Nopember Surabaya


Kampus ITS Sukolilo - Surabaya 60111

Phone : 031-5921733 , 5923623
Fax : 031-5937774
E-mail : libits@its.ac.id
Website : http://library.its.ac.id

Support (Customer Service) :
timit_perpus@its.ac.id




Welcome..guys!

Have a problem with your access?
Please, contact our technical support below:
LIVE SUPPORT


Moh. Fandika Aqsa


Davi Wahyuni


Tondo Indra Nyata


Anis Wulandari


Ansi Aflacha




ITS » Undergraduate Theses » Teknik Informatika
Posted by hassane at 11/12/2008 15:45:57  •  6354 Views


PEMBUATAN APLIKASI OLAP PADA SISTEM INFORMASI MONITORING TUGAS AKHIR JURUSAN TEKNIK INFORMATIKA ITS DENGAN MENGGUNAKAN SQL SERVER 2005

IMPLEMENTATION OF OLAP APPLICATION FOR FINAL PROJECT MONITORING INFORMATION SYSTEM IN INFORMATICS ITS USING SQL SERVER 2005

Author :
BUDI, RIANTARI TISNA 




ABSTRAK

Multidimensional database merupakan suatu cara yang digunakan untuk melakukan analisa data guna mendukung keputusan dengan didukung oleh teknologi OLAP Online Analytical Processing yang dapat digunakan untuk membantu dalam perancangan data multidimensi. Dalam tugas akhir ini aplikasi OLAP yang dibangun berdasarkan data pada sistem informasi monitoring tugas akhir jurusan Teknik Informatika ITS. Dari sumber data tersebut akan diekstraksi dan mengumpulkannya dalam sebuah data warehouse. Selama proses ekstraksi juga dilakukan proses transformasi dengan menerapkan agregasi maupun validasi dimana proses ini juga dikenal sebagai Extract Transform dan Load ETL sehingga didapat data yang sesuai dengan kepentingan analisa. Aplikasi OLAP dibuat dengan menggunakan SQL Server 2005 Analysis Service SSAS yang menyediakan komponen aplikasi yang dapat digunakan untuk pengembangan aplikasi Business Intelligence secara cepat. Dari hasil uji coba maka aplikasi yang dibuat mampu melakukan proses analisa perhitungan data dan melakukan agregasi dari data.


ABSTRACT

Multidimensional database is a way used to conduct data analysis for decision support system supported by OLAP technology that can be used to help multidimensional data design. In this final task OLAP application that is built based on information system data monitors final task of ITSs Informatics Engineering. From this data source it will be extracted and collected in a data warehouse. In extraction process transformation process also done with implementing aggregation and validation which is this process known by Extract Transform and Load ETL so that we can get data according to analysis business. OLAP application made with using SQL Server 2005 Analysis Service SSAS that provides application component for application development of Business Intelligence quickly. From the testing result the made application can do analysis process with implementing OLAPs basic operation and data calculating aggregation from data.



KeywordsOLAP ; ETL ; Bussiness Intelligence ; SQL Server
 
Subject:  Pangkalan Data
Contributor
  1. SARWOSRI, S.Kom, MT
    Darlis Heru Murti, S. Kom
Date Create: 11/12/2008
Type: Text
Format: pdf
Language: Indonesian
Identifier: ITS-Undergraduate-3100008031081
Collection ID: 3100008031081
Call Number: RSIf 005.740 68 Bud p


Source
Undergraduate Theses of Informatics Engineering Department, RSIf 005.740 68 Bud p, 2007

Coverage
ITS Community

Rights
Copyright @2007 by ITS Library. This publication is protected by copyright and permission should be obtained from the ITS Library prior to any prohibited reproduction, storage in a retrievel system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permission(s), write to ITS Library




[ Download - Summary ]

ITS-Undergraduate-3100008031081-2851.pdf




 Similar Document...




! ATTENTION !

To facilitate the activation process, please fill out the member application form correctly and completely

Registration activation of our members will process up to max 24 hours (confirm by email). Please wait patiently

POLLING

Bagaimana pendapat Anda tentang layanan repository kami ?

Bagus Sekali
Baik
Biasa
Jelek
Mengecewakan





You are connected from 3.92.92.168
using CCBot/2.0 (https://commoncrawl.org/faq/)



Copyright © ITS Library 2006 - 2019 - All rights reserved.
Dublin Core Metadata Initiative and OpenArchives Compatible
Developed by Hassan