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

    Cart