Advertising Firm Boosts Client Services with Faster Reporting and New BI Capabilities
Havas Media wanted to improve operations and client services with better business intelligence (BI) tools. After evaluating more than 20 solutions—including those from Oracle and IBM—Havas Media implemented a Microsoft data warehouse and BI solution to take advantage of enhanced reporting capabilities. As a result, it has cut report generation time by 80 percent and improved client services. The company is more competitive with the new solution and believes that BI services will drive business growth.
Solution
Havas Media began designing a new BI strategy in January 2010 and evaluated approximately 20 vendors including Microsoft, Oracle, and IBM. The company ultimately chose a data warehouse with self-service BI tools based on SQL Server 2012 Enterprise data management software. “The deciding factor in choosing SQL Server 2012 was the local authoring capability,” says Jaskeran. “We wanted to give end users the ability to work with data with very little IT help.”
Havas Media manages more than 100 terabytes of complex data, and it needed a technology partner to help implement the solution. “We’re loading 300 million rows of data every single day here from multiple sources, and by the end of the year we expect the number to reach 1 billion,” says Jaskeran. “So we chose Corbus to help us implement the solution because of its expertise from a software engineering perspective.”
The company’s end users can quickly analyze large data sets with Microsoft SQL Server PowerPivot for Microsoft Excel 2010. They also work with Power View, a self-service BI data exploration and visualization feature in SQL Server 2012 Reporting Services that they can launch in Microsoft SharePoint Server 2010. Havas Media publishes data for both Microsoft Excel 2010 spreadsheet software and Power View with the Business Intelligence Semantic Model in SQL Server 2012 Analysis Services. The company also looks forward to implementing Microsoft Atlas with the new data warehouse. Part of Microsoft Advertising, Atlas includes a suite of digital media tools that agencies can use to optimize marketing campaigns.
Benefits
- Cuts report generation time by 80 percent
- Improves operational insight
- Increases revenue and opportunities
SQL Server 2012 Business Intelligence Overview
Learn more about the business intelligence capabilities of SQL Server 2012.
SQL Server 2012 Breakthrough Insight Whitepaper
This white paper presents an overview of the new features related to the business intelligence stack in Microsoft SQL Server 2012.
SQL Server 2012 Breakthrough Insight Whitepaper for TDMs
This white paper presents an overview of the new features related to the business intelligence stack in Microsoft SQL Server for technical decision makers.
Forrester Consulting: Total Economic Impact of SQL Server 2012 Upgrade
Forrester Consulting examines the total economic impact and potential return on investment enterprises might realize by upgrading from SQL Server 2008 to SQL Server 2012 in this white paper.