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 …read more

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 …read more

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. …read more

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 …read more

It is encouraging to see the level of emerging focus on the data-centric enterprise, putting data, at least, near the forefront on the business mindset. But how do we keep such a step change true to itself? If we continue with the same behaviours, will we not just keep getting the same results? The Data …read more

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 …read more

Do you want to be  successful data steward? This question sounds like a sales pitch, it’s not. If you want to be a successful data steward, you need to have these 4 sets of skills. You need to have the business know-how and experience, technical skills, analysis skills and interpersonal skills. OK, so you’re basically …read more

Data Scientists can now create Garbage from Truth itself!!! I call it TIGO : Truth In Garbage OutIs the worthy discipline of Data Management and it’s wiser sidekick Data Governance fighting a losing battle? Well it might just be…because now you can dedicate much effort to getting such foundational stuff right and have it all …read more

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 …read more

While almost every country in the world is struggling to keep up with the consequences of the deadly COVID-19 disease spread, efforts continue to find a cure or a vaccine or, at the least, methods that can limit the uncontrolled multiplication of the virus. The dilemma that many countries face today is twofold – explore …read more