What is your design strategy to support global vision

Assignment Help Computer Engineering
Reference no: EM132192374

Question: Consider you are working for a global organization and it has well established Data warehouses in each region(North America, Europe, Asia and Latin America). These 4 regional DWs support both Top and operational management needs including but not limited to year over analysis including quarterly and yearly results. It also supports operational managers with day to day reports on sales by product, product category, sales region, customer and by Sales managers. Sales data is captured every day in delta mode. Note that these regional DWs were designed and developed by regional IT teams with consideration their reginal needs.

Due to the nature of business, you have hundred thousand customers and over a million parts(products). So, Product dimension is one of the biggest dimensions. All master data related to customer, product, sales region are managed in global SAP system(OLTP).

Each regional sales fact table holds over a trillion records. Two out of 4 regions are using global SAP system as source system for product sales while two other regions are using different local ERP solutions.

Now, you are challenged by global management to have one single Analytic solution that will allow the management to have a global analysis with a flexibility to drill down into regional daily sales by product, customer.

Given the fact you have one of the larger dimension and very large regional sales data, what is your design strategy to support global vision with regional focus Analytic solution? Explain your answer with a clear explanation of your assumptions.

Reference no: EM132192374

Questions Cloud

Offered number of houses for sale : Innova construction Corp. built a subdivision in which it offered a number of houses for sale. Mike bought one of these houses.
What steps might have been taken to prevent an offense : David Doe is a network administrator for the ABC Company. David is passed over for promotion three times. He is quite vocal in his dissatisfaction.
Why did you trust that persons recommendation : Why did you trust that person's recommendation? How important is a recommendation by someone else in your purchase decisions?
Trinity solary using porter five forces model : Write an industry analysis of Trinity Solary using Porter’s Five Forces Model.
What is your design strategy to support global vision : Given the fact you have one of the larger dimension and very large regional sales data, what is your design strategy to support global vision with regional.
What is countertrade : FIN540 : Propose two applications of knowledge that you have learned in this course that you could apply to your current or future career.
Model certain situations using linear equations : In section 2.1 you read about how we can model certain situations using linear equations.
Companies make for employees who take foreign assignments : Of the many reimbursements and allowances that U.S. companies make for employees who take foreign assignments, which one is the most essential?
What is your topic statistics of river pollution : What is your topic Statistics of river pollution. What is your research plan for moving forward?

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

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