Stanford’s Data Governance Program Corrie Potter, Associate

Stanford’s Data Governance Program Corrie Potter, Associate Vice Provost and Director, Institutional Research & Decision Support Kathleen Warmoth, Data Governance Manager 1

Outline Review of Data Governance Program Case Studies Land, Buildings & Real Estate School of Medicine Graduate School of Business

“Data Governance is formalizing behavior around the definition, production and usage of data to manage risk and improve the quality and usability of selected data” (R. Seiner, Non-Invasive Data Governance)

Original Goals Support central BI projects Build consensus on data definitions and metadata Resolve data issues identified by various project teams Establish best practices, data governance policies and structure

Best Practices, Standards and DG Structure Formalizing behavior Naming standards Class words Best practice on writing a definition Stanford University Data Stewardship Groups (SUDS) roles and responsibilities

Current Goals Improve the effectiveness and usefulness of the university data assets Know what data represent Know where data are stored Know how data should be used

Data Governance Program: Know what data represent Business terms Aliases Identified business owners and audit trail Reference data

Data Governance Program: Know where data are stored Reporting index Documentation of data sources Current database table column business term report Legacy database table column business term Derivation High-level Traceability

Data Governance Program: Know how data should be used Business rules One page infographics on relationships between entities Appropriate usage

Case Studies Land, Buildings & Real Estate School of Medicine Graduate School of Business 10

1 Data Stewardship Activity: LBRE Project: Implement Data Governance around space data tables in Archibus Goals Starting with the “building table” elements create approved business terms and document association with Archibus element and legacy iSpace element Identify areas for future LBRE infographic projects

Data Stewardship Activity: LBRE 12

3 Data Stewardship Activity: LBRE

4 Data Stewardship Activity: School of Medicine Project: Incorporate naming standards and definitions for reporting elements in Workforce Analytics Tableau dashboards Goals Apply naming standards and create definitions on SoM HR specific business terms Build a reporting index for Workforce Analytics dashboards

5 Data Stewardship Activity: School of Medicine

6 Data Stewardship Activity: School of Medicine

7 Data Stewardship Activity: Graduate School of Business Project: Naming standards and definitions for reporting elements in Tableau Faculty and Dean dashboards Goals: Apply naming standards and create definitions on GSB specific business terms Document Salesforce object, label and API name Build a reporting index for GSB Faculty and Dean Tableau dashboards

8 Data Stewardship Activity: Graduate School of Business

9 Data Stewardship Activity: Graduate School of Business

Stakeholder Feedback

Call to Action

2 Contact Information Data Governance Manager: Kathleen Warmoth [email protected] 650-723-2822 Business Sponsor: Corrie Potter [email protected] 650-721-2389 Technical Sponsor: Vijay Gandra [email protected] 650-725-4427 Data Governance Website: [email protected] Data Governance Center: https://dgcenter.stanford.edu Slack Space: Data Governance @ Stanford Channels: #data stewardship #dgc

3

4 You can mouse over any term to see its definition

5

6 DG @ Stanford: Why do we need it Operational Perspective Reduce reliance on individuals’ knowledge Improves rate of business operations and analysis Improves quality of business operations and analysis Reduces change management efforts and encourages adoption Compliance with internal (Stanford) and external (Government, Partner, and Legal) policy Development Perspective Increase rate of IT Development Increase quality of IT Development Reduce reliance on individuals’ knowledge Reduce risk of unintended downstream impact

7 DG @ Stanford: Structure Executive Leadership Business Intelligence Competency Center Steering Committee (BICC SC) Strategic Data Governance Committee Development & Incorporating Definitions & Metadat Stanford University Data Stewardship Groups (SUDS)

8 Metadata Management Business Stewardship Groups Data Access Use Reference and Master Data Management Data y Qualit e em Manag nt MDM ULTIMATE OUTCOME SU Data Governance Reference Metadata Program Data & Manageme nt Administrative Systems Data Access and Use Data Quality Management DG@ Stanford: Structure