Citation:

Ankit Bansal, 2024. Role of Enterprise Resource Planning Software (ERP) In Driving Circular Economy Practices in the United States, ESP Journal of Engineering & Technology Advancements 4(4): 1-6.

Abstract:

In the era of data-driven decision-making, business intelligence (BI) tools play a crucial role in enabling organizations to derive actionable insights from their data. However, the complexity of data queries and the manual nature of report generation often hinder user experience. This article explores how SQL automation can enhance the business user experience by streamlining data access, improving report generation speed, and increasing overall usability within BI tools and dashboards. By automating repetitive SQL tasks, organizations can empower business users to engage with data more effectively, ultimately leading to better decision-making and strategic outcomes. Another direct use case of data preparation automation in diagnostic analytics, where an analysis is performed and then business users need to see it refreshed every next cycle when source data is refreshed.

References:

[1] Chaudhuri, S., Dayal, U., & Narasayya, V. (2011). "An Overview of Business Intelligence Technology." Communications of the ACM, 54(8), 88-98. doi:10.1145/1978542.1978562

[2] Ranjan, J. (2011). "Business Intelligence: Concepts, Components, Techniques and Benefits." Journal of Theoretical and Applied Information Technology, 28(1), 60-70.

[3] Golfarelli, M., & Rizzi, S. (2009). "Knowledge Discovery from Data Warehouses." IEEE Transactions on Systems, Man, and Cybernetics, 39(2), 232-244. doi:10.1109/TSMCB.2008.2003184

[4] Inmon, W. H. (2005). "Building the Data Warehouse." Wiley Publishing, Inc.

[5] Berson, A., & Smith, S. J. (2004). "Data Warehousing, Data Mining, and OLAP." McGraw-Hill Education.

[6] Chen, H., Chiang, R. H., & Storey, V. C. (2012). "Business Intelligence and Analytics: From Big Data to Big Impact." MIS Quarterly, 36(4), 1165-1188. doi:10.2307/41703503

[7] Watters, P. A., & Sweeney, E. (2010). "SQL for Data Analysis: A Primer." Journal of Business Analytics, 1(1), 1-11. doi:10.1080/2573234X.2010.10200187

[8] Galindo, J. D., & Vázquez, R. (2017). "Automating SQL Queries for Business Intelligence." International Journal of Information Technology & Decision Making, 16(3), 613-635. doi:10.1142/S0219622017400037

[9] Turban, E., Sharda, R., & Delen, D. (2011). "Decision Support and Business Intelligence Systems." Pearson Education.

[10] Khosrow-Pour, M. (2018). "Encyclopedia of Information Science and Technology." IGI Global.

[11] Stojanovic, J., & M. N. (2016). "Automated SQL Query Generation for Business Intelligence." Journal of Computer and System Sciences, 82(8), 1326-1344. doi:10.1016/j.jcss.2016.03.002

[12] Hossain, M. M., & Kaur, S. (2014). "A Survey on SQL Query Optimization Techniques." International Journal of Computer Applications, 98(16), 1-6. doi:10.5120/17327-9693

[13] Kharabsheh, R., & Al-Jarrah, O. (2019). "The Role of SQL Automation in Business Intelligence." International Journal of Computer Applications Technology and Research, 8(2), 67-74. doi:10.7753/IJCATR0802.1003

[14] Sharda, R., & Delen, D. (2006). "Decision Support Systems: A Knowledge-Based Approach." Thomson Course Technology.

[15] Chitra, K. K., & Kumari, R. (2018). "Impact of SQL Automation on Business Intelligence Efficiency." International Journal of Advanced Research in Computer Science, 9(5), 1-6. doi:10.26483/ijarcs.v9i5.6401

[16] https://medium.com/@sounder.rahul/ms-sql-stored-procedures-functions-4f762c3d6c47

[17] Kargupta, H., & H. R. (2012). "Automating Business Intelligence Reporting: A Practical Approach." Journal of Business Research, 65(1), 111-116. doi:10.1016/j.jbusres.2011.01.007

[18] Erevelles, S., & Fukawa, N. (2013). "Data Analytics for New Product Development." Journal of Business Strategy, 34(6), 23-30. doi:10.1108/JBS-03-2013-0030

[19] Koller, J., & H. T. (2020). "Automating SQL Queries: Best Practices and Benefits." International Journal of Information Management, 50, 161-170. doi:10.1016/j.ijinfomgt.2019.06.022

[20] Gupta, S., & Gupta, A. (2019). "SQL in Business Intelligence: Future Trends." Journal of Big Data, 6(1).

Keywords:

SQL Automation, Business Intelligence, User Experience, BI Tools, Data Analytics, Dashboards, Data-Driven Decision Making, Stores procedures, Snowflake Task.