Explain the database specialist or the business manager

Assignment Help Operation Management
Reference no: EM13752337

Your industrial supply company wants to create a data warehouse where management can obtain a single corporate-wide view of critical sales information to identify bestselling products, key customers, and sales trends. Your sales and product information are stored in two different systems: a divisional sales system running on a UNIX server and a corporate sales system running on an IBM mainframe. You would like to create a single standard format that consolidates these data from both systems.

Identify the primary key of MPD. Sales table.

Identify the data problems that must be resolved as you determine the system of record for each of the attributes in the proposed data warehouse. Who should make those decisions, the database specialist or the business manager leading this data warehouse project? Why?

What business problems are created by having two disparate sales systems?

List and describe how each of the five business intelligence reports covered in section 10.2 of your text will leverage the information below to provide actionable information.

Reference no: EM13752337

Questions Cloud

Despite some of the business challenges : Despite some of the business challenges that you identified about your chosen country, you decided to move ahead and open an office in the financial center of this country. Your first customer is a large MNC that is looking to finance a plant in L..
Types of debt are desirable for a healthcare organization : Does adding debt increase or decrease the flexibility of a healthcare provider? Why or why not? Explain which types of debt are most desirable for a healthcare organization. As a future healthcare manager, just making a profit is not the ultimate ..
How has the ehr changed the way healthcare functions today : You have learned a great deal about the roles and functions of the electronic health record (EHR) in healthcare. How has the EHR changed the way healthcare functions today
What is the difference between routing and forwarding : What is the difference between routing and forwarding and What are the two most important network-layer functions in a datagram network
Explain the database specialist or the business manager : Identify the data problems that must be resolved as you determine the system of record for each of the attributes in the proposed data warehouse. Who should make those decisions, the database specialist or the business manager leading this data w..
Determine the strategic business goals : Using a company of your choice, determine the strategic business goals. Develop an IT strategy that aligns to the business goals. You can use the balanced scorecard approach or you can develop your own method for defining and aligning the IT strat..
Analyze the potential pitfalls in capital budgeting practice : Analyze the potential pitfalls in his capital budgeting practices that George should be aware of.
Write research paper on network cost assessment : Write Research paper on network cost assessment
Identify causes of problem in tourism development in country : Identify the causes of any problems in tourism development in the country or region and cite specific readings relevant to tourism development planning in Hall.

Reviews

Write a Review

Operation Management Questions & Answers

  United research associates had received a contract

United Research Associates (URA) had received a contract to produce two units of a new cruise missile guidance control. The first unit took 5,000 hours to complete and cost $50,000 in materials and equipment usage

  Submit a brief write up of the opportunity

Submit a brief write up of the opportunity, their data collection plan, anticipated tools to be used for optimization, and potential benefits to the instructor, no later than 5 weeks into the semester. Term projects must be completed at least ..

  Calculate the overall return on investment of the project

Also calculate the overall return on investment of the project and then present a break-even analysis. At what point does breakeven occur?

  Evaluating decision outcomes more effectively

How would you apply the strategy in in your decision to select or not select the candidate? Include the selected strategy in your response.

  What safety stock level do you recommend for bx-5

Barbara Flynn is in charge of maintaining hospital supplies at General Hospital. During the past year, the mean lead time demand for bandage BX-5 was 60 (and was normally distributed). Furthermore, the standard deviation for BX-5 was 7. Ms. Flynn ..

  Describe the major goals for it

What are the four major goals for IT? How are the four goals achieved? How does the integration of IT improve the management of supply chains?

  Describe what is involved at each stage

What are the three stages of the strategy-formulation process? Describe what is involved at each stage.

  What roles do data and business processes play in achieving

What roles do data and business processes play in achieving the benefits and what can companies do to obtain management committment to BI?

  Compare and contrast the micro and macro-environmental force

Analyze the marketing strategies of these two countries and compare them with Western-based consumption marketers (e.g., US).

  Why is the planning stage often referred to as phase 0 zero

a why is the planning phase often referred to as phase 0 zero of the generic product development process?b what is a

  Prepare a scatter diagram for each of these data sets

Prepare a scatter diagram for each of these data sets and then express in words the apparent relationship between the two variables. Put the first variable on the horizontal axis and the second variable on the vertical axis.

  How alternative will affect various parts of organization

Your assistant comes to you with the feasibility evaluation of a decision alternative. What should he be describing to you? 1.How well the alternative will satisfy the conditions of the problem situation.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd