Archive for the ‘Announcement’ Category

Data Governance and Stewardship Materials

Tuesday, December 2nd, 2014

A major recent focus of our data governance and stewardship efforts has been the development of standards, best practices, and especially documentation — metadata about metadata. These materials are compiled into an annotated index of resources, Getting Started with Stanford Data Governance (metadata about metadata about metadata?).

This document is intended as a quick reference for users from a variety of perspectives, compiling information on themes including:

  • The SUDS Dictionary (the basics)
    • Goals and principles
    • Field inventory and usage
  • Running a Data Stewardship Group
  • Creating Content in the SUDS Dictionary
    • Developing definitions
    • Creating new term names
    • Statuses
    • Policy references
    • Reporting definitions
  • Using Collibra
  • Further Reading: Data Governance and Data Stewardship at Stanford
    • Data Governance and Data Stewardship at Stanford
    • The Stanford Data Governance Maturity Model
    • Miscellaneous

The document will be updated as materials evolve, with updates announced here (RSS this page to easily watch for updates) as well as circulated to core participants in Stanford’s DG/DS efforts.

Data dictionary migrated to Collibra

Wednesday, July 30th, 2014

As of June 3, our SUDS Data Dictionary has migrated from Confluence to Stanford’s new Collibra-based Data Governance Center.

collibra

Initial users are extremely enthusiastic about the extremely powerful content management capabilities that this tool provides.

User resources include the ‘SUDS-ZOO Dictionary‘ sandbox, where users can experiment freely with the tool, without editing live content, as well as documentation compiled in our Collibra Resources community.

Data Naming Standards

Wednesday, July 30th, 2014

A detailed set of naming standards for data elements in BICC-sponsored reporting projects has been approved by the data stewardship steering committee (SUDS-SC) and the BICC steering committee.

These standards support the use of official names that serve as unambiguous identifiers of specific entities and data elements. Official names are intended for broad audiences who may not be familiar with each element, and for contexts where precise identification and definition of elements is critical. For users who aren’t already familiar with an element, the official name should be informative about its nature.

The naming standards include both structural principles (eg, names should include standard identifiers of the element’s entity, attribute, and data class) and controlled vocabularies (eg, restricted sets of defined class words, approved abbreviations). Approved terms in the SUDS data dictionary should be fully compliant with these standards, and the use of reporting aliases should follow standard principles around usage and documentation.

Related materials:

User support for research query environment

Saturday, February 22nd, 2014

In response to user requests, a subgroup of SUDS-SPO has collaborated with the reporting environment development team to provide user support via mouseover text for folders in the OBI research ad hoc query environment. These provide key details about data definitions and usage. For example:

  • The Fact folder contains “Amounts (dollars, etc.) associated with SeRA transactions. Data are transaction total amounts which take any changes to date into consideration.”
  • The Sponsored Project Dimension folder contains “Current SPO number, title, and status of all sponsored proposals regardless of proposal status, plus additional attributes in subfolders. See ‘Dim – Time’ for start/end dates and ‘Fact – Research’ for amounts.”

Definitions for the entities underlying each folder are available in the data dictionary; test users also recommended directing new users to this central resource for orientation. If the audience for this reporting environment broadens beyond the current small number of high-level analysts, the group recommends including these entity definitions in mouseovers as well for quick reference.

Developing and approving definitions for all entities referenced in this reporting environment, and then for all associated data elements, is the initial scope of the SUDS-SPO group.

Data Governance & Stewardship

Sunday, February 2nd, 2014

Stanford’s Data Governance supports the Business Intelligence Comptency Center and the development of BI Dashboards. Many of Stanford’s current Data Governance activities fall under the umbrella of Stanford University Data Stewardship (SUDS), which focuses primarily on the development of definitions and other metadata for data elements used in BI reporting projects.

Stanford’s Data Governance Center, which houses the SUDS Data Dictionary and other metadata resources, can be found at https://dgcenter.stanford.edu/.

Current SUDS initiatives are coordinated by the data stewardship steering committee (SUDS-SC), which includes leadership from each SUDS group and other key university stakeholders. There are four active data stewardship groups at present:

  • SUDS-FIN (Finance)
    • Leadership: Matt Hoying (Director, IDMA)
    • Current activities primarily support the Evolve Financial Reporting program.
  • SUDS-HR (Human Resources)
    • Leadership: Rana Glasgal (Assistant VP, HR & Workforce Analytics)
    • Current activities are primarily focused on project-independent HR data issues.
  • SUDS-SPO (Research & Sponsored Projects)
    • Leadership: Kathleen Thompson (Director, Research Management Group), Mich Pane (Director/Pre-Award Operations, Office of Sponsored Research); John Markley (Senior Business Data Analyst, Office of Sponsored Research)
    • Current activities primarily support the research lifecycle reporting program.
  • SUDS-STU (Student)
    • Leadership: Paddy McGowan (Director of Institutional Research/Student Records, Institutional Research & Decision Support)
    • Current activities primarily support the Student Integrated Reporting & Information Systems project.

All groups welcome participants from all areas of the university. If you have any questions, would like to discuss ways that you or your team could become involved, would like to request access to any of our resources, or believe that you’ve identified a Data Governance, Data Quality or Data Stewardship opportunity at Stanford, please don’t hesitate to contact us.

Kathryn Flack Potts
Data Stewardship Coordinator
kfpotts@stanford.edu

Collibra Adoption, Coming Soon!

Monday, January 6th, 2014

We are delighted to announce that Stanford will soon begin using Collibra to manage our business glossary, metadata, and other data governance activities. This will be a significant upgrade from our current metadata repository, supporting our active ongoing metadata development activities and allowing rapid expansion into new areas. Stay tuned for further updates.

Faculty Map Update

Wednesday, December 18th, 2013

An updated version of Stanford’s “faculty map” (Stanford University Faculty and Related Staff Groupings) was released on December 18:

http://www.stanford.edu/dept/pres-provost/cgi-bin/dg/wordpress/wp-content/uploads/2014/02/StanfordFacultyGroupings-titles.pdf

Further information, and other versions of this document, are available at http://irds.stanford.edu/facmap/.

The faculty map illustrates relationships and properties of Stanford’s Professoriate Faculty, Academic Staff, and Other Teaching Staff, synthesizing information from PeopleSoft, Stanford’s Faculty Handbook, and other sources. The purpose of the faculty map is to facilitate a consistent understanding of these populations in communication and reporting within Stanford as well as externally.

The faculty map is intended as a reference for administrative use only. This document was developed by IR&DS in collaboration with Faculty Affairs, Office of the Provost, University Human Resources, the School of Medicine Office of Academic Affairs, and other Stanford stakeholders.

Updated Maturity Model (SUDS-SC Meeting 10/22/2013)

Tuesday, October 22nd, 2013

The data stewardship steering committee met on October 22 to update the Stanford Data Governance Maturity Model, reflecting developments and accomplishments over the past two years. The updated version can be found here: StanfordDataGovernanceMaturityModel-2013-overview.pdf

Degree and Student Map

Monday, September 9th, 2013

The definitions and other metadata collected by the student data stewardship (SUDS-STU) group during Summer 2013 are informative about relationships and reporting groupings among properties of Stanford’s degrees and student populations. The draft Degree and Student Map illustrates the kinds of information, beyond strictly definitions, that are produced as part of the data stewardship and metadata collection process. We welcome any feedback on these drafts, or suggestions for similar documentation in other subject areas.

SUDS-STU_degree-student_map.pdf

Open Invitation to the Weekly HR Metrics Data Definition Meeting

Friday, October 28th, 2011

The 31st of October will be our last “Ad-hoc” Data Definitions meeting.  We will be scheduling a reoccurring weekly meeting on the same day of the week and time each week.  In order to do this, please let Matt (hoying@stanford.edu) know what days of the week and times work best (from November 7, 2011 forward).  Additionally, we’ll be looking for a central meeting location, so please let Matt know where your office is and if you have a room that you would like to offer for this meeting.  We will try and get a conference call going at each meeting as well (although in-person attendance is encouraged).