Business Intelligent in an E-Commerce Industry

Abstract

According to a survey from statista.com about in 2017, retail e-commerce sales worldwide amounted to 2.3 trillion US dollars and e-retail revenues are projected to grow to 4.88 trillion US dollars in 2021. Each year, e-commerce business increasingly popular. Some retail companies finally decided to focus on internet-based sales to get more customers. Along with transactions that continue to be carried out from year to year, transaction data continues to be stored and stacked and of course space consuming. So after years, Business Intelligence is finally appeared and offer great data processing. Without a business intelligence, these stacked big data are useless and wait to be removed because of poor knowledge. Business intelligence turns on the poor knowledge data into rich knowledge data visualization. This paper proposed a data warehouse that can be used to build a business intelligent with utilize information obtained from the history of transactions. To build up this business intelligent, authors uses methodology steps by Kimball which consists 4 steps of dimensional design process. Furthermore, data analysis will be presented in a dashboard using Power BI.