Key Requirements: Report on current performance metrics for benefits attributed to energy savings on sites and capital assets.
Delivered: SQL Server database designed and populated via SQL Views with Reporting Services (SSRS) reports designed, enabling any point-in-time suite of management information generated and exportable into individual PDF documents for sharing and archiving.
Greenfield database design
SQL Server integration
Tables, Views, Queries and Stored Procedures
SSRS design for integrated deployment
Generation of shareable reports as full PDF documents
Operational Reporting - SSRS
SQL Server 2016, SSRS