For more info on a specific newsletter, click the title. Details will be displayed in a new window.
Subscribe to
Computerworld 40 years of the most authoritative source of news and information for IT leaders.
Cruise Line Changes BI Tack
or
Other Business Intelligence Stories
|
|
|
|
October 06, 2003 (Computerworld) -- In an attempt to navigate rough economic seas, Holland America Line Inc. is trading its cumbersome old big-iron-based business intelligence reporting system for a Web-based one that end users can more easily and flexibly access.
The move was triggered by the Seattle-based cruise company's decision to use improved BI tools in order to make an additional $1 million annually through more efficient sales, marketing and revenue management. This required changes to its existing reporting and analysis system.
Prior to launching the upgrade to the new reporting system a year ago, the information systems staff needed to access operations information from the company's IBM S/390 mainframe and format it into reports, says Jon Dawson, Holland America project manager.
The reports included everything from small, ad hoc inquiries to major "canned" reports that were prepared weekly to assess the company's revenue and inventory performance, says Paul Grigsby, senior revenue manager at Holland America.
To improve this system, Holland America installed software from Information Builders Inc., a New York-based BI software maker. Dawson says the cruise company implemented Information Builders' WebFocus analysis tool to connect to the mainframe through an adapter and pull out the relevant information for queries and reports. The application, which runs on a Sun Microsystems Inc. box with a single CPU, uses extract, transform and load data-prepping technology for use with Microsoft Excel or Word. The system also includes WebFocus Reporting Server, which enables users to do analysis, reporting and querying.
Dawson says that turning around report requests previously took up to two days. Using the WebFocus BI dashboard, Holland America's IS staff can fine-tune parameters and turn over reports to end users almost immediately.
Some end users even make their own reports. But in order to do that they need to be trained and, as Dawson says, "spend the time to get to know the data."
According to Grigsby, WebFocus is primarily used by revenue management personnel for the smaller reports, whereas IS staffers working off the mainframe still handle the bigger ones.
Starting Slowly
"We're still growing the system," says Dawson. "It's the tip of the iceberg."
For instance, Holland America is working to define the data needed from the ships to analyze onboard spending by department and for specific excursion purposes. The company is facing limitations because of the size of the existing database system, says Dawson, so it plans to load the information into an Oracle Corp.-based data warehouse by December.
End users are already noticing a difference. A report that required coding and printing by IS staffers and took days to complete now takes just minutes to run with WebFocus on a PC, says Grigsby. "And this is where the flexibility comes into play," he adds. "If I wish to see a different view of the same information, I can simply change the sort sequence or introduce new fields into the inquiry without having to formally request a new report from the information systems department. It makes both my time and the information systems department's time more efficient."
The reports are indeed more flexible and easier to get to, says Teresa Tennant, manager of online communications for the shore excursion department at Holland America. Currently, the IT department and a BI specialist prepare reports for her, but Tennant plans to be trained to prepare them herself.
After the report is written, she can get it by logging into a Web site and accessing it in whatever format she wants—Excel or Word document or PDF. Tennant needs several types of reports for her work and she's able to select them from a complete menu.
"It's very handy. I can drill down into complete details of the booking by travel agency and individual," she says.
There was some doubt among the company's end users when the project began, says Grigsby. "We are yield managers, not computer programmers, and I was frankly suspicious about putting the reporting function in our hands," he explains. "However, after training and a goodly amount of trial and error, we began to see the rewards of empowering the end users."
Given current conditions in the travel industry, which has been squeezed by factors like the SARS outbreak, the war in Iraq and the down economy, Holland America needed to be able to rapidly identify and track industry trends, says Bill Hostmann, an analyst at Gartner Inc. in Stamford, Conn.
The real value of the new system at Holland America, Hostmann says, "is how it makes it easier to develop and distribute business management information to more users in a timely fashion around the world than ever before and thereby more fully leverage existing IT investments."
Holland America
HEADQUARTERS: Seattle
BUSINESS PROBLEM: End users were unable to access useful data easily, which was costing the company money.
SOLUTION: The company replaced a mainframe-based business intelligence reporting system with a Web-based reporting and analysis system.
|
Print this Story |
|
Send Us Feedback |
|
E-mail this Story |
|
Digg this Story |
|
Slashdot this Story |
|
|
|
|
|
|
 |
|
All Zones Application Performance Zone Enterprise-Class Security Zone Enterprise Solutions Zone The File Data Management Zone Grid Computing on Windows Zone Security Management Zone ITIL Best Practices Zone The SAS Zone Storage Virtualization Zone The Data Center Management Zone |
 See your link here
|
 |
||||||||
| ||||||||
| ||||||||
| ||||||||
|
Download this Computerworld Report, free, compliments of HP.
Why SaaS is Vital to Email and Web Security
Get this report now!
Read up on the latest ideas and technologies from companies that sell hardware, software and services.
- Mozilla launches Firefox 3.0 RC1 early
- Microsoft: Don't misunderstand UAC, other Vista features
- HP confirms XP SP3 endless reboot snafu, promises patch
- More top stories
Computerworld Technology Briefing: An open-source path to optimal virtualization Looking for a virtualization strategy that offers both the flexibility and reliability to meet the demands of mixed-source environments? Look no further than the fast-emerging open virtualization approach backed by some of the biggest names in enterprise computing. Together they are pointing the way toward higher data center performance without higher costs.Download this briefing
|
| XenServer FREE trial Citrix XenServer is the simplest and most effective way to virtualize and provision servers. XenServer combines comprehensive server virtualization capabilities with unparalleled scalability, performance, economics, and ease-of-use. Based on the open source Xen hypervisor, XenServer delivers fast performance, easy management, and advanced features such as live migration. |
 Since You AskedA weekly storage column from storage analyst, Steve Duplessie of the Enterprise Strategy Group |
 |
SAS Information Management Kit
SAS is the leader in business intelligence and analytical software and services. Only SAS offers leading data integration, storage, analytics and business intelligence applications within a comprehensive enterprise intelligence platform. SAS gives 97 of the top 100 companies in the 2007 Fortune 500 THE POWER TO KNOW®. |
Webcast: The Information Management Roadmap
Imagine high-quality data, cleansed, analyzed and delivered throughout your organization. Join Computerworld, IT visionary Thornton May and a panel of experts to learn how SAS® can help you make it happen. View this webcast
|
Research Report: Information Management Initiatives at Midsize and Large Organizations
See the top-line results of this Computerworld sponsored survey to see how IT and business leaders are handling information management implementation.
Download this report
|
White Paper: Information Management: Better Information for Winning Decisions.
This white paper explains how the SAS Information Evolution Model aids companies in assessing how they use this information to make strategic decisions and drive business.
Download this white paper
|
|
|