Hasil Pencarian  ::  Simpan CSV :: Kembali

"Penelitian ini mengangkat permasalahan mengenai belum adanya suatu bentuk pelaporan tentang status penjualan dan rincian penjualan dari sales group secara cepat dan ringkas. Tujuan penelitian ini ialah mengimplementasikan data warehouse dan aplikasi dashboard serta proses OLAP guna pelaporan status penjualan. Metodologi penelitian diawali dengan proses perumusan masalah dan pertanyaan penelitian, tinjauan pustaka, pengumpulan data, analisis kebutuhan informasi, arsitektur data warehouse, perancangan data warehouse, perancangan dashboard informasi dan ditutup dengan kesimpulan dan saran. Metodologi substansi untuk perancangan data warehouse akan mengikuti proses dari Ralph Kimball untuk industri retail. Hasil penelitian ini adalah data warehouse terhadap data penjualan lengkap dengan aplikasi pelaporan berbasis web dari proses OLAP dan aplikasi dashboard yang menampilkan perkembangan penjualan sales group dari waktu ke waktu dalam tampilan grafik.

---

This study starts with the issue about the lack of the reporting form that can give information about sales status and details of sale from sales group in a fast and concise way. The purpose of this study is to implement a data warehouse and dashboard application, also with OLAP process to formulate sales status report. The research methodology in this study starts with the process of formulating of the problem and research question, literature review, data collection, needs analysis, data warehouse architecture, data warehouse design, business intelligence dashboard design and ended with conclusions and suggestions. The substance methodology for designing the data warehouse follows the process of Ralph Kimball’s data warehouse design methodology for retail industry. The result of this study are data warehouse of sales data, web-based reporting application from OLAP process and also a dashboard application that shows sales growth over time in a graphical display."

"Direktorat Jenderal Perbendaharaan sebagai perpanjangan fungsi dari Menteri Keuangan dalam bidang pelaksanaan anggaran, saat ini sedang melakukan proses piloting aplikasi SAKTI. Aplikasi SAKTI merupakan sebuah sistem aplikasi berbasis ERP yang merangkum proses perencanaan anggaran sampai dengan proses pelaporannya. Sebagai aplikasi yang digunakan oleh mitra kerja, SAKTI memiliki data secara mendetail atas kinerja pelaksanaan dan pelaporan anggaran pada tingkat satuan kerja. Dikarenakan data yang tersimpan cukup besar, diperlukan suatu sistem yang dapat digunakan untuk melakukan analisis serta menampilkan data historis yang terdapat pada aplikasi SAKTI. Penggunaan data warehouse dapat menjadi alat untuk melakukan analisis atas data yang tersimpan. Selain itu dengan penggunaan teknologi business intelligence seperti Dashboard dapat menjadi bahan masukan bagi pemangku kebijakan baik dari sisi DJPb sebagai pemangku kebijakan maupun dari sisi satuan kerja sebagai pengguna SAKTI. Metodologi yang digunakan dalam proses pengembangan data warehouse adalah metodologi Kimball. Proses analisis kebutuhan dilaksanakan dengan pendekatan campuran dimana kebutuhan organisasi yang tercantum pada rencana strategis disandingkan dengan kebutuhan pengguna. Alat bantu pada penelitian ini adalah Talend Open Studio untuk melakukan integrasi data dan Metabase sebagai alat presentation view. Proses integrasi atas data SAKTI maupun dari data pendukung seperti data RKAKL menghasilkan sebuah prototype DW yang dapat digunakan untuk menampilkan data maupun melakukan analisis atas data pelaksanaan anggaran. Presentation view yang dibuat dapat digunakan untuk memberikan gambaran mengenai pelaksanaan anggaran pada data sistem SAKTI.

---

Directorate General of Treasury is an extension of the function of the Minister of Finance in the budget execution process, currently conducting a pilot process of SAKTI. SAKTI is an ERP based system that will summarize the budget management from planning process up to the reporting process. The application will be used by partners, SAKTI will have detailed data on the performance of implementation and budget reporting at the unit level.With considerable data stored, we need a system that can be used to perform analysis and display existing historical data in SAKTI. Data warehouse can be used as a tool to perform analysis of stored data. In addition, the use of business intelligence technology such as dashboard can be an input for policy makers both from the side of DJPb as a decision maker as well as from the work unit as a user of SAKTI.The methodology used in the data warehouse development process is the Kimball methodology. The needs analysis process is carried out with a mixed approach whereby the organizational needs listed on the strategic plan are juxtaposed with the needs of the users. The tool in this research is Talend Open Studio to perform data integration and Metabase as presentation view tool. The integration process of SAKTI data as well as from supporting data such as RKAKL data resulted in a DW prototype that can be used to display data as well as to analyze data on budget execution. The presentation view created can be used to provide an overview of budget execution on the SAKTI system data."

