Employee Strength using Periodic Snapshot

View previous topic View next topic Go down

Employee Strength using Periodic Snapshot

Post  mark.tan on Wed Sep 09, 2009 12:34 am

Hi,

I am currently working on a employee strength data mart. Basically, it is suppose to track the staff strength over time, and profile the trend in term of nationality, citizenship, grading etc.

Hence, my thought is to use a periodic snapshot fact table design. Each month will contain the number of active employee in this fact table. So essentially, say for example, Jan-09 (350 records), Feb-09 (339 records) and so forth... In reporting, I will be able to trend the number of employees over time and by different grouping.

I hope my design is appropriate and elegant. All experts, please comment and advise on my design. Am I missing anything? Please share with me your thoughts!

Thank and Best Regards,
Mark
avatar
mark.tan

Posts : 14
Join date : 2009-02-04

View user profile

Back to top Go down

Re: Employee Strength using Periodic Snapshot

Post  ngalemmo on Wed Sep 09, 2009 11:10 am

A snapshot is fine for what you are trying to do. It is the usual way for tracking things like that.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Employee Strength using Periodic Snapshot

Post  mark.tan on Thu Sep 10, 2009 3:01 am

Thanks ngalemmo!
avatar
mark.tan

Posts : 14
Join date : 2009-02-04

View user profile

Back to top Go down

Re: Employee Strength using Periodic Snapshot

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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