In the 6 weeks of my course, Data Quality Improvement at BCIT, I try to impart to them an understanding of how to ‘discover’ the instances of poor data quality in the data sets they are responsible for so that they can begin to help
Ever since the passage of the Patient Protection and Affordable Act (PPACA) in 2012, all healthcare providers in the US have been mandated to store patient data in the form of electronic medical records (EMRs). EMRs do away with clunky, paper-based records of patient medical
So far I’ve provided an overview on 6 different maturity models which I will post links below in case you’d like to learn more about them. Maturity models can provide a road map to follow in order to advance from one maturity stage/ level to
In the domain of agile and data warehouse (DW) project testing, a DW Master Test Plan (MTP) is often considered an out-dated practice, even unnecessary. With this viewpoint, project teams may overlook long-standing motives and rationale for a project-wide DW MTP. A DW “Master Test
Digital Transformation can mean a lot of different things to different people. But for everyone it means dealing with more data than ever before. Industry 4.0, Cloud, Big Data, Robotics, Artificial Intelligence, Machine Learning, blockchain, IoT (internet of things) and similar technological advancements are changing
In the first evening of my 6-week course on Data Quality Improvement I try to communicate the high cost of poor data quality (PDQ) to my students. Their eyes are usually starting to close while I cover the course administrative details as for most of
An introduction to DW/ BI data quality risk assessmentsData warehouse and business intelligence (DW/ BI) projects are showered with risks – from data quality in the warehouse to analytic values in BI reports. If not addressed properly, data quality risks can bring entire projects to
I’m not a fan of meetings in general and data governance requires quite a few and they are always packed. To be as efficient as possible, you need an agenda, for the attendees to come prepared and for the chair to keep the meeting on
The principles of data quality management are a set of fundamental beliefs, standards, rules and values that are accepted as true and can be used as a foundation for guiding an organization’s data quality management. They have been adapted from ISO 9000 principles of quality
Ad hoc means “for this” in Latin and refers to something done for a specific purpose. Ad hoc reporting, then, is the process of creating reports for a specific occasion (as opposed to for general use). In business intelligence, ad hoc reporting supplements canned reports