Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Agent Dimension in Call Center DW

2 posters

Go down

Agent Dimension in Call Center DW Empty Agent Dimension in Call Center DW

Post  CCAgent2015 Wed May 13, 2015 9:15 am

My question is for anyone that has experience implementing an Agent dimension in a DW that supports a call center.  


Our Agents generate activity in source operational systems including call management, workforce management, evaluation and order management to name just a few.  These logons vary from system to system (jasmith in one system and smithja12 in another).  There is no central repository for Agent logons and logons can be recycled as the call center staff experiences a lot of turnover.

The greatest challenge we face is that there is no agent natural key such as SSN or employee ID that can be used to consistently identify an Agent.  The workforce management system (Aspect Workforce Management) does generate what appears to be a unique and durable surrogate key for each Agent.  This package also allows agent level user defined fields that could be used to store logons for each Agent.

My somewhat vague question is…. Has anyone implemented or worked with an Agent dimension under similar circumstances (no durable Agent natural key, multiple dissimilar logons, Aspect Workforce Management) and could you please provide some high level direction on how to best model a solution?

Thanks for your help!


Posts : 1
Join date : 2015-05-13

Back to top Go down

Agent Dimension in Call Center DW Empty Re: Agent Dimension in Call Center DW

Post  ngalemmo Wed May 13, 2015 4:29 pm

Not agents specifically, but having different natural keys coming from different sources for the same entity is not uncommon.

The most important thing is to identify dimension rows using their true natural key.  If Jane Doe is in three systems and has three different natural keys, there should be three dimension rows.  Facts from a particular source would be linked using the natural key from that source.  This creates a stable link between transactional data and the agent as identified by the system where the transaction occurred.

To 'consolidate' transactions for Jane, you populate the dimension rows with the same attribute values.

This is a similar issue to the one discussed here:

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum