ETL based Billing System for Azure Services with Cost Estimation using Cloud Computing
Vaishnavi Pawar, Shubham Kumawat, Madhuri Ahire, Rutika Musmade, Rohit Ravindra Nikam, P. William
Abstract
As more companies move their on-demand computing workloads to the public cloud, Azure cost control is becoming an important topic. Many public cloud providers employ the "pay-as-you-use" business model; however, clients typically pay considerably more than they actually use. Customers still frequently pay significantly more than what they are really using for solutions to problems they are having. By taking into account this issue, we chose the project's topic, which is Approximate Monthly Billing for the Client to Load the Data, to better find the cost optimization potential. A set of tools called Microsoft Cost Management assists businesses in tracking, allocating, and reducing the cost of their Microsoft Cloud workloads. Anyone with access to a billing or resource management scope can use cost management. The accumulation of enormous amounts of data in modern industry makes decision-making difficult. How to improve the current "mass data, poor knowledge" situation, promote better business decision-making, assist businesses in gaining market share, and boost profits are concerns that both the business and IT sectors are concerned about. Technologies for business intelligence are developed as necessary. ETL is crucial to BI projects since it helps with technical support and decision-making. The core ETL module, the ETL optimization method, and the specific ETL process implementation are all covered in this article's overview.