A cube exists for Daxeam to allow analysis of the budgeted cost and the actual costs for work orders.
Below is a PivotTable I created to compare the budget vs actual costs by the asset type. Then I have a slicer filter by department. I could have prettied this up to analyse over time. Drawn some graphs.
Create a quick graph to compare the costs over time by department.
The matrix below illustrates the dimension relationship in the cube. At the top, you see the measure groups (transactions). On the left, you see the dimensions to analyse by.
More to come in future blog posts on BI.
