In these tough economic times, I am seeing more and more information posted on the web about tracking HR Data in Excel. Is this a good idea?
The short answer is - NO. While Excel is great for manipulating and rearranging data, it is not good at handling complex relational data.
What's That? Complex Relational Data. As an example, One employee may have had a history of many positions within an organization. One employee may have many entries related to leave and attendance. One employee may have many entries related to benefits. The list goes on and on. Tracking this in Excel without duplicating data and increasing your chances for error is a nightmare.
If you are a small or medium business and large solutions such as PeopleSoft and SAP are not in your budget, you can look to more appropriate tools than Microsoft Excel.
Microsoft Access is a relational database system capable of managing complex data and sharing within small workgroups. To see an HRIS created with Microsoft Access, see http://www.hrdatamanager.com/. Full Source Code is available allowing you to expand upon what is there and create what you want.
Good Luck with your HRIS searches and just remember to use the right tool for the right job.
Thanks,
Mark
mark@hrdatamanager.com
http://www.hrdatamanager.com/
Wednesday, February 18, 2009
Sunday, February 8, 2009
Tough Times Not Time To Cut Some Corners
Well, I guess we are a little over due for a post looking at Frosty in the post below.
Near the end of the year common folk throughout the country were shocked by events that our leaders should have seen coming through at least the last two Presidents.
In these tough times, businesses small and large are seeking ways to cut corners. Owners, Managers and CEO's must be careful to ensure they are cutting fat and not muscle. While it is great to look for ways to operate more efficiently and save money, some corners should not be cut.
Regardless of the economy, a good HRIS system will help businesses more efficiently track data and ensure government compliance while avoiding costly fines from the government for being found out of compliance.
Small and Medium sized organizations can help ensure they are compliant with government rules by using the HR Data Manager (http://www.hrdatamanager.com/) HRIS system designed specifically for small and medium business. Available for between $599.95 and $999.95 for a five user network license, businesses can be be efficient and compliant for a fraction of the cost associated with government fines or costly employee lawsuits.
Some food for thought as we endure a difficult 2009!
Mark
mark@hrdatamanager.com
http://www.hrdatamanager.com/
Near the end of the year common folk throughout the country were shocked by events that our leaders should have seen coming through at least the last two Presidents.
In these tough times, businesses small and large are seeking ways to cut corners. Owners, Managers and CEO's must be careful to ensure they are cutting fat and not muscle. While it is great to look for ways to operate more efficiently and save money, some corners should not be cut.
Regardless of the economy, a good HRIS system will help businesses more efficiently track data and ensure government compliance while avoiding costly fines from the government for being found out of compliance.
Small and Medium sized organizations can help ensure they are compliant with government rules by using the HR Data Manager (http://www.hrdatamanager.com/) HRIS system designed specifically for small and medium business. Available for between $599.95 and $999.95 for a five user network license, businesses can be be efficient and compliant for a fraction of the cost associated with government fines or costly employee lawsuits.
Some food for thought as we endure a difficult 2009!
Mark
mark@hrdatamanager.com
http://www.hrdatamanager.com/
Subscribe to:
Posts (Atom)
