Use Adventureworks2014 or later database

1. Review the factInternetSales table.

1. What combination of column values uniquely identifies a row in factInternetSales?

2. What does a row in the factInternetSales table represent to the business? Explain in your own words.

3. What is the total (SUM) of the Freight for all of the rows? When writing your response, round to two decimal places.

2. For each dimension table in the diagram you created, identify each column in the fact table that relates the fact table to the dimension table. Note: Be sure to include multiple date columns.

3. Using the data in this data warehouse, find and list the name and email address of customer whose customer key is 11037. Explain in your own words how you found your answer.

4. Using the data in this data warehouse, find and list the names of the products customer 11037 has purchased.

5. For the Date dimension:

1. Describe the values in the column(s) that serve as primary key(s) in the Date dimension.

2. What column in the Date dimension table holds the actual date?

DimProduct ProductKey ProductAlternatekey ProductSubcategoryKey WeightUnit MeasureCode SizeUnit MeasureCode English ProductName Spanish ProductName FrenchProduct Name StandardCost Finished GoodsFlag Color SafetyStockLevel ReorderPoint ListPrice Size SizeRange Weight Days To Manufacture ProductLine Dealer Price Class Style ModelName Large Photo English Description French Description Chinese Description ArabicDescription Hebrew Description ThaiDescription GermanDescription Japanese Description Turkish Description StartDate EndDate FactInternetSales * ProductKey OrderDatekey DueDateKey ShipDateKey Customerkey PromotionKey Currencykey Sales TerritoryKey SalesOrder Number SalesOrderlineNumber Revision Number OrderQuantity UnitPrice ExtendedAmount UnitPriceDiscountPct DiscountAmount Product StandardCost Total Product Cost SalesAmount TaxAmt Freight Carrier Tracking Number CustomerPONumber Order Date DueDate Ship Date Dim Date * DateKey FullDate Alternatekey DayNumberOfWeek English DayNameOfWeek SpanishDayNameOfWeek French DayNameOfWeek DayNumberOfMonth DayNumberOfYear WeekNumberOfYear EnglishMonthName SpanishMonthName French MonthName MonthNumberOfYear CalendarQuarter CalendarYear CalendarSemester FiscalQuarter Fiscal Year FiscalSemester DimCustomer Customerkey Geography Key CustomerAlternateKey Title First Name MiddleName LastName NameStyle BirthDate Marital Status Suffix Gender EmailAddress YearlyIncome TotalChildren NumberChildrenAtHome EnglishEducation SpanishEducation FrenchEducation English Occupation Spanish Occupation French Occupation House OwnerFlag NumberCarsOwned AddressLine1 AddressLine2 Phone Date FirstPurchase CommuteDistance Status