Prev: Problem with line Chart
Next: Using drop down lists
From: drew on 10 Dec 2009 12:14
i want to create a depiction of data sources based on latency and durability,
but these are not numeric.
Durability
Latency Now Week Pay Run Month Qtr Yr Archive Forever
Analytic
DW------------------------------------------------
Intervention
MDM-------------------------------------------------------
PDM-------------------------------------------
CDM-----------------------------------
Transaction HSD------------------------------------------------------
P4P--------------------------------------------
SE --------------------------------------------

DW = Data Warehouse
MDM = Member Data Mart
PDM = Provider Data Mart
CDM = Clinical Data Mart
....etc, there are other transactional systems with shorter shelf lives that
are not folded into a data mart or subsequently injected into the data
warehouse yet.
The Y axis speaks to the latency of the activity, we dont do analysis on a
day, and we arent up to daily refresh on the clinical side, but we may do a
disease intervention from a monitoring applicaiton on a daily basis, which is
why the stores have different start times.
Each store is good for a particular duration, meaning that we recognized the
passage of time in the Member Data Mart with type 2 columns on the works, so
its references go back further in time than the data warehouse's member
dimension, where the decision to left censor the data was made.

clear like mud?
thanks for any clue you can provide as to how to graph these relationships
in Excel
 | 
Pages: 1
Prev: Problem with line Chart
Next: Using drop down lists