Introduction
For Project META, the Business Strategy & Data Integration team created an online survey system linked to the SQL database which allows data interaction using SQL on the backend page. The purpose of the survey system was to receive basic user information including name, email, and gender, and also get additional information on user clothing preferences, including the size, color, and style preferred by the users.
In addition, an admin dashboard was developed. The development included data interaction using SQL on a backend page, and a frontend dashboard linked to the SQL database. The purpose of the admin dashboard was to allow shop owners (admin) to easily access and understand the survey data through data visualization and interactive graphs.
<aside> <img src="/icons/report_red.svg" alt="/icons/report_red.svg" width="40px" /> Disclaimer: The dashboard we have developed is not going to be used as a public website, but will be integrated in the internal software of shop owners in the future. Thus, the dashboard is in a locally controllable format, not a public website.
</aside>
Survey Form | Final Design & Features
The screenshot below demonstrates the complete survey form. Survey questions include the name, email, gender, age, and height of customers, and also include clothing features such as size and color to collect additional information on customer clothes preferences.
HTML and CSS were used when developing the survey form for Project META.
Database | Functionality
To access submitted surveys store responses and manage the data, we created a web server connected to a MySQL database. After responses have been submitted, the admin can access the data from MySQL Workbench, as shown below:
The submission of the survey form by users highlights the successful implementation of user registration on the front end. This marks the initiation of user engagement with the system and demonstrates the system’s capability to store survey data and integrate it with the backend.
Admin Dashboard | Functionality
The final admin dashboard created looks like the figure below. Features include each of the questions on the survey form in visualized forms (interactive charts) and admin activity.