The Weather Channel needed to increase business insight, streamline reporting processes, and improve data control. In 2012, it implemented a flexible business intelligence (BI) solution based on Microsoft SQL Server 2012 to take advantage of
Microsoft SQL Server 2012 Power View via a portal and virtual desktops. As a result, The Weather Channel saves more than 160 hours each month generating reports, improves security and control, boosts efficiency, and increases insight and agility.
The Weather Channel is a leading provider of round-the-clock weather forecasts and programs. From all over the world, people tune in to The Weather Channel via TV, the Internet, mobile devices, and tablets.
||By deploying a Microsoft BI solution based on SQL Server 2012 and Power View, we save 160 hours each month generating just one of our key reports.
| Andy Drooker
Director of Emerging Platforms
The Weather Channel
Before 2012, the company used automated and manual processes to manage and analyze subscriptions from hundreds of service providers. Collectively, 1 petabyte of financial data resided in five different systems, and on employees’ desktops, that ran on the Microsoft
platform. Each system used a separate process to generate reports. As a result, every automated report contained information from only one system. To create BI, the reports were manually consolidated with Microsoft Excel 2010 spreadsheet software—a process
that took hours or days. “The complexity of our business data was very difficult to manage with our previous solution,” says Andy Drooker, Senior Director of Emerging Platforms at The Weather Channel. “And employees could not view real-time BI.”
Only IT personnel could customize static reports, and staff had no easy way to view the details that constituted aggregate values. Drooker says, “Reports tell a story about our business. However, employees had to engage IT personnel to look at the story
from a different perspective or obtain details.” He continues to explain that for The Weather Channel, the need to effectively analyze data is increasing. “As more people switch to online offerings, we can no longer just depend on companies like Nielsen to
understand trends. We need to make better use of our own data.”
The company also wanted to streamline data access and management. Employees circulated reports via email; as a result, people had to wait for business intelligence. Employees also stored large volumes of BI on desktops using email and other business applications.
Not only did The Weather Channel need to manage 2 terabytes of new business data each year, but IT personnel also wanted to contain the increasing storage requirements for individual desktops.
The company sought a flexible BI solution to accelerate business insight, simplify and enhance BI, and increase data control.
Initially, The Weather Channel planned to implement QlikView as a BI tool. However, after experiencing scalability issues, the company decided to switch to a solution based on Microsoft BI tools including Power View, a new BI tool in Microsoft SQL Server
2012 Reporting Services. “We wanted to bring in data from multiple sources and add features that were either not possible or not easy to implement with QlikView,” says Drooker. “Another benefit of the Microsoft BI solution is that training is minimal. Why
add complexity and increase costs with a third-party solution when we can use SQL Server 2012 and Power View to simplify integration with our existing technologies?”
In March 2012, IT personnel from The Weather Channel worked with Microsoft Services consultants to set up a data warehouse using SQL Server 2012 Enterprise software. Because the company virtualizes most of its desktops and servers, the warehouse runs on
a virtual machine supported by an HP ProLiant DL380 server computer and Hyper-V technology in the Windows Server 2008 R2 Enterprise operating system.
The team also took advantage of other built-in capabilities of the Microsoft platform. For example, consultants used Microsoft SQL Server 2012 Integration Services to extract data from business systems and load it into the warehouse. To facilitate multidimensional
data analysis, engineers created online analytical processing (OLAP) cubes with Microsoft SQL Server 2012 Analysis Services. The team also used SQL Server 2012 Reporting Services to create static reports.
To provide access to the reports and Power View, engineers set up a portal with Microsoft SharePoint Server 2010. The team manages who can view BI using permission levels within SharePoint Server.
By May 2012, seven people were accessing the solution from virtual desktops running the Windows 7 Professional operating system. Commenting on the deployment, Drooker says, “Once we got the core structure in place, the implementation took less than one week.”
The company will continue deploying the solution to more employees, and it plans to take advantage of other built-in BI capabilities such as dashboards.
With its solution, the Weather Channel recoups more than 160 hours in report-generation time, increases security, boosts efficiency, and improves insight and agility.
Saves More Than 160 Hours Each Month
Today, the company can generate reports in seconds or minutes instead of hours and days. Drooker says, “By deploying a Microsoft BI solution based on SQL Server 2012 and Power View, we save 160 hours each month generating just one of our key reports.”
Improves Security and Control
Even though the company has sped access to BI, IT personnel have increased control over business data. “Our new solution stores BI on SQL Server, and people access it from the portal, which means employees can stop using email as a file cabinet,” Drooker
says. “This helps us contain data growth, and we can enhance data security by controlling access to information through the portal.”
With the new solution, people get the insight that they need faster. “We no longer have to wait for reports sent by email,” Drooker says. “This saves time and streamlines workflow because people can get real-time BI whenever they need it.”
Increases Insight and Agility
Employees can create BI independently to gain the insight needed to answer questions and help the business evolve. Drooker says, “With Power View, employees can customize reports without an analyst’s help.” This flexibility translates into greater business
agility. He continues, “Our Microsoft BI solution will eventually help the entire organization. With it, employees can instantly see the big picture and trends in business data, and they can drill down into the details to understand changes. This ability is
critical to help us continually adapt our business model to meet demand.”
This case study is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.