Download PDF
Biogen Idec Deploys Agile Reporting Solution Using Denodo to Provide Accurate Daily Sales Reports Across 90 Countries
Technology Category
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Functions
- Sales & Marketing
Use Cases
- Predictive Quality Analytics
- Real-Time Location System (RTLS)
Services
- Data Science Services
The Challenge
Biogen Idec, a global biotechnology company, 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 internal 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. As the operations grew, Biogen was concerned about how to automate the generation of daily sales reports and improve accuracy.
About The Customer
Biogen Idec is a global biotechnology company, founded in 1978, with over $4B in revenue. Biogen Idec is a global leader in the discovery, development, manufacturing and commercialization of innovative therapies such as multiple sclerosis (MS), lymphoma and rheumatoid arthritis. Biogen has multiple distributors globally that sells and distributes their drugs in over 90 countries. 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.
The Solution
After a thorough 3-month evaluation of leading vendors, Biogen selected Denodo's Data Virtualization Platform to support agile reporting solutions across many uses starting with daily sales reports. The solution provided remarkable breadth and flexibility at every level of functionality and was ideally suited to their needs. Data Access: Wrappers automated access to disparate sources of data from external partners (Excel spreadsheets, PDF, TXT files, Web Services), internal budgets and forecasts (databases), and external market data (web feeds or sites). Semistructured and Web data was automatically converted to structured 'base views'. Data Integration and Quality: Analysts used easy, graphical tools to define data normalization, cleansing, transformation, data validation and combination of disparate sources of data, and modified the data structures to support hierarchical summaries and drill-downs. Data lineage, change impact analysis and governance functions would monitor and alert analysts to potential issues and provide both automatic and manual options for resolution.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Leading Tools Manufacturer Transforms Operations with IoT
Stanley Black & Decker required transparency of real-time overall equipment effectiveness and line productivity to reduce production line change over time.The goal was to to improve production to schedule, reduce actual labor costs and understanding the effects of shift changes and resource shifts from line to line.
Case Study
IoT Data Analytics Case Study - Packaging Films Manufacturer
The company manufactures packaging films on made to order or configure to order basis. Every order has a different set of requirements from the product characteristics perspective and hence requires machine’s settings to be adjusted accordingly. If the film quality does not meet the required standards, the degraded quality impacts customer delivery causes customer dissatisfaction and results in lower margins. The biggest challenge was to identify the real root cause and devise a remedy for that.
Case Study
Jaguar Land Rover Speeds Order-to-Cash Cycle
At Jaguar Land Rover, vehicles physically move around the facility for testing, configuration setting, rework and rectification, leading to a longer search time to get each vehicle to its next process facility. The main goal is to minimize the vehicles' dwell time between end of line and the delivery chain which was previously a manually intensive process. Jaguar Land Rover's goal was to build on the success of an earlier RFID project and improve the efficiency of delivering vehicles to meet dealer orders.
Case Study
Improve Postal Mail and Package Delivery Company Efficiency and Service
Postal mail and package delivery company wanted to replace legacy yard management system, increase inbound and outbound yard velocity, improve priority parcel delivery time and accuracy, reduce workload and overtime, reduce driver detention and measure performance and utilization of yard resources.
Case Study
Hospital Management Solution
The Oncology Diagnosis and Treatment Center of Brasov wanted to give patients as much freedom to roam as possible, while at the same time ensuring optimal patient safety and security. The centre was in need of an adequate wireless voice communication and messaging solution that would give patients the confi dence that medical staff is always on call, and reduce stress levels of nurses and doctors when called in case of urgent need.
Case Study
Worker Tracking & Safety Monitoring in Construction
One of the main challenges facing the technology was to create a network within underground tunnels and another was to provide products that can withstand harsh working environment. The team used amplifiers to enhance bandwidth and Litum produced IP67-rated hardware that is durable for harsh working conditions.
