Please enter your email address to get a message with login information for your application
Please enter your email address to get a message with login information for your application

Thousands of XLSX tables in a single application

Typical process of data collection from divisions

The bigger the company, the more divisions, often spatially dispersed, it contains. It is often necessary to collect data from remote employees and divisions. For this purpose remote employees usually fill in lots of XLSX files and e-mail them to the head office. After that, consolidated reports of baseline performance indicators are formed and used for management decision-making.

This typical process of work causes several problems: files get lost in e-mail, file versions get mixed up, it is difficult to control data inflow and it takes a lot of effort to create consolidated reports. As a result, information is received by the management with a delay, in an incorrect or incomplete form. Moreover, a lot of resources are spent to combine data collected from different employees and divisions into comprehensive data tables.

A typical data collection process is shown in the diagram below.

NinjaTable offers a solution

NinjaTable allows you to automate the process of data collection from divisions and remote employees. NinjaTable is accessible via the web interface, which means that you do not need any programs to install, only a web browser.

Instead of filling in lots of XSLX files and e-mailing them employees just open the application in a browser and complete necessary forms. After the report forms have been filled in, new information instantly gets to the database where the incoming data is checked and consolidated reports are created.

Data collection algorithm


Step 1. Form template creation

The Administrator creates a form template and a set of fields which will have to be filled in by the divisions (for example, revenue, number of clients, energy meter's readings for a period of time). Once created, the template is reusable.


Step 2. Adding a task

While adding a task a deadline is indicated and a list of users is assigned to the task. A form template can be attached which every user from the list will have to complete. ​


Step 3. Monitoring the tasks

The system allows to monitor the task, which means determining the percentage of the collected data and the phase of a task on which a certain user is working.


Step 4. Consolidated reports

After the users have completed the report form, a consolidated report for the management is automatically created. You can build diagrams and construct reports based on the collected data. NinjaTable will accelerate the work of the whole organization and will make all the incoming information available for analysis and decision-making.

This name will be used to create a unique NinjaTable Application for you
Please enter your email address to get a message with login information for your application
Try it for free!
NinjaTable is the original low-code development platform. Create powerful online database applications, customized to your unique needs.
Copyright © 2017-2018