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.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: IOP Conference Series: Materials Science and Engineering
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
