TELMORE, a Danish telecommunications operator, needed an easier way to analyze 5 terabytes of disparate data without hindering system performance or availability. To achieve this, TELMORE built an enterprise data platform with Microsoft SQL Server Fast Track Data Warehouse. Now, TELMORE expects to enhance customer service, speed time-to-market, increase revenue, and boost productivity.
TELMORE provides mobile phone plans and broadband services to residents in Denmark. The company’s 130 employees support 750,000 customers through a corporate Web site and by phone. TELMORE does not have a physical retail presence, so its IT systems must be available around the clock—and the architecture must facilitate reliable, high-performance transactions.
||Our new data warehouse built with SQL Server Fast Track Data Warehouse gives us a 360-degree view of customers. This helps us design the best products and provide the best possible customer service.
Chief Financial Officer
In 2009, TELMORE struggled to effectively use its data. Changing business models and rapid expansion had spurred the creation of disparate systems to support processes such as ordering, billing, Web tracking, and customer care. More than 5 terabytes of data was essentially in silos, a number that was expected to quickly grow to 10 terabytes. Only a few scheduled reports existed, and it was hard to alter them or create new ones. For ad-hoc analysis, employees had to contact system administrators, who manually extracted the data from production systems. After obtaining the requested data, employees had to manually compile and analyze it.
Without an easy way to create meaningful reports, TELMORE found it difficult to quickly customize its offerings—a critical requirement for success. “The telecom market in Denmark is extremely competitive,” explains David Bojsen, Data Warehouse Coordinator for TELMORE. “We have to be very focused on understanding our customers’ needs and providing them with solutions they can use. However, analyzing data at a detailed level was not really possible—not without slowing the performance of the production systems.”
To address its challenges, TELMORE decided to implement a data warehouse solution that would aggregate all corporate data. It needed to be easy to deploy, maintain, and use, and the architecture had to be highly scalable and reliable.Solution
After several attempts to design its own data warehouse, TELMORE evaluated numerous turnkey offerings and ultimately chose to build one with Microsoft SQL Server Fast Track Data Warehouse. It includes preconfigured and flexible reference architectures and implementation plans to create a highly available, reliable, and scalable enterprise data platform that provides self-service business intelligence capabilities. “After evaluating offerings from the leading suppliers, we found that we could implement a data warehouse with SQL Server Fast Track Data Warehouse 50 percent faster,” says Bojsen. “Most importantly, the Microsoft solution would provide the best end-user experience because it can integrate more easily with our existing office tools. Microsoft also offered a professional approach and a stronger vision for the future.”
In addition, TELMORE recognized that the Microsoft solution would speed implementation and lower risk. “The packaged enterprise data warehouse offering from Microsoft would help us greatly with planning, designing, and documenting our solution because we could use standard templates,” he adds.
In September 2009, one engineer from TELMORE began to work with three Microsoft Services consultants to help design and implement the solution—supported by Microsoft SQL Server 2008 Enterprise data management software—starting with one data source and one cube. To load and combine data in the warehouse, the team uses Microsoft SQL Server 2008 Integration Services. To provide for online analytical processing and data mining, the team employs Microsoft SQL Server 2008 Analysis Services. TELMORE also uses Microsoft SharePoint Server 2010, TARGIT reporting tools, and Microsoft Office Professional 2007 to support an interface to the data warehouse. The underlying hardware architecture includes one HP ProLiant DL785 G6 server computer with six HP Smart Array P800 controllers—and a direct-attached storage solution built with six HP StorageWorks 60 Modular Smart Arrays, each with eleven 450-GB disks.
The framework and knowledge provided by Microsoft Services will allow the IT staff at TELMORE to add 19 additional data sources to its warehouse. Employees will begin to use the solution in May 2010.Benefits
By deploying SQL Server Fast Track Data Warehouse, TELMORE expects to increase service levels, speed time-to-market, and accelerate productivity.Enhances Customer Service
The new data warehouse provides reliable access to the company’s rapidly expanding data without jeopardizing system availability or performance. Employees can access this information—which is updated nightly—to generate detailed business-intelligence reports whenever they want without the help of IT employees. “Our new data warehouse built with SQL Server Fast Track Data Warehouse gives us a 360-degree view of customers,” says Claus Nielsen, Chief Financial Officer of TELMORE. “This helps us design the best products and provide the best possible customer service.”Boosts Time-to-Market and Revenue
By gaining a greater understanding of its customers and business trends, TELMORE can reduce the time required to produce innovative offerings. “With our enterprise data platform based on SQL Server Fast Track Data Warehouse, we can create products that customers need by looking at their behavior,” explains Nielsen. “Our product managers can also rapidly calculate the costs of these new solutions. This will help us to bring new offerings to market about one week faster, and we expect to gain more revenue as a result.”Increases Productivity
The new solution includes pretested components, tools for integration, and an easy-to-use interface that facilitates scalability, reliability, productivity, and cost savings. “Our new data warehouse built with Fast Track Data Warehouse looks a lot like our employees’ everyday tools, which will be a big help in user adoption,” says Bojsen. “Our super users will have the ability to perform ‘drag-and-drop’ analysis, and employees will be able to create reports in days rather than weeks. If the information is in the data warehouse, they can analyze it as easily as opening up their mailbox in the morning. This level of usability was simply not possible before.”This case study is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.