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 be an efficient way to track data from varied sources in real time. It will provide a centralized system to monitor and analyze the performance of any business/organization. With the help of this software, or dashboard an environment can be created for business analysis as well as management. This module includes all phases of the Data Analysis life cycle, like data collection, data pre-processing, data analysis, visualization, and eventually effective decision making. A holistic solution for each step is given by the software so as to yield as many insights as possible. In today’s time where data is the new currency, this software or module or dashboard will provide users with a wide range of options to work with and around 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 the options to check factors like tracking progress towards a set target, effective decision-making for planning, and predicting sector trends and performances. The customers will have autonomy to work with variable sizes and types of data. Propagating the results is also an important thing for the customers; therefore, the module or dashboard provides effective data visualization 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