NOVEL APPROACH TO ANALYZE EXCEL MACRO DATA
Loading...
Date
2025
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
UMT, Lahore
Abstract
Massive development in storage architecture over the last decade has assisted users by
facilitating them to store heterogeneous data on their system. Extracting the insights from
data has been more complex with this progress. In this study, a novel approach to analyze
the excel macro data is presented. GCSE results datasets as a sample excel macro data is
used to evaluate the approach. Web application is designed and developed that offers visual
analytics and prediction on this excel macro-based GCSE results. Data wrangling along
with ETL is applied to transform the data in a structure where it can be analyzed, since the
raw data source is in excel-macro structure.