Our client needed a company with technical expertise to design and build a database-driven webpage that integrated into their existing website, including interactive data visualization of the collected information.
For the past seven years, our client had been collecting data on the state of a particular business sector in Alberta. They had been presenting this data in a static report, and were looking to move to an online portal that presents viewers with new and historical data in a more interactive way.
We were ideally suited to complete the job because of our experience with extensive data sets, as seen in Spartan One software.
The following were deliverables, expectations, and benchmarks for success:
- Meeting with key stakeholders to confirm alignment of objectives and review existing dataset to ensure sufficient normalization for database development - within 10 days of contract signing
- Creating database schema - within 7 days of data gathering
- Development - 5 weeks
- Quality Assurance Testing - upon completion of development
- User Acceptance Testing - within 1 week of QA testing
- Audit and Recommendations Report - within 15 days of project completion
The deliverables for this project were:
- Database Schema
- API Documentation
- Database restore SQL for environment creation
- Node JSapplication package for deployment
- Node JScontains theAngular JSapplication
- Unit Tests forNode JSandAngular JScode
- Node.js® is a platform built on Chrome's Java Script runtime for easily building fast, scalable network applications. Node.js uses an event-driven, non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices.
- Authentication will be leveraged through existing services of: LinkedIn, Google+, Twitter, Facebook, Client Database
- Restful API service will be used to present data
- Restful API has been chosen because it is:
- Standards-based (runs on top of HTTP)
- The back-end database will be created with SQL
- My SQL
- Angular JSis a client-side Java Script framework that allows the extension of HTML vocabulary for applications. The resulting environment is extraordinarily expressive, readable, and quick to develop.
- A custom application will be created to consume the Restful API
- Use of existing graphing libraries will be used to present data
- Twitter Bootstrap Responsive Design will be used to support all device types
- Bootstrap is compatible with the latest versions of all major browsers. It gracefully degrades when used on older browsers such as Internet Explorer 8. It also supports responsive web design, meaning that the layout of web pages adjusts dynamically, taking into account the characteristics of the device used (desktop, tablet, mobile phone).
- Gather requirements for Data Visualizations requirements
- Creation of a data schema to support existing data set
- Creation of a Restful service with data filtering services on top of SQL
- Creation of documentation for the API
- Creation of a Web Application to consume the Restful service
- Creation of data visualization
The estimated project timeline was as follows:
- 1 week gathering data
- 1 week creating database schema
- 1 week to develop Restful API service
- 4 weeks to develop Angular JS client and Data Visualizations
- 1 week of Quality Assurance Testing
Our client was looking to create a flexible reporting engine for a series of annual datasets. This required the creation of a standard database to draw information from, as well as a finished web page to display the data, enabling users to quickly and easily filter data by size, sub-sector, and region to isolate and compare the information that matters the most to them. The information was presented to users as online interactive infographics, and developed according to modern web standards, with accompanying support technical documentation.
Leveraging Spartan Spark’s technical experience, we were able to create a quality software application that was able to scale as their dataset grew, and customize as their uses for the data grew.
The online interactive data visualization webpage, as developed by Spartan Spark, provided an optimum user experience because of its loading speed and ease of use on a variety of devices (desktops, tablets, mobile).