Data

Collection by George F

81 
Pins

A board on data management, data quality, data governance, data analytics, business intelligence and more

George F
Data Stewardship
Data quality
Business Intelligence
Data governance
Other Pins

Data Stewardship

Data stewardship is the discipline for defining, implementing, and enforcing the accountability and responsibility of the organization’s data stakeholders.

What is Data Stewardship? #datastewardship

WHAT IS DATA STEWARDSHIP? // Data stewardship is the discipline for defining, implementing, and enforcing the accountability and responsibility of the organi...

5 best practices for managing reference data

5 best practices for managing reference data | LightsOnData

Managing reference data poorly can have a profound impact on your operations as well as business intelligence and analytical outcomes. Here are my 5 best practices for managing reference data: 1. Formalize reference data management (RDM) Most often than not, reference data is not maintained if there is no accountability and ownership determined. Usually the […]

3 types of data quality projects a data steward should work on

3 types of data quality projects a data steward should work on | LightsOnData

The three data quality projects every one needs to do are: data quality assessment project, data cleansing project, and bad data prevention project.

Understanding the different types of a data steward

Understanding the different types of a data steward | LightsOnData

There are 4 different types of data stewards for which your own organization might have different titles or variants for: data object data steward, business data steward, process data steward, and system data steward.

The 4 main roles of metadata

The 4 main roles of metadata | LightsOnData

I love metadata because of the benefits it offers. In fact, I never “metadata” \met a data\ I did not find useful (geeky joke, I know). If you don’t have a metadata management program or initiative in place, there are a lot of reasons why you should consider investing into it. In fact, the following […]

Data stewardship definition

What is data stewardship? | LightsOnData

What is Data Stewardship? Data Stewardship is the discipline for defining, implementing, and enforcing the accountability and responsibility of the organization's data stakeholders.

Data quality

Data Quality Myth #1: Data Cleansing #datacleansing

A lot of people think that data quality is all about cleansing the data. This is a myth! To checkout Dataedo: * https://dataedo.com/?utm_source=youtube&utm_c...

How to use the barrier analysis for improved data quality | LightsOnData

Fixing data quality issues is only part of the solution. In order for these not to reoccur, one needs to identify the root cause and prevent from further creating poor data quality. As we know, for every effect there is a cause, and that’s the basis of the root cause analysis. The chain of relationship […]

Sample DW/ BI verification framework and sample verifications provided

3 key data integrity testing strategies for DW/ BI systems | LightsOnData

Data warehousing and business intelligence users assume, and need, trustworthy data.In the Gartner Group’s Online IT Glossary, data integrity and data integrity testing are defined as follows:Data Integrity: the quality of the data residing in data repositories and database objects. The measurement which users consider when analyzing the value and reliability of the data.Data Integrity […]

Here are the 9 questions to ask the data provider to help you better assess the data veracity.

9 questions to ask for data veracity assessment | LightsOnData

Data veracity helps us better understand the risks associated with analysis and business decisions based on a particular big data set.

Calculate the cost of poor data quality and why management does not get it...

How much does poor data quality cost your organization? | LightsOnData

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 their team to ‘monetize’ the effects of that poor data […]

An interesting reason as to why executives underestimate the poor data quality costs.

Do executives underestimate the costs of poor data quality? | LightsOnData

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 them it has already been a hard week of working […]

How to identify and reduce DW/ BI data quality risks. You can find a free, but comprehensive risks and how to mitigate them.

How to identify and reduce DW/ BI data quality risks | LightsOnData

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 a halt, leaving planners scrambling for cover, sponsors looking for […]

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.

7 principles of data quality management | LightsOnData

The set of fundamental beliefs, standards, rules and values to be used as a foundation for guiding an organization's data quality management program.

Data is an enterprise asset, enabling the organization to make informed decisions. In order to secure data’s position as a highly valuable asset, the organization needs to implement a data qu…

The trifecta of the best data quality management | LightsOnData

Data is an enterprise asset, enabling the organization to make informed decisions. In order to secure data’s position as a highly valuable asset, the organization needs to implement a data quality management program. This will achieve and sustain a high level of quality for the data the enterprise is generating and consuming. The following is […]

Estimating the cost of poor data quality in 5 steps

Estimating the cost of poor data quality in 5 steps | LightsOnData

According to the IBM Big Data & Analytics Hub, poor data costs the US economy $3.1 trillion every year. Ovum Research reported that poor data can cost businesses at least 30% of revenues. These numbers are staggering and in my opinion, they should be enough to motivate any organization to start investing in data governance, […]

7 mistakes to avoid when building a data quality program

7 mistakes to avoid when building a data quality program | LightsOnData

A data quality program is often viewed as an organizational necessity. In order to be a successful one, the following mistakes need to be avoided.

How to uncover the root cause with the 5 why?s technique.

Data quality root cause analysis - 5 whys | LightsOnData

Learn all about the 5 why Iterative interrogative technique to determine the root cause of a particular issue, such as a data quality issue.

What is the fishbone diagram method and how you can use it to uncover the root cause of your data quality issues. FREE template provided

How to use the fishbone diagram to determine data quality root causes | LightsOnData

The fishbone diagram is a powerful tool used to identify the possible root causes for your data quality issues. Here's all you need to know on how to use it

Here's a free data profiling solution you already have access to.

The quick data profiling solution you didn't know you had access to | LightsOnData

Data profiling brings a lot of benefits and provides a first step into better understanding your data structure and quality. There are a few dedicated tools, but they have associated costs. What if I told you that you might already have access to a data profiling solution? Well, if you are using Excel 2010 and […]

If your organisation is overwhelmed by poor quality data, here's a great technique that will help you prioritize and decide what to tackle first.  It's very easy (no fancy technical skills required) and very accessible (no fancy technology required - you can simply use excel and there's even a link to a video to explain how to set up the workbook) - so it's very accessible to non-profits that need to keep a close eye on their budgets.

How learning to use Pareto analysis can improve your data quality | LightsOnData

Pareto analysis is a technique to help identify the top portion of causes that need to be addressed in order to resolve the majority portion of the problem.

4 myths about Data Quality everyone thinks are true

4 myths about Data Quality everyone thinks are true | LightsOnData

Myth #1: It’s all about fixing the data Data cleansing is a very important aspect of improving data quality, but it’s not the only one. In order to have a sustainable data quality program you can’t just fix the data. You need to understand what needs to be fixed and why; analyze the root cause […]

The single best strategy for improving your mailing addresses

The single best strategy for improving your mailing addresses | LightsOnData

Having accurate and current addresses for your constituents is one of the most important thing in your database. You’re using this information to engage with them, solicit them, inform them, communicate with them, and learn more about them in order to develop and evolve a two-way relationship. So why don’t we then have good addresses? […]

Data Quality Issue Log

The ultimate guide to a Data Quality issues log | LightsOnData

If you’ve already started or planning to start a data governance program to support your data quality improvement goals, you need a structured way of tracking your data quality issues and their status. There are different ways of doing this, of course, with either the help of dedicated data quality tools, or incident management and […]

Business Intelligence

6 must-have goals of your Business Intelligence program | LightsOnData

To get a successful business intelligence (BI) program started, I believe it should aim to address and abide by the following 6 goals: 1. Information must be easily accessible End users must be able to access information in a timely fashion so that their timely decision making is not compromised by this. Ease of accessibility […]

5 key stakeholders for successful report/ dashboard development | LightsOnData

One of the main functions of the Business Intelligence (BI) team is to provide the right information to the right people at the right time. 99% of the time, this comes in the form of well-designed, structured, and built reports and/or dashboards. There are a lot of challenges in getting that deliverable right in the […]

Good guide to follow and learn from

What no one tells you about developing a Master Test Plan for your DW/ BI project | LightsOnData

A Master Test Plan provides the plan of action and processes designed to accomplish quality assurance from beginning to end of a DW/BI development lifecycle

Every data conveys a story. Do you want to learn how to tell yours? Then please read the following article on the anatomy of a data story.

The anatomy of a data story | LightsOnData

Stories are how people make sense of the world, so it follows that they’d also be our way of making sense of data. As much as technology can facilitate data storytelling, it cannot (yet) perform the pivotal step of placing data into the human context. That’s our job, and we’re really good at it. We’re […]

10 components of the Business Intelligence landscape

10 components of the Business Intelligence landscape | LightsOnData

All business intelligence landscapes have the same format at a macro level. It's usually comprised of the following 5 pillars and 5 foundation blocks:

Why report templates are important

Why you should focus on creating a report template | LightsOnData

The 3 most important reasons why a template is one of the most important factors for creating a successful set of reports.

3 principles on how to use color to draw attention to data visualizations

3 principles on how to use color to draw attention to data visualizations | LightsOnData

In all data visualizations you want to have the user quickly identify the most important information. Draw attention through color, by applying these principles.

White paper on best practices for powerful dashboards

White paper on best practices for powerful dashboards | LightsOnData

In any domain in any organization, great dashboards are valuable not only because they can sum up important information and offer a single view of data, but also because they are simple to use and offer a quick, unambiguous way to draw meaningful conclusions from data. Developing and designing such powerful dashboards does not come […]

To the best of my knowledge, there are no dedicated tools for creating and managing an inventory of reports/dashboards. At best these are done at the report/dashboard server level where you can aud…

Tools for managing your report inventory (Part 1 of 2) | LightsOnData

To the best of my knowledge, there are no dedicated tools for creating and managing an inventory of reports/dashboards. At best these are done at the report/dashboard server level where you can audit user access, and read/write stats for the specific reports on that server. What happens if you have different environments and platforms for […]

5 graphs you should always use

5 graphs you should always use | LightsOnData

The following are some of my favorite types of graphs and what they are best used for.

These are the 3 main outcomes of analytics and business intelligence

3 main outcomes of analytics and business intelligence | LightsOnData

The BI and Analytics umbrella produces and harnesses information and knowledge to enable an organization get more insight, hindsight, and foresight.

Here's a template for a report template.

How to empower your developer with a report template | LightsOnData

Provide your developer with this report template and empower them to give your stakeholders fast and accessible reports with a common look and feel.

Tools for managing your report inventory (Part 2 of 2)

Tools for managing your report inventory (Part 2 of 2) | LightsOnData

Part 2: This is the second and final article on tools for managing your report inventory. For the first article, please read “Tools for managing your report inventory (Part 1 of 2)“. 4. Data governance tool Dedicated data governance tools can track information about reports as individual elements in a data dictionary or business glossary, but these […]

Data governance

5 main data roles found in data governance programs | LightsOnData

I’ve previously wrote about more obscure, though intriguing, data roles I’ve encountered, but I’ve been asked several times to go over the main data roles found in a data governance program. I’ll skip the sometimes dreaded introduction and get straight to it. The 5 main data roles found in data governance programs are: 1. Data […]

a description and overview into what a data governance council/ committee/ group is

What is a Data Governance Council? #datagovernance

WHAT IS A DATA GOVERNANCE COUNCIL // A data governance council is more than a governing body. Checkout this video to find out more, as well as the accompanyi...

5 Reference Data Characteristics #referencedata

5 REFERENCE DATA CHARACTERISTICS // Reference data is important data to manage and in order to manage it, you need to understand it. So here are its 5 main c...

Stephen King's 5 rules for data governance practitioners (kind of) | LightsOnData

Most of us know Stephen King as a great writer and a great storyteller. His books have been translated into 33 different languages, published in over 35 different countries. There are over 350 million copies of his novels in publication, with some of his most notable books being Carrie, The Shining, The Stand, The Green […]

Free TOR template for your data governance committee/ council/ group

The ultimate Terms of Reference template for data governance council

Any working group, steering committee, strategy setting council and so on, will be more successful if it understands its purpose, responsibilities, and overall expectations. Outlining all these expectations will ensure a higher commitment and engagement rate from its members. This is also the case with a Data Governance Council (or however else you would like […]

The latest overview of yet another data governance maturity model

Data governance maturity models - Kalido | LightsOnData

So far I’ve provided an overview on 6 different data governance 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 another. Today I’ll provide an introduction into the […]

10 pieces of advice over 10 days

Understand Main Pain Points - MacGyver of Data Governance Tip #1 #datagovernance

Here's my first video of the 10 day challenge: post a video each day with one advice on how YOU can become the MacGyver of Data Governance. *****************...

How to survive the data revolution | LightsOnData

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 the very nature of commerce across every business sector in […]

5 topics to cover in data governance council meetings | LightsOnData

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 schedule and within its scope. There are also a lot […]

To get a data governance program started on the right path or have a course correction for one which is already underway, I believe the following 10 guiding principles should be followed.

10 Guiding Principles for Successful Data Governance #datagovernance

10 GUIDING PRINCIPLES FOR SUCCESSFUL DATA GOVERNANCE // To get a data governance program started on the right path or have a course correction for one which ...

14 must-have data governance artifacts

14 must have data governance artifacts | LightsOnData

I know it’s not easy to put the necessary foundation in place for a successful data governance program, not to even mention the data governance artifacts / deliverables. On the foundation piece, I’m referring to the: initial business case the data governance operational framework maturity model the data governance council guiding principles resources, etc. Let’s […]

3 best ways to secure funding for your data governance program

3 proven ways to secure funding for your data governance program | LightsOnData

Here are 3 proven ways to secure funding for your data governance program

Data governance council – what is it and why do you need one?

Data governance council - what is it and why do you need one? | LightsOnData

A data governance council is a governing body responsible for the strategic guidance of the data governance program, prioritization for the data governance projects and initiatives, approval of organization-wide data policies and standards, as well as enabling ongoing support, understanding and awareness of the data governance program.

Here are the most common drivers for starting a data governance program.

3 most common data governance drivers | LightsOnData

These are the 3 most common drivers for starting a data governance program in an organization.

5 data roles you might not know about (but should)

5 data roles you might not know about (but should) | LightsOnData

Here are 5 interesting data governance roles which I find useful enough to share as they might fit within your own unique program.

The 3 communication steps for any successful data governance and data management program

3 communication steps for successful data governance | LightsOnData

3 communicaiton steps for success in data governance programs.

Reference data. What is it?

Reference data needs a standard definition - here is one | LightsOnData

A set of permissible values associated with a distinct definition, used within a system or shared between multiple systems in an organization, domain or industry, which provides a standardized semantic to further categorize a data record.

How to create an inventory of your data sources - FREE template

How to create an inventory of your data sources | LightsOnData

A data sources inventory is meant to record basic information about the different systems across and/or outside your ecosystem from which you are capturing, producing, acquiring or procuring data.

How to create a data governance scorecard – FREE template

How to create a data governance scorecard - Free template | LightsOnData

A data governance scorecard is a collection of agreed-upon baseline and metrics reported on a regular basis to the data governance program sponsor and stakeholders.

Data governance maturity models: IBM

IBM data governance maturity model | LightsOnData

One way of measuring the effectiveness of your data governance program is to assess it against an existing maturity model. This can help by indicating: where you are with the data governance program how you are progressing or not; and what are some of the steps you need to take in order to evolve your […]

10 guiding priciples every data governance program should follow

10 guiding principles every data governance program should follow | LightsOnData

Follow these 10 guiding principles to get a data governance program started on the right path or have a course correction for one which is already underway.

Data governance maturity models: Stanford

Stanford data governance maturity model | LightsOnData

The Stanford maturity model considers six components subidivded by three dimensions, all across 5 maturity levels. Here's how you can use it.

Data governance operating models exposed

Data governance operating models exposed | LightsOnData

Deciding what the operating model your organization will adopt is part of the initial steps in setting up your data governance program. Why? The most important reasons I see are the fact that: It outlines how your program will operate Sets the expectations of escalation and decision making as well as program oversight Provides the […]

One of the challenges for starting a data governance program is a lack of funding. Luckily for us, there are 3 proven ways to secure funding for a data governance program.

3 Proven Ways to Secure Funding for a Data Governance Program #datagovernance

One of the challenges for starting a data governance program is a lack of funding. Luckily for us, there are 3 proven ways to secure funding for a data gover...

Data governance maturity models: DataFlux

DataFlux data governance maturity models | LightsOnData

DataFlux maturity model was based on their ten years of experience in developing the core components of data governance technology. The model has 4 levels of maturity with the following characteristics

Data governance maturity models: Gartner

Gartner data governance maturity model | LightsOnData

The Gartner maturity model looks at enterprise information management (EIM) as a whole. The model has 6 phases of maturity, each with its own characteristics and action items

Adapting data governance to big data in 4 areas

Adapting data governance to big data in 4 areas | LightsOnData

It’s generally accepted that any organization working with data needs to adopt data governance. Readily available frameworks, tools, and services can be adapted to the requirements and environment of your organization, yet when it comes to big data governance, the options are a bit more complex. Organizations must adapt to big data in four important […]

4 crucial Terms Of Reference components for successful data governance council meetings

4 crucial TOR components for successful council meetings | LightsOnData

In order to have a successful and fully functioning data governance council/ committee, you need to establish a Terms of Reference (TOR). What is this TOR? It’s a document which outlines the purpose, structure, and roles and sets certain expectations for the members. The details listed in the TOR are are important as the selection of […]

The benefits and risks of standard data models

The benefits and risks of standard data models | LightsOnData

Templates for data models can be found for different industries, such as education and learning, healthcare, energy and utilities, banking and financial markets, insurance, telecommunications, retail, aviation, and more others. As a quick FYI, these are often put together by standards bodies or vendors of different systems and databases. They can also go by different […]

11 essential elements of a communication plan

11 essential elements of a communication plan | LightsOnData

I’m a strong believer that communication is one of the vital ingredients for any successful implementation and deployment of a Business Intelligence, Data Governance or overall Data Management program. Your Business Intelligence, Data Governance or Data Management strategy should have a communication plan as one of its deliverables. If you haven’t done one already or […]

Data governance maturity models: Oracle

Oracle data governance maturity model | LightsOnData

Maturity models contain a set of levels or phases, each with their own characteristics, usually about the status of processes and structures, people and culture, tools technology. As an organization advances in a level/ phase, it is considered more mature in its treatment, usage, and understanding towards data and information. Organizations often use maturity models as a […]

These are the 3 most common drivers for starting a data governance program in an organization.

3 Main Drivers for Data Governance #datagovernance

3 MAIN DRIVERS FOR DATA GOVERNANCE // These are the 3 most common drivers for starting a data governance program in an organization. Read our accompanying ar...

Learn how to create a MDM change request

Learn how to create a MDM change request | LightsOnData

Managing and securing your organization’s master data is crucial for supporting any organizational goals which rely on data – so all of them!!! It’s also important for today’s business to work with their master data in an accurate, efficient, and well understood way. As such, the process for managing change requests to either add, remove, […]

Get the scoop on data classification and GDPR before you're too late

Get the scoop on data classification and GDPR before you're too late | LightsOnData

Data classification is an important foundation needed for auditing and reviewing your data as well as establishing an organization wide awareness of GDPR implications and mitigation. Data and information can be classified into 3 main groups. Here are their definitions, examples, and considerations.

Other Pins

What is Reference Data? #referencedata

WHAT IS REFERENCE DATA? // This is a high level overview answer to "What is reference data?" and why you should care about reference data. To checkout Dataed...

Data Quality Myth #1: Data Cleansing #datacleansing

A lot of people think that data quality is all about cleansing the data. This is a myth! To checkout Dataedo: * https://dataedo.com/?utm_source=youtube&utm_c...

3 Best Practices for Managing Reference Data #referencedata

3 BEST PRACTICES FOR MANAGING REFERENCE DATA // Managing reference data poorly can have a profound impact on your operations as well as business intelligence...

6 must-have goals of your Business Intelligence program | LightsOnData

To get a successful business intelligence (BI) program started, I believe it should aim to address and abide by the following 6 goals: 1. Information must be easily accessible End users must be able to access information in a timely fashion so that their timely decision making is not compromised by this. Ease of accessibility […]

5 main data roles found in data governance programs | LightsOnData

I’ve previously wrote about more obscure, though intriguing, data roles I’ve encountered, but I’ve been asked several times to go over the main data roles found in a data governance program. I’ll skip the sometimes dreaded introduction and get straight to it. The 5 main data roles found in data governance programs are: 1. Data […]

a description and overview into what a data governance council/ committee/ group is

What is a Data Governance Council? #datagovernance

WHAT IS A DATA GOVERNANCE COUNCIL // A data governance council is more than a governing body. Checkout this video to find out more, as well as the accompanyi...

5 Reference Data Characteristics #referencedata

5 REFERENCE DATA CHARACTERISTICS // Reference data is important data to manage and in order to manage it, you need to understand it. So here are its 5 main c...

Stephen King's 5 rules for data governance practitioners (kind of) | LightsOnData

Most of us know Stephen King as a great writer and a great storyteller. His books have been translated into 33 different languages, published in over 35 different countries. There are over 350 million copies of his novels in publication, with some of his most notable books being Carrie, The Shining, The Stand, The Green […]

How to use the barrier analysis for improved data quality | LightsOnData

Fixing data quality issues is only part of the solution. In order for these not to reoccur, one needs to identify the root cause and prevent from further creating poor data quality. As we know, for every effect there is a cause, and that’s the basis of the root cause analysis. The chain of relationship […]

5 key stakeholders for successful report/ dashboard development | LightsOnData

One of the main functions of the Business Intelligence (BI) team is to provide the right information to the right people at the right time. 99% of the time, this comes in the form of well-designed, structured, and built reports and/or dashboards. There are a lot of challenges in getting that deliverable right in the […]

Sample DW/ BI verification framework and sample verifications provided

3 key data integrity testing strategies for DW/ BI systems | LightsOnData

Data warehousing and business intelligence users assume, and need, trustworthy data.In the Gartner Group’s Online IT Glossary, data integrity and data integrity testing are defined as follows:Data Integrity: the quality of the data residing in data repositories and database objects. The measurement which users consider when analyzing the value and reliability of the data.Data Integrity […]

Free TOR template for your data governance committee/ council/ group

The ultimate Terms of Reference template for data governance council

Any working group, steering committee, strategy setting council and so on, will be more successful if it understands its purpose, responsibilities, and overall expectations. Outlining all these expectations will ensure a higher commitment and engagement rate from its members. This is also the case with a Data Governance Council (or however else you would like […]

Here are the 9 questions to ask the data provider to help you better assess the data veracity.

9 questions to ask for data veracity assessment | LightsOnData

Data veracity helps us better understand the risks associated with analysis and business decisions based on a particular big data set.

The latest overview of yet another data governance maturity model

Data governance maturity models - Kalido | LightsOnData

So far I’ve provided an overview on 6 different data governance 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 another. Today I’ll provide an introduction into the […]

Calculate the cost of poor data quality and why management does not get it...

How much does poor data quality cost your organization? | LightsOnData

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 their team to ‘monetize’ the effects of that poor data […]

Practical takeaways in video format for your data governance and data management questions and challenges.

LightsOnData YouTube Channel

The LightsOnData channel is all about providing informative videos to best address your data governance and data management questions and challenges. Here yo...

Pinterest