Collect and share monthly sales forecasts from your sales team, financial statements from your group subsidiaries, cost budgets from your department leaders and many more.
The data1.io cloud service is updated with 11 monthly releases per year.
HOW DOES IT WORK?
Excel Web Client
Normal Excel files are enriched with the data1.io framework to so-called Workbooks. After uploading the workbook into your application your collector users can use it immediately as Web Client for their data entry. The data1.io framework enables a bidirectional connection between the spreadsheet and the cloud service. Every application gets its own, individualized workbook file(s). Workbooks are available for our public showcases and can be created individually either with the workbook wizard or manually from scratch. Programmed in Angular, the Web Client is hosted in the Microsoft Azure Cloud.
The heart and brain of the data1.io system. In writing mode it transforms the collected data from the Excel Web Client into records and stores them into your indiviual data1.io application database. In reading mode, the cloud service extracts and aggregates the records for delivery to the Excel Web Client and/or the Web App. The cloud service also contains the API which provides all your data as a secure ODATA feed for your receiving applications like Power BI, MS Excel, your ERP system, your enterprise budgeting and consolidation solution and to every system that can connect to ODATA feeds. The Cloud Service is hosted in the Microsoft Azure Cloud.
#2 Workflow & Security Functions
As an organizer you define the collection workflow(s). That means you set the time frame the application is open for data entry and you define the users who are part of this data collection (“Access control”). The application is closed automatically for all collector users after reaching the closing date of a collection process.
Your collector users automatically get invited and reminded via workflow e-mails as long as they did not deliver their data. Every collector user can close his/her individual collection task by clicking the FINISH button after entering all relevant data. Track the collection progress and handle your „black sheeps“.
Within the application the dimension tree brings multi-user security into Excel. As an organizer you can restrict access of a single user to defined organizational elements in the dimension tree (“Row Level Security”).
#3 Open data architecture
data1.io is designed with an open data architecture – i.e. it is easy for you as the owner of the data to use your collected data in other systems. The data1.io cloud service provides a modern ODATA feed which makes it easy to connect data1.io with other systems like Microsoft Power BI, MS Excel, Power Apps as well as ERP Systems and other Business Intelligence applications. Of course, alternatively all data can be exported to traditional csv files as well.
data1.io and Power BI – better together! We recommend to use data1.io together with Power BI since data1.io has its focus on data collection (and not reporting) and Power BI is a great dashboarding service which makes it easy to combine different data sources within the same dashboard application.
WHO USES IT?
data1.io automatizes typically excel-based data collection processes on a daily/weekly/monthly basis, therefore data1.io is used by companies and public institutions
- who are typically innovative pioneers within their line of industry
with a data-driven management culture
with a strong digital transformation strategy
investing in projects to automatize business processes
- who have a need to automatize their forecasting and data collection processes
with the need for the flexibility of an Excel interface
with a number of users > 5 (but better > 20, 50, 100)
recurring on a daily/weekly/monthly basis
with a preference for a cloud solution (although data1.io also offers an on-premise option)
- who have evaluated the technology alternatives and are not satisfied with them
Register now and test the public showcases immediately! Furthermore you have the option to create your own data1.io application which enables you to setup your individual data collection process inside or outside your organization. Please let us know your feedback!
Sign up to our monthly community newsletter and get all the news about the latest monthly release!