Perhitungan Anggaran Otomatis Acara Reses Dengan Teknik Power Query Menggunakan Paket Program Niaga

Abstract

The increasingly rapid development of technology and information means that we must always hone our knowledge and skills so as not to be left behind by technology that continues to develop. The initial capital that can be used as a guide is to master the commercial package application in the form of Microsoft Office. Calculations and accessing large amounts of data certainly take a long time to complete, using power query techniques without having to sort data based on criteria can be a faster solution for managing data. Next, a collection of data is used as a source of information, which at any time will be easy to retrieve data for further purposes and use. In queries, data filter services are available with table query facilities. The final data processing process for the recess event at the Medan City DPRD has not been automatically compiled with the final remainder because it has to recalculate the previous recess data. In a year, the Medan City DPRD holds three recesses. During the third recess, DPRD members must recap data from the first and second recesses to calculate the remainder of the previous recess activities. With the help of query techniques, it makes it easier for the facilities, budget and supervision departments to recapitulate data during the recess period of the year