Operational Reporting – SSRS
Report on current performance metrics for benefits attributed to energy savings on sites and capital assets.
Analysis Services – MDX
Analysis Services data cube structure with complex criteria to query conflicting records due to different data sources, formats and categorisation.
Power App – Site Maintenance
Power App on standard Android Tablets and Phones, linked to SQL Server database for further BI.