Data Governance & Stewardship Flashcards
What are some of the questions you can ask when looking at data governance?
What is being collected
How is it being kept secure
Who can create / update / manage the data
What quality rules and standards need to be met
How available and usable the data is (are)
Processes for managing conflicting data flows
How should you design integration to ensure it does not impact Data governance?
Design interfaces to collect quality data
Transformation of data (when importing, ensure your csv file has been setup correctly)
How do Profiles and Permission Sets impact Data Governance?
Control the fields people can access
Control CRED access to objects
What are some De-Duplication options?
Matching rules
De-Duplication rules
Data.com
AppExchange tools (ex: Demand tools)
Lightning page - duplicate indicators
What options do you have for great quality data (as part of data governance)?
Validation Rules
Defaults
Actions with pre-defined field values
Field settings - unique/required
Page layouts and record types
Validation rules
Automation!
Data.com
What is part of data stewardship?
Monitoring data collection
Maintaining standards
Responding to questions about data
Resolving conflicting data problems
What are some stewardship tools?
Data Quality scoring
Data Quality dashboards
Good AppExchange analysers e.g. Field Trip
Chatter
Clinics
Good old-fashioned conversations
What 4 types of data are there?
Master data (Customers, Partners, Products)
Transactional data (Orders, contracts)
Reference Data (Currencies, Industry classifications)
Metadata (Login History)
Who could be data stewards?
End users in Sales, Support, Marketing who create the data
Admins, champions and Ops people who work with users to maintain the standards of the data
Admins and architects who monitor the flow of data and resolve / escalate issues
What does the data governance committee do?
Resolves escalated problems
Defines governance metrics
Manages integrity and quality of data
Who is the data governance council?
People who set policies and provide strategic direction
Who is the steering committee?
Business sponsors who campion policies and strategies
Oversees the success of the data governance office
Who is the data governance office
Works with the business to build implement governance solutions
Administers and reports on data governance activities
What is the main reason for having data governance?
It drives data quality
What is Data Governance?
It refers to the overall management of the availability, usability, integrity, and security of the data employed in an enterprise. A sound data governance program includes a governing body or council, a defined set of procedures, and a plan to execute those procedures
