What is data?

What is data?

By Bryce Finnerty

What is data? Many businesses struggle when accessing, finding, mining, cleaning and organizing data about their business. We help a lot of businesses… Read More

What is Data Mining?

What is Data Mining?

By Bryce Finnerty

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… Read More

What is Data Visualization?

What is Data Visualization?

By Bryce Finnerty

Many businesses are still creating reports and comparing and contrasting business trends with PDFs exported from Excel instead of using the latest data visualization… Read More

4 Reasons You Don’t Have Clean Data

4 Reasons You Don’t Have Clean Data

By Bryce Finnerty

Often when we launch or upgrade new software like SharePoint for our customers, what they are really after is clean data. We want to keep track of important… Read More


WP_Query Object
(
    [query] => Array
        (
            [tag] => clean-data
        )

    [query_vars] => Array
        (
            [tag] => clean-data
            [error] => 
            [m] => 
            [p] => 0
            [post_parent] => 
            [subpost] => 
            [subpost_id] => 
            [attachment] => 
            [attachment_id] => 0
            [name] => 
            [static] => 
            [pagename] => 
            [page_id] => 0
            [second] => 
            [minute] => 
            [hour] => 
            [day] => 0
            [monthnum] => 0
            [year] => 0
            [w] => 0
            [category_name] => 
            [cat] => 
            [tag_id] => 248
            [author] => 
            [author_name] => 
            [feed] => 
            [tb] => 
            [paged] => 0
            [meta_key] => 
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => 
            [menu_order] => 
            [embed] => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => Array
                (
                )

            [post__not_in] => Array
                (
                )

            [post_name__in] => Array
                (
                )

            [tag__in] => Array
                (
                )

            [tag__not_in] => Array
                (
                )

            [tag__and] => Array
                (
                )

            [tag_slug__in] => Array
                (
                    [0] => clean-data
                )

            [tag_slug__and] => Array
                (
                )

            [post_parent__in] => Array
                (
                )

            [post_parent__not_in] => Array
                (
                )

            [author__in] => Array
                (
                )

            [author__not_in] => Array
                (
                )

            [ignore_sticky_posts] => 
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [post_type] => 
            [posts_per_page] => 10
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
            [order] => DESC
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [taxonomy] => post_tag
                            [terms] => Array
                                (
                                    [0] => clean-data
                                )

                            [field] => slug
                            [operator] => IN
                            [include_children] => 1
                        )

                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                    [0] => wp_term_relationships
                )

            [queried_terms] => Array
                (
                    [post_tag] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => clean-data
                                )

                            [field] => slug
                        )

                )

            [primary_table] => wp_posts
            [primary_id_column] => ID
        )

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                )

            [relation] => 
            [meta_table] => 
            [meta_id_column] => 
            [primary_table] => 
            [primary_id_column] => 
            [table_aliases:protected] => Array
                (
                )

            [clauses:protected] => Array
                (
                )

            [has_or_relation:protected] => 
        )

    [date_query] => 
    [queried_object] => WP_Term Object
        (
            [term_id] => 248
            [name] => Clean Data
            [slug] => clean-data
            [term_group] => 0
            [term_taxonomy_id] => 248
            [taxonomy] => post_tag
            [description] => 
            [parent] => 0
            [count] => 9
            [filter] => raw
        )

    [queried_object_id] => 248
    [request] => SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (248)
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 13245
                    [post_author] => 3
                    [post_date] => 2017-12-08 03:11:15
                    [post_date_gmt] => 2017-12-08 09:11:15
                    [post_content] => There are many reasons why your organization's SharePoint database doesn't have the clean and trustworthy data you need to run your business efficiently.

Most businesses realize the data and documents you store in SharePoint are extremely important. For example, SharePoint is probably your "system of record" for marketing data and customer data. It may even run the company's intranet (containing things like human resources policies, IT procedures, your team document libraries, etc). Project collaboration, issues tracking, and task management critical to operations may be in your SharePoint system.

Our customers turn to HingePoint because they struggle to keep pace and organize SharePoint. They may have even outsourced the development of SharePoint in the past, but it still isn't working as efficiently as the Microsoft commercials lead you to believe is possible.

4 Reasons Why You Might Not Have the SharePoint Data You Need

1. The Data Doesn't Exist

Management or associates may assume you have information about your processes and training, but in some cases, it literally may not exist yet. Nobody has created it and put it in SharePoint. This may sound obvious, but it's something to consider. 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. Dirty Data

