Expert answer:Report on Data Warehouse only Introduction and con

Solved by verified expert:Task : write introduction and conclusion only based on below directionWord length: 1000 wordsReference : minimum 5 reference( from conference papers, articles, or journals )Special remark : the report submitted to turnitin.comAttached file: just for your reference- DB structure of adventureworks- Dimensional modeling for below main question1. 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 part3. Lesson learned- No need to do this part4. Conclusion and Feature development- conclusion based on your findings and discuss existing limitation or issues- feature extension of your solutionMain Question for Data warehouse(For your information)Best Employee1. 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/year2. 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.
adventureworks2014.pdf

dw_dimensionalmode.xlsx

Unformatted Attachment Preview

SalesOrderDetail
SalesOrderID
SalesOrderDetailID
CarrierTrackingNumber
OrderQty
ProductID
SpecialOfferID
UnitPrice
UnitPriceDiscount
LineTotal
rowguid
ModifiedDate
int
int
varchar
smallint
int
int
decimal
decimal
decimal
varchar
timestamp
DatabaseLog
SalesOrderHeaderSalesReason
SalesOrderID
int
SalesReasonID int
ModifiedDate
timestamp
AWBuildVersion
SystemInformationID
Database Version
VersionDate
ModifiedDate
tinyint
varchar
datetime
timestamp
DatabaseLogID
PostTime
DatabaseUser
Event
Schema
Object
TSQL
XmlEvent
int
datetime
varchar
varchar
varchar
varchar
longtext
text
ErrorLog
ErrorLogID
ErrorTime
UserName
ErrorNumber
ErrorSeverity
ErrorState
ErrorProcedure
ErrorLine
ErrorMessage
TransactionHistoryArchive
int
timestamp
varchar
int
int
int
varchar
int
varchar
TransactionID
ProductID
ReferenceOrderID
ReferenceOrderLineID
TransactionDate
TransactionType
Quantity
ActualCost
ModifiedDate
int
int
int
int
timestamp
char
int
decimal
timestamp
SalesOrderHeader
BusinessEntityAddress
BusinessEntityID
AddressID
AddressTypeID
rowguid
ModifiedDate
SalesOrderID
RevisionNumber
OrderDate
DueDate
ShipDate
Status
OnlineOrderFlag
SalesOrderNumber
PurchaseOrderNumber
AccountNumber
CustomerID
SalesPersonID
TerritoryID
BillToAddressID
ShipToAddressID
ShipMethodID
CreditCardID
CreditCardApprovalCode
CurrencyRateID
SubTotal
TaxAmt
Freight
TotalDue
Comment
rowguid
ModifiedDate
SpecialOfferProduct
int
int
int
varchar
timestamp
SpecialOfferID
ProductID
rowguid
ModifiedDate
int
int
varchar
timestamp
int
tinyint
timestamp
datetime
datetime
tinyint
tinyint
varchar
varchar
varchar
int
int
int
int
int
int
int
varchar
int
decimal
decimal
decimal
decimal
varchar
varchar
timestamp
PersonCreditCard
BusinessEntityID int
CreditCardID
int
ModifiedDate
timestamp
AddressType
AddressTypeID
Name
rowguid
ModifiedDate
int
varchar
varchar
timestamp
CountryRegionCurrency
CountryRegionCode varchar
CurrencyCode
char
ModifiedDate
timestamp
int
varchar
decimal
varchar
varchar
datetime
datetime
int
int
varchar
timestamp
WorkOrderID
ProductID
OperationSequence
LocationID
ScheduledStartDate
ScheduledEndDate
ActualStartDate
ActualEndDate
ActualResourceHrs
PlannedCost
ActualCost
ModifiedDate
Address
AddressID
AddressLine1
AddressLine2
City
StateProvinceID
PostalCode
SpatialLocation
rowguid
ModifiedDate
int
varchar
varchar
varchar
int
varchar
geometry
varchar
timestamp
CurrencyRate
CurrencyRateID
CurrencyRateDate
FromCurrencyCode
ToCurrencyCode
AverageRate
EndOfDayRate
ModifiedDate
Customer
int
datetime
char
char
decimal
decimal
timestamp
CustomerID
PersonID
StoreID
TerritoryID
AccountNumber
rowguid
ModifiedDate
int
int
int
int
varchar
varchar
timestamp
int
int
smallint
smallint
datetime
datetime
datetime
datetime
decimal
decimal
decimal
timestamp
ProductInventory
ProductID
LocationID
Shelf
Bin
Quantity
rowguid
ModifiedDate
SalesTaxRate
CurrencyCode char
Name
varchar
ModifiedDate timestamp
int
varchar
varchar
timestamp
SalesTaxRateID
StateProvinceID
TaxType
TaxRate
Name
rowguid
ModifiedDate
SalesTerritoryHistory
int
int
tinyint
decimal
varchar
varchar
timestamp

