Manufacturer Speeds Queries and Improves Business Decisions with New BI Solution
RHI, a global supplier of refractory products, wanted better BI (Business Intelligence) tools. To improve query performance and reporting capabilities, the company implemented a tabular data model based on Microsoft SQL Server 2012 Analysis Services and the new xVelocity memory-optimized column store index. Queries that once took more than a minute to run now finish in less than 2 seconds and the company has a simpler data model that it can use with multiple BI tools. The company can now make better data-driven decisions while cutting costs.