Your SharePoint data may not be "clean". What is clean data? Clean data is properly organized, fully filled in, accurate, and searchable. SharePoint lists and syncing Excel Sheets into SharePoint may result in incomplete or inaccurate data. This is especially the case if employees don't fill it out accurately and/or you don't have a data management and data quality process in place.

3. Downstream Data

In some cases, you may be pulling in data from a downstream system such as a CRM (like Salesforce or Siebel), financial system (like Sage), or project management system . If the data isn't accurate or clean in that system, then you are importing dirty data from other systems into SharePoint.

4. SharePoint Graphics and Charts

SharePoint has great list views, teams’ sites, and tasks lists, but it doesn't have the best chart and graphic capabilities. So, you may have the data in SharePoint, but you just can't seem to find it if it's not visually presented on the screen. There are many ways to enhance SharePoint with BI (business intelligence) tools like Tableau. See examples in the screenshots below. HingePoint can show you how! [post_title] => 4 Reasons You Don't Have Clean SharePoint Data [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => 4-reasons-you-dont-have-clean-sharepoint-data [to_ping] => [pinged] => [post_modified] => 2018-02-20 23:52:54 [post_modified_gmt] => 2018-02-21 05:52:54 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/blog/sharepoint/sharepoint-online-and-office-365-ingredients-for-the-perfect-intranet-copy/ [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 13058 [post_author] => 3 [post_date] => 2017-08-07 14:45:44 [post_date_gmt] => 2017-08-07 19:45:44 [post_content] => SharePoint is an incredible data management tool that helps organize and find on-demand data for your business. One of the greatest things SharePoint can do is give employees in different departments the ability to have their data easily accessible and organized in one place, instead of hunting for it. What do we mean by data? We mean contracts, project information, policies, employee training, and metrics. But there is a lot more to data than just simply having it. See our free, online eBook to learn more about getting the right kind of data in your business. How companies hunt Companies have historically not trusted the data they have about projects or HR tasks like employee training. Instead of going to a trusted system of record or data source, employees must hunt and gather the data. There are many ways to hunt. Often, companies who do not trust data will have a lot of meetings about projects and find information through email, instead of looking at the system of record. Here are four areas where SharePoint helps companies be more efficient and have more accurate, accessible information for employees. Projects Management Dashboard – Project management dashboard is important because it keeps helps you stay on top of your projects. You can get your projects done faster, cheaper, better with fewer mistakes. SharePoint can even predict when your projects are finished, provide all necessary documentation for a project and details. Sales Contracts and RFPs — We’ve seen businesses use SharePoint to track contracts with governments and track hundreds of RFPs. SharePoint can even report on RFPs and – if a company has the information – the competitive intelligence needed to win an RFP, all at a push of the button. Human Resource Portal for Corporate Policies and Procedures & Employee Training – One company we worked with had a paper sign in sheet to determine who went to mandatory training. Human resources would spend countless hours following up with employees to see who finished mandatory, government training. Now, employees can self-report by checking a box in SharePoint, and all the information is automatically reported. Performance Metrics –  A lot of companies track how well they are doing with SharePoint. They track how well they’re completing their tasks, compliance with various procedures, safety incidents, sales numbers, and contract wins. Again, with performance metrics reporting in one place, employees are not forced to track information down.

Quit the Spreadsheet

Use the tools large enterprises use, control your data with SharePoint

Managing Data with SharePoint Will Transform Your Business

Are you managing your entire company from a spreadsheet? How are you going to grow with those document management tools? Does your SharePoint work the way you want it to? If you properly implement SharePoint, it will transform your company's productivity. Employees will be more efficient, you'll have better access to your company's data, and you'll be able to better report on key metrics. HingePoint’s custom SharePoint solutions have helped many companies struggling with unorganized data and manual, multi-step processes. Those same customers have transitioned into a more organized, productive organization through automated workflows and easy-to-search information.   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 Saleforce 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] => 4 Ways to Use SharePoint For Company Data Management [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => 4-ways-to-use-sharepoint-to-manage-company-data [to_ping] => [pinged] => [post_modified] => 2018-09-05 13:34:27 [post_modified_gmt] => 2018-09-05 18:34:27 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=13058 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => 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 ) [3] => 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: 
  • Devices 
  • Systems (like software) 
  • Humans 
 This is how we categorize data flow when we onboard a new client. We’re going to use the airline industry to show you the different categories of data management.
Devices – device 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?  
system 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.
human 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:

Data Management Strategy Evaluation with HingePoint

[post_title] => The Oversimplified Data Management Workflow [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => data-oversimplified-workflow [to_ping] => [pinged] => [post_modified] => 2018-02-21 00:07:32 [post_modified_gmt] => 2018-02-21 06:07:32 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/blog/aec/bim-oversimplified-workflow-copy/ [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 12997 [post_author] => 3 [post_date] => 2017-07-26 09:08:34 [post_date_gmt] => 2017-07-26 14:08:34 [post_content] => Many reasons exist on why you don’t have the data you want or need for your business. It’s no secret that data is becoming important. Companies like AT&T and Amazon have a large Big Data business unit where they are trying to find trends in their massive data sets. Our customers have struggled with this constantly, especially if they are using a system like 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 Two

4 Reasons You Don’t Have Clean Data

[post_title] => 4 Reasons You Can't Get the Business Data You Want or Need [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => 4-reasons-you-cannot-get-the-business-data-you-need [to_ping] => [pinged] => [post_modified] => 2018-02-09 01:42:29 [post_modified_gmt] => 2018-02-09 07:42:29 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=12997 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => 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.

Chapter Seven

The Oversimplified Data Management Workflow

[post_title] =>

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-04-03 03:52:25 [post_modified_gmt] => 2018-04-03 08:52:25 [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 ) [6] => 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?
Ideally, we’d go into the actual database and look at the tables and categorize and classify each column and data set. Once our customer understands what data they actually have, we can begin creating solutions that will mine for the data they want and need to maximize their business.

Chapter Four:

What is Data Visualization?

[post_title] => What is Data Mining? [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => what-is-data-mining [to_ping] => [pinged] => [post_modified] => 2018-02-09 02:43:58 [post_modified_gmt] => 2018-02-09 08:43:58 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=12971 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) [7] => WP_Post Object ( [ID] => 12951 [post_author] => 3 [post_date] => 2017-07-14 08:01:08 [post_date_gmt] => 2017-07-14 13:01:08 [post_content] => Many businesses are still creating reports and comparing and contrasting business trends with PDFs exported from Excel instead of using the latest data visualization tools. But what is data visualization? Data visualization is looking at your key metrics and data with a graph, and it is usually on a dashboard. Think the dashboard in your car; it shows your gas tank, your speed, your miles. You can have a dashboard for your business with your sales funnel data, financial data and project hours for employees. However, all of this assumes your data is clean and can be trusted. If you don’t have data you can trust, then you definitely cannot use this data to make sound business decisions. Currently, a lot of companies look at their sales and financial data as line items on a sheet. If you are not looking at accurate data in a visual manner you’re probably missing a trend or an extra expense about your business. Here’s an example: One of our customers had a financial system made out of PDFs. They had about six restaurants they were tracking. They would collect the finances for each of the restaurants and make separate PDFs. The PDFs would be shipped to the CFO team and they would dissect the information. Usually, the information was more than a month late because it took a while to build the reports. We built a financial dashboard. This collects all the information from the PDFs and puts the information on one screen. You can instantly get simple, comprehensive views of critical financial information on your phone. The customer had the ability to select what they wanted to compare from each restaurant in pie charts. So for example, if they wanted to see how much money each restaurant was spending on entertainment, they could easily see it. As soon as the financial dashboard came online… the customer realized they were spending way too much money on music and entertainment in one of their venues. They were able to make the decision to stop hiring so many bands immediately. Before the data wasn’t accessible. It wasn’t visible. The entertainment data was a line item in six separate PDFs. It also wasn’t in the same place. We created a dashboard to show side by side views of expenses like music and entertainment. They could see as a percentage of the pie that it was huge. As soon as they were able to visually see the data they could tell where their money was going and what changes needed to be made.

Chapter Five:

3 Reasons You Should Quit Managing Data with Spreadsheets

[post_title] => What is Data Visualization? [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => what-is-data-visualization [to_ping] => [pinged] => [post_modified] => 2018-02-26 13:42:20 [post_modified_gmt] => 2018-02-26 19:42:20 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=12951 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) [8] => WP_Post Object ( [ID] => 12948 [post_author] => 3 [post_date] => 2017-07-12 07:05:54 [post_date_gmt] => 2017-07-12 12:05:54 [post_content] =>

Often when we launch or upgrade new software like SharePoint for our customers, what they are really after is clean data.

We want to keep track of important information that will make us smarter about our business. When we work with a new customer that wants to fix their SharePoint or Salesforce, we inevitably find that their data is not clean.

To get systems to work the way the customer wants them to, we must help clean this data up so their software will be able to do what they want it to do, which usually is show accurate data.

We often get the question, why isn’t my data clean in the first place?

There are factors that can contribute to data that is not clean.

1. Usually, the data architecture is wrong. In other words, the way the databases were set up and the way different kinds of data related to each other are wrong. In a database, there are different tables that relate to each other. And that is the subject of data architecture… what columns are on which tables and how they relate to each other? So if you don’t set it the tables and databases up correctly, then while drilling down on your data you will get problems in terms of categorization or classification.

Bottom line, tables, and databases need to be set up properly. If you do not know how to do this, you need to find a consultant or hire someone who understands how to set this up. It’s critical if you want to use data to maximize your business.

2. Permission Issues – Sometimes employees who should not are changing data. Someone had permissions that they were not supposed to have.

Make sure that only the people that need to have permission to edit data have the right settings to do so. Set appropriate security permissions for employees. For example, only accountants should have permission to edit accounting data. If you are using something like Excel to manage financial data, then it might be time for a better system.

3. Data Entry Problems– Redundant data entry is a major culprit to unclean data. If you need to enter data multiple times, then this multiplies potential human errors. Errors also occur when copying it from one place to another.

To prevent this, make sure data is automated as much as possible. Eliminate as much manual entry as you can. Let software and systems do that data transfer rather than people. Software can talk other software. Integration part.

4. Data Entered Wrong – The alternative is that the data was entered incorrectly the first time. Ideally, customers can use a system that guides people through the data entry process. You can use checkboxes and dropdowns with limited possible entries as guides to control what data goes where. Many software systems have controls on what you can enter.To prevent this, make sure data is automated as much as possible. Eliminate as much manual entry as you can. Let software and systems transfer data rather than people. Software can talk to other software.

Chapter Three

What is Data Mining?

[post_title] => 4 Reasons You Don't Have Clean Data [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => 4-reasons-why-you-dont-not-have-clean-data [to_ping] => [pinged] => [post_modified] => 2018-02-21 00:09:14 [post_modified_gmt] => 2018-02-21 06:09:14 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=12948 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 9 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 13245 [post_author] => 3 [post_date] => 2017-12-08 03:11:15 [post_date_gmt] => 2017-12-08 09:11:15 [post_content] => There are many reasons why your organization's SharePoint database doesn't have the clean and trustworthy data you need to run your business efficiently. Most businesses realize the data and documents you store in SharePoint are extremely important. For example, SharePoint is probably your "system of record" for marketing data and customer data. It may even run the company's intranet (containing things like human resources policies, IT procedures, your team document libraries, etc). Project collaboration, issues tracking, and task management critical to operations may be in your SharePoint system. Our customers turn to HingePoint because they struggle to keep pace and organize SharePoint. They may have even outsourced the development of SharePoint in the past, but it still isn't working as efficiently as the Microsoft commercials lead you to believe is possible.

4 Reasons Why You Might Not Have the SharePoint Data You Need

1. The Data Doesn't Exist

Management or associates may assume you have information about your processes and training, but in some cases, it literally may not exist yet. Nobody has created it and put it in SharePoint. This may sound obvious, but it's something to consider. 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. Dirty Data

Your SharePoint data may not be "clean". What is clean data? Clean data is properly organized, fully filled in, accurate, and searchable. SharePoint lists and syncing Excel Sheets into SharePoint may result in incomplete or inaccurate data. This is especially the case if employees don't fill it out accurately and/or you don't have a data management and data quality process in place.

3. Downstream Data

In some cases, you may be pulling in data from a downstream system such as a CRM (like Salesforce or Siebel), financial system (like Sage), or project management system . If the data isn't accurate or clean in that system, then you are importing dirty data from other systems into SharePoint.

4. SharePoint Graphics and Charts

SharePoint has great list views, teams’ sites, and tasks lists, but it doesn't have the best chart and graphic capabilities. So, you may have the data in SharePoint, but you just can't seem to find it if it's not visually presented on the screen. There are many ways to enhance SharePoint with BI (business intelligence) tools like Tableau. See examples in the screenshots below. HingePoint can show you how! [post_title] => 4 Reasons You Don't Have Clean SharePoint Data [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => 4-reasons-you-dont-have-clean-sharepoint-data [to_ping] => [pinged] => [post_modified] => 2018-02-20 23:52:54 [post_modified_gmt] => 2018-02-21 05:52:54 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/blog/sharepoint/sharepoint-online-and-office-365-ingredients-for-the-perfect-intranet-copy/ [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 9 [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_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] => 2e44505edf947df5055a5efa795b183b [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 ) )