BusinessEntityID
TerritoryID
StartDate
EndDate
rowguid
ModifiedDate
int
int
datetime
datetime
varchar
timestamp
Store
SalesPersonQuotaHistory
BusinessEntityID
QuotaDate
SalesQuota
rowguid
ModifiedDate
WorkOrderID
ProductID
OrderQty
StockedQty
ScrappedQty
StartDate
EndDate
DueDate
ScrapReasonID
ModifiedDate
BusinessEntityID
Name
SalesPersonID
Demographics
rowguid
ModifiedDate
int
datetime
decimal
varchar
timestamp
int
varchar
int
text
varchar
timestamp
int
int
int
int
smallint
datetime
datetime
datetime
smallint
timestamp
CreditCard
int
smallint
varchar
tinyint
smallint
varchar
timestamp
CreditCardID
CardType
CardNumber
ExpMonth
ExpYear
ModifiedDate
PurchaseOrderDetail
WorkOrder
Currency
SalesReasonID
Name
ReasonType
ModifiedDate
WorkOrderRouting
SpecialOffer
SpecialOfferID
Description
DiscountPct
Type
Category
StartDate
EndDate
MinQty
MaxQty
rowguid
ModifiedDate
SalesReason
BillOfMaterials
Location
ProductDocument
LocationID
Name
CostRate
Availability
ModifiedDate
ProductID
int
DocumentNode varchar
ModifiedDate
timestamp
smallint
varchar
decimal
decimal
timestamp
BillOfMaterialsID
ProductAssemblyID
ComponentID
StartDate
EndDate
UnitMeasureCode
BOMLevel
PerAssemblyQty
ModifiedDate
int
int
int
timestamp
datetime
char
smallint
decimal
timestamp
TransactionHistory
ProductReview
ProductCostHistory
ProductID
StartDate
EndDate
StandardCost
ModifiedDate
int
datetime
datetime
decimal
timestamp
ProductListPriceHistory
ProductID
StartDate
EndDate
ListPrice
ModifiedDate
int
datetime
datetime
decimal
timestamp
ProductReviewID
ProductID
ReviewerName
ReviewDate
EmailAddress
Rating
Comments
ModifiedDate
int
int
varchar
timestamp
varchar
int
varchar
timestamp
ShoppingCartItem
ShoppingCartItemID
ShoppingCartID
Quantity
ProductID
DateCreated
ModifiedDate
int
varchar
int
int
timestamp
timestamp
TransactionID
ProductID
ReferenceOrderID
ReferenceOrderLineID
TransactionDate
TransactionType
Quantity
ActualCost
ModifiedDate
int
int
int
int
timestamp
char
int
decimal
timestamp
PurchaseOrderID
PurchaseOrderDetailID
DueDate
OrderQty
ProductID
UnitPrice
LineTotal
ReceivedQty
RejectedQty
StockedQty
ModifiedDate
int
int
datetime
smallint
int
decimal
decimal
decimal
decimal
decimal
timestamp
int
varchar
varchar
tinyint
smallint
timestamp
ProductVendor
ProductID
BusinessEntityID
AverageLeadTime
StandardPrice
LastReceiptCost
LastReceiptDate
MinOrderQty
MaxOrderQty
OnOrderQty
UnitMeasureCode
ModifiedDate
int
int
int
decimal
decimal
datetime
int
int
int
char
timestamp
ProductProductPhoto
ProductID
ProductPhotoID
Primary
ModifiedDate
int
int
tinyint
timestamp
Product
ProductID
Name
ProductNumber
MakeFlag
FinishedGoodsFlag
Color
SafetyStockLevel
ReorderPoint
StandardCost
ListPrice
Size
SizeUnitMeasureCode
WeightUnitMeasureCode
Weight
DaysToManufacture
ProductLine
Class
Style
ProductSubcategoryID
ProductModelID
SellStartDate
SellEndDate
DiscontinuedDate
rowguid
ModifiedDate
Document
SalesPerson
StateProvince
StateProvinceID
StateProvinceCode
CountryRegionCode
IsOnlyStateProvinceFlag
Name
TerritoryID
rowguid
ModifiedDate
BusinessEntityID
TerritoryID
SalesQuota
Bonus
CommissionPct
SalesYTD
SalesLastYear
rowguid
ModifiedDate
int
char
varchar
tinyint
varchar
int
varchar
timestamp
int
int
decimal
decimal
decimal
decimal
decimal
varchar
timestamp
ScrapReason
ScrapReasonID smallint
Name
varchar
ModifiedDate
timestamp
DocumentNode
DocumentLevel
Title
Owner
FolderFlag
FileName
FileExtension
Revision
ChangeNumber
Status
DocumentSummary
Document
rowguid
ModifiedDate
varchar
smallint
varchar
int
tinyint
varchar
varchar
char
int
tinyint
longtext
longblob
varchar
timestamp
EmployeePayHistory
BusinessEntityID
RateChangeDate
Rate
PayFrequency
ModifiedDate
JobCandidate
int
datetime
decimal
tinyint
timestamp
JobCandidateID
BusinessEntityID
Resume
ModifiedDate
int
int
text
timestamp
int
varchar
varchar
tinyint
tinyint
varchar
smallint
smallint
decimal
decimal
varchar
char
char
decimal
int
char
char
char
int
int
datetime
datetime
datetime
varchar
timestamp
PurchaseOrderHeader
PurchaseOrderID
RevisionNumber
Status
EmployeeID
VendorID
ShipMethodID
OrderDate
ShipDate
SubTotal
TaxAmt
Freight
TotalDue
ModifiedDate
int
tinyint
tinyint
int
int
int
timestamp
datetime
decimal
decimal
decimal
decimal
timestamp
ProductPhoto
ProductModelIllustration
ProductModelID int
IllustrationID
int
ModifiedDate
timestamp
ProductModelProductDescriptionCulture
ProductModelID
ProductDescriptionID
CultureID
ModifiedDate
int
int
char
timestamp
ProductPhotoID
ThumbNailPhoto
ThumbnailPhotoFileName
LargePhoto
LargePhotoFileName
ModifiedDate
EmployeeDepartmentHistory
int
longblob
varchar
longblob
varchar
timestamp
BusinessEntityID
DepartmentID
ShiftID
StartDate
EndDate
ModifiedDate
int
smallint
tinyint
date
date
timestamp
Employee
SalesTerritory
TerritoryID
Name
CountryRegionCode
Group
SalesYTD
SalesLastYear
CostYTD
CostLastYear
int
varchar
varchar
varchar
decimal
decimal
decimal
decimal
rowguid
ModifiedDate
varchar
timestamp
BusinessEntityContact
BusinessEntityID
PersonID
ContactTypeID
rowguid
ModifiedDate
Password
int
int
int
varchar
timestamp
BusinessEntityID
PasswordHash
PasswordSalt
rowguid
ModifiedDate
int
varchar
varchar
varchar
timestamp
BusinessEntityID
NationalIDNumber
LoginID
OrganizationNode
OrganizationLevel
JobTitle
BirthDate
MaritalStatus
Gender
HireDate
SalariedFlag
int
varchar
varchar
varchar
smallint
varchar
date
char
char
date
tinyint
VacationHours
SickLeaveHours
CurrentFlag
rowguid
ModifiedDate
smallint
smallint
tinyint
varchar
timestamp
Vendor
EmailAddress
UnitMeasure
UnitMeasureCode char
Name
varchar
ModifiedDate
timestamp
BusinessEntityID
EmailAddressID
EmailAddress
rowguid
ModifiedDate
int
int
varchar
varchar
timestamp
PersonPhone
BusinessEntityID
PhoneNumber
PhoneNumberTypeID
ModifiedDate
int
varchar
int
timestamp
ProductSubcategory
ProductSubcategoryID
ProductCategoryID
Name
rowguid
ModifiedDate
int
int
varchar
varchar
timestamp
Person
CountryRegion
ContactType
CountryRegionCode varchar
ContactTypeID int
Name
ModifiedDate
Name
ModifiedDate
varchar
timestamp
varchar
timestamp
BusinessEntity
BusinessEntityID int
rowguid
varchar
ModifiedDate
timestamp
BusinessEntityID
PersonType
NameStyle
Title
FirstName
MiddleName
int
char
tinyint
varchar
varchar
varchar
LastName
Suffix
EmailPromotion
AdditionalContactInfo
Demographics
rowguid
ModifiedDate
varchar
varchar
int
text
text
varchar
timestamp
PhoneNumberType
PhoneNumberTypeID int
Name
ModifiedDate
varchar
timestamp
ProductCategory
ProductCategoryID int
Name
rowguid
ModifiedDate
varchar
varchar
timestamp
BusinessEntityID
AccountNumber
Name
CreditRating
PreferredVendorStatus
ActiveFlag
PurchasingWebServiceURL
int
varchar
varchar
tinyint
tinyint
tinyint
varchar
ModifiedDate
timestamp
ShipMethod
ShipMethodID
Name
ShipBase
ShipRate
rowguid
ModifiedDate
int
varchar
decimal
decimal
varchar
timestamp
ProductModel
Illustration
IllustrationID int
Diagram
text
ModifiedDate timestamp
ProductModelID
Name
CatalogDescription
Instructions
rowguid
ModifiedDate
int
varchar
text
text
varchar
timestamp
ProductDescription
ProductDescriptionID
Description
rowguid
ModifiedDate
int
varchar
varchar
timestamp
Culture
CultureID
char
Name
varchar
ModifiedDate timestamp
Department
DepartmentID
Name
GroupName
ModifiedDate
smallint
varchar
varchar
timestamp
Shift
ShiftID
Name
StartTime
EndTime
ModifiedDate
tinyint
varchar
time
time
timestamp
dimSalesOrder
PK SalesOrderKey
CustomerID
OrderQty(Sales)
ProductID
CountryRegionCode
Group
PK SalesPersonID
UnitPrice
UnitPriceDiscount
dimTime
PK TimeKey
Date
Day
DayOfWeek
DayOfMonth
DayOfYear
WeekOfYear
Month
MonthOfYear
QuarterOfYear
Year
PK
FK1
FK2
FK3
FK4
FK5
FK6
FK7
FK8
factEmployee
EmployeeKey
OrderDateKey(SO)
DueDateKey(SO)
ShipDateKey(SO)
OrderDateKey(PO)
DueDateKey(PO)
ShipDateKey(PO)
EmployeePayHistoryKey
EmployeeID
JobTitle
HireDate
SalariedFlag
Bonus
ComissionPct
NumberOfCustomer
AvgNumberOfSOProducts
AvgNumberOfSOOrderQty
TotNumberOfSOProducts
TotNumberOfSOOrderQty
NumberOfSalesOrder
NumberOfVendors
NumberOfPreferredVendor
AvgNumberOfPOProducts
AvgNumberOfPOOrderQty
TotNumberOfPOProducts
TotNumberOfPOOrderQty
AvgNumberOfPOTotalDue
TotNumberOfPOTotalDue
AvgNumberOfPORejectProduct
TotNumberOfPORejectProduct
NumberOfPurchaseOrder
NumberOfProductFromPreferredVendor
NumberOfSalaryChanged
Rate
VacationHours
SickLeaveHours
dimPurchaseOrder
PK PurchaseOrderKey
VendorID
PK EmployeeID
ProductID
TotalDue
OrderQty
RejectedQty
PreferredVendorStatus
Name
dimEmployeePayHistory
PK EmployeePayHistoryKey
RateChangeDate
Rate
PayFrequency
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades