Posted: November 25th, 2014
Description of a data data warehouse.
What data warehouse it is? Why do you want to do it? page 1
verbal description of fact tables…use key terminology page 2
verbal description of dimension tables…use key terminology page 3 and 4
make 3 star schema page 5
Please quote all defination and provide refferences
Dimension Dimension Table Name Fact Fact Table Name
Customers DimCustomer Order FactOrder
Employees DimEmployee Inventory FactInventory
Products DimProduct salesCoverage FactSalesCoverage
Shippers DimShipper
Suppliers DimSupplier
Date DimDate
Audit DimAudit
Dimension Order Date Shipped Date Customers Employees Shippers Products Suppliers Territory
Business Process
Sales Analysis X X X X X X This is the bus matrix
Orders X X X X X
Inventory X X X X
Sales Coverage X X
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂
Place an order in 3 easy steps. Takes less than 5 mins.