 Thank you for joining this lightning talk about doing data analytics in NextCloud. I will talk about open source data warehouse and reporting using the analytics app. My name is Marcel Charello, and after several years of offending the audio player, this is my second major app. Every application starts with the demand. With analytics, the idea was to have a data warehouse completely on-premise. It should connect data from different sources and provide seamless NextCloud integration for perfect usability. Of course, flexible visualization of your data in all directions. Afterwards, if you have a report, share the data with your internal users, with your colleagues, or even with the external customers. The aim was to create a small alternative to existing business intelligence tools on the market. Based on my professional background in business intelligence, the architecture of the analytics app is following a layered and modular approach and is fully integrated into the NextCloud user experience, like workflows, notifications, activities, and also the new NextCloud 20 dashboard. On the following slides, I will give you an overview about the backend, front, and then also two use cases of the app. Let's have a look at the backend first. Analytics offers various connectors out of the box. On the NextCloud side, data can come from files, workflows, or manual data. If you need to read data from external sources, connectors for GitHub, JSON, or also a website grabber is available. And if you plan to integrate analytics in your IoT setup, for example, a REST API, can receive data from external scripts. Then all of these data sources can either be used for real-time reporting or also be stored into the internal storage via daily snapshots, for example. Let's have a look what it can do with the data. Obviously, it's all about visualization. Reports offers table, various chart types, filter, drill-down capabilities. It's everything that you would expect from a reporting solution. For collaboration, reports can be shared externally via links or internally for users and groups. And when talking about seamless NextCloud integration, obviously the new NextCloud 20 dashboards with these nice microcharts, the best example, or also notifications based on acceptance. But how does it look like in the real world? I would like to show you two use cases which I am actually using on a daily basis. I have little Bluetooth moisture sensors in some of my plans. Then I have a little Raspberry which is reading these values and pushing them into the NextCloud REST API. Within the reporting, then I can see the history of the watering, but to make a real use out of it, I defined threshold for the moisture levels. And whenever a plant is drying out, I'm receiving a push notification via the NextCloud. IOS app. My next real world example is financial data. Using NextCloud workflow, I'm monitoring files with the NextCloud. And whenever new data is added, it's automatically added into the analytics report. I shared this report via a password link with external customers who can always analyze this up to date data without even having a user in NextCloud. I want to thank you for your attention and have some numbers to close the presentation. Analytics is now nine month olds, has already around 8,000 installations. It's now the next feature release and is already fully NextCloud 20 ready. In this context, I want to send some special thanks to Julius and Yoas from the NextCloud team who made this integration even possible. Please enjoy the rest of the conference and I'm looking forward to any feedback or questions. Thank you.