Consider disparate data sets where tables of sales data

Assignment Help Operation Management

Reference no: EM131124399

As a business owner of a mid-sized retail company, consider disparate data sets where tables of sales data exists for multiple products (top adapters, binoculars, cameras, and filters) from multiple locations in different city, state and country. Your business has collected these tables of data from different OLTP sources each week over three years. a. What method is used to retrieve these disparate sources of information? Briefly note each step b. Give a specific example of a type of model to use in order to hold this information together in your data warehouse? c. Give an example of each of the following operations. In each case, what is the result of the operation before the operation and afterward (e.g. "a table displaying sales for product A by year"). i. Drill-Down ii. Slice iii. Pivot

Reference no: EM131124399

Questions Cloud

Spindles for subsequent use in the weaving process : One of the stages in the process of making denim cloth at the Southern Mills Company is to spin cotton yarn onto spindles for subsequent use in the weaving process. Occasionally, the yarn breaks during the spinning process and an operate ties it back..

Colloquial language in writing and paraphrasing : You are to define the phrases: a) Colloquial language in writing, b) Declarative statements in writing, c) paraphrasing, and c) Formal language in writing. Provide a short summary discussing each phrase or term (two to three paragraphs for each) and ..

Marketing is as much social as it is economic : It has been said that marketing is as much social as it is economic. People have to market themselves to be successful just like organizations do. Explain how you develop yourself as a brand to establish mutually-beneficial relationships throughout y..

Fully explain each of five phases of the guest lifecycle : Fully explain each of the 5 phases of the Guest Lifecycle (Dream, Purchase, Anticipate, Experience, Remember) AND one example of how technology is used in each phase.

Consider disparate data sets where tables of sales data : As a business owner of a mid-sized retail company, consider disparate data sets where tables of sales data exists for multiple products (top adapters, binoculars, cameras, and filters) from multiple locations in different city, state and country. You..

How resoucrce dependce theory-transaction cost theory : Compare and contrast resource dependence theory and transaction cost theory. Describe the purpose and assumptions of each theory. Explain how they are similar and how they are different. expalin how resoucrce dependce theory and transaction cost theo..

Using traditional lean techniques on current push flown : Using traditional lean techniques on a current "push" flown (from "learning to see" text): Define process value-added (VA) time and how to determine the VA of a process work station. Define change over (C/O) time and how to determine it for a process..

True statement about procurement documents : Which of the following is a true statement about Procurement Documents? Identify the document that is developed from the project scope statement, the project work breakdown structure (WBS) and the WBS dictionary that will be part of the procurement d..

What is the minimum batch size that will meet the demand : A furnace used in the heat treat operation of cast iron railroad car couplers can hold up to 20 parts. The operation takes an average of 4 hours to process a batch of parts with a standard deviation of 2 hours. What is the maximum capacity (parts per..

User Account

All Pages