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 Now

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.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.