Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started