National Conference on Advancements in Computer & Information Technology |
Foundation of Computer Science USA |
NCACIT2016 - Number 3 |
May 2016 |
Authors: Amol Modi, Anjana Pradeep, Rohan Jain, Payal Rathod |
99a5938f-ec2c-4426-b490-e485471cb081 |
Amol Modi, Anjana Pradeep, Rohan Jain, Payal Rathod . Analysis of E-Commerce Backend Operations Data. National Conference on Advancements in Computer & Information Technology. NCACIT2016, 3 (May 2016), 26-28.
Data analysis is the process of finding the analyzing data to find useful results for decision-making, understanding fundamental the data, discovering the significant pattern in the data. Analysis of e-commerce data (which includes guidelines details, record details, stuffing details, delivery details, etc. ) involves scanning through the database and extracting data and probing pattern that can be helpful to the company in classify to get better their competence in the backend behavior like selection, superiority checks, packing and shipping. Such information obtained from analysis can provide insight into the various operations and can help the company to make informed decisions to speed up activities and ensure delivery in shortest possible time. The raw data from the various sources needs to be extracted, transformed and loaded into the data warehousebefore beginning the proper analysis on the data. This consolidated data is availableto run a series of patterns for knowledge discovery. In this paper, ETL process, architecture of a system involving Pentaho ETL tool for analysis of large e-commerce data sets and the final visualization of the analysis are discussed.