This Media BI analysis understandably requires that both the Traffic spot revenue and program rights amortization are loaded into the Media data warehouse. Shared dimensions between the different fact transactions 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 analysis across the shared dimensions..
BIAnalytix is an advanced Data Warehouse and Business intelligence system that provides modules for both advertising revenue qnd program amortization. Calculated measures provide program profitability by comparing the projected program revenue with the projected amortized program costs.
|
|
