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
