3M Global enterprise data warehouse ( gedw ). Jennifer Dawn Dudley – BUS 550 Fall 2010. Brief History of 3m’s GEDW – Global enterprise data warehouse.
PowerPoint Slideshow about '3M Global enterprise data warehouse ( gedw )' - salvador
An Image/Link below is provided (as is) to download presentation
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
According to a November 2000 Bloomberg Businessweek article ,3M grew from a modest seller of sandpaper to a $15.7 billion per year company that sells more than 50,000 products in 200 countries and has more than 70,000 employees
As of the calendar year end for 2009 the company sold $23.1 billion with more than 55,000 products in 200 countries and has more than 76,000 employees – 47% increase in sales
Alan L. Messerli of 3M started an initiative to build an integrated database that would help develop better customer relations by providing easy to get to sales and product reports – gets initial funding in mid 1996
Before the GEDW was created it was easier to ask a customer how much it spent with 3M than to research the figures internally
3M’s GEDW is the foundation for it’s CRM (Customer Relation Management) initiatives throughout the company
Before 3M had centralized data they were competing against themselves, one country or division against another because they could not accurately show who was buying what from where and at what pricing levels
The effort positioned the GEDW for meeting long-term needs. Now that GEDW data standards exist, 3M finds that when new operational systems are designed, the GEDW data standards are used as the basis for data within the new systems.
The data management team spent more than 20 people years standardizing data globally. They created more than 1,000 tables and 3,000 data elements.
The strongest resistance to the GEDW came from the IT groups, who were losing control of their data as it shifted decision-support applications away from the legacy platforms even though the savings from making this shift were significant and the data was of higher quality
The GEDW includes data for every 3M order, shipment, customer and product. Direct sales, indirect sales (POS), price, gross margin, service metrics, demand, forecasts, inventory, supply plans, procurement, vendor and financial data are all included
Ultimately the GEDW team compromised on forcing all data into a set of completely standardized global tables. They now allow local users to put some of their own local tables in the warehouse to better meet local needs