IoT Heatmapping

Key Requirement: Process millions of records into visual dashboards for BI.

Delivered: PowerPivot and base Excel 2010+ heatmapped frontends to SQL Server system. T-SQL Stored Procedures used to process data into OLAP structures and fed into pivots.

  • Big data visualised with variances
  • Worked around Excel PowerPivot licencing differences
  • User driven processes
  • SQL Server data sources
Project: IoT Heatmapping Year: 2016 Technology: PowerPivot, PowerBI, SQL Server 2016
    Project Categories