Charter Communications

Capacity Planning Application

DotsDots

How Devetry Helps Charter Communications Visualize Capacity Planning

24

Data centers Across the US

80%

Productivity Leap

Devetry is helping Charter Communications design and develop a custom application. Within the app, resource requests are approved based on custom forecasting and trend models.

The Charter capacity planning team uses this information to make accurate predictions of resource needs. While we continue to iterate on the application, they can begin to justify large infrastructure spending that helps them stay ahead of these needs.

The Problem

Setting up cloud compute resource infrastructure in data centers all over the country is not a quick and easy task. It takes investment, time, and technical expertise. Missteps can cost tens of thousands of dollars. 

Charter Communication’s capacity planning team came to Devetry with the challenge of multiple data sources, and no way to visualize all the data comprehensively. 

The team needed a way to take resource requests and examine historical/current resource usage data to accurately plan for resource needs. This tool would incorporate current utilization, planned decommissions, and future requests to display forecast models that would empower the team to stay ahead of the need. 

Charter Communications needed a custom application to easily and accurately predict future resource utilization so they could plan ahead for additional resource needs and confidently approve requests.

DotsDots
01

Request Management Dashboard

02

Data Visualization

Requirements

Charter Communications needed a requestor and admin-facing dashboard.

Requirements

Charter Communications needed a requestor and admin-facing dashboard.

Requirements

Chater required both historical and projected resource usage.

The Solution

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.

Left

01

/03

Right
Ellipse

The team used typescript on both the front and back ends that would allow them to share components. The advantage of using Typescript over other programming languages (such as traditional javascript) is that it empowers the team to catch bugs sooner (with features such as type checking).

Background

The Results

  1. Aggregated allocation, utilization, and capacity data are now viewable all in one place.
  2. The Capacity planning team can see all requests without making siloed approvals on resources.
  3. Requests are associated with projects allowing the admin team to see the rolled-up capacity needs of a given project. (CPU, RAM, Storage)
  4. Each request enables the requestor and admin to communicate about a specific request and notifies the admin and requestor when changes on that request are made.
  5. The new request form requires requesters to provide all the information necessary for provisioning before submission.
  6. Requests made within very specific parameters are auto-approved saving the Capacity Planning team time on reviewing requests.
  7. The Charter team can more confidently and accurately justify resource spending based on the modeling algorithm
  8. Helps the Charter team avoid the rush of implementing new resources in an unreasonable time frame.
Background