"ABSTRAKPT XYZadalah perusahaan yang bergerak di industri otomotif dan dikenal sebagai agen tunggal pemegang merk (ATPM) untuk merk kendaraan niaga kelas dunia asal negara Jermanserta memiliki jaringan dealerdiseluruh Indonesia. PT XYZsangat menaruh perhatian khusus dalam hal layanan purna jual terutama pada suku cadang kendaraannya. Pada industri otomotif terutama pada kendaraan niaga itu sendiri pengelolaan suku cadangmenjadi faktor penting keberhasilan penjualan unit kendaraan tersebut. Dari hal ketersediaan, penjualan, hingga pendistribusianke dealer-dealerseluruh Indonesia. Jumlahdata yang besardalam pengelolaannyamenyulitkan PT XYZdalammemproses analisis data dan juga membutuhkan waktu yang lama. Penelitian ini dilakukan untuk memberikan solusi pada permasalahan tersebut melalui implementasi datawarehousedan menggunakan business intelligencedalam membuat dashboard monitor. Pendekatan data warehousedigunakan adalah pendekatan Kimballyang dikemukakan oleh Kimballdan Ralph. Pengumpulan data didapatkan dari hasil observasi lapangan, dan wawancara dengan dengan narasumber dari unit kerja yang berkaitan dengan pengelolaan suku cadang di perusahaan.Hasil dari penelitian ini adalah implementasi data warehouseserta dashboardbusiness intelligenceyang dapat menjawab kebutuhan informasi dari PT XYZ.

---

ABSTRACT

PT XYZis mainly distributor in the automotive industry aswell known as sole brand agent (ATPM) for a world class commercial vehiclesbrand from Germanyand has a dealer network throughout Indonesia. PT XYZis very particular in terms of after-sales services specifically for vehicle spare parts. In the automotive industry the most important thing in commercial vehicles is that sparepart managementis an important factor in the sale of the vehicle units. From things that are approved, sales prices, to distributors to dealers throughout Indonesia. The large volume of data makes it difficult for PT XYZto process data analysis and also requires a long time. This research was conducted to provide problem solution with implementation of data warehouses and using business intelligence tools to create dashboard monitors. The suggestion for the data warehouse as suggested by Kimball and Ralph. Data collection is obtained from the results of fieldobservations, and interviews with management from business unitrelated to management spare partsat the company.

The results of this study are the implementation of a data warehouse and business intelligence dashboard that can answer the information needs of PT XYZ.

"

"Fitur dashboard yang diimplementasikan pada aplikasi web dan mobile bermanfaat untuk meningkatkan efektifitas dan efisiensi dalam memantau informasi tentang pencapaian target tim keagenan pada PT XYZ. Penelitian ini bertujuan untuk meningkatkan kinerja sistem dalam menyediakan data yang ditampilkan pada dashboard dengan melakukan perancangan serta penerapan data warehouse dan proses ETL. Perancangan data warehouse dan proses ETL dalam penelitian ini menggunakan metode Model Multidimensi. Hasil dari penelitian ini adalah data warehouse dan proses ETL yang digunakan sebagai sumber data pada dashboard.

---

The dashboard feature that has been implemented in both web and mobile applications is useful to increase the effectiveness and efficiency in monitoring information about the agency target achievement of PT XYZ. The aim of this study is to improve the system performance in providing data that are displayed on the dashboard by designing and implementing data warehouse and ETL processes. Designing of data warehouse and ETL processes in this study used Multidimensional Model method. The results of this study are data warehouse and ETL processes that are used as data sources for the dashboard."

"Data warehousing in the age of the big data will help you and your organization make the most of unstructured data with your existing data warehouse.As big data continues to revolutionize how we use data, it doesn't have to create more confusion. Expert author Krish Krishnan helps you make sense of how big data fits into the world of data warehousing in clear and concise detail. The book is presented in three distinct parts. Part 1 discusses big data, its technologies and use cases from early adopters. Part 2 addresses data warehousing, its shortcomings, and new architecture options, workloads, and integration techniques for Big Data and the data warehouse. Part 3 deals with data governance, data visualization, information life-cycle management, data scientists, and implementing a big data–ready data warehouse. Extensive appendixes include case studies from vendor implementations and a special segment on how we can build a healthcare information factory."

"Big data analytics will assist managers in providing an overview of the drivers for introducing big data technology into the organization and for understanding the types of business problems best suited to big data analytics solutions, understanding the value drivers and benefits, strategic planning, developing a pilot, and eventually planning to integrate back into production within the enterprise."

