OLAP Cube Design
Budget: $30 – $250 USD
Design an OLAP cube that fulfills the following requirements:
Headcount Planning
Automatic calculation of staff cost based on Headcount planning
Reporting Actuals for number of FTE, cost per FTE split by different cost types, cost centers and level of work experience
Compare actuals vs. Budget
Reporting available in EUR and USD
Headcount forecast modeling based on deployed service points (customer contracts)
What would this cube look like?
Which additional information would perhaps be necessary? Where could these pieces of information come from?
What could be other ways to use or expand the cube?
Please present your answers / results in a suitable form."
Headcount Planning
Automatic calculation of staff cost based on Headcount planning
Reporting Actuals for number of FTE, cost per FTE split by different cost types, cost centers and level of work experience
Compare actuals vs. Budget
Reporting available in EUR and USD
Headcount forecast modeling based on deployed service points (customer contracts)
What would this cube look like?
Which additional information would perhaps be necessary? Where could these pieces of information come from?
What could be other ways to use or expand the cube?
Please present your answers / results in a suitable form."