Identify the client’s use of singular data marts to consolidate content about a single area of their business or departmental function. Ask and rate the following questions
SOURCE TYPE
CHARACTERISTIC
QUESTIONS
Data Silos
Collaboration
Does the organization have many cross-functional teams?
Do departments and functions in the organization share data?
How is it shared? What is the most common method?
Is the shared data updated regularly by a provider? How often?
Is the shared data updated by the recipient? Are those updates shared?
Ownership
How is data ownership determined in the organization?
Am I allowed to extract, store, manipulate and build reports on data in my area?
How is data controlled by its owner?
Does the owner notify others when data is updated? How often?
Are there areas within the organization that doesn’t share data?
Processes
How do I gain access to owned data?
Once I gain access, what rights do I have?
How is the data I’m provided maintained? Who maintains it?
Does requested data now flow to me automatically? How often
Discovery
Can you identify an area whose data is tightly controlled?
Is there an area within an enterprise whose data is inaccessible?
How difficult is it to merge data from different areas of the enterprise?
How many different organizational areas have customer data?
How many different organizational areas have product data?
How many different organizational areas have pricing data?
Give the client a definition of a data silo, which areas in the organization does this explanation sound like?
Data Trust
Data Source Status
What are the primary sources of data within the organization?
Are the data sources reliable and reputable?
How is data collected, and is there a standardized process for data collection?
Are there any concerns or issues related to the accuracy or reliability of data sources?
Data Quality Status
Is there a data quality assurance process in place?
How is data quality measured and assessed?
Are there any known data quality issues or challenges?
Are there procedures for addressing and resolving data quality issues?
Data Governance Status
Is there a defined data governance framework in place?
Are there clear roles and responsibilities for data management and oversight?
Is there a data stewardship program to ensure data integrity and compliance?
Are there data access and security policies in place to protect sensitive data?
Data Transparency Status
Is data transparently shared across departments and teams?
Are there mechanisms in place to track data lineage and provenance?
Are data definitions and metadata documented and accessible?
Are there procedures for resolving discrepancies or conflicts in data interpretation?
Data Privacy
Are there policies and procedures in place to protect data privacy?
Is data access restricted to authorized personnel?
Are there measures to safeguard sensitive or confidential data?
Is there awareness and compliance with relevant data protection regulations?
Data Quality
Are there processes in place to validate and verify data accuracy?
Are there methods for cross-referencing or cross-validating data from different sources?
Are there procedures for identifying and addressing data anomalies or outliers?
Are data validation results documented and communicated effectively?