Global CIO: Microsoft BI Wins Raves From Giant Shipping Company

The world's second-largest container shipper is using PowerPivot for Excel to manage massive demand for data and overcome a "nightmare."
"With these new tools from Microsoft, we saw a way for us to become proactive from the IT side," Catassi said. "For example, a recent challenge for the company was to assess the optimal routes for our services shipping goods from the Far East to the U.S.

"We had to assess where are the ships going, what are the commodities they're carrying, what is the weight, when are they due, etc., and then we tried to analyze whether they should come across the Pacific and through the Panama Canal and up the East Coast, or go south and west from China through the Suez Canal to the Mediterranean and across the Atlantic to the East Coast."

Under the old system, Catassi said, that type of extensive evaluation would require a multi-day series of meetings. At the end of each day, the report-generation frenzy would begin, with Catassi's team doing the extracting, organizing, analyzing, and collating into a single massive report of 200 megabytes or more.

"And we'd take all that data and burn it onto CD's overnight and pass them out at the start of the next day's meeting," Catassi said.

"But not any more."

With the new Microsoft PowerPivot for Excel 2010 tools plus PowerPivot for SharePoint, the reports can be done in close to real time, Catassi said, and the functional but archaic process of burning CD's became little more than a company legend.

"That absolutely opened the floodgates, and now our executives and decision-makers want to use PowerPivot and SharePoint for everything," he said. "It's a real game-changer."

Catassi said that while those new products are much simpler to use than traditional BI tools, there's still some complexity involved that requires a certain expertise—but because most of that expertise involves Excel, the company's widespread familiarity with the spreadsheet's features has made that less of a challenge.

Because Mediterranean Shipping is a privately held company, Catassi said, he and his team have not been asked to compile rigorous ROI metrics for PowerPivot, but he said the savings in time, increased collaborative capabilities, reduced overnight strain on servers, and greatly reduced strain on the sanity of the IT team have been huge.

Catassi said the cost savings extend to the ways in which he and his team are now disseminating those massive data files to some or all of Mediterranean Shippings 100 offices worldwide. In the past, he said, "We dumped thousands of files each day into our data center, which would replicate them all and send them all to each of our branches. Now we can eliminate all that replication and we've also been able to cut our bendwidth costs accordingly."

"This has been tremendously beneficial," he said. "Here's one more small but important example: we rely heavily on the statistics published in the Journal of Commerce (full disclosure: the Journal of Commerce and InformationWeek are owned by the same corporate parent, United Business Media) on what's being shipped in and out of the U.S. by all the shipping companies. In the past, to combine that data with our internal data was a very big job.

"But now, we can just do it directly: we use the Excel Files and PowerPivot, and mix and match the data from external sources with our internal data. It's very easy," Catassi said. "In fact, I would say that the only reason that another CTO or CIO would not be excited about these new tools is that they must not have seen them yet."


Global CIO: Microsoft Pushes BI For The Masses: 500 Million Prospects

Global CIO: An Open Letter To Microsoft CEO Steve Ballmer

Global CIO: As Google And Microsoft Slug It Out, CIOs Come Out On Top

Global CIO: Top 10 Strategic Vendors' #1 Challenges

Global CIO: Are Oracle, HP, Cisco & IBM Too Big To Innovate?

Global CIO: Oracle, SAP, And The End Of Enterprise Software Companies

GlobalCIO Bob Evans is senior VP and director of InformationWeek's Global CIO unit.

To find out more about Bob Evans, please visit his page.

For more Global CIO perspectives, check out Global CIO,
or write to Bob at [email protected].

Editor's Choice
John Edwards, Technology Journalist & Author
Michael Gibbs, Founder, Go Cloud Architects
Jack Berkowitz, Chief Data Officer, ADP
John Edwards, Technology Journalist & Author