Challenge Summary
Welcome to the "Hestia - Control Center Design Concepts Challenge ". In this challenge, we are looking to explore design concepts for a new application that will take a current spreadsheet process and design how it would work and look like a desktop application.
Hestia is a wholesale distributor of a variety of plumbing and building-related products. Hestia Control Center is an internal application that will help Hestia modernize their current spreadsheet process and allow them better access to data for reporting and analysis.
This challenge is to create concepts for the new Hestia Control Center screens and potential flow based on the provided information. This is not a complicated user experience - what we need is an application that will sit on top of a database and make interacting with the data easy for users.
We are providing the Hestia application brand guide to get you started. Let us know if you have any questions in the Forum!
Submit your initial designs for a checkpoint feedback
- IMPORTANT: We will not be extending Round 1. Adroc has an in-person Checkpoint Review with Hestia on Wednesday. Look to complete as much as possible as the review and feedback will be quick! The more detail and questions you have in your concepts the better for this meeting!
- As a part of your checkpoint submission, you must upload your submission to MarvelApp so we can provide direct feedback on your designs.
- Make sure to include a URL/comment the link to your marvel app while uploading your submission
- Make sure all pages have the correct flow! Use correct file numbering. (00, 01, 02, 03)
- As a part of your checkpoint submission, you must upload your submission to MarvelApp so we can provide direct feedback on your designs.
- Make sure to include a URL/comment the link to your marvelapp while uploading your submission
- Make sure all pages have the correct flow! Use correct file numbering. (00, 01, 02, 03)
Challenge Details
Hestia is a wholesale distributor of a variety of plumbing and building-related products. The Hestia Control Center is an internal application that will help Hestia maintain their data (for better reporting and analysis) while providing a simple user experience for users who need to keep their data up-to-date (but do not need to be technical/database wizards).
Background Overview
In the course of our standard reporting and analysis, Hestia manages data from many systems. While most of these systems contain fact and dimensions, they do not contain all the information that is required to create the reports the company uses on a regular basis. The data we use to classify and group our dimensions and measures are currently stored and maintained through excel spreadsheets stored on our internal network. As we move into a cloud-focused environment, we find ourselves in a situation where the old way of doing this is no longer sufficient. We now need a better system (web-based application) and database where files can be stored and maintained by the users (data owners) for many years.
Using a database presents its own complications. Most employees who maintain a spreadsheet for use in reporting have no skill in maintaining data in a database environment.
That is why we are looking to concept and design a new application that makes this experience easier!
Requirements
It is very important to think about how web-based applications work and how a user will interact with this data as it is not the same experience as using an excel spreadsheet. We are looking for the experience to be simple and easy to manage.
Wireframe (Hestia - Wireframe)
Please see the provided Wireframe. This will help you to understand how we see this information. We are looking for NEW and better user experience from the provided wireframe.
Application Flow and Functionality
1. Home/Login
- Users will be able to log in
- Users will use their existing MS Active Directory login
2. Main Dashboard/Table selection for editing (see wireframe)
- We invite different concepts/solutions for this interaction.
Database Selection
- The user will need the ability to identify and change the internal database that the application connects to.
- This is intended to connect to an Azure SQL DB. It can already be saved a saved connection when logging in to view or they can change/select another DB.
Data View
- Show a list of tables that the logged in user has access to. The user will only be able to edit data they have access to.
- Table names can be 15-20 characters
Table Selection
- The user selects from their list of tables and once they select the table they are able to see the information and filter on the different columns of data.
- A user will need to be able to filter and select records to update. (The current thought is that this should be done similar to excel ‘filter on top of the row’ format.)
- The user selects a different name and it will clear out the data/associate the new data
- The data will have a minimum of 2 columns and average up to 30 columns (Technically it can have hundreds of columns so if this happens how does the user interact with it?)
Data Edit
- After selecting the records, the Data Owner will be able to make changes to them or mark them as removed/deleted.
- The user is able to select multiple records in the table view to edit
- When a user incorrectly enters information, there needs to be a process to mark that data as invalid.
Approval
- An approver will see the ability to approve the edits
- Might need a way to identify tables that need approvals
Admin
- Admin screen to see all actions
3. Data Import / Export
- Provide import and export capabilities for large datasets.
- This could be done either through a select and import – or a copy/paste window.
- Copy Paste needs to be supported (Maybe excel like copy paste of multiple rows and columns needed)
- Excel / CSV Import and export
- When uploading/importing make sure the "error" experience is considered.
4. User Management
- We have 3 types of users (Associate, Approver, Admin)
- Admin will have a view where they can manage the users and edit their access
- Associate: This type of user will have 4-5 tables to choose from
- Approver: This type of user will approve the changes
- Admin: Will see many tables (so need to be able to handle viewing a large number of tables)
Design Considerations
- We are looking for a simple, easy-to-use, Informative, modern design.
- Have your designs of size: 1366 x 768px (Desktop only)
- Look at existing modern GUI guidelines and Angular UI components (standard systems of forms etc.)
Branding Guidelines
- Follow the provided Hestia guidelines
Important:
- Keep things consistent. This means all graphic styles should work together.
- All of the graphics should have a similar feel and general aesthetic appearance.
- Focus on User Experience / how the user interacts within this application
MarvelApp Prototype
- As part of this challenge, you must upload your screens to Marvel App
- Please send your Marvel app request to csystic@gmail.com (Challenge Copilot)
- You MUST include your Marvel app URL in notes /comments while uploading (in your marvel app prototype, click on share and then copy the link & share it within your notes while you upload).
Target Audience
- Internal Employees
Judging Criteria
- How well you plan the user experience and capture your ideas visually.
- Cleanliness of your graphics and design.
- Overall design, UI and user experience.
- Consistency across the UX/UI
- How well you interpret the example screens (business relevance) and show us new ideas and concepts.
Submission & Source Files
Preview Image
Please create your preview image as one (1) 1024x1024px JPG or PNG file in RGB color mode at 72dpi and place a screenshot of your submission within it.
Submission File
- Submit JPG/PNG for your submission files
- Submit Marvelapp as part of your submission.
Source Files
All original source files of the submitted design. Files should be created in Adobe Photoshop, Illustrator, XD, or Sketch!
Final Fixes
As part of the final fixes phase, you may be asked to modify your graphics (sizes or colors) or modify overall colors. We may ask you to update your design or graphics based on checkpoint feedback.
Hestia is a wholesale distributor of a variety of plumbing and building-related products. Hestia Control Center is an internal application that will help Hestia modernize their current spreadsheet process and allow them better access to data for reporting and analysis.
This challenge is to create concepts for the new Hestia Control Center screens and potential flow based on the provided information. This is not a complicated user experience - what we need is an application that will sit on top of a database and make interacting with the data easy for users.
We are providing the Hestia application brand guide to get you started. Let us know if you have any questions in the Forum!
Round 1
Round 1Submit your initial designs for a checkpoint feedback
- IMPORTANT: We will not be extending Round 1. Adroc has an in-person Checkpoint Review with Hestia on Wednesday. Look to complete as much as possible as the review and feedback will be quick! The more detail and questions you have in your concepts the better for this meeting!
- As a part of your checkpoint submission, you must upload your submission to MarvelApp so we can provide direct feedback on your designs.
- Make sure to include a URL/comment the link to your marvel app while uploading your submission
- Make sure all pages have the correct flow! Use correct file numbering. (00, 01, 02, 03)
Round 2
Submit your final designs with all checkpoint feedback implemented.- As a part of your checkpoint submission, you must upload your submission to MarvelApp so we can provide direct feedback on your designs.
- Make sure to include a URL/comment the link to your marvelapp while uploading your submission
- Make sure all pages have the correct flow! Use correct file numbering. (00, 01, 02, 03)
Challenge Details
Hestia is a wholesale distributor of a variety of plumbing and building-related products. The Hestia Control Center is an internal application that will help Hestia maintain their data (for better reporting and analysis) while providing a simple user experience for users who need to keep their data up-to-date (but do not need to be technical/database wizards).
Background Overview
In the course of our standard reporting and analysis, Hestia manages data from many systems. While most of these systems contain fact and dimensions, they do not contain all the information that is required to create the reports the company uses on a regular basis. The data we use to classify and group our dimensions and measures are currently stored and maintained through excel spreadsheets stored on our internal network. As we move into a cloud-focused environment, we find ourselves in a situation where the old way of doing this is no longer sufficient. We now need a better system (web-based application) and database where files can be stored and maintained by the users (data owners) for many years.
Using a database presents its own complications. Most employees who maintain a spreadsheet for use in reporting have no skill in maintaining data in a database environment.
That is why we are looking to concept and design a new application that makes this experience easier!
Requirements
It is very important to think about how web-based applications work and how a user will interact with this data as it is not the same experience as using an excel spreadsheet. We are looking for the experience to be simple and easy to manage.
Wireframe (Hestia - Wireframe)
Please see the provided Wireframe. This will help you to understand how we see this information. We are looking for NEW and better user experience from the provided wireframe.
Application Flow and Functionality
1. Home/Login
- Users will be able to log in
- Users will use their existing MS Active Directory login
2. Main Dashboard/Table selection for editing (see wireframe)
- We invite different concepts/solutions for this interaction.
Database Selection
- The user will need the ability to identify and change the internal database that the application connects to.
- This is intended to connect to an Azure SQL DB. It can already be saved a saved connection when logging in to view or they can change/select another DB.
Data View
- Show a list of tables that the logged in user has access to. The user will only be able to edit data they have access to.
- Table names can be 15-20 characters
Table Selection
- The user selects from their list of tables and once they select the table they are able to see the information and filter on the different columns of data.
- A user will need to be able to filter and select records to update. (The current thought is that this should be done similar to excel ‘filter on top of the row’ format.)
- The user selects a different name and it will clear out the data/associate the new data
- The data will have a minimum of 2 columns and average up to 30 columns (Technically it can have hundreds of columns so if this happens how does the user interact with it?)
Data Edit
- After selecting the records, the Data Owner will be able to make changes to them or mark them as removed/deleted.
- The user is able to select multiple records in the table view to edit
- When a user incorrectly enters information, there needs to be a process to mark that data as invalid.
Approval
- An approver will see the ability to approve the edits
- Might need a way to identify tables that need approvals
Admin
- Admin screen to see all actions
3. Data Import / Export
- Provide import and export capabilities for large datasets.
- This could be done either through a select and import – or a copy/paste window.
- Copy Paste needs to be supported (Maybe excel like copy paste of multiple rows and columns needed)
- Excel / CSV Import and export
- When uploading/importing make sure the "error" experience is considered.
4. User Management
- We have 3 types of users (Associate, Approver, Admin)
- Admin will have a view where they can manage the users and edit their access
- Associate: This type of user will have 4-5 tables to choose from
- Approver: This type of user will approve the changes
- Admin: Will see many tables (so need to be able to handle viewing a large number of tables)
Design Considerations
- We are looking for a simple, easy-to-use, Informative, modern design.
- Have your designs of size: 1366 x 768px (Desktop only)
- Look at existing modern GUI guidelines and Angular UI components (standard systems of forms etc.)
Branding Guidelines
- Follow the provided Hestia guidelines
Important:
- Keep things consistent. This means all graphic styles should work together.
- All of the graphics should have a similar feel and general aesthetic appearance.
- Focus on User Experience / how the user interacts within this application
MarvelApp Prototype
- As part of this challenge, you must upload your screens to Marvel App
- Please send your Marvel app request to csystic@gmail.com (Challenge Copilot)
- You MUST include your Marvel app URL in notes /comments while uploading (in your marvel app prototype, click on share and then copy the link & share it within your notes while you upload).
Target Audience
- Internal Employees
Judging Criteria
- How well you plan the user experience and capture your ideas visually.
- Cleanliness of your graphics and design.
- Overall design, UI and user experience.
- Consistency across the UX/UI
- How well you interpret the example screens (business relevance) and show us new ideas and concepts.
Submission & Source Files
Preview Image
Please create your preview image as one (1) 1024x1024px JPG or PNG file in RGB color mode at 72dpi and place a screenshot of your submission within it.
Submission File
- Submit JPG/PNG for your submission files
- Submit Marvelapp as part of your submission.
Source Files
All original source files of the submitted design. Files should be created in Adobe Photoshop, Illustrator, XD, or Sketch!
Final Fixes
As part of the final fixes phase, you may be asked to modify your graphics (sizes or colors) or modify overall colors. We may ask you to update your design or graphics based on checkpoint feedback.
Please read the challenge specification carefully and watch the forums for any questions or feedback concerning this challenge. It is important that you monitor any updates provided by the client or Studio Admins in the forums. Please post any questions you might have for the client in the forums.