Almost all large companies have extensive technology portfolios to manage. Often there are large savings to be made where some tools are under utilised. The challenge is to uncover risks involved in development of portfolio management system that aims to save money when used by an IT leader at a large Design Consultancy.  
Design Brief
Create a web interface with the following requirements.
A user can upload a file that they have exported from another system. 
This file will contain information about their software licenses: name of license, number of licenses they own and number of people who are using the licenses.
Graphically represent this information in a manageable way for the user to understand which licenses are not being used and how many they have.
Here is an example file that you have to upload (imagine there are 10 - 20 lines)
Process
a) Inspiration Board 
b) Basic user story development 
c) Risks
d) Wireframe development
e) Prototype
f) Frames presentation 
g) Enhancements 

Inspiration board
  
User Story Development
By describing the desired outcome of a product feature, a user story reminds everyone involved what the user’s goals are. But most importantly, it allows myself, the designer, to visualise the functionality of a product and helps organise and prioritise the way each function is designed. Used at an early stage of the design process, this is a quick way to empathise with the users when designing a product that has multiple features.   
User Story 1 - As an IT Leader I want to be able to upload a .xls file using an Analysis Dashboard. Assume this an error free file (no blank fields, incorrect format, etc). Feedback to the user about the successful upload is needed. Another assumption is that users cannot upload the wrong file format as the file browser will only display the files that are ‘readable by the system’ making picking the file as easy as possible.

User Story 2 – As an IT Leader, who has a successful file uploaded, I am shown that the upload is successful. Then all the results are displayed on the one page in a dashboard format. Assume this is instant and loading frames are not needed. The page header displays a title matching the uploaded file name (September 2020 System Upload).  Below the header section, an overview of the system upload file is displayed. The overview section contains cards detailing the uploaded file information.  These cards should be as follows –  
Pie chart that displays the ‘In Use’ Vs ‘Not In Use’ details of all programs.
Potential monthly savings based on removing all ‘Unused’ programs.
Chart called ‘Monthly Trend’ showing September's file upload vs other file uploads. This will be to highlight the reduction in ‘Unused’ programs across time.
Under the Overview section of the Analysis Dashboard is a program by program breakdown. One program per card. The cards should be compact and scannable. Display the program with the biggest potential savings first. There is the ability to search by program, sort by a) ‘Number of licences’ descending and ascending AND b) ‘Licences In Use’ descending & ascending. 
Risks
The file is uploaded immediately and a simple loader displays the progress. Therefore there is no need for a list screen to manage the uploads / view the progress of the upload. If this cannot be accomplished there is a risk of the user experience being compromised.
This tool is part of a bigger web application. I should assume that there is a home page that is used to navigate to this page. There may be a risk of the user not understanding what is meant by the navigation to get to the Portfolio Analysis tool. This should be the subject of a usability study.
I am calling this page ‘Licence Analysis”. But this could need to be change in line with the results of any testing with the users. 
The software analysis is done on a monthly basis by the auxiliary system. This auxiliary system provides a .xls file. The file name is based on the date of creation. This is also how the Software Analysis system segregates the uploaded files. Uploading a file with a name that already exists in the Analysis System will override the original file data. The risk here is if the auxiliary system changes to allow user to export multiple files per month, the structure of Portfolio Management system will also need to change. 
Wireframe Development
Interactive Prototype 
Failed Upload Process
A failed upload can occur when the file format is incorrect. Only the correct file types can be selected for upload.  
Enhancements 
1)
There should be a calendar input within the header to look back at older uploads.
2)
Users should have the means of flagging a program that needs attention. This would provide an action derived from the analysis page workflow.  A method of filtering flagged items would also be needed. 

Learnings
When undertaking a project with similar undefined aspects in the future, I would like to talking to users that have experience in similar systems. This would uncover patterns that may help a product team improve the final implementation tenfold.  




Back to Top