Report-on-Data-Warehouse-only-Introduction-and-conclusion
Report-on-Data-Warehouse-only-Introduction-and-conclusion.
Task : write introduction and conclusion only based on below direction
Word length: 1000 words
Reference : 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.
Place this order or a similar order with usand get an amazing discount
Source link
Report-on-Data-Warehouse-only-Introduction-and-conclusion
