With an increasing amount of data being stored in the modern data warehouses, organizations need solutions that scale proportionally. This paper illustrates the integration of Microsoft SQL Server* 2016 and Intel® Xeon® E7 platform driving advanced analytics on a large 100TB dataset. The work is the culmination of a thoroughly tested configuration to provide meaningful insights on large datasets.