{"id":31148,"date":"2019-12-18T14:02:58","date_gmt":"2019-12-18T22:02:58","guid":{"rendered":"https:\/\/www.orgchartpro.com\/?p=31148"},"modified":"2019-12-18T23:18:36","modified_gmt":"2019-12-18T23:18:36","slug":"making-sense-of-your-data","status":"publish","type":"post","link":"https:\/\/orgchartpro.de\/de\/making-sense-of-your-data\/","title":{"rendered":"Making Sense of Your Data"},"content":{"rendered":"

Making Sense of your HR Data with Org Charts<\/h2>\n

The great power of modern organizational chart software is being able to make sense of the trove of HR data you already have. By importing the data into a centralized chart, data is transformed into something organized and visual which can then be used to make considered business decisions. Currently, if your data is scattered across a variety of sources, this may seem like a daunting or even impossible task. In this blog we\u2019ll aim to show you that you\u2019re closer than you think to a robust and accurate chart of your company\u2019s personnel data.<\/p>\n

<\/a>Data Import<\/h3>\n

OrgChart can import from a wide range of formats:<\/p>\n

    \n
  1. \n
    1.<\/span>Microsoft Excel files.<\/div>\n<\/li>\n
  2. \n
    2.<\/span>Microsoft Outlook contacts.<\/div>\n<\/li>\n
  3. \n
    3.<\/span>CSV (Comma Separated Values) files.<\/div>\n<\/li>\n
  4. \n
    4.<\/span>Active Directory \/ LDAP<\/div>\n<\/li>\n
  5. \n
    5.<\/span>Microsoft SQL Server<\/div>\n<\/li>\n
  6. \n
    6.<\/span>XML Document (OrgChart Schema)<\/div>\n<\/li>\n
  7. \n
    7.<\/span>Oracle<\/div>\n<\/li>\n
  8. \n
    8.<\/span>Tab delimited files<\/div>\n<\/li>\n
  9. \n
    9.<\/span>SAP XML and SAP Extract files<\/div>\n<\/li>\n
  10. \n
    10.<\/span>Org Chart Now Files<\/div>\n<\/li>\n
  11. \n
    11.<\/span>OLE DB DataSource. OrgChart supports the following OLE DB Data sources:<\/div>\n
      \n
    1. \n
      a.<\/span>Microsoft ISAM 1.1 OLE DB Provider.<\/div>\n<\/li>\n
    2. \n
      b.<\/span>Jet 4.0 OLE DB Provider.<\/div>\n<\/li>\n
    3. \n
      c.<\/span>Microsoft OLE DB Provider for Indexing Service.<\/div>\n<\/li>\n
    4. \n
      d.<\/span>Microsoft OLE DB Provider for Internet Publishing<\/div>\n<\/li>\n
    5. \n
      e.<\/span>Microsoft OLE DB Provider for ODBC Drivers.<\/div>\n<\/li>\n
    6. \n
      f.<\/span>Microsoft OLE DB Provider for OLAP Services.<\/div>\n<\/li>\n
    7. \n
      g.<\/span>Microsoft OLE DB Provider for Oracle.<\/div>\n<\/li>\n
    8. \n
      h.<\/span>Microsoft OLE DB Provider for SQL Server.<\/div>\n<\/li>\n
    9. \n
      i.<\/span>MS Data Shape.<\/div>\n<\/li>\n
    10. \n
      j.<\/span>OLE DB Provider for Microsoft Directory Services.<\/div>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

      OrgChart has an Import Wizard which works for all of the above. It has a familiar Back, Next, Cancel and Help button navigation system you are likely familiar with that steps you through the various phases of the import process. It also allows you to visualize how the data will be presented as you go.<\/p>\n

      <\/a>Hierarchy<\/h3>\n

      The hierarchy can be set either manually or automatically. By manipulating the \u201cPosition\u201d and \u201cReports to\u201d fields relationship hierarchy can be assigned manually within the wizard if that information is not available in the raw data.<\/p>\n

      <\/a>Dotted-Line (indirect) reporting.<\/h3>\n

      What is dotted-line reporting? Simply it\u2019s the relationship between an employee with a secondary supervisor that also provides direction or management in the work performed. You may be concerned how dotted-line relationships might complicate the creation of your org chart. This too is easily accomplished in OrgChart using the Dotted-Line Hierarchy<\/em> function, giving results like Figure 1.<\/p>\n

      <\/p>\n

      Figure 1: OrgChart displaying normal and dotted-line relationships between employees<\/em><\/p>\n

      Once your basic org chart is set-up it\u2019s time to move past the traditional org chart above and supercharge it with HR data from across your organization. What metrics might be the most interesting to stakeholders?<\/p>\n

      Here are just a few of the top metrics our clients use in their org charts to analyze their workforces:<\/p>\n