Data Quality Archives | LightsOnData https://www.lightsondata.com/category/data-quality/ Practical resources, online courses, free articles and videos for data management, data governance, data quality, and business intelligence Tue, 01 Aug 2023 02:04:48 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.3 https://i0.wp.com/www.lightsondata.com/wp-content/uploads/2020/03/LOD-logo-favicon2.png?fit=32%2C32&ssl=1 Data Quality Archives | LightsOnData https://www.lightsondata.com/category/data-quality/ 32 32 142004744 Top 10 Data Quality Myths You Should Know https://www.lightsondata.com/top-10-data-quality-myths/ https://www.lightsondata.com/top-10-data-quality-myths/#comments Mon, 10 Jul 2023 13:56:57 +0000 https://www.lightsondata.com/?p=5310 In the current digital era, the power of data has never been more crucial to the success of businesses. Data quality – the degree to which data is accurate, reliable, and applicable – is now a hot topic, as companies scramble to derive the most insights from their burgeoning data reserves. However, navigating the complex […]

The post Top 10 Data Quality Myths You Should Know appeared first on LightsOnData.

]]>
https://www.lightsondata.com/top-10-data-quality-myths/feed/ 1 5310
Data quality and data governance https://www.lightsondata.com/data-quality-and-data-governance/ https://www.lightsondata.com/data-quality-and-data-governance/#respond Tue, 09 Aug 2022 00:30:24 +0000 https://www.lightsondata.com/?p=4131 We often hear of data quality and data governance belonging together. That one cannot have good data quality without data governance. And that by doing data governance we achieve data quality. How so? What does that mean?What is the relationship between data governance and data quality? Or are they the same thing? Let's find out. […]

The post Data quality and data governance appeared first on LightsOnData.

]]>
https://www.lightsondata.com/data-quality-and-data-governance/feed/ 0 4131
Incentive as a catalyst for data quality https://www.lightsondata.com/incentive-as-a-catalyst-for-data-quality/ https://www.lightsondata.com/incentive-as-a-catalyst-for-data-quality/#respond Tue, 12 Apr 2022 07:14:42 +0000 https://www.lightsondata.com/?p=3954 A particular department has the responsibility of both onboarding new customers and cancellation of customer policy upon the customer's request. Their KPIs are based on the number of new customers they have onboarded and no KPI is attached to those of cancellation. This is reasonable, every organization wants to grow. In a way, no one […]

The post Incentive as a catalyst for data quality appeared first on LightsOnData.

]]>
https://www.lightsondata.com/incentive-as-a-catalyst-for-data-quality/feed/ 0 3954
Data deluge: critical data elements and their quality https://www.lightsondata.com/data-deluge-critical-data-elements-and-their-quality/ https://www.lightsondata.com/data-deluge-critical-data-elements-and-their-quality/#comments Thu, 06 Jan 2022 19:26:15 +0000 https://www.lightsondata.com/?p=3791 Not everything that can be counted counts, and not everything that counts can be counted...Albert Einstein. Table Of Contents 1The data deluge and the concept of critical data elements2Some key data concepts3Data quality4What data is important?5Impact of data on the bottom line The data deluge and the concept of critical data elementsThe digital age is […]

The post Data deluge: critical data elements and their quality appeared first on LightsOnData.

]]>
https://www.lightsondata.com/data-deluge-critical-data-elements-and-their-quality/feed/ 2 3791
Why better data quality needs top-level management https://www.lightsondata.com/why-better-data-quality-needs-top-level-management/ https://www.lightsondata.com/why-better-data-quality-needs-top-level-management/#comments Mon, 01 Feb 2021 19:14:43 +0000 https://www.lightsondata.com/?p=2911 You need top-level management involvement to improve the quality of your data. Fact! It's not enough for the IT manager to support your initiatives in improving the quality of your data. Thinking otherwise, won't get your data quality efforts too far.  Even if you're not part of IT, your department's manager understands the need to […]

The post Why better data quality needs top-level management appeared first on LightsOnData.

]]>
https://www.lightsondata.com/why-better-data-quality-needs-top-level-management/feed/ 1 2911
What data quality testing skills are needed for data integration projects? https://www.lightsondata.com/what-data-quality-testing-skills-needed-data-integration-projects/ https://www.lightsondata.com/what-data-quality-testing-skills-needed-data-integration-projects/#respond Wed, 12 Aug 2020 15:38:53 +0000 https://www.lightsondata.com/?p=2192 The impulse to cut project costs is often strong, especially in the final delivery phase of data integration and data migration projects. At this late phase of the project, a common mistake is to delegate testing responsibilities to resources with limited business and data testing skills. Data integrations are at the core of data warehousing, […]

The post What data quality testing skills are needed for data integration projects? appeared first on LightsOnData.

]]>
https://www.lightsondata.com/what-data-quality-testing-skills-needed-data-integration-projects/feed/ 0 2192
Data quality myth: our data is good https://www.lightsondata.com/data-quality-myth-good-data/ https://www.lightsondata.com/data-quality-myth-good-data/#respond Wed, 29 Jul 2020 22:58:54 +0000 https://www.lightsondata.com/?p=2183 There are quite a few data quality myths that need to be dispelled in order to move forward and mitigate the data quality risks. Last year I’ve covered 4 myths about Data Quality everyone thinks are true that started an entire trend on LinkedIn and also sparked a series of YouTube videos. So, here is […]

The post Data quality myth: our data is good appeared first on LightsOnData.

]]>
https://www.lightsondata.com/data-quality-myth-good-data/feed/ 0 2183
Data quality considerations during the DW/ BI design phase https://www.lightsondata.com/data-quality-considerations-during-the-dw-bi-design-phase/ https://www.lightsondata.com/data-quality-considerations-during-the-dw-bi-design-phase/#respond Wed, 20 May 2020 15:05:59 +0000 https://www.lightsondata.com/?p=1972 Decisions in today’s organizations have become increasingly data-driven and real-time. Therefore, the business intelligence databases that support decision makers must be of exceptional quality. We sometimes confuse testing a data warehouse that produce business intelligence (BI) reports with backend or database testing or with testing the BI reports themselves. Data warehouse testing is much more […]

The post Data quality considerations during the DW/ BI design phase appeared first on LightsOnData.

]]>
https://www.lightsondata.com/data-quality-considerations-during-the-dw-bi-design-phase/feed/ 0 1972
What you need to know about regression testing on DW/ BI projects (part 2) https://www.lightsondata.com/what-you-need-to-know-about-regression-testing-on-dw-bi-projects-part-2/ https://www.lightsondata.com/what-you-need-to-know-about-regression-testing-on-dw-bi-projects-part-2/#respond Wed, 29 Apr 2020 13:00:26 +0000 https://www.lightsondata.com/?p=1913 In the first article of this series on DW/BI regression testing, DW/BI regression test planning was defined accordingly: Testing performed after developing functional improvements or repairs to data and reports. Its purpose is to determine if changes have regressed other attributes of data and reports. A repetition of tests intended to show that the software’s […]

The post What you need to know about regression testing on DW/ BI projects (part 2) appeared first on LightsOnData.

]]>
https://www.lightsondata.com/what-you-need-to-know-about-regression-testing-on-dw-bi-projects-part-2/feed/ 0 1913
Data quality: goal or enabler? https://www.lightsondata.com/data-quality-goal-or-enabler/ https://www.lightsondata.com/data-quality-goal-or-enabler/#comments Wed, 12 Feb 2020 19:31:37 +0000 https://www.lightsondata.com/?p=1448 Recently I had a discussion on the question if the goal of data management would be to achieve good data quality or if data quality is an enabler for the most different business purposes. Data quality (DQ) is, in my personal opinion, an extremely interesting topic. When I started to learn about data quality more […]

The post Data quality: goal or enabler? appeared first on LightsOnData.

]]>
https://www.lightsondata.com/data-quality-goal-or-enabler/feed/ 1 1448