Fact table design for "State Workflow Analysis": Analysis Services Dimensional modeling
There are many business analytical needs whose data is in the form of “State Workflow”. A state workflow consists of a set of states. There are a valid number of “State Transitions”, i.e. changing of one state to another. The state transitions happen by some event. There can be a valid number of events responsible for state transition.
The typical business problem that conforms to above situation is “Sales Pipeline” analysis. The typical queries that need to be resolved are:
Read more...