"Badan Kepegawaian Negara BKN sesuai dengan tugas yang diamanatkan dalam Undang-Undang ASN berkewajiban melakukan pembinaan dan menyelenggarakan manajemen Aparatur Sipil Negara ASN. Dalam rangka menjalankan tugasnya, BKN memerlukan informasi perkembangan PNS dari tahun ke tahun. Informasi PNS didapat dari implementasi data warehouse kepegawaian nasional. Pengembangan data warehouse menggunakan metode Kimball Life-Cycle dengan pendekatan yang menggabungkan user-driven dan goal-driven dalam analisis kebutuhan. Tujuan penelitian ini untuk merancang, mengimplementasikan dan memvisualisasikan informasi dari data warehouse yang mendukung perumusan kebijakan dan pengambilan keputusan mengenai manajemen PNS. Data kepegawaian akan diintegrasikan dengan data spasial yang akan memberikan nilai tambah pada informasi yang ditampilkan.

---

Badan Kepegawaian Negara BKN , Indonesian National Civil Service Agency, that has been mandated in Law of the Republic of Indonesia on the Civil State Apparatus, is obliged to conduct guidance and organize the management of civil servants. In order to undertake its duties, BKN requires global civil servants information periodically. Information on civil servants obtained from the implementation of national civil servants data warehouses. The data warehouses development is carried out based on the Kimball Life Cycle method with the combination of user driven and goal driven approach in requirement analysis.

The purpose of this study is to design, implement and visualize information from data warehouses that support policy and decision making regarding civil servant management especially related to the analysis of the needs of civil servants procurement. Employment data will be integrated with spatial data that will be added value in visualizing information."

"[ABSTRAKPenelitian ini mengangkat isu masalah aksesibilitas informasi Pajak Daerah dan penetapan target penerimaan. Isu aksesibilitas disebabkan oleh kompleksitas prosesdalam mengumpulkan dan mengkonsolidasi data dari beberapa sumber yangtersebar pada unit-unit pelayanan. Di sisi lain Dinas Pelayanan Pajak (DPP) harusmenetapkan target penerimaan berdasarkan data tahun sebelumnya denganmenggunakan metode tertentu. Tujuan penelitian ini untuk menjawab permasalahantersebut dengan melakukan perancangan data warehouse, mengimplementasikandalam bentuk prototipe, memproses cube untuk kepentingan analisis multi dimensional, membuat business intelligence dashboard, dan data mining untuk proyeksi penerimaan Pajak Daerah di masa mendatang. Metodologi yangdigunakan untuk merancang data warehouse adalah metodologi yang dikemukakanoleh Ralph Kimball. Hasil dari penelitian ini adalah rancangan dan implementasiprototipe data warehouse, business intelligence dashboard, dan proyeksi penerimaan Pajak Daerah di masa mendatang yang dapat menjawab kebutuhan informasi DPP.

---

ABSTRACTThis research addresses both local taxes information accessibility and revenue target setting issues. The accessibility issue arise from the complexity of compilingprocess since these data have to be gathered and consolidated from several sourcesacross many tax offices. Simultaneously the Local Tax Authority (Dinas PelayananPajak-DPP) has to set annual revenue target which usually derived from time seriesdata by implementing a certain revenue forecasting method. The purposes of thisresearch is to solve the accessibility issue and provide a scientific forecastingmethod by designing data warehouse, implementing its prototype, processing thecubes for multi dimensional analysis, providing a business intelligence dashboard,and mining the data which used in the forecasting process. This research uses datawarehouse design methodology provided by Ralph Kimball. The outcomes of thisresearch are data warehouse design and prototype, business intelligence dashboard, and local taxes revenue forecasting method to provide the information as needed by DPP. ;This research addresses both local taxes information accessibility and revenue target setting issues. The accessibility issue arise from the complexity of compilingprocess since these data have to be gathered and consolidated from several sourcesacross many tax offices. Simultaneously the Local Tax Authority (Dinas PelayananPajak-DPP) has to set annual revenue target which usually derived from time seriesdata by implementing a certain revenue forecasting method. The purposes of thisresearch is to solve the accessibility issue and provide a scientific forecastingmethod by designing data warehouse, implementing its prototype, processing thecubes for multi dimensional analysis, providing a business intelligence dashboard,and mining the data which used in the forecasting process. This research uses datawarehouse design methodology provided by Ralph Kimball. The outcomes of thisresearch are data warehouse design and prototype, business intelligence dashboard, and local taxes revenue forecasting method to provide the information as needed by DPP. , This research addresses both local taxes information accessibility and revenue target setting issues. The accessibility issue arise from the complexity of compilingprocess since these data have to be gathered and consolidated from several sourcesacross many tax offices. Simultaneously the Local Tax Authority (Dinas PelayananPajak-DPP) has to set annual revenue target which usually derived from time seriesdata by implementing a certain revenue forecasting method. The purposes of thisresearch is to solve the accessibility issue and provide a scientific forecastingmethod by designing data warehouse, implementing its prototype, processing thecubes for multi dimensional analysis, providing a business intelligence dashboard,and mining the data which used in the forecasting process. This research uses datawarehouse design methodology provided by Ralph Kimball. The outcomes of thisresearch are data warehouse design and prototype, business intelligence dashboard, and local taxes revenue forecasting method to provide the information as needed by DPP. ]"