Ads by TechWords

See your link here
Receive the latest technology news and information.
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
Cloud Computing
View all newsletters




Privacy Policy
 

Cruise Line Changes BI Tack

Web-based reporting system promises returns in sales, marketing and management. By Marc L. Songini

October 6, 2003 12:00 PM ET

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."



Jump to comments

Business Intelligence

Additional Resources

WHITE PAPER
Approximately 60 percent of data migration projects overrun time or budget, while some fail completely. Download this white paper, "Enhancing Your Chance for Successful Data Migration," to learn the critical steps you need to take to execute a data migration project with minimum cost and risk to your business.
WHITE PAPER
Read the Gartner research note to learn why the TCO of a server-based computing deployment used to deliver all applications to users is around 50% lower than that of an unmanaged desktop deployment.
WHITE PAPER
Economic downturns have a tendency to accelerate emerging technologies, boost the adoption of effective solutions, and punish solutions that are not cost competitive or that are out of synch with industry trends. This IDC White Paper presents the results of an IDC survey of 330 companies in Western Europe, Asia/Pacific and the Americas that measures the receptiveness to Linux and takes into consideration changing views driven by the disruptive economic environment that businesses face today.
 

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