title: how to put data in fact table?
body: <p>i'm new in business intelligence
  and i design a star schema that implement a data mart to help analyst to take a decision about student grades
  dimensions tables :
  - module (module code, module name) that contains information about the module
  - student ( code, first_name, last_name, ....) that contains information about the model
  - school subject ( code, name, professor name...)
  - degree ( code, libelle)
  - specialite (code, libelle)
  - time(year,half year)
  - geographie(continent,country,city)
  fact table :
  - result ( score, module score, year score)
  the data source is excel file :
  in each file i have a set of sheet for each sheet he present a students score in "Niveau 'X' , Specialite 'Y', Year and Half-Year 'Z',Module 'U',City 'A'...
  my question is :
  how i can't put data from excel to my dimensions and fact
  to dimensions i suppose that is easy but i need your proposition
  to fact i have no idea</p>
  
  <p>i'm sorry for my bad english  </p>