What is a Business Glossary? At times I feel that the answer to this is obvious and that it does not merit its own article. But then I read a blog post, a LinkedIn post, a whitepaper, or even watch a webinar that talks about the Business Glossary, that talks about it incorrectly. That’s when

Data governance maturity models are a favorite topic and a highly sought after online course here on LightsOnData. Why is that? The short answer is that a data governance maturity model is a sought after tool as it brings quite a few benefits which could be placed in the following 5 buckets: 1. Regulation Sometimes

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,

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

Organizations have several lines of defense in addressing various risks, at the project, department, or enterprise level and it all start with the awareness and monitoring of these risks. Risks also occur within and from data and data management areas (data quality, data security ,data architecture, etc.) as well as data governance and so data

In this article I’ll provide an introduction to the TDWI data governance maturity model, but here are the other ones covered so far: Stanford’s Data Governance Maturity Model IBM’s Data Governance Maturity Model DataFlux’s Data Governance Maturity Model Gartner’s Data Governance Maturity Model Oracle’s Data Governance Maturity Model Open Universiteit Nederland Data Governance Maturity Model

Introduction Data lineage documents where data is coming from, where it is going, and what transformations are applied to it as it flows through multiple processes. It helps in understanding the data life cycle. It is one of the most critical pieces of information from a metadata management point of view. From data-quality and data-governance perspectives, it is essential

How do we move Data Accessibility and, therefore, Decision Intelligence closer to the business users? Clearly, there is great benefit in providing seamless and secure accessibility to the right data as and when it is needed…such a capability provides your business with the means to make the right choices at the right time at the

When it comes to data accessibility or data democratization, there are those who believe that nothing should change while the rest believe it is time for data democratization to become the default state. To understand both of these views, here are the opportunities and considerations of data democratization.  Quick Navigation The opportunities of data democratization: 1.

Among the most important phases of DW/BI testing is front-end report testing. The DW/BI project team should ensure that everything tested in the back-end DW and ETLs is now processed and displayed correctly in end-user reports. BI reports are often the most visible product of any DW/BI system. Data quality defects that are not discovered