Human Resources Data Mart Design Guidelines
2 posters
Page 1 of 1
Human Resources Data Mart Design Guidelines
Dear All,
i will be working on a data mart design project for Oracle HRMS system. i understood that the data mart design for human resource data (with Data Tracking tables and non additive measures) is not same as that of sales data marts.
Can you who worked on this earlier, please share your guidelines that need to be followed while designing data marts for human resources systems with date track (history data) tables?
Any pointers to any book or we blinks that discusses this topics very well from the real word background would be of great help.
We are starting with workforce and compensation data marts.
Regards,
Venkat
i will be working on a data mart design project for Oracle HRMS system. i understood that the data mart design for human resource data (with Data Tracking tables and non additive measures) is not same as that of sales data marts.
Can you who worked on this earlier, please share your guidelines that need to be followed while designing data marts for human resources systems with date track (history data) tables?
Any pointers to any book or we blinks that discusses this topics very well from the real word background would be of great help.
We are starting with workforce and compensation data marts.
Regards,
Venkat
venkatareddy.gali- Posts : 2
Join date : 2011-11-16
Re: Human Resources Data Mart Design Guidelines
It is the same as a sales data mart, it is just that HR is in a different business.
Facts track events and states, it is just a matter of identifying states and events in the HR process. For example, any time HR has some interaction with an employee, it is an event (transfer, salary change, leave, etc...).
Facts track events and states, it is just a matter of identifying states and events in the HR process. For example, any time HR has some interaction with an employee, it is an event (transfer, salary change, leave, etc...).
Human Resources Data Mart Design Guidelines
Hi,
Thanks for the quick reply. If possible, can you please point me towards some more details / 'exercises for practice' on the same topic? i have gone through one of the vendors pre built data mart for Oracle HRMS Data and it is super complex with one fact table storing all the events (SNAPSHOT,AGE_BAND,POWER_BAND, PERFORMANCE etc). Is the data model/mart needs to be so complex?
Thanks in advance
Regards,
Venkat
Thanks for the quick reply. If possible, can you please point me towards some more details / 'exercises for practice' on the same topic? i have gone through one of the vendors pre built data mart for Oracle HRMS Data and it is super complex with one fact table storing all the events (SNAPSHOT,AGE_BAND,POWER_BAND, PERFORMANCE etc). Is the data model/mart needs to be so complex?
Thanks in advance
Regards,
Venkat
venkatareddy.gali- Posts : 2
Join date : 2011-11-16
Re: Human Resources Data Mart Design Guidelines
Pre-built models tend to be overly complex as they are not focus on a particular task at hand, but evolve as the vendor encounters new clients and adds 'features' from disparate use cases.
But central to any HR model is an HR action fact which records all interactions with employees. There are usually a lot of dimensions, with 'before' and 'after' versions of a lot of them (position, department, job/title, etc...). Aggregates, such as head count, are derived from this one fact. There are, of course, a lot others, depending on your scope, such as hiring pipeline, service/experience/retirement analysis, etc...
But central to any HR model is an HR action fact which records all interactions with employees. There are usually a lot of dimensions, with 'before' and 'after' versions of a lot of them (position, department, job/title, etc...). Aggregates, such as head count, are derived from this one fact. There are, of course, a lot others, depending on your scope, such as hiring pipeline, service/experience/retirement analysis, etc...
Similar topics
» Human Resources Dimensional Modeling
» Data mart design
» Data mart Design Question
» [b]Need Help on Employee Data Mart Design[/b]
» Data Mart Philosophical Design Differences
» Data mart design
» Data mart Design Question
» [b]Need Help on Employee Data Mart Design[/b]
» Data Mart Philosophical Design Differences
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum