Construction Project Management: Stop Using Spreadsheets
Having and maintaining accurate, up-to-date employee data is crucial in the construction business. If… Read More
Construction Project Management: Stop Using Spreadsheets
Having and maintaining accurate, up-to-date employee data is crucial in the construction business.
If your business is rapidly growing (like so many other construction companies in the Dallas area where HingePoint is headquartered) and you’re onboarding employees, vendors, and contractors, accurate data on who your employees are and what they are working on is critical for success.
Although it sounds like a simple task, project management for construction companies can be quite challenging and lead to more serious issues if not managed properly.
The Spreadsheet Problem
Many of our clients in the construction industry previously used Excel spreadsheets to manage their financial data, employee data, project status, and assets. Some were using old versions of SharePoint with unorganized data. When working with software and older systems, data about employees are prone to be full of errors (out-dated and inaccurate).
The trick is to get up-to-date, accurate information out of your data management system instead of old, error-prone data.
Spreadsheets are great tools for handling smaller and more manageable datasets. But what happens when you start hiring 10, 100, or even 500 employees at a time while managing employee data in a spreadsheet or in multiple, unstructured databases?
It gets unmanageable - fast.
As your construction business grows, more departments need human resource employee data because more information is attached to each employee. And soon, just having the right name, address, phone number, and social security number across the enterprise become more challenging if you don’t have the right controls and organization.
If this data is in an actual spreadsheet, then anyone can enter and change data in that workbook.
(See: Why spreadsheets don’t manage big data sets well)
The Situation
For example, a manager could get access to a Human Resource spreadsheet with employee names and other important information. Let’s say the manager has an employee named Suzanne, but she likes to be called Suzy. The manager changes the data because they can and there are no restrictions preventing it.
But there is a big problem. Now the source data – the system of record – is not consistent/accurate.
Suzanne will be called different names in different versions of spreadsheets.
(Check out our FREE eBook on The Secret To Systems Integration: The System Of Record.)
Throw time in there, too. Perhaps “Suzy” is a contractor who is keeping her time in a spreadsheet that gets sent to her manager. The manager sends Suzanne’s hours and all contractors to Human Resources so they can get paid. The manager’s project data is being merged with HR’s data.
The problem is that we have two different names in the system. “Suzanne” and “Suzy”.
No VLOOKUP formula or Pivot Table is going to solve this. It’s going to take someone to manually go in and fix the data.
This might not seem like a big deal, but as the company grows, these smaller errors will multiply in other departments. Once this happens, the employee data cannot be trusted, and it will take a lot of manual work to fix the errors each pay period. The data problems can become so big that businesses end up just not trusting their data, causing a lot of rework, manual data entry, etc.
The Solution
A lot of construction companies we work with the hope that the software an IT company is going to install will solve the data problem.
Unfortunately, this just adds another layer of complexity to the original problem.
The problem that needs to be solved is how you're going to clean up your data, actually collecting it, and then showing it in a way that lets you see the data in a new light.
Ideally, you want to make decisions with information that automatically reports to you.
Seeing year-over-year and month-to-month views of data can quickly identify trends. With the right devices collecting the data and the right systems transposing it into information, humans can focus on making strategic decisions that will make their customers happy.
That is how technology should work. And that what HingePoint can help you acheive!
If you're looking to solve your company's HR and Project Management employee data problem, we'd love to hear what you're looking to accomplish! Feel free to start a live chat with our solution consultant on this page, email us, or call us at (214) 301-0000 to get started today.
--
About HingePoint
HingePoint offers cloud and mobile applications for construction and real estate that are easy to adopt and employees love. Specializing in the systems that run the construction and real estate business including SharePoint, Salesforce, Procore, MS Dynamics, and Autodesk. Scale and grow profitably with Financial and Project Management Dashboards, document management, and workflow automation for field to office collaboration.
HingePoint
8105 Rasor Blvd.
Suite 241
Plano, TX 75024
(214) 301-0000
www.hingepoint.com
[post_title] => Best Practices for Construction Companies to Control Employee Data
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => best-practices-for-construction-companies-to-control-employee-data
[to_ping] =>
[pinged] =>
[post_modified] => 2018-10-22 00:34:23
[post_modified_gmt] => 2018-10-22 05:34:23
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.hingepoint.com/?p=14266
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 12991
[post_author] => 3
[post_date] => 2017-07-24 10:36:52
[post_date_gmt] => 2017-07-24 15:36:52
[post_content] => Accurate, up-to-date human resource employee data is crucial for your business
If you’re a growing company and you’re onboarding employees and vendors, accurate data on who your employees are and what they are working on is critical for success. Although it sounds like a simple human resources task, it can actually be quite challenging.
Many of our customers have used spreadsheets like Excel to manage their financial data, employee data, and assets. Some were using old versions of SharePoint with unorganized data.
When we’re working with software and older systems, our data about employees are prone to be full of errors, inaccurate and old. The trick is to get up-to-date, accurate information out of your data management system instead of old, error-prone data.
Spreadsheets were great tools when the data was smaller and more manageable. But what happens when you start hiring 10 to a hundred or even 500 employees at a time while managing employee data in a spreadsheet or in multiple, unstructured databases?
It gets unmanageable. Here’s why.
As the business grows, more departments need human resource employee data. More information is attached to the employee.
And soon just having the right name, address, phone number and social security number across the enterprise are challenging if you don’t have the right controls and organization.
The Spreadsheet Problem
If this data is in an actual spreadsheet, then anyone can enter and change data in that sheet. (Check out our story on why spreadsheets don’t manage big data sets well.)
For example, a manager could get access to a Human Resource spreadsheet with employee names and other important information. Let’s say he has an employee named JoAnne, but she likes to be called Jo. He changes the data because he can and there are no restrictions preventing him.
But there is a big problem. Now the source data – the system of record – is not accurate. (Check out our eBook on what it takes to have a System of Record.)
JoAnne will be called different names in different versions of spreadsheets.
Throw time in there, too. Perhaps “Jo” is a contractor and keeping her time with a spreadsheet and must give the time to the manager. The manager sends JoAnne’s hours and all contractors to Human Resources so they can get paid.
The manager’s project data is being merged with human resource’s data. The problem is that we have two different names in the system.
No V-lookup or Pivot Table is going to solve this. It’s going to take someone to manually go in and fix the data.
This might not seem like a big deal, but as the company grows, these smaller errors will multiply in other departments. Once this happens, the employee data cannot be trusted, and it will take a lot of manual work to fix the errors each pay period.
The data problems can become so big that businesses end up just not trusting their data, causing a lot of rework and manual data entry.
The solution
A lot of companies hope that the software an IT company is going to install will solve the data problem. Unfortunately, this just adds another layer of complexity to the original problem.
The problem that needs to be solved is how are you going to clean up your data, and then collect that data and then show it in a way that lets you see the data in a new light.
Ideally, you want to make decisions with information that automatically reports to you. Seeing year over year, and month to month views of data can quickly identify trends.
But the first step is clean data.
Construction Project Management: Stop Using Spreadsheets
Having and maintaining accurate, up-to-date employee data is crucial in the construction business.
If your business is rapidly growing (like so many other construction companies in the Dallas area where HingePoint is headquartered) and you’re onboarding employees, vendors, and contractors, accurate data on who your employees are and what they are working on is critical for success.
Although it sounds like a simple task, project management for construction companies can be quite challenging and lead to more serious issues if not managed properly.
The Spreadsheet Problem
Many of our clients in the construction industry previously used Excel spreadsheets to manage their financial data, employee data, project status, and assets. Some were using old versions of SharePoint with unorganized data. When working with software and older systems, data about employees are prone to be full of errors (out-dated and inaccurate).
The trick is to get up-to-date, accurate information out of your data management system instead of old, error-prone data.
Spreadsheets are great tools for handling smaller and more manageable datasets. But what happens when you start hiring 10, 100, or even 500 employees at a time while managing employee data in a spreadsheet or in multiple, unstructured databases?
It gets unmanageable - fast.
As your construction business grows, more departments need human resource employee data because more information is attached to each employee. And soon, just having the right name, address, phone number, and social security number across the enterprise become more challenging if you don’t have the right controls and organization.
If this data is in an actual spreadsheet, then anyone can enter and change data in that workbook.
(See: Why spreadsheets don’t manage big data sets well)
The Situation
For example, a manager could get access to a Human Resource spreadsheet with employee names and other important information. Let’s say the manager has an employee named Suzanne, but she likes to be called Suzy. The manager changes the data because they can and there are no restrictions preventing it.
But there is a big problem. Now the source data – the system of record – is not consistent/accurate.
Suzanne will be called different names in different versions of spreadsheets.
(Check out our FREE eBook on The Secret To Systems Integration: The System Of Record.)
Throw time in there, too. Perhaps “Suzy” is a contractor who is keeping her time in a spreadsheet that gets sent to her manager. The manager sends Suzanne’s hours and all contractors to Human Resources so they can get paid. The manager’s project data is being merged with HR’s data.
The problem is that we have two different names in the system. “Suzanne” and “Suzy”.
No VLOOKUP formula or Pivot Table is going to solve this. It’s going to take someone to manually go in and fix the data.
This might not seem like a big deal, but as the company grows, these smaller errors will multiply in other departments. Once this happens, the employee data cannot be trusted, and it will take a lot of manual work to fix the errors each pay period. The data problems can become so big that businesses end up just not trusting their data, causing a lot of rework, manual data entry, etc.
The Solution
A lot of construction companies we work with the hope that the software an IT company is going to install will solve the data problem.
Unfortunately, this just adds another layer of complexity to the original problem.
The problem that needs to be solved is how you're going to clean up your data, actually collecting it, and then showing it in a way that lets you see the data in a new light.
Ideally, you want to make decisions with information that automatically reports to you.
Seeing year-over-year and month-to-month views of data can quickly identify trends. With the right devices collecting the data and the right systems transposing it into information, humans can focus on making strategic decisions that will make their customers happy.
That is how technology should work. And that what HingePoint can help you acheive!
If you're looking to solve your company's HR and Project Management employee data problem, we'd love to hear what you're looking to accomplish! Feel free to start a live chat with our solution consultant on this page, email us, or call us at (214) 301-0000 to get started today.
--
About HingePoint
HingePoint offers cloud and mobile applications for construction and real estate that are easy to adopt and employees love. Specializing in the systems that run the construction and real estate business including SharePoint, Salesforce, Procore, MS Dynamics, and Autodesk. Scale and grow profitably with Financial and Project Management Dashboards, document management, and workflow automation for field to office collaboration.
HingePoint
8105 Rasor Blvd.
Suite 241
Plano, TX 75024
(214) 301-0000
www.hingepoint.com
[post_title] => Best Practices for Construction Companies to Control Employee Data
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => best-practices-for-construction-companies-to-control-employee-data
[to_ping] =>
[pinged] =>
[post_modified] => 2018-10-22 00:34:23
[post_modified_gmt] => 2018-10-22 05:34:23
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.hingepoint.com/?p=14266
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 2
[max_num_pages] => 1
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] => 1
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] => 1
[is_tax] =>
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] =>
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] =>
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_posts_page] =>
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => 5b2f0835ffcc9220a425c87b18b59d4a
[query_vars_changed:WP_Query:private] =>
[thumbnails_cached] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)
[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)
)
As your construction business grows, more departments need human resource employee data because more information is attached to each employee. And soon, just having the right name, address, phone number, and social security number across the enterprise become more challenging if you don’t have the right controls and organization.
If this data is in an actual spreadsheet, then anyone can enter and change data in that workbook.
(See: Why spreadsheets don’t manage big data sets well)
As your construction business grows, more departments need human resource employee data because more information is attached to each employee. And soon, just having the right name, address, phone number, and social security number across the enterprise become more challenging if you don’t have the right controls and organization.
If this data is in an actual spreadsheet, then anyone can enter and change data in that workbook.
(See: