High Level Design
Overview
As a record label manager, one of the main operations is to oversee marketing and sales in relation to growth, trends, and overall areas that need improvement. It is also important to be able to gauge yourself, not only in comparison to your previous performance, but the industry standards as well. This dashboard allows a manager to get a sense of how their label is performing, revenue wise, within different sales areas by the way of streams, merchandize, physical copies sold and tours. It provides actionable information that a business can use to immediately lower costs.Goals
Comparison for a record label with its competitors/industry standard and identify opportunities to increase revenue.
Objectives
- Understanding overall revenue costs and how it compares to competitors
- Understanding current state of opportunities through high level KPIs.
- Increase revenue stream and ‘closed won’ of more opportunities.
KPIs Architecture
|
Objectives |
KPIs |
Measures |
Data Source |
|
Understanding the overall revenue costs and how it compares to competitors. |
Current Year Revenue Your Record Label’s Current Year Revenue Is Computed As The Sum Of The Weekly Averages For Each Revenue Type For That Selected Year |
Sum (Revenue Amount) |
Fact_HotStuff2/ RevenueAmount |
|
Past Year Revenue Your Record Labels Last Year Revenue |
PastYear(Total Revenue) |
Fact_HotStuff2/ RevenueAmount |
|
|
Current Year Industry Average A Combination/Average of All Record Label’s (Inlcuding Yours) Sums of The Weekly Averages For Each Revenue Type For That Selected Year |
Sum(AVG Revenue Amount) |
Fact_Benchmark2/ AVG Revenue Amount |
|
|
Past Year Revenue |
PastYear( Average Total Revenue ) |
Fact_Benchmark2/ AVG Revenue Amount |
|
|
2 Understanding current state of opportunities through high level KPIs — More Specific — How Much Revenue Does Each Revenue Type Generate (Per Week, Per Year) & What’s It’s Contribution to the overall revenue total |
Revenue Of Merchandize |
Revenue = 1000 * C30_ What Percentage % of Revenue is made up of Merchandize : RANDBETWEEN(20/30)/100 Revenue of Stream (Per Week) : L30_ * Q30_ Totaled Revenue : P30_ + R30_ + T30_ |
Fact_ HotStuff/Revenue Of Merchandize |
|
Revenue Of PC |
Revenue = 1000 * C30_ What Percentage % of Revenue is made up of PC : RANDBETWEEN(20/30)/100 Revenue of PC (Per Week): L30_ * 030_ |
Fact_ Hot Stuff/ Revenue Of PC |
|
|
Revenue of Stream |
Revenue = 1000 * C30_ What Percentage % of Revenue is made up of Streams : RANDBETWEEN(20/30)/100 Revenue of Streams (Per Week): L30_ * M30_ Totaled Revenue : P30_ + R30_ + T30_ |
Fact_ Hot Stuff/ Revenue Of Stream |
|
|
Revenue of Tours |
Revenue = 1000 * C30_ What Percentage % of Revenue is made up of Tours : 1- M30_ – 030_ – Q30_ Revenue of Stream: L30_ * M30_ Totaled Revenue : P30_ + R30_ + T30_ |
Fact_ Hot Stuff/ Revenue Of Tours |
|
|
3 Increase revenue stream and ‘closed won’ of more opportunities by checking on .. How We Are Performing As A Record Label Per Genre In Comparison To Our Competitors |
Genre |
||
|
Record Label |
Sum(Revenue Amount) |
Fact_ HotStuff2/ Revenue Amount |
|
|
Industry Average |
Sum(AVG Revenue Amount) |
Fact_ Benchmark2/ AVG Revenue Amount |
|
Plugins
Data Connectors
