Emerson Process Management, a global supplier of measurement, analytical, and monitoring instruments and services based in Austin,...

90.2K

Verified Solution

Question

Accounting

Emerson Process Management, a global supplier of measurement,analytical, and monitoring instruments and services based inAustin, Texas, had a new data warehouse designed for analyzingcustomer activity to improve service and marketing that was full ofinaccurate and redundant data. The data in the warehouse came fromnumerous transaction processing systems in Europe, Asia, and otherlocations around the world. The team that designed the warehousehad assumed that sales groups in all these areas would entercustomer names and addresses the same way, regardless of theirlocation. In fact, cultural differences combined with complicationsfrom absorbing companies that Emerson had acquired led to multipleways of entering quote, billing, shipping, and other data. Assessthe potential business impact of these data quality problems. Whatdecisions have to be made and steps taken to reach a solution?

Answer & Explanation Solved by verified expert

4.2 Ratings (869 Votes)

Data warehouse is an information system that contains historical and commutative data from single or multiple sources A data warehouse is subject oriented as it offers information regarding subject instead of organizations ongoing operations In Data Warehouse integration means the establishment of a common unit of measure for all similar data from the different databases Data warehouse is also nonvolatile means the previous data is not erased when new data is entered in it A Datawarehouse is Timevariant as the data in a DW has high shelf life There are 5 main components of a Datawarehouse 1 Database 2 ETL Tools 3 Meta Data 4 Query Tools 5 DataMarts These are four main categories of query tools 1 Query and reporting tools 2 Application Development tools 3 Data mining tools 4 OLAP tools The data sourcing transformation and migration tools are used for performing all the conversions and summarizations In the Data Warehouse Architecture metadata plays an important role as it specifies the source usage values and features of data warehouse data Characteristics of Data warehouse A data warehouse has following characteristics SubjectOriented Integrated Timevariant Nonvolatile SubjectOriented A data warehouse is subject oriented as it offers information regarding a theme instead of companies ongoing operations These subjects can be sales marketing distributions etc A data warehouse never focuses on the ongoing operations Instead it put emphasis on modeling and analysis of data for decision making It also provides a simple and concise view around the specific subject by excluding data which not helpful to support the decision process Integrated In Data Warehouse integration means the establishment of a common unit of measure for all similar data from the dissimilar database The data also needs to be stored in the Datawarehouse in common and universally acceptable manner A data warehouse is developed by integrating data from varied sources like a mainframe relational databases flat files etc Moreover it must keep consistent naming conventions format and coding This integration helps in effective analysis of data Consistency in naming conventions attribute measures encoding structure etc have to be ensured TimeVariant The time horizon for data warehouse is quite extensive compared with operational systems The data collected in a data warehouse is recognized with a particular period and offers information from the historical point of view It See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member