Business Intelligence For a Digital Music Content Provider

摘要

As an online digital music content provider, company PT ABC has a portal that contains songs that can be streamed by customers. The music director has been using global trend, i.e. radio top music charts to produce favorite song list. This study will utilize data warehouse and business intelligence for PT ABC's marketing and sales strategy, e.g. to improve its service to customers, to increase number of active users and the duration of streaming per user. OLTP data suggested for the data warehouse is the existing streaming transactions, which will be used to analyze customers' most preferred songs. The proposed method to design the data warehouse is using 9-steps from Kimball. The selected process for the data warehouse is customers' streaming and downloading process, with dimensions of location, time and song, with fact less table of the streaming itself. The result of analysis will be customers' most preferred play list based on several parameters, such as customers' locations, streaming hours or days and genre of songs.