Please take a moment to complete this survey below
Library's collection Library's IT development CancelE-Commerce is one field that has rapid growth and extensive impact on society. As society started to adopt E-Commerce services, there is a lot of data that must be handled properly due to the increasing traffic. Instead of only using the data for gaining customers, E-Commerce needs to improve the performance of the sellers. Business Intelligence supported by Google Big Query is utilized to process the big data which leads to business decisions. Beforehand, the data must be collected from the trackers to capture the whole session of customers’ interaction (perform traffic analysis). In addition, the data is scheduled to update regularly by using Airflow to ensure data relevancy.
Often times historical data which is represented in Tableau dashboard is used to learn the pattern and evaluate the performance in the past. Tableau dashboard helps the data to speak and notify some insights to the business users. However, it might fail to catch some occurrences when the data is limited. A simple Structured Query Language (SQL) reinforced by Business intelligence sense could be used as an early detection tool to address this condition. This technique helps company to identify fraud practices which usually unique from case to case immediately.