SQL Reps - PAVIS Reporting System
The PAVIS REPORTING SYSTEM offers you, as a plant operator, an effective and clear way to get an overview of the production data stored on your SQL databases.
Relevant production data stored on SQL servers is filtered out as required, processed and incorporated into reports specially prepared for you.
Manually generated data such as laboratory values are recorded for specific reports and written back to the databases. The reports are accessed via a web browser.
BASIS OF THE REPORTING SYSTEM
SQL database tables are used to record production data and recipe values.
The reports to be created are based on data from database queries that are generated or read using the SQL Server Management Studio and database query functions.
Example for Braumat:
USER INTERFACE
SQL database tables are used to record production data and recipe values.
If necessary, solutions such as Power BI can also be used for visualization.
ADVANTAGES FOR THE SYSTEM OPERATOR
✓ Comprehensive storage of production data in the associated databases
✓ Professional processing of data for analysis purposes
✓ Needs-based, tailor-made reports for individual business areas and the specific information needs of plant operators
✓ Basis for energy management and ERP systems
✓ Flexibly expandable
