Implementing Agile Methodologies in Data Warehouse Projects

Authors

  • Saketh Reddy Cheruku Independent Researcher, Pulimamidi Estates Beside Sri Sai Prashanthi Highschool Bhongir Nalgonda Highway, Bhongir Yadadrinbhongir (Dist) Telangana 508116,
  • Pandi Kirupa Gopalakrishna Pandian Sobha Emerald Phase 1, Jakkur, Bangalore 560064,
  • Prof.(Dr.) Punit Goel Research Supervisor , Maharaja Agrasen Himalayan Garhwal University, Uttarakhand,

DOI:

https://doi.org/10.36676/jrps.v15.i3.1498

Keywords:

Agile methods, data warehouse projects, iterative development, incremental delivery, Scrum, Kanban, data governance, project management

Abstract

Agile techniques have transformed project management and software development by stressing flexibility, collaboration, and customer-centricity. Data warehouse initiatives have traditionally used a waterfall methodology, which may delay, cost more, and misalign with business needs. Agile techniques are applied to data warehouse projects in this article, examining their pros and cons.

The study starts with Agile fundamentals including iterative development, incremental delivery, and adaptive planning. It compares these concepts with the linear, sequential waterfall approach employed in data warehousing. Agile approaches like Scrum or Kanban may help data warehouse projects adapt to changing business demands and improve results.

The report recommends creating cross-functional Agile teams with data administration, analytical, and development competence to execute Agile in data warehouses. Collaborative teams encourage communication and feedback loops. Sprints, stand-ups, and retrospectives help data warehousing teams make quick changes and meet business goals, according to the report.

References

Kumar, S., Jain, A., Rani, S., Ghai, D., Achampeta, S., & Raja, P. (2021, December). Enhanced SBIR based Re-Ranking and Relevance Feedback. In 2021 10th International Conference on System Modeling & Advancement in Research Trends (SMART) (pp. 7-12). IEEE.

Jain, A., Singh, J., Kumar, S., Florin-Emilian, Ț., Traian Candin, M., & Chithaluru, P. (2022). Improved recurrent neural network schema for validating digital signatures in VANET. Mathematics, 10(20), 3895. DOI: https://doi.org/10.3390/math10203895

Kumar, S., Haq, M. A., Jain, A., Jason, C. A., Moparthi, N. R., Mittal, N., & Alzamil, Z. S. (2023). Multilayer Neural Network Based Speech Emotion Recognition for Smart Assistance. Computers, Materials & Continua, 75(1). DOI: https://doi.org/10.32604/cmc.2023.028631

Misra, N. R., Kumar, S., & Jain, A. (2021, February). A review on E-waste: Fostering the need for green electronics. In 2021 international conference on computing, communication, and intelligent systems (ICCCIS) (pp. 1032-1036). IEEE.

Kumar, S., Shailu, A., Jain, A., & Moparthi, N. R. (2022). Enhanced method of object tracing using extended Kalman filter via binary search algorithm. Journal of Information Technology Management, 14(Special Issue: Security and Resource Management challenges for Internet of Things), 180-199.

Harshitha, G., Kumar, S., Rani, S., & Jain, A. (2021, November). Cotton disease detection based on deep learning techniques. In 4th Smart Cities Symposium (SCS 2021) (Vol. 2021, pp. 496-501). IET.

Jain, A., Dwivedi, R., Kumar, A., & Sharma, S. (2017). Scalable design and synthesis of 3D mesh network on chip. In Proceeding of International Conference on Intelligent Communication, Control and Devices: ICICCD 2016 (pp. 661-666). Springer Singapore. DOI: https://doi.org/10.1007/978-981-10-1708-7_75

Morgan, P. (2021). AI and IT Service Management: Strategies for Success. CRC Press. (AITMS)

Newman, D. J. (2020). AI-Powered IT Service Delivery. Informa PLC. (APISD)

Osborne, G., & Thompson, N. (2018). AI in Enterprise IT Service Delivery. Palgrave Macmillan. (AIETSD)

Parker, R., & Clark, D. (2021). Leveraging AI for IT Service Excellence. Packt Publishing. (LAITSE)

Quinton, S. (2022). AI-Driven Transformation in IT Services. Kogan Page. (AITIS)

Reynolds, T. (2019). AI and Automation in IT Service Management. Emerald Publishing. (AAITSM)

Taylor, J., & Brown, W. (2021). Strategic AI Integration in IT Services. Harvard University Press. (SAIITS)

Wilson, F. (2020). AI for Service Delivery Optimization in IT. Springer Nature. (AISDO)

Vishesh Narendra Pamadi, Dr. Ajay Kumar Chaurasia, Dr. Tikam Singh, "Effective Strategies for Building Parallel and Distributed Systems", International Journal of Novel Research and Development (www.ijnrd.org), Vol.5, Issue 1, pp.23-42, January 2020. Available: http://www.ijnrd.org/papers/IJNRD2001005.pdf

Sumit Shekhar, Shalu Jain, Dr. Poornima Tyagi, "Advanced Strategies for Cloud Security and Compliance: A Comparative Study", International Journal of Research and Analytical Reviews (IJRAR), Vol.7, Issue 1, pp.396-407, January 2020. Available: http://www.ijrar.org/IJRAR19S1816.pdf

Venkata Ramanaiah Chinth, Priyanshi, Prof. Dr. Sangeet Vashishtha, "5G Networks: Optimization of Massive MIMO", International Journal of Research and Analytical Reviews (IJRAR), Vol.7, Issue 1, pp.389-406, February 2020. Available: http://www.ijrar.org/IJRAR19S1815.pdf

Cherukuri, H., Goel, E. L., & Kushwaha, G. S. (2021). Monetizing financial data analytics: Best practice. International Journal of Computer Science and Publication (IJCSPub), 11(1), 76-87. https://rjpn.org/ijcspub/viewpaperforall.php?paper=IJCSP21A1011

Pattabi Rama Rao, Er. Priyanshi, & Prof.(Dr) Sangeet Vashishtha. (2023). Angular vs. React: A comparative study for single page applications. International Journal of Computer Science and Programming, 13(1), 875-894. https://rjpn.org/ijcspub/viewpaperforall.php?paper=IJCSP23A1361

Kanchi, P., Gupta, V., & Khan, S. (2021). Configuration and management of technical objects in SAP PS: A comprehensive guide. The International Journal of Engineering Research, 8(7). https://tijer.org/tijer/papers/TIJER2107002.pdf

Kolli, R. K., Goel, E. O., & Kumar, L. (2021). Enhanced network efficiency in telecoms. International Journal of Computer Science and Programming, 11(3), Article IJCSP21C1004. https://rjpn.org/ijcspub/papers/IJCSP21C1004.pdf

“Building and Deploying Microservices on Azure: Techniques and Best Practices". International Journal of Novel Research and Development (www.ijnrd.org), ISSN:2456-4184, Vol.6, Issue 3, page no.34-49, March-2021, Available : http://www.ijnrd.org/papers/IJNRD2103005.pdf

Pattabi Rama Rao, Er. Om Goel, Dr. Lalit Kumar, "Optimizing Cloud Architectures for Better Performance: A Comparative Analysis", International Journal of Creative Research Thoughts (IJCRT), ISSN:2320-2882, Volume.9, Issue 7, pp.g930-g943, July 2021, Available at : http://www.ijcrt.org/papers/IJCRT2107756.pdf

Eeti, S., Goel, P. (Dr.), & Renuka, A. (2021). Strategies for migrating data from legacy systems to the cloud: Challenges and solutions. TIJER (The International Journal of Engineering Research), 8(10), a1-a11. https://tijer.org/tijer/viewpaperforall.php?paper=TIJER2110001

Shanmukha Eeti, Dr. Ajay Kumar Chaurasia,, Dr. Tikam Singh,, "Real-Time Data Processing: An Analysis of PySpark's Capabilities", IJRAR - International Journal of Research and Analytical Reviews (IJRAR), E-ISSN 2348-1269, P- ISSN 2349-5138, Volume.8, Issue 3, Page No pp.929-939, September 2021, Available at : http://www.ijrar.org/IJRAR21C2359.pdf

Pattabi Rama Rao, Er. Om Goel, Dr. Lalit Kumar. (2021). Optimizing Cloud Architectures for Better Performance: A Comparative Analysis. International Journal of Creative Research Thoughts (IJCRT), 9(7), g930-g943. http://www.ijcrt.org/papers/IJCRT2107756.pdf

Kumar, S., Jain, A., Rani, S., Ghai, D., Achampeta, S., & Raja, P. (2021, December). Enhanced SBIR based Re-Ranking and Relevance Feedback. In 2021 10th International Conference on System Modeling & Advancement in Research Trends (SMART) (pp. 7-12). IEEE. DOI: https://doi.org/10.1109/SMART52563.2021.9676245

Kanchi, P., Gupta, V., & Khan, S. (2021). Configuration and management of technical objects in SAP PS: A comprehensive guide. The International Journal of Engineering Research, 8(7). https://tijer.org/tijer/papers/TIJER2107002.pdf

Harshitha, G., Kumar, S., Rani, S., & Jain, A. (2021, November). Cotton disease detection based on deep learning techniques. In 4th Smart Cities Symposium (SCS 2021) (Vol. 2021, pp. 496-501). IET. DOI: https://doi.org/10.1049/icp.2022.0393

Misra, N. R., Kumar, S., & Jain, A. (2021, February). A review on E-waste: Fostering the need for green electronics. In 2021 international conference on computing, communication, and intelligent systems (ICCCIS) (pp. 1032-1036). IEEE. DOI: https://doi.org/10.1109/ICCCIS51004.2021.9397191

Cherukuri, H., Goel, E. L., & Kushwaha, G. S. (2021). Monetizing financial data analytics: Best practice. International Journal of Computer Science and Publication (IJCSPub), 11(1), 76-87. https://rjpn.org/ijcspub/viewpaperforall.php?paper=IJCSP21A1011

Swamy, H. (2020). Unsupervised machine learning for feedback loop processing in cognitive DevOps settings. Yingyong Jichu yu Gongcheng Kexue Xuebao/Journal of Basic Science and Engineering, 17(1), 168-183. https://www.researchgate.net/publication/382654014

Downloads

Published

30-08-2024

How to Cite

Saketh Reddy Cheruku, Pandi Kirupa Gopalakrishna Pandian, & Prof.(Dr.) Punit Goel. (2024). Implementing Agile Methodologies in Data Warehouse Projects. International Journal for Research Publication and Seminar, 15(3), 306–317. https://doi.org/10.36676/jrps.v15.i3.1498

Most read articles by the same author(s)

1 2 > >>