|
Reporting Time Zones
We are in the process of developing a data warehouse for our organization, and are trying to determine how time zones should be handled. We currently have contact centers in Eastern, Central & Mountain time zones, and servers in all of these, plus Pacific. Our corporate HQ is in Central, and our DW team seems to think that all times should be converted to Central time for reporting through the warehouse, even though from an Operations side, we would like to be able to see the centers performance along with a rolled up performance.
Has anyone had experience in this? What would you recommend? What are the pros/cons of each?
Thanks in advance!
Shawn Livengood
|