The GoSpotCheck application helps retailers and brands collect thousands of data points each day. Although it seems instant to many of our customers, the process to aggregate data from the field into an online dashboard is complex.
The information from the app goes into the SQL database, which is accessed by our data team. Then, there are two separate pools that the data team addresses differently – customers that do want advanced reporting, and customers that do not.
If the data does not require advanced reporting, our data team is not involved. The data comes in from a device – mobile phone, tablet or computer – and is kept in a data store. This store drives almost everything visible within the product and is also the source of aggregations in the mission overview page – or homepage – for customers. Then, a web application makes an aggregation request of the data store and does the necessary calculations. The initial data that comes in from various devices is like stored static records – counts, totals, sums and other operations transform raw data into a map, graph or other framework.