- Define what matters to you, your company and your customers.
- Determine if what you spend most of your time on is what truly matters to your customer or company.
- Determine who else needs input on how you work.
- What must you deliver to your customer or boss?
- What is the end result that you are supposed to produce?
- Does it require software, applications,
- Are you looking for lost documents?
- Are you looking something up because it’s not in your system, files or where you store your data?
- Are you doing the work that a device or system should be doing to finish your work? If you don't know about our oversimplified workflow, you should learn it.
- Do you do redundant tasks, like enter data in multiple systems to finish your work?
- How productive are you? Are living by the 80/20 rule?
- Do you need to get data or information from someone else to complete your deliverable?
- Are other people counting on you?
- Do multiple people enter the same information in multiple times?
- Based on all this information, what do you want technology to do for you?
- If technology could do anything in a perfect world, what would it do for you?
Get Help with Data Management for Your Business
If you need help getting the most out of your data, please fill in the contact us button below to set up a free consultation with our data and systems experts.HingePoint covers the AEC Industry and is the author of The AEC Industry 4.0 Report and the Autodesk Industry Report 2017. HingePoint helps construction and real estate development companies take control of their company’s information. We combine systems, software, and data so all company information can be seen and accessed from one screen, like a smartphone or computer. HingePoint provides Procore, SharePoint and Salesforce consulting for Commercial Real Estate and Construction companies. HingePoint also helps the AEC industry with development & integration of AutoDesk and Procore products with enterprise systems. We are a trusted partner with over 25 years experience of systems development and integration work in the AEC industry. Our clients range from top hotel brands and restaurant chains to AEC firms and real estate developers and Facilities Management. We provide BIM with ROI. Results Guaranteed…Literally Guaranteed. [post_title] => Evaluate your Data Management Strategy with HingePoint [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => data-management-strategy-evaluation-hingepoint [to_ping] => [pinged] => [post_modified] => 2018-02-09 02:56:53 [post_modified_gmt] => 2018-02-09 08:56:53 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=12501 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw )  => WP_Post Object ( [ID] => 12956 [post_author] => 3 [post_date] => 2017-07-31 10:50:29 [post_date_gmt] => 2017-07-31 15:50:29 [post_content] => What is data? Many businesses struggle when accessing, finding, mining, cleaning and organizing data about their business. We help a lot of businesses using SharePoint, Salesforce, and Power BI and other enterprise tools, and almost always, they need help migrating, mining and cleaning their data. We want to explain the data that can maximize your business. What is it and what kind of data do you need to transform your business so you can make quicker and more accurate decisions? Types of Data Bad Data – Several companies we worked with have Customer Relationship Management (CRM) systems. A CRM is software that keeps track of your customer and prospect information, like Salesforce. Sometimes the information in the system gets unorganized. For whatever reason, the data in the CRM cannot be trusted. The phone numbers don’t match with the right customers. Address fields are not lined up and the information cannot be trusted. This is bad data. The test to determine if you have bad data is to ask yourself, “Would I make a major business decision based on this data?” If the answer is no, you might need help cleaning your data. Good Data – Good data is accurate; it can’t be faulty. It’s got to be true data and it reflects what happened in the real world. If you hired a new employee and his name is Jonathan, your human resources records, and all other records need to state that the new employee's name is Jonathan. Not Jon or Jonathon. Obviously, good data is the opposite of bad data. It’s data that is clean and accurate. Think of the CRM again. All fields are lined up and it can be trusted. But this is not the best form of data. Information can be accurate, but if it’s difficult to find and analyze then it is not going to do very much for you. If the goal is to analyze your data to see trends and make decisions, the data needs to be accessible and visual. HingePoint Data – This isn’t just a shameless plug for our business; you do need more than just good data. Let us explain. A hinge point is a point where things change. A HingePoint is a point where something literally pivots. It’s the turning point where you are going to see a significant change take place.To get HingePoint data it needs to be good, accurate and visual data. The goal of Hinge Point Data is to give you the insights that revolutionize and transform your business. Data is accurate, clean and can be trusted about a particular subject. But you need to be able to easily compare and contrast this data. Data helps us understand what is really going on, then we can make more informed decisions. It can help you make predictions and forecasts by understanding the trends of your business. HingePoint covers the AEC Industry and is the author of The AEC Industry 4.0 Report and the Autodesk Industry Report 2017. HingePoint helps construction and real estate development companies take control of their company’s information. We combine systems, software, and data so all company information can be seen and accessed from one screen, like a smartphone or computer. HingePoint provides Procore, SharePoint and Salesforce consulting for Commercial Real Estate and Construction companies. HingePoint also helps the AEC industry with development & integration of AutoDesk and Procore products with enterprise systems. We are a trusted partner with over 25 years experience of systems development and integration work in the AEC industry. Our clients range from top hotel brands and restaurant chains to AEC firms and real estate developers and Facilities Management. We provide BIM with ROI. Results Guaranteed…Literally Guaranteed. [post_title] => What is data? [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => what-is-data [to_ping] => [pinged] => [post_modified] => 2018-02-21 00:06:53 [post_modified_gmt] => 2018-02-21 06:06:53 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=12956 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw )  => WP_Post Object ( [ID] => 13017 [post_author] => 3 [post_date] => 2017-07-28 12:45:14 [post_date_gmt] => 2017-07-28 17:45:14 [post_content] => If you are just starting to get your feet wet with better data management workflow for your business, here are three key aspects of data that you should consider while creating accurate reports on your KPIs. We’d like to teach you an oversimplified data workflow that works for data management, no matter what company you are in. We think there are three pieces to a data workflow:
- Systems (like software)
Devices – We should use devices to collect data. Sometimes people must collect data. But if we can use a tool it will save a lot of time and get rid of a ton of busy work. Let’s look at the airline and weather example. Instead of making people continuously report the temperature in various cities, devices collect this information. Could you imagine how much tickets would be if people had to report this data?
Systems (Like software) – Many times devices collect data and then people turn it into information for senior leaders to make decisions. Many employees in corporate America are “Deck Donkeys,” which means the solely create decks to share information. These Power Point decks are typical graphs, reports, etc. Taking the airline industry example, instead of someone constantly making reports on the weather and showing where there is inclement weather, the airline industry has software that automatically reports on severe weather. Based on the weather, systems can predict airport congestion, taxi times and even what runways will be available and when. You can read a blog o n how The Weather Company uses systems for prediction.
Humans – Humans ultimately make the decisions. Let’s look at the airline industry one last time. After looking over the information on freezing temperatures, the information is funneled to the pilots, control towers, and airlines so they can make the best decisions for passengers. More from The Weather Company:
Airlines cannot change the weather, but they can mitigate the effect if they know the impact in advance. By understanding situations and the potential of their impacts ahead of time, airlines can execute time-sensitive strategies (such as flight cancellation, flight swaps, reserve crew, and etc.) to mitigate such impacts.Could you imagine what would happen if ALL this work was completed by a human? There would certainly be errors and airline prices would be even higher! 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 for us.
Chapter Eight:SharePoint or Smartsheets. By the time a customer has called us, they have usually exhausted every resource within their business and often have hired a standard IT company that did not fix the root cause of their woes. Here are a few reasons why you might not have the data you want or need for your business. 1. You may not have the data. It’s not there at all in any of your databases or spreadsheets. For example, one of our customers wanted to know what projects everyone was working on. They did not understand why they could not see that level of detail. The reason, they didn’t have tools that were collecting that information. We integrated T-Sheets with SharePoint and now they have that data. 2. Your data might not be clean. Read, 4 Reasons Why Your Data is Not Clean. If you are using a spreadsheet to manage your business’s data, then you will most likely have errors in that data. It could be hard to trust it, too. 3. Data Integration problems. Sometimes the software we use is “closed.” This basically means that the software you are using cannot talk to other software. For example, SharePoint can integrate with virtually every type of software and share data in multiple ways. However, a spreadsheet, like Excel or SmartSheets, can’t talk to other software or share data effectively. 4. Data visualization problems. You might have the data you need, you just cannot see it. You may not have the tools you need to visualize the data… like Tableau and Power BI. See our data visualization story and an example of how this could happen in your business.
Chapter Twospreadsheets 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.
How to Control Human Resource Employee Data[post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => how-to-control-human-resource-employee-data [to_ping] => [pinged] => [post_modified] => 2018-02-09 01:46:18 [post_modified_gmt] => 2018-02-09 07:46:18 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=12991 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw )  => WP_Post Object ( [ID] => 12971 [post_author] => 3 [post_date] => 2017-07-21 11:04:15 [post_date_gmt] => 2017-07-21 16:04:15 [post_content] => What is Data Mining? Data mining is looking at a lot of data and trying to get valuable information out of it. Data mining deals with large data sets that would take too long to go through manually. So, data scientists create and use programs or software to look at these huge data sets and discover patterns in the data. The core of data mining is turning data into information. It can be overwhelming to look at a lot of data and not see the value in it. But what happens if you are a company and do not have so much information you need a program to determine the data you have? When dealing with smaller sets of data, you don’t necessarily need to hire a team of data scientists. You need someone who understands data and can extract it enough to show you it visually. HingePoint Data and Data Detective Work Before you can mine your data for trends, you need to understand what data you have and if it is good or bad data. This is fundamental to using data to maximize your business. We call this the Data Detective phase of our unique process. The goal is to get Hinge Point Data, which is data that if accessed and visualized the right way can revolutionize and transform your business. A HingePoint is the point where something literally pivots. It’s the turning point where you are going to see a significant change take place. We found this happens best when you have the right data to make the best decisions or keep employees and customers the best informed. HingePoint executes this fundamental level of data detection with our data dictionary work. When we work with a customer, we go into the data and define every piece of data they have. With our Data Dictionary we identify the following:
- Where is it?
- What database?
- What table?
- What system?
Business Intelligence in the age of artificial intelligenceBusiness intelligence -- which is the ability to make better decisions on real-time, visual data -- will be the reason for the next renaissance. The last renaissance was after the printing press revolutionized humanity by causing literacy to increase after its invention in the 1440s. But literacy didn't actually skyrocket until the Industrial Revolution made literacy economically valuable. Instruction manuals for machines became important to read during the Industrial Revolution. Books were cheaper and more subjects were available. Kamal Hathi, a general manager at Microsoft, said spreadsheets were the printing press of data literacy. But artificial intelligence will make data literacy skyrocket like the industrial revolution made literacy skyrocket. Artificial intelligence will remove the need to understand statistics and code because it will automatically find interesting trends and outliers for users. Business intelligence and artificial intelligence will democratize data so it will be available to everyone, not just data scientists.
Cool Stuff We Learned about Power BI at Microsoft Ignite Power BI now has the ability to turn on forecasting, see trends, and automatically see clusters with one click. Go to analysis tab and click add forecast and it automatically and immediately adds a forecast. No statistics or coding is required. Now Power BI has the ability to show drive times and demographic data by merging existing information with Geospatial data by Esri. Companies can also publish and share Power BI reports from local servers, instead of using it through the web. That’s good for organizations that don’t want or can’t put certain data in the cloud, but they can still get the Power BI functionality.