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.