title: How to design dimension and fact tables in ssas
body: <p>I have a database with few tables, ex.:</p>
  
  <ul>
  <li>Employee (Id, Name, state, country)</li>
  <li>Material (Id, Name, color, Type, amount, stock)</li>
  <li>Order (Id, MaterialId, EmployeeId, amount, discount, total amount)</li>
  <li>ShippingOrders (OrderId, MaterialId, EmployeeId, amount, discount, total amount)</li>
  <li>ShippingCountries (Id, CountryName)</li>
  <li>Customers (Id, Name, state,address, CountryId)</li>
  <li>MaterialImages (Image, MaterialId)</li>
  <li>PlacedOrders (OrderId, EmployeeId, CustomerId, Amount, shippingDate)</li>
  <li>SavedCarts </li>
  </ul>
  
  <p>Now, I have to create data warehouse from this table. Like we have <em>AdventureWorksDW</em> from <em>AdventureWorks</em> database.</p>
  
  <p>As I am completely new to database, I am curious to know how will I decide which fields should be selected as dimensions and which fields should be selected as Facts. </p>
  
  <p>and once I decide that then how would I create a DW database (like <em>AdventureWorksDW</em>)? 
  Is this will be like Creating database and table. After that fill those tables with select query from master database (Ex. <strong>DimProduct</strong> in <em>AdventureWorksDW</em> is might made up from joins of few tables from <em>AdventureWorks</em> database)</p>
  
  <p>To summarize, I am curious to know that how can I create my datawarehose db from existing db.</p>
  
  <p>I am very new to SSAS and your suggestion and opinion will be very useful to me.</p>