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,
  • Dr. Punit Goel Research Supervisor , Maharaja Agrasen Himalayan Garhwal University, Uttarakhand,

DOI:

https://doi.org/10.36676/dira.v12.i1.75

Keywords:

Agile methods, data warehouse projects, iterative development, incremental delivery

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.

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).

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.

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.

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.

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.

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

Hemanth Swamy. Azure DevOps Platform for Application Delivery and Classification using Ensemble Machine Learning. Authorea. July 15, 2024. DOI: https://doi.org/10.22541/au.172107338.89425605/v1

Swamy, H. (2024). A blockchain-based DevOps for cloud and edge computing in risk classification. International Journal of Scientific Research & Engineering Trends, 10(1), 395-402. https://doi.org/10.61137/ijsret.vol.10.issue1.180

Bipin Gajbhiye, Shalu Jain, & Om Goel. (2023). Defense in Depth Strategies for Zero Trust Security Models. Darpan International Research Analysis, 11(1), 27–39. https://doi.org/10.36676/dira.v11.i1.70

Kumar Kodyvaur Krishna Murthy, Om Goel, & Shalu Jain. (2023). Advancements in Digital Initiatives for Enhancing Passenger Experience in Railways. Darpan International Research Analysis, 11(1), 40–60. https://doi.org/10.36676/dira.v11.i1.71

Aravindsundeep Musunuri, Shalu Jain, & Anshika Aggarwal. (2023). Characterization and Validation of PAM4 Signaling in Modern Hardware Designs. Darpan International Research Analysis, 11(1), 60–74. https://doi.org/10.36676/dira.v11.i1.72

Umababu Chinta, Shalu Jain, & Pandi Kirupa Gopalakrishna Pandian. (2024). Effective Delivery Management in Geographically Dispersed Teams: Overcoming Challenges in Salesforce Projects. Darpan International Research Analysis, 12(1), 35–50. https://doi.org/10.36676/dira.v12.i1.73

Dignesh Kumar Khatri, Prof.(Dr.) Punit Goel, & Ujjawal Jain. (2024). SAP FICO in Financial Consolidation: SEM-BCS and EC-CS Integration. Darpan International Research Analysis, 12(1), 51–64. https://doi.org/10.36676/dira.v12.i1.74

Downloads

Published

2024-03-30
CITATION
DOI: 10.36676/dira.v12.i1.75
Published: 2024-03-30

How to Cite

Saketh Reddy Cheruku, Pandi Kirupa Gopalakrishna Pandian, & Dr. Punit Goel. (2024). Implementing Agile Methodologies in Data Warehouse Projects. Darpan International Research Analysis, 12(1), 65–79. https://doi.org/10.36676/dira.v12.i1.75