Most people know of The Weather Channel, a leading provider of weather related content. 24 hours a day individuals rely on The Weather Channel for up to date weather content via TV, the internet, and mobile devices. It is conceivable to many that The Weather Channel manages a large amount of data, but it may be a surprise to hear how large their data needs actually are.

Prior to upgrading to SQL Server 2012, The Weather Channel managed 1 petabyte of financial data on five different systems as well as on employees’ desktops. Each system operated in a silo, requiring consolidation on a Microsoft Excel 2010 spreadsheet to create any type of business intelligence report. As you can imagine, this process was very time consuming, often taking days to complete.

The Weather Channel wanted to find a flexible BI solution that would allow them to gain business insight at a much quicker pace, as well as simplify their processes and increasing their data security. After considering a solution based on QlikView, the company decided to implement the Microsoft BI tools including Power View. “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.

Additionally, utilizing SharePoint Server 2010, The Weather Channel was able to control data security with permissions levels and a secure collaboration portal. “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.”

Find out more on how The Weather Channel gained efficiency and improved IT control by implementing SQL Server 2012 with Power View by reading the Microsoft Case Study. To learn more about Microsoft BI and Power View visit www.microsoft.com/bi.