Report Portal

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...

Tags: design, sample

 

2007-2015 VidasSoft Systems Inc.