"As a large biotechnology company, Biogen Idec sells its drugs globally in over 90 countries through multiple wholesalers and distributors. Senior executives monitor drug sales and market share using daily sales reports by drug and territory.
Business analysts at Biogen were manually collecting sales data from numerous internal and external sources, including wholesalers and distributors worldwide, in various formats like Excel, PDF, XML file transfer etc. They had to monitor the file versions, normalize formats and currencies, and consolidate sales figures with in - ternal forecast and budget databases. The combined data was output into Excel reports for review by management. They also archived the data to support historical reporting. The process was cumbersome, time consuming and error prone."