Development of a Data Analysis Module
Atharva Gupte1, Kaushal Bhide2, Swarupa Deshpande3, Manas Apte4, Rohan Rasane5
1Atharva Gupte, Department of Computer Engineering, Marathwada Mitra Mandal College of Engineering, Pune (Maharashtra) India.
2Kaushal Bhide, Department of Computer Engineering, Marathwada Mitra Mandal College of Engineering, Pune (Maharashtra) India.
3Swarupa Deshpande, Department of Computer Engineering, Marathwada Mitra Mandal College of Engineering, Pune (Maharashtra) India.
4Manas Apte, Department of Computer Engineering, Marathwada Mitra Mandal College of Engineering, Pune (Maharashtra) India.
5Rohan Rasane, Department of Computer Engineering, Marathwada Mitra Mandal College of Engineering, Pune (Maharashtra) India.
Manuscript received on 26 May 2023 | Revised Manuscript received on 06 June 2023 | Manuscript Accepted on 15 June 2023 | Manuscript published on 30 June 2023 | PP: 22-27 | Volume-12 Issue-7, June 2023 | Retrieval Number: 100.1/ijitee.G96140612723 | DOI: 10.35940/ijitee.G9614.0612723
Open Access | Editorial and Publishing Policies | Cite | Zenodo | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: A module that gathers data from various sources like SQL databases or CSVs and then, with the help of this data, provides meaningful insights to the customer. The software will provide an efficient way to track data from various sources in realtime. It will provide a centralised system to monitor and analyse the performance of any business or organisation. With the help of this software or dashboard, an environment can be created for both business analysis and management. This module encompasses all phases of the Data Analysis life cycle, including data collection, data preprocessing, data analysis, visualisation, and ultimately, effective decision-making. The software provides a holistic solution for each step, yielding as many insights as possible. In today’s digital age, where data is the new currency, this software, module, or dashboard will provide users with a wide range of options for working with and managing data. With the help of this software, one can achieve effective monitoring and evaluation of the business sector. Due to the lack of such software, the available raw data is often not transformed and used for decision-making. To fill this void, this module will play a vital role. The software will provide customers with options to track progress towards a set target, make informed decisions for planning, and predict sector trends and performance. The customers will have autonomy to work with various sizes and types of data. Propagating the results is also essential for customers; therefore, the module or dashboard provides practical data visualisation tools as well. Thus, this software is defined as an end-to-end solution for the customers.
Keywords: Model Building, Data Collection, Data Analysis, Data Pre-processing, Extract, Transform, Load, SQL Database, API, DLL, NoSQL, Data Aggregation, OOP, Script Generation.
Scope of the Article: Data Analytics