Business Intelligence

Share0
Tweet0
Pin0

Managing DW/ BI data integration risks through data reconciliation and data lineage processes

Author Image

Wayne Yaddow

July 8, 2020

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

Data Governance

Share0
Tweet0
Pin0

Maximum data accessibility construction

Author Image

Robert Vane

June 17, 2020

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

Data Governance

Share0
Tweet0
Pin0

The opportunities and considerations of data democratization

Author Image

George Firican

June 10, 2020

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

Business Intelligence

Share0
Tweet0
Pin0

Main considerations for testing BI reports

Author Image

Wayne Yaddow

June 3, 2020

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

Data Governance

Share0
Tweet0
Pin0

4 lessons to improve your data diet

Author Image

Robert Vane

May 27, 2020

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

Data Quality

Share0
Tweet0
Pin0

Data quality considerations during the DW/ BI design phase

Author Image

Wayne Yaddow

May 20, 2020

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

Data Stewardship

Share0
Tweet0
Pin0

4 skill sets needed for a successful data steward

Author Image

George Firican

May 13, 2020

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

Uncategorized

Share0
Tweet0
Pin0

A dangerous data science invention

Author Image

Robert Vane

May 6, 2020

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

Data Quality

Share0
Tweet0
Pin0

What you need to know about regression testing on DW/ BI projects (part 2)

Author Image

Wayne Yaddow

April 29, 2020

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

Uncategorized

Share0
Tweet0
Pin0

Data protection during a pandemic

Author Image

Sowmya Kandregula

April 22, 2020

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