{"id":22458,"date":"2020-11-23T10:11:17","date_gmt":"2020-11-23T10:11:17","guid":{"rendered":"https:\/\/www.experfy.com\/blog\/how-create-data-quality-dashboard\/"},"modified":"2023-10-04T15:40:06","modified_gmt":"2023-10-04T15:40:06","slug":"how-create-data-quality-dashboard","status":"publish","type":"post","link":"https:\/\/www.experfy.com\/blog\/ai-ml\/how-create-data-quality-dashboard\/","title":{"rendered":"How to Create a Data Quality Dashboard"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Your cornerstone in improving data quality<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

The main purpose of a dashboard is to provide a comprehensive snapshot of performance, which means that you should incorporate a large amount of detail without using too many drill-downs. It uses data from the past to identify trends and patterns that can help design future process improvements.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Data Quality Dashboard is an information management\u00a0tool that visually tracks, analyzes, and displays key performance indicators metrics It`s highlighting key data points to monitor the health of a business<\/a>, department, or specific process. They can be customized to meet the specific needs of a business and it shows how much trust you can put in your data.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Improvement of Data Quality is a long-term process and the best outcomes of such initiatives are bulletproof processes that will serve you in the future instead of just on time cleaned data. If You want to be effective you should get your process in shape monitor variations and control it instead of performing periodically data cleansing exercises. Correcting data is time-consuming so try thinking ahead when designing and implementing new processes. Investing time into quality assurance can save you a lot of later work.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

If you still don\u2019t know why you need reliable data quality check this article:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Here you can check 10 reasons why you need to have your data quality in order.<\/em><\/strong><\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

“How to Create a Data Quality Dashboard”\u00a0<\/p>\n

Photo by\u00a0Stephen Dawson\u00a0on\u00a0Unsplash<\/a><\/p>\n

\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

These are the main Data quality dimensions<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Completeness \u2014\u00a0<\/strong>doesn\u2019t bring too much value to the table. It can be misleading as you can have all the attributes completed but it`s about the content of the field you are validating and it still can be garbage.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Compliance\/Validity \u2014\u00a0<\/strong>This should be the focus when starting a data quality program. Does your data is satisfying business usage requirements? Start with defining rules and then profiling data against them. We can split this to :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

1. Format checks, depends on company standards, location and markets examples are:<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t



  • Formats of postal codes (you need to define this per countries)<\/li>
  • Minimum and Maximum Number of characters \u2014 so there are no 1 character addresses or company names<\/li>
  • In the case of a global company you can check if local characters are used in global names<\/li>
    <\/ul>
    <\/p>\n


    2. External Reference data compliance<\/strong><\/p>
    <\/p>\n



    • Checking external standard can be very beneficial as this will be very usable in reporting but also many of those classifications can be regulatory ones that are mandatory to run business (Customs Tariffs numbers)<\/li>
    • countries codes validation against ISO codes standard.<\/li>
    • Customers classified with SIC codes that are valid according to a global list<\/li>
    • Various Product classifications are mandatory in many markets: WEE classification, ETIM, UNSPC, Customs Tariffs codes. You can get the list of valid codes and perform validation of your products so they can fulfill business requirements.<\/li>
      <\/ul>
      <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      3. Master Data compliance<\/strong> \u2014 for better Strategic reporting companies are implementing internal segmentation or classification of customers products and orders. You need to create a master data reference table and then validate your records classifications against it. Various internal business rules can be implemented here but this should be suited to your needs and started with the design phase to address actual issues of organizations like:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      <\/p>\n

      \u00a0<\/p>\n

        \n
      • \n
          \n
        • Each product need to have an assigned active profit centre<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

          \u00a0<\/p>\n

            \n
          • \n
              \n
            • Each Client needs to have an active owner.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

              \u00a0<\/p>\n

              <\/p>\n

              <\/p>\n

              Consistency \u2014<\/strong>\u00a0is your data the same in different sources? This should be relatively easy if you have Master data in place and each local records are connected to your master data source of truth with a global identifier. Just compare key attributes in different sources. In an ideal world data should be syndicated from source of truth to consuming systems:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

              \n\t\t\t\t\t\t
              \n\t\t\t\t\t
              \n\t\t\t
              \n\t\t\t\t\t\t
              \n\t\t\t\t
              \n\t\t\t\t\t\t\t\t\t<\/p>\n

               <\/p>\n

                \n
              • \n
                  \n
                • Customers addresses in CRM against SAP against your Master Data<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                   <\/p>\n\n

                  Timeliness \u2014<\/strong>\u00a0is your data up to date<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

                  \n\t\t\t\t\t\t
                  \n\t\t\t\t\t
                  \n\t\t\t
                  \n\t\t\t\t\t\t
                  \n\t\t\t\t
                  \n\t\t\t\t\t\t\t\t\t



                  • schedule and monitor the data review process. Each records with<\/li>
                  • defined last edit date should be reviewed by the owner<\/li>
                  • Is your data provided on time? \u2014 Creating new customers is a workflow and you can have different requirements on different steps of the sales process, always consider the business process when monitoring such aspects.<\/li>
                  • For example, newly locally created customers records should be cleared and assigned with Global Customer Id withing 2 working days<\/li>
                    <\/ul>
                    <\/p>\n


                    Correctness\/Accuracy<\/strong>\u00a0\u2014 This is the most difficult one as there is no easy way to check that from the IS point of view. How can you check if the product weight is 10 kg and not 15 kg? Ideally, it`s established through primary research. In practice:<\/p>
                    <\/p>\n



                    • Manual auditing of sample<\/li>
                    • use 3rd party reference data from sources which are deemed trustworthy<\/li>
                    • Data Profiling and finding coherence patterns<\/li>
                    • Manual validation by owner \u2014 akin to crowdsourcing<\/li>
                      <\/ul>
                      <\/p>\n


                      It is not possible to set up a validation rule. Instead, you should focus on creating logic that will help discover any suspicious pattern in your data that varies from what you saw in past.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

                      \n\t\t\t\t
                      \n\t\t\t\t\t\t\t\t\t

                      What you should measure :<\/em> <\/strong><\/p>
                      <\/p>\n


                      Start with talking to data users and define your top elements and attributes and then the purpose of it.<\/p>
                      <\/p>\n


                      Look into user problems try a design thinking approach to discover opportunities.<\/p>
                      <\/p>\n


                      Define more crucial ones and start measuring them.<\/p>
                      <\/p>\n


                      You can group your KPI`s into business domains and accountable parties, then calculate quality indexes.<\/p>
                      <\/p>\n

                      Customer Data Quality can be built as a weighted average of attributes quality (Address, Vat, Owner) but also can include processes whenever these records are updated on time or are consistent in different sources. Calibrate the weights over measuring iteration based on business feedback.<\/p>
                      <\/p>\n


                      Make them SMART<\/em><\/p>
                      <\/p>\n


                      Specific \u2014 specifically designed to fulfill certain criteria<\/p>
                      <\/p>\n


                      Measurable \u2014Status is constantly monitored and available on the dashboard<\/p>
                      <\/p>\n


                      Accountable \u2014 Clearly defined responsible party<\/p>
                      <\/p>\n


                      Relevant \u2014 They have an impact on business<\/p>
                      <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

                      \n\t\t\t\t\t\t
                      \n\t\t\t\t\t
                      \n\t\t\t
                      \n\t\t\t\t\t\t
                      \n\t\t\t\t
                      \n\t\t\t\t\t

                      To recap, to improve and manage your data quality you need to know where you are now and where you want to be in a defined period so:<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
                      \n\t\t\t\t\t\t
                      \n\t\t\t\t\t
                      \n\t\t\t
                      \n\t\t\t\t\t\t
                      \n\t\t\t\t
                      \n\t\t\t\t\t\t\t\t\t

                      <\/p>\n

                        <\/p>\n

                      • Describe your data with clear definition and rules<\/li>\n

                        <\/p>\n

                      • Implement a continuous monitoring process and keep systems and processes up to date.<\/li>\n

                        <\/p>\n

                      • Engage with everyone responsible for the data tell them why and build data quality awareness<\/li>\n

                        <\/p>\n

                      • Increase the accountability for the data by assigning responsible<\/li>\n

                        <\/p><\/ul>\n


                        <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<\/p>\n


                        Time-based \u2014 there is time scope within they should be reach<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

                        \n\t\t\t\t\t\t
                        \n\t\t\t\t\t
                        \n\t\t\t
                        \n\t\t\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t

                        My KPI`s checklist:<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
                        \n\t\t\t\t\t\t
                        \n\t\t\t\t\t
                        \n\t\t\t
                        \n\t\t\t\t\t\t
                        \n\t\t\t\t
                        \n\t\t\t\t\t\t\t\t\t



                        • The object\/attribute is defined in the metadata tool rule-book or instruction<\/li>
                        • There is a clear business \u201cWHY\u201d \u2014 so people now why are they doing it this is important and it is building data quality awareness across the organization<\/li>
                        • Clearly accountable function\/person\/organization<\/li>
                          &
                        • Communication plan<\/li>
                        • Reviewed with reference team and stakeholders<\/li>
                          <\/ul>
                          <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
                          \n\t\t\t\t\t\t
                          \n\t\t\t\t\t
                          \n\t\t\t
                          \n\t\t\t\t\t\t
                          \n\t\t\t\t
                          \n\t\t\t\t\t

                          To recap, to improve and manage your data quality you need to know where you are now and where you want to be in a defined period so:<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
                          \n\t\t\t\t\t\t
                          \n\t\t\t\t\t
                          \n\t\t\t
                          \n\t\t\t\t\t\t
                          \n\t\t\t\t
                          \n\t\t\t\t\t\t\t\t\t

                          <\/p>\n

                            <\/p>\n

                          • Describe your data with clear definition and rules<\/li>\n

                            <\/p>\n

                          • Implement a continuous monitoring process and keep systems and processes up to date.<\/li>\n

                            <\/p>\n

                          • Engage with everyone responsible for the data tell them why and build data quality awareness<\/li>\n

                            <\/p>\n

                          • Increase the accountability for the data by assigning responsible<\/li>\n

                            <\/p><\/ul>\n


                            <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

                            Data Quality Dashboard is an information management tool that visually tracks, analyzes, and displays key performance indicators metrics. They can be customized to meet the specific needs of a business and it shows how much trust you can put in your data.<\/p>\n","protected":false},"author":985,"featured_media":17987,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[183],"tags":[1000,940,767,94,1045,592],"ppma_author":[3724],"class_list":["post-22458","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-ml","tag-dashboard","tag-data-governance","tag-data-quality","tag-data-science","tag-information-management-tool","tag-master-data-management"],"authors":[{"term_id":3724,"user_id":985,"is_guest":0,"slug":"maciek-lasota","display_name":"Maciek Lasota","avatar_url":"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/Maciek-Lasota-150x150.jpeg","user_url":"https:\/\/www.solution-tailor.com\/","last_name":"Lasota","first_name":"Maciek","job_title":"","description":"Maciek Lasota is Data Quality Manager at ABB. He is skilled in KPI Dashboards, SAP ERP, Data Governance, Having technical knowledge of SQL, PowerBI, and basic R and Python. Machine Learning enthusiast."}],"_links":{"self":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/22458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/users\/985"}],"replies":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/comments?post=22458"}],"version-history":[{"count":5,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/22458\/revisions"}],"predecessor-version":[{"id":33234,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/22458\/revisions\/33234"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/media\/17987"}],"wp:attachment":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/media?parent=22458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/categories?post=22458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/tags?post=22458"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=22458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}