Devetry built (and continues to build) Charter Communications a capacity planning application that aggregates historical allocation and usage data. The application organizes the information using ETL scripts which incorporate digestible data into the application database. The data is then displayed in trend charts so the team can see how capacity utilization changes over time.
Using an algorithm that incorporates yearly trends along with more recent historical data, the graphs display future usage predictions that also incorporate pending request data (planned, provisioned, and decommissioned).
Later this year, we will be working on a portal that allows end-users to 'request' capacity, and an admin side that can 'approve' it. This enables them to see 'the future' capacity because we know what the requests are, and how long they will be provisioned for.