A collaborative web application developed by a team of students using agile methodology. The platform, targeted at small Singapore-based organisations, was finalised after undergoing multiple iterations of prototyping with thorough market research, as well as surveys, interviews and user testing with HR executives/leaders, managers in SMEs, and data scientists.
To create a webapp with the following:
- Prioritise ease-of-use, customisability, and speed.
- Generate visualisations from the selected four HR metrics – Payments, Attrition, Skills, and Demographics.
- Form validation; Flag errors to the user in simple terms.
- Customisable visualisations with recommended graph types based on user's selected options.
- View raw data in a table and export to different file formats.
- Generate basic analysis with simple statistical techniques.
Install external dependencies
npm init
npm install
Create a local MySQL server using MySQL WORKBENCH
- Install MySQL by following this guide: https://dev.mysql.com/doc/mysql-installation-excerpt/5.7/en/windows-installation.html (for windows)
- Select "Developer Default" to install MySQL server and other MySQL tools
- If you would prefer not to install "Developer Default", please make sure MySQL Workbench is installed
- Open MySQL Workbench
- Create a local server following this guide: https://dev.mysql.com/doc/mysql-installation-excerpt/5.7/en/starting-server.html
- Once you are in your local server instance, select "Data Import/Restore" in the navigator sidebar on the left.
- Select the "Import from Self-Contained File" option.
- Select the "ASP.sql" file included with the webapp
- Click "Start Import"
Once you have completed the steps above
- Please change "host" and "user" fields in index.js to your personal MySQL username and password
- You can also change your preferred port by changing the value of the port variable
- Run
node index.jsto start the webapp - Open your browser and navigate to "http://localhost:/". The default port number is 8080.