Custom Server Design App
Dell’s server design team of twelve needed help converting a bloated Excel sheet into a usable web product. After years of using a home grown spreadsheet for planning, it was time for a devoted tool to bring much needed efficiency. This interface was a major challenge, and a ton of fun!
High-Level User Needs
- A need for a user-friendly interface to quickly build a large system for ordering parts
- Performance and reliability issues
- Reduction of human error to save money and time
- Quicker onboarding of new team members
Solutions
- A new snappy web app and visual interface
- A new interactive visualization of the rack being built
- Interactivity helped to reduce the viscosity of content
- The ability to and remove secure users
- Simplicity reduced training and reliance on human knowledge
- Increased cable length accuracy
Discovery of initial workflow
This sheet had over 20 tabs and each tab had way too many columns. Just viewing this document is a challenge and required side-scrolling. Some of the information was redundant, some of it was false, and all of it required a deep knowledge of the history and layout of the document.
Reducing width
I began by reviewing the relevant information and creating a concept sketch. I stacked the columns horizontally. At this point it was still bad, but was starting to look more feasible.
A new interactive layout
Instead of endless tabs, we now had an interactive visual diagram of the server rack and its components.
Adding a device
To add a new device, you simply click an empty slot and select a device from the database.
Managing cables
To manage cables, we were able to stack the corresponding rows. We also added visual indicators for colors.