Open AccessData warehouse for analysing music sales on a digital media store
Author(s) -
Kiefer Stefano Ranti,
Deyanara Tuapattinaya,
Calvin Chang,
Abba Suganda Girsang
Publication year - 2020
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1477/3/032013
Subject(s) - data warehouse , dashboard , computer science , dimensional modeling , warehouse , order (exchange) , decision support system , database , online analytical processing , data science , data mining , business , marketing , finance
Nowadays, every company knows that when making a decision that has a potential in affecting their assets, an accurately processed report is necessary in order to support the reasoning behind their decision. Generating a report for stakeholders quickly and accurately is highly required in assisting them making a data-driven decision. By developing a data warehouse, it is possible for a company to do a data-driven decision making to appeal to their customer segments. This paper proposes a data warehouse model design to analyse the sales data contained in the database. The method that was implemented for this particular data warehouse development is the nine-step methodology designed by Kimball. The results are then presented in pdf form and an interactive dashboard.