This Media BI analysis understandably required that both the Traffic spot revenue and program rights amortization are loaded into the Media data warehouse. Shared dimensions between the different fact tables should include the Programs, the Dayparts, the Program Categories, the Channels, and the Date and Time Dimensions. Calculated Measures can be defined to form the profitability for analysis across the shared dimensions.
BIAnalytix is an advanced Data Warehouse and Business Intelligence system that has modules for both spot revenue (Media Base Module) as well as program expenses (Program Profitability Module) so that it can forecast program profitability.
|
|
