A metadata-driven automation framework that leverages AI-assisted refactoring and Python-based pipelines to accelerate migration while maintaining functional correctness is presented, providing a scalable blueprint for enterprise-wide BI modernization.
Abstract
Large enterprise business intelligence (BI) systems have accumulated thousands of datasets, reports, and embedded transformation and presentation logic developed over decades using procedural programming languages and scripting. These systems support both extract-transform-load (ETL) operations and analytical dashboards, often supplemented by low-code tools for rapid visualization and decision support. Migrating such complex landscapes to modern cloud-native platforms is challenging due to the volume of custom code, intricate dependencies, and the need to preserve semantic integrity across ETL processes, analytical models, and dashboards. Manual migration is labor-intensive, error-prone, and relies on scarce expertise, resulting in extended timelines and high costs. This paper presents a metadata-driven automation framework that leverages AI-assisted refactoring and Python-based pipelines to accelerate migration while maintaining functional correctness. The framework includes modules for code extraction, classification and refactoring of ETL and presentation logic, automated conversion and validation, and integration with target platforms. Applied to a representative large-scale BI system, the approach achieved significant automation coverage, reduced manual effort by over 50%, and enabled seamless transformation of both data workflows and low-code dashboards, providing a scalable blueprint for enterprise-wide BI modernization.
The results are packaged in the Greenfield Startup Model (GSM), which explains the priority of startups to release the product as quickly as possible, and the need to shorten time-to-market, by speeding up the development through low-precision engineering activities.
Carmine Giardino, Nicolò Paternoster, M. Unterkalmsteiner et al.· IEEE Transactions on Softwar...· 178 citations· ⚡14
Software startup companies develop innovative, software-intensive products within limited timeframes and with few resources, searching for sustainable and scalable business models.
M. Unterkalmsteiner, P. Abrahamsson, Xiaofeng Wang et al.· e-Informatica Software Engin...· 157 citations· ⚡17
This study conducts a case survey study based on the secondary data of the major pivots happened in 49 software startups, and demonstrates that customer need pivot is the most common among all pivot types.
Sohaib Shahid Bajwa, Xiaofeng Wang, Anh Nguyen-Duc et al.· Empirical Software Engineeri...· 127 citations· ⚡15
The comparison of adopter and non-adopter sample reveals three potential adoption inhibitor, security, data privacy, and portability, which underlines the importance of the technical and security perspectives for research investigating the adoption of technology.
Nattakarn Phaphoom, Xiaofeng Wang, S. Samuel et al.· Journal of Systems and Softw...· 111 citations· ⚡8
The ongoing work building a Raspberry Pi cluster consisting of 300 nodes is presented, with potential use cases being an inexpensive and green test bed for cloud computing research and a robust and mobile data center for operating in adverse environments.
P. Abrahamsson, S. Helmer, Nattakarn Phaphoom et al.· IEEE International Conferenc...· 110 citations· ⚡7
Objective There is dearth of information on the timeliness of antenatal care (ANC) uptake. This study aimed to determine the timely ANC uptake by a medically trained provider (MTP) as per the World Health Organization (WHO) recommendations and the country guideline. Methods Cross-sectional survey was done with 2,731 wo...
B. Sarker, Musfikur Rahman, T. Rahman et al.· PLoS ONE· 89 citations· ⚡7
Related blog posts
MIT News · Artificial Intelligence· news.mit.eduNov 20, 2026
Senior Research Scientist Jim Glass discusses how his MIT-IBM Computing Research Lab collaboration connects perception and language, and addresses the shortcoming of current models.
MIT News · Artificial Intelligence· news.mit.eduNov 20, 2026
Enforcing physics-based constraints prevents AI models from generating unreliable predictions for complex nonlinear systems in weather, climate, and turbulent flows.
An MIT and Dana-Farber Institute-led team used large language models to examine nearly 4,000 studies and hundreds of code repositories, revealing gaps in the information needed to scrutinize and reuse published research.
We use cookies to run the site and, with your consent, for analytics and to show ads.
See our Cookie Policy.