By choosing Adatis and Windows Azure, HarperCollins could rapidly deploy the BI solution it needed, give employees control over data, and boost efficiency and agility.
Speeds Deployment by More Than Five Months and Saves $200,000
HarperCollins was able to get the BI solution it wanted with negligible risk. “By choosing Windows Azure, we could deliver a BI solution in two weeks with minimal investment and planning,” says Boyle. “If we had deployed a traditional solution, it would have taken us 6 to 12 months to get similar results and it would have cost us an additional $200,000 in development costs.”
Gives Employees Control over Data
Rather than basing decisions on third-party summaries, employees now make their own decisions. “With our Microsoft BI solution, every employee can pull up visually rich, easy-to-use reports right at their desk when they need insight,” says Boyle. “This ability is driving a cultural change that goes beyond using research for marketing. It’s more about how we work and how we think because now, we make our own decisions based on up-to-date information—and we use BI more often because it’s so easy to access.”
Improves Efficiency and Services
Employees are also more efficient and decisive. “It used to take months to identify an audience for a book,” Boyle says. “Today, based on the insight we get with our Microsoft BI solution, we can fine- tune an audience in a week—and we can provide this service to hundreds of authors, rather than just headline authors.”
By glancing at a report, staff instantly see the big trends and key messages in the data. They can also explore the rich story behind the summaries and graphs to better understand how factors such as age or geographic region influence sales. “We’re bolder because of our Microsoft BI solution,” says Boyle. “We can confidently say let’s not waste a penny on trying to sell this book to a ‘youngish, teenage’ audience. Instead, let’s focus on readers who are between the ages of 17 and 24 because that’s who will be interested in it.”
The increased efficiency also makes it possible for HarperCollins to provide differentiating services to authors, such as helping each one understand and connect to a larger audience. And the company can also help more readers find the books and authors that will interest them.
Increases Agility and Flexibility
By choosing the Microsoft platform, HarperCollins can easily evolve its solution to meet changing business and employee requirements. For example, at any time it can easily move the solution to a corporate datacenter in approximately one to two days. Or, it can adopt a hybrid-cloud scenario by simply migrating some components onsite, such as the data warehouse. “We're exploring making some of the cloud-based reports available to authors, agents, and retail partners,” says Boyle. “The Windows Azure cloud enables this, since we'd otherwise have trouble exposing reporting from inside our network to the outside world.”
In addition, the company can work with Adatis to easily add new types of BI for global users including on-demand custom reports. By doing so, each employee could explore data in the warehouse (wherever it resides) from their desktop and create their own reports using tools such as Microsoft SQL Server 2012 PowerPivot for Excel. “I don't believe in IT business as usual,” says Boyle. “I believe in quickly and cheaply making a big difference and then refining the solution to better meet business needs as you better understand them and as they evolve. It's as simple as that really, and this solution allows us to do that.”
By running its solution on Windows Azure, HarperCollins also has an infrastructure that almost instantly adjusts to change. Tim Kent, Co-Owner of Adatis, says, “Soon after we had deployed the solution, we needed a larger server to match demand. It was literally a five-minute job to spin down the current server, resize it, and spin it back up with more memory and bigger processors.” Such changes can also require less up-front investment. “This Windows Azure configuration costs about $250 each month,” says Kent. “To buy, install, and configure a new server would have cost at least $12,000 in addition to ongoing costs to monitor and maintain it. Having this level of IT and economic agility are some of the great advantages of using Windows Azure.”