{"id":14825,"date":"2021-09-07T15:04:38","date_gmt":"2021-09-07T19:04:38","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=14825"},"modified":"2024-12-17T15:31:33","modified_gmt":"2024-12-17T20:31:33","slug":"data-discovery-charts-iri-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/","title":{"rendered":"FieldShield PII Discovery Charts"},"content":{"rendered":"<p>Among the PII data profiling and data discovery tools in the\u00a0<span style=\"font-weight: 400;\"><a href=\"https:\/\/www.iri.com\/products\/fieldshield\">IRI FieldShield<\/a> data masking product is an interactive data visualization panel, or dashboard, for PII search results. These data discovery displays are derived from the results of searches for PII in structured sources like relational databases and flat files. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">The HTML5-comptabible charts are viewed in a browser, and created from schema or directory searches launched from job configuration wizards in the <\/span><a href=\"https:\/\/www.iri.com\/products\/workbench\/discover-data\"><span style=\"font-weight: 400;\">IRI Workbench Data Discovery menu<\/span><\/a>. The search jobs<span style=\"font-weight: 400;\"> produce statistics about, and provide insight into, specifically defined <a href=\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-classification\/\">classes of data<\/a>. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Each data visualization is based on a data profiling or search log, and complements the text-based reports the search wizards also produce. <\/span><span style=\"font-weight: 400;\">Note that <a href=\"https:\/\/www.iri.com\/products\/darkshield\">IRI DarkShield<\/a> users can also produce graphical dashboard charts for data analysis from their searches through structured, semi-structured, and unstructured data sources<\/span><span style=\"font-weight: 400;\">. See <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/darkshield-pii-discovery-masking-charts\/\"><span style=\"font-weight: 400;\">this article<\/span><\/a><span style=\"font-weight: 400;\">\u00a0for those details.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The dashboards described in this article flow from these Workbench data data discovery wizards:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/\"><span style=\"font-weight: 400;\">DB Profiling<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/flat-file-profiling\/\"><span style=\"font-weight: 400;\">Flat-File Profiling<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/schema-data-class-search-2\/\"><span style=\"font-weight: 400;\">Schema Data Class Search<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/directory-data-class-search-wizard\/\"><span style=\"font-weight: 400;\">Directory Data Class Search<\/span><\/a><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Each dashboard uses Chart.js to create graphs that provide visual frames of reference for the data, rather than merely exporting log data to a spreadsheet or BI tool to provide the visuals. Any external system like that would have to import, restructure, and build a display from the log data from scratch. Instead now, it\u2019s all automated in, and launched from, <\/span><a href=\"https:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In addition to providing a more graphical version of what\u2019s in the text output, the charts actually extend the capabilities of the data discovery wizards. If the chart option is selected, a page containing the charts will automatically display upon completion of the wizard.<\/span><\/p>\n<h5><b>Data Profiling Dashboards<\/b><\/h5>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17192\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/database-profiling-chart-1024x806-1-300x236.png\" alt=\"\" width=\"514\" height=\"405\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/database-profiling-chart-1024x806-1-300x236.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/database-profiling-chart-1024x806-1-768x605.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/database-profiling-chart-1024x806-1.png 1024w\" sizes=\"(max-width: 514px) 100vw, 514px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">In the case of the <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/database-profiling-in-iri-workbench\/\"><span style=\"font-weight: 400;\">DB Profiling wizard<\/span><\/a><span style=\"font-weight: 400;\">, the HTML page will display the following charts:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Recurring Column Table<\/span><\/i><span style=\"font-weight: 400;\"> \u2013 displays titles of the most common columns throughout the dataset. When you hover the mouse pointer over the right column (number of occurrences), a box display shows the list of tables where the column was observed.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Data Type chart <\/span><\/i><span style=\"font-weight: 400;\">\u2013 represents how data is represented across different types<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Min and max values<\/span><\/i><span style=\"font-weight: 400;\"> \u2013 area charts indicate trends via minimum and maximum values<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Count measurements <\/span><\/i><span style=\"font-weight: 400;\">\u2013 these bar charts can also reveal trends or anomalies<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Length measurements<\/span><\/i><span style=\"font-weight: 400;\"> \u2013 area charts show trends in the length of the values, helping to identify consistency within a dataset<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Null values per field <\/span><\/i><span style=\"font-weight: 400;\">\u2013 charts showing how much of each field of the dataset is null<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Regex &amp; Value match counts<\/span><\/i><span style=\"font-weight: 400;\"> \u2013 any results displayed here, or shown as \u201cNot performed\u201d<\/span><\/li>\n<\/ul>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17193\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/flat-file-profile-chart-1024x780-1-300x229.png\" alt=\"\" width=\"510\" height=\"389\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/flat-file-profile-chart-1024x780-1-300x229.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/flat-file-profile-chart-1024x780-1-768x585.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/flat-file-profile-chart-1024x780-1.png 1024w\" sizes=\"(max-width: 510px) 100vw, 510px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">For the <\/span><a href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/flat-file-profiling\/\"><span style=\"font-weight: 400;\">Flat File Profiling wizard<\/span><\/a><span style=\"font-weight: 400;\">, that dashboard contains the following:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Recurring Column Table<\/span><\/i><span style=\"font-weight: 400;\"> \u2013 displays titles of the most common columns in the dataset. When you hover the mouse pointer over the right column (number of occurrences), a box display shows the list of tables in which the column was observed<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Data Type chart <\/span><\/i><span style=\"font-weight: 400;\">\u2013 a doughnut graph of how data is represented across different types<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Min and max values<\/span><\/i><span style=\"font-weight: 400;\"> \u2013 displayed side-by-side in a table, indicate trends via minimum and maximum values<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Count measurements <\/span><\/i><span style=\"font-weight: 400;\">\u2013 horizontal bar charts that may reveal trends or anomalies<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Length measurements<\/span><\/i><span style=\"font-weight: 400;\"> \u2013 bar charts show trends in length helping to identify consistency amongst a dataset<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Null values per field <\/span><\/i><span style=\"font-weight: 400;\">\u2013 charts showing how much of each field of the dataset is null<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Regex &amp; Value match counts<\/span><\/i><span style=\"font-weight: 400;\"> \u2013 results display here, or else show, \u201cNot performed\u201d<\/span><\/li>\n<\/ul>\n<h5><b>Data Class Search Dashboards<\/b><\/h5>\n<p><span style=\"font-weight: 400;\">Each <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/schema-data-class-search-2\/\"><span style=\"font-weight: 400;\">Schema Data Class Search<\/span><\/a><span style=\"font-weight: 400;\"> job can produce two charts:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Top Sources Table <\/span><\/i><span style=\"font-weight: 400;\">\u2013 displays the schema, table, and data class found through the search. When you hover over the schema column, a box displays the profile name. When you hover over the data class column, the corresponding column is shown. The table is also scrollable, allowing you to see the rankings of large datasets.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Top Data Classes \u2013 <\/span><\/i><span style=\"font-weight: 400;\">represents the data classes by number of occurrences, all<br \/>\nowing you to understand what portion of the data matches the selected class. Within this chart, you can click on a pattern in the legend, and the selected section of the chart will be hidden.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-17536 aligncenter\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/image-1-1024x573.png\" alt=\"FieldShield PII Discovery - Schema Data Class Search Results chart\" width=\"657\" height=\"368\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/image-1-1024x573.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/image-1-300x168.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/image-1-768x430.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/image-1-1536x860.png 1536w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/image-1-2048x1147.png 2048w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/image-1.png 1110w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/p>\n<p><span style=\"font-weight: 400;\"><br \/>\nFinally, the <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/directory-data-class-search-wizard\/\"><span style=\"font-weight: 400;\">Directory Data Class Search<\/span><\/a><span style=\"font-weight: 400;\"> dashboard also consists of two charts:<\/span><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-17195 aligncenter\" style=\"text-align: center;\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/dir-data-class-chart-1024x588-1-300x172.png\" alt=\"\" width=\"614\" height=\"352\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/dir-data-class-chart-1024x588-1-300x172.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/dir-data-class-chart-1024x588-1-768x441.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/dir-data-class-chart-1024x588-1.png 1024w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Top Sources Table <\/span><\/i><span style=\"font-weight: 400;\">\u2013 displays the data class and corresponding file found through the search. When you hover over the file column, a box displays showing the path, and when you hover over the data class column, the corresponding column is shown. The table is scrollable, allowing you to see rankings of large datasets<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Top Data Classes \u2013 <\/span><\/i><span style=\"font-weight: 400;\">represents the data classes by number of occurrences, allowing you to understand what portion of the data matches the selected class. Within this chart, you can click on a pattern in the legend, and the selected section of the chart will be hidden.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/li>\n<\/ul>\n<h5><b>Interactive Charts<\/b><\/h5>\n<p><span style=\"font-weight: 400;\">Following are more detailed looks into the charts available in some of the dashboards above.<\/span><\/p>\n<h5><b>Profile charts<\/b><\/h5>\n<p><span style=\"font-weight: 400;\">Most of the charts feature hover functionality, where a user can learn more about the data while pointing the mouse at a dataset. This makes it easier to see individual details like the number of occurrences of a searched value, or data type, in the tables you selected in the wizard to profile:<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17197\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/horizontal-profile-chart-1-300x138.jpg\" alt=\"\" width=\"520\" height=\"239\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/horizontal-profile-chart-1-300x138.jpg 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/horizontal-profile-chart-1-768x353.jpg 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/horizontal-profile-chart-1.jpg 833w\" sizes=\"(max-width: 520px) 100vw, 520px\" \/><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17198\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/vertical-profile-chart-1-300x127.jpg\" alt=\"\" width=\"508\" height=\"215\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/vertical-profile-chart-1-300x127.jpg 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/vertical-profile-chart-1-768x324.jpg 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/vertical-profile-chart-1.jpg 831w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Beneath the title of each section is a small <\/span><i><span style=\"font-weight: 400;\">About<\/span><\/i><span style=\"font-weight: 400;\"> link. When clicked, a section is displayed that describes the data being shown in each section:<\/span><\/p>\n<p><em><span style=\"font-weight: 400;\">Before<\/span><\/em><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17199\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/min-max-about-closed-1024x106-1-300x31.jpg\" alt=\"\" width=\"513\" height=\"53\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/min-max-about-closed-1024x106-1-300x31.jpg 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/min-max-about-closed-1024x106-1-768x80.jpg 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/min-max-about-closed-1024x106-1.jpg 1024w\" sizes=\"(max-width: 513px) 100vw, 513px\" \/><\/p>\n<p><em><span style=\"font-weight: 400;\">After<\/span><\/em><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17200\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/min-max-about-opened-1024x167-1-300x49.jpg\" alt=\"\" width=\"502\" height=\"82\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/min-max-about-opened-1024x167-1-300x49.jpg 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/min-max-about-opened-1024x167-1-768x125.jpg 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/min-max-about-opened-1024x167-1.jpg 1024w\" sizes=\"(max-width: 502px) 100vw, 502px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The chart\u2019s algorithms parse and process the results from the wizard, and utilize Chart.js to create a visual representation for each item of information. However, if the item was not selected within the wizard, or contains a null data set, it will not be created, and the other charts will simply resize to use the space available:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Row with 3 items:<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17202\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/three-chart-row-1024x179-1-300x52.jpg\" alt=\"\" width=\"1159\" height=\"201\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/three-chart-row-1024x179-1-300x52.jpg 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/three-chart-row-1024x179-1-768x134.jpg 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/three-chart-row-1024x179-1.jpg 1024w\" sizes=\"(max-width: 1159px) 100vw, 1159px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Row with 2 items:<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17203\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/two-chart-row-1024x254-1-300x74.jpg\" alt=\"\" width=\"689\" height=\"170\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/two-chart-row-1024x254-1-300x74.jpg 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/two-chart-row-1024x254-1-768x191.jpg 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/two-chart-row-1024x254-1.jpg 1024w\" sizes=\"(max-width: 689px) 100vw, 689px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">A way to double-check if an item is null is to scroll to the <\/span><i><span style=\"font-weight: 400;\">Null Values per Field<\/span><\/i><span style=\"font-weight: 400;\"> section. There is a small doughnut chart for each field showing what percentage of the data is null, or not null.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The charts are automatically colored to help make the result stand out: if the chart is green, then 50% or more of the field data is not null. If it is red, 50% or more of the data is null:<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17204\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/null-values-per-field-1024x536-1-300x157.jpg\" alt=\"\" width=\"629\" height=\"329\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/null-values-per-field-1024x536-1-300x157.jpg 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/null-values-per-field-1024x536-1-768x402.jpg 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/null-values-per-field-1024x536-1.jpg 1024w\" sizes=\"(max-width: 629px) 100vw, 629px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Again, hovering will allow you to get a more detailed look at the raw data:<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17205\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/row-count-null-not-null-1-300x138.png\" alt=\"\" width=\"467\" height=\"215\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/row-count-null-not-null-1-300x138.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/row-count-null-not-null-1.png 384w\" sizes=\"(max-width: 467px) 100vw, 467px\" \/><\/p>\n<h5><b>Data Class Charts<\/b><\/h5>\n<p><span style=\"font-weight: 400;\">For the Data Type doughnut charts seen after Schema Data Class Search and Directory Data Class Search jobs, you can click on an element within the legend and hide that section. This way you can customize the chart to show filtered results.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Hovering over sections of the chart will also reveal the number of hits associated with the data class:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-17206 \" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/live-filter-data-types-1.gif\" alt=\"\" width=\"494\" height=\"374\" \/><\/p>\n<p><span style=\"font-weight: 400;\">These dashboards also include a table of the top sources. Each row contains the source and the class or pattern found in that source.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The data class charts have three columns containing the schema, table, and data class while the directory data class chart only contains the source file and data class.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Hovering over the entries will reveal more information about the location of the data class.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17209\" src=\"\/blog\/wp-content\/uploads\/2021\/09\/top-columns-1-300x103.png\" alt=\"\" width=\"525\" height=\"180\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/top-columns-1-300x103.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/top-columns-1-768x264.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/top-columns-1.png 774w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">You can learn more about the IRI Workbench graphical IDE for IRI data management jobs <\/span><a href=\"https:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">here<\/span><\/a><span style=\"font-weight: 400;\">. If you have any questions about or need help using the charts or reports from the data discovery logs generated by the wizards in that menu, please contact <\/span><a href=\"mailto:support@iri.com\"><span style=\"font-weight: 400;\">support@iri.com<\/span><\/a><span style=\"font-weight: 400;\"> or your IRI <\/span><a href=\"https:\/\/www.iri.com\/partners\/resellers\"><span style=\"font-weight: 400;\">representative<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Among the PII data profiling and data discovery tools in the\u00a0IRI FieldShield data masking product is an interactive data visualization panel, or dashboard, for PII search results. These data discovery displays are derived from the results of searches for PII in structured sources like relational databases and flat files. The HTML5-comptabible charts are viewed in<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/\" title=\"FieldShield PII Discovery Charts\">Read More<\/a><\/div>\n","protected":false},"author":154,"featured_media":17214,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[8,91],"tags":[267,1081,280,1975,278,229,1762,754,1763,1523,1524,1388,850,1734,1764,1522,1303,1737],"class_list":["post-14825","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-iri-workbench","tag-data-analysis","tag-data-classification","tag-data-discovery","tag-data-governance-solutions","tag-data-profiling","tag-data-visualization","tag-database-data-discovery","tag-database-profiling","tag-database-search","tag-directory-data-class-search","tag-html-charts","tag-iri-darkshield","tag-iri-workbench","tag-pii-discovery","tag-pii-search","tag-schema-data-class-search","tag-schema-pattern-search","tag-sensitive-data-discovery"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>FieldShield PII Discovery Charts - IRI<\/title>\n<meta name=\"description\" content=\"Gain valuable insights with interactive data visualizations of PII search and data profiling results in the IRI FieldShield data masking tool.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FieldShield PII Discovery Charts\" \/>\n<meta property=\"og:description\" content=\"Gain valuable insights with interactive data visualizations of PII search and data profiling results in the IRI FieldShield data masking tool.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-07T19:04:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-17T20:31:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"368\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Chris Quintin and Adam Lewis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chris Quintin and Adam Lewis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/\"},\"author\":{\"name\":\"Chris Quintin and Adam Lewis\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/a9da5c3bc28cbd1016a414444c5d8f7b\"},\"headline\":\"FieldShield PII Discovery Charts\",\"datePublished\":\"2021-09-07T19:04:38+00:00\",\"dateModified\":\"2024-12-17T20:31:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/\"},\"wordCount\":1227,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png\",\"keywords\":[\"data analysis\",\"data classification\",\"data discovery\",\"data governance solutions\",\"data profiling\",\"data visualization\",\"database data discovery\",\"database profiling\",\"database search\",\"Directory Data Class Search\",\"html charts\",\"IRI DarkShield\",\"IRI Workbench\",\"PII discovery\",\"PII search\",\"schema data class search\",\"schema pattern search\",\"sensitive data discovery\"],\"articleSection\":[\"Data Masking\/Protection\",\"IRI Workbench\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/\",\"name\":\"FieldShield PII Discovery Charts - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png\",\"datePublished\":\"2021-09-07T19:04:38+00:00\",\"dateModified\":\"2024-12-17T20:31:33+00:00\",\"description\":\"Gain valuable insights with interactive data visualizations of PII search and data profiling results in the IRI FieldShield data masking tool.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png\",\"width\":768,\"height\":368},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FieldShield PII Discovery Charts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},[{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/a9da5c3bc28cbd1016a414444c5d8f7b\",\"name\":\"Chris Quintin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"inLanguage\":\"en_US\",\"url\":\"\",\"caption\":\"Chris Quintin\"}},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/a9da5c3bc28cbd1016a414444c5d8f7b\",\"name\":\"Adam Lewis\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"inLanguage\":\"en_US\",\"url\":\"\",\"caption\":\"Adam Lewis\"}}]]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"FieldShield PII Discovery Charts - IRI","description":"Gain valuable insights with interactive data visualizations of PII search and data profiling results in the IRI FieldShield data masking tool.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"FieldShield PII Discovery Charts","og_description":"Gain valuable insights with interactive data visualizations of PII search and data profiling results in the IRI FieldShield data masking tool.","og_url":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/","og_site_name":"IRI","article_published_time":"2021-09-07T19:04:38+00:00","article_modified_time":"2024-12-17T20:31:33+00:00","og_image":[{"width":768,"height":368,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png","type":"image\/png"}],"author":"Chris Quintin and Adam Lewis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chris Quintin and Adam Lewis","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/"},"author":{"name":"Chris Quintin and Adam Lewis","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/a9da5c3bc28cbd1016a414444c5d8f7b"},"headline":"FieldShield PII Discovery Charts","datePublished":"2021-09-07T19:04:38+00:00","dateModified":"2024-12-17T20:31:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/"},"wordCount":1227,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png","keywords":["data analysis","data classification","data discovery","data governance solutions","data profiling","data visualization","database data discovery","database profiling","database search","Directory Data Class Search","html charts","IRI DarkShield","IRI Workbench","PII discovery","PII search","schema data class search","schema pattern search","sensitive data discovery"],"articleSection":["Data Masking\/Protection","IRI Workbench"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/","url":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/","name":"FieldShield PII Discovery Charts - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png","datePublished":"2021-09-07T19:04:38+00:00","dateModified":"2024-12-17T20:31:33+00:00","description":"Gain valuable insights with interactive data visualizations of PII search and data profiling results in the IRI FieldShield data masking tool.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png","width":768,"height":368},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/data-protection\/data-discovery-charts-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"FieldShield PII Discovery Charts"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},[{"@type":["Person"],"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/a9da5c3bc28cbd1016a414444c5d8f7b","name":"Chris Quintin","image":{"@type":"ImageObject","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","inLanguage":"en_US","url":"","caption":"Chris Quintin"}},{"@type":["Person"],"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/a9da5c3bc28cbd1016a414444c5d8f7b","name":"Adam Lewis","image":{"@type":"ImageObject","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","inLanguage":"en_US","url":"","caption":"Adam Lewis"}}]]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2021\/09\/FieldShield-PII-Discovery-Charts-Featured-image2.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14825"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/154"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=14825"}],"version-history":[{"count":20,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14825\/revisions"}],"predecessor-version":[{"id":18168,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14825\/revisions\/18168"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/17214"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=14825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=14825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=14825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}