The PowerApp PowerAnalytics combines several functions that allow the user to accumulate, analyze and graphically present the data provided by the Datasync.
For the graphical processing of the data we use PowerBI (Microsoft), which comes with a set of standard reports. In cooperation with our customers, these reports are continuously developed further, whereby everyone always benefits from the further developments. In addition, a section for customized reports is under development to meet special requirements.
Direct data access
If the “normal” functions of PowerAnalytics are not enough for you and your power users have further requirements, we can also set up access options to the database area on request. Here you can create your own queries via SQL (JDBC/ODBC).
As an additional option, Reporting Delivery is an automated, configurable and scheduled system for creating customized and standard reports. Reports are stored in target directories on a scheduled basis. In addition, used SQL queries are stored in the customer area of the database, allowing reports to be generated on demand.
If you want to “freeze” your data on a specific date, such as for a year-end closing, the database snapshot is the solution you are looking for. If desired, this snapshot can also be integrated into PowerBI as a separate instance for further analysis.