The four steps to deriving a fact table when modelling a data warehouse are:
- Choosing business process to model – The first step is to decide what business process to model by gathering and understanding business needs and available data
- Declare the grain – by declaring a grain means describing exactly what a fact table record represents
- Choose the dimensions – once grain of fact table is stated clearly, it is time to determine dimensions for the fact table.
- Identify facts – identify carefully which facts will appear in the fact table.