Business Intelligent in an E-Commerce Industry

[摘要] 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.

[发布机构] Computer Science Department, BINUS Graduate Program-Master of Computer Science, Bina Usantara University, Jakarta; 11480, Indonesia^1

[学科分类] 工业工程学

[关键词] Business intelligent;Dimensional design;E retails;E-commerce business;Internet based;Transaction data;US dollar