December 2019 Release

We are happy to announce the December 2019 Release which is dedicated to the preview of the Tenant Admin Portal and to some important research.

1. New Tenant Admin Portal in the Web App (Preview)
   The Tenant Admin Portal will be accessable for the role "Tenant Admin" as a new item group in the left pane navigation menu:
   
   Please be aware that the Tenant Admin Portal is not yet publicly available in the Web App, it will finally be released together with the "Enterprise Plan" (planned for later 2020). All existing Free Users are now allocated to the role "Application Admin", with the purchase of an Enterprise Plan the role "Tenant Admin" will be activated.
   
   
2. New Application Switch in the Web App (Preview)
   The Tenant Admin will have access to all applications within a Company`s Tenant and therefore the (already existing) dropdown will contain all applications. With the dropdown the application can easily be switched in every menu item of the navigation pane.
   
   
   
3. New Datamodel Settings in the Web App (Preview)
   For the Tenant Admin it will be possible to design the datamodel behind a data1.io application, i.e. the tables and fields can be defined individually:
   
   We did not finally decide how much individual configuration we will grant (resp. will make sense).
   
   
4. Research: Template Automation in Excel Online
   We did some important research concerning using Excel Online for data entry. One major issue with Excel Online is that it is made (by Microsoft) for concurrent data entry in the same Excel File. But exactly this functionality is counterproduktive for collection workflows with data1.io since we use the Excel File (the "Template") only as a form and not as a file. So we have developed a prototype which generates an individual Copy of the Template File for every active collector user. In the workflow files we integrate the invidual link:
   
   This way the collector users opens his/her individual copy of the Template File and is not disturbed by other users who do their data entry at the same time:
   
   
   
5. Research: data1.io API with sensor data
   We did some other important research concerning generating a huge amount of records in a data1.io application. We used a sensor on a Raspberry Pi which writes ~ 38.000 signals per day (i.e. one signal every 2-3 seconds) to the API of a data1.io application.
   As you can see in the area chart below we made a lot of experiments in November so that the regular amount of data is sent +/- since the beginning of December. Until yesterday the application contains 1,5 m records ("signals"):
   
   This experiment is important for us to learn how much hardware ressources are necessary for different database processes. While the write process to the API only needs small ressources, especially SQL queries with a "group by" (generated by a Direct Query application in MS Power BI) needs lots of ressources (see peaks on the left). In contrast, the extraction of the overall fact table (executed with the ODATA Konnektor of MS Power BI) works with only little database ressources: 
   
   
   
6. Further Improvements
   Like every month, we have removed some bugs and solved a few smaller issues.
   

Thanks again to all early adopters who gave us their valuable feedback. Hope you like the new features, let us know what you think about it!