Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Designing a Data Warehouse Managers in Purchasing department, asked you (the analytics department) to provide information on a. How many purchase orders was authorized

 

Designing a Data Warehouse Managers in Purchasing department, asked you (the analytics department) to provide information on a. How many purchase orders was authorized by your company buyers? b. What was the total amount of purchases or discount for a specific year/month or years/months authorized by your company buyers? c. What was the total amount of purchases from vendors and who authorized the purchases? You know that for providing the requested information, you need to build a data warehouse from purchasing database and then providing requested information by using a pivot table tools. Use the purchasing database shown below and build the required data warehouse. PO PO NO Document Date Posting Date Status Delivery Date Total Amount Discount Vendor ID (FK) Buyer ID (FK) PO No Item No Quantity PO Line (FK) Unit Price Line total Vendor Vendor ID Vendor Name Buyer Buyer ID Buyer Name Item No Item Desc Item

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Services Marketing

Authors: Jochen Wirtz

4th Edition

1292425199, 9781292425191

More Books

Students also viewed these Databases questions

Question

Solve each equation or inequality. |6x8-4 = 0

Answered: 1 week ago

Question

Correctly create a four part Istatement.

Answered: 1 week ago