Danish Supermarket Group Manages 10 Terabytes of Business Intelligence

Tags: CRM, Supermarkets & Grocery Stores, Technology

Type: Case Study

With more than 1,000 stores, Danish Supermarket group is one of Denmark’s largest retailers. To help keep up with customer needs, the company manages more than 10 terabytes of business intelligence data on the Microsoft Application Platform. To enhance its analytics, Danish Supermarket recently upgraded to Microsoft® SQL Server™ 2005 Analysis Services for its 600 gigabytes of multidimensional cubes. The company has an additional 9 terabytes of data in its relational data warehouse, which has also been upgraded from SQL Server 2000 to SQL Server 2005 Enterprise Edition (64-bit). All of the BI data is hosted on an HP Integrity server computer with 8 Dual-Core Intel Itanium processors. Moving to SQL Server 2005 Analysis Services has given the company’s 700 analysts the ability to do product-level analytics of the more than 1 million products carried by the stores.

“Our previous system worked well but it wasn’t until upgrading to SQL Server 2005 Analysis Services that we were able to perform the analytics we needed to do on the product level,” says Kim Nissen, IT&S System Development Manager, at Danish Supermarket. “Our purchasers and analysts now have access to the data they need from more than 12 billion rows of relational data feeding into our multidimensional cubes. The combination of Analysis Services 2005 with our TARGIT BI solution is enabling our people to perform analytics on the product level that simply weren’t possible before. This is important to us because we use our product analytics to better meet the needs of our customers in the store.”