Extract transform load process in banking reporting system.

Banks must maintain, calculate, and monitor liquidity using the Liquidity Coverage Ratio (LCR) indicator. In Indonesia, they reported daily, monthly, or quarterly online through a paper template prepared by the Financial Services Authority (OJK). This reporting must accurate and on time or be subject to penalties. For banks that are still processing LCR semi-automatically, this reporting system is an obstacle that they continue to face and resolve. This article discusses the automation process method developed using the concept of Extract Transform Load (ETL), with a waterfall software development model, so that daily reports are generated automatically. This article proposed a methodology to anticipate problems in integrating banking with regulators by applying one of the Basel III frameworks, primarily based on Indonesia's case studies. The finding of the research is a method for the LCR report process through ETL. The proposed ETL method in this research had proven used success in processing LCR in the banking industry. This method is a solution and recommendation for banks in making reports based on Basel III to complete LCR reporting through the ETL method.•o Maintain, calculate, and monitor liquidity using the Liquidity Coverage Ratio (LCR) indicator in Banking .•o Automation process method developed using the concept of Extract Transform Load (ETL).•o Recommendation for Banks to complete LCR reporting through the ETL method).

Dataset smartphone usage of international tourist behavior.

This article contains dataset on the behavior of international tourists when traveling is related to 1) tourist demographics, 2) things that affect tourists to choose travel destinations when planning, 3) use of mobile data while traveling, 4) how to get internet access while traveling, 5) social media used during traveling, and 6) behavior of smartphone use for tourists during traveling. The raw data presented here can be used as material to analyze the behavior of international tourists related to any media that affects international tourists in planning their trips, and how they behave during traveling. This data is a source of raw data from our research on smartphones and international tourist behavior, besides being used for various other research purposes.