Report-on-Data-Warehouse-only-Introduction-and-conclusion
Task : write introduction and conclusion only based on below direction
Word length: 1000 words
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowReference : minimum 5 reference( from conference papers, articles, or journals )
Special remark : the report submitted to turnitin.com
Attached file: just for your reference
– DB structure of adventureworks
– Dimensional modeling for below main question
1. Introduction
– about AdventureWorks(sample Database from microsoft.)
– process/approaches to make data warehouse
(discussion need to include development methodology (e.g., Kimball approach),
detailed requirement analysis, dimensional modeling, physical database design,
ETL design, data quality assurance, and other relevant topics)
2. Body
– No need to do this part
3. Lesson learned
– No need to do this part
4. Conclusion and Feature development
– conclusion based on your findings and discuss existing limitation or issues
– feature extension of your solution
Main Question for Data warehouse(For your information)
Best Employee
1. For each salesperson, display & sort based on the their sales commission/bonus, total/average number of (unique) customers and the total/average number of products/SalesOrderDetail.OrderQty it has served when it was buying product at discount/original price in a specific/all territory at a specific month/year
2. For each buyer, display & sort based on the total number of (unique) vendors, total number of (unique) preferred vendors, total/average number of products/PurchaseOrderDetail.OrderQty, total/average PurchaseOrderHeader.TotalDue and total/average number of rejected products.
3. For each employee, display & sort based on the number of times their salaries has changed since they were hired, vacation/sick leave hours and current salary rate.
4. Display & sort employee based on their performance as salesperson or buyer. The best salesperson, sell many products, has many customers and low sick leave hours, salary rate, bonus and sales commission. The best buyer, purchased many products from many preferred vendors with low rejected quantity, sick leave hours and salary rate.