Archive for the ‘BI’ Category

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.

BICC Monthly – DG in 2012 Presentation, 2/13/2012

Sunday, February 12th, 2012

Presentation given on 2/13/2012 to the Stanford BICC: DG at Stanford in 2012

The Data Governance Organization

Wednesday, January 25th, 2012

A key aspect of data governance is the formalization of roles and responsibilities.  Although it may not be feasible to move directly to the goal state in the near term, having a well defined target and agreement upon this strategic goal will help align stakeholders and assure that tactical activities have a consistent direction.  For this reason, we designed our vision of the Stanford Data Governance Organization.  Note that the core councils (Data Governance Council and Data Stewardship Council) are compact and separate from the more operational Data Stewardship Committees and Working Committees.  Additionally, to more clearly manage the adoption of centralized policies throughout the schools and functions, the Data Policy Review Board members are asked to become gate keepers for the approval of data policies within their portion of the organization.

Please email Matt with any questions or comments.

Stanford Data Governance Organization

BICC Monthly – Developing Business Metadata Presentation, 11/21/2011

Monday, November 21st, 2011

Presentation #3: Developing Business Metadata Presentation

BICC Monthly – DG Maturity Model Presentation, 10/17/2011

Monday, October 17th, 2011

DG Presentation: The Stanford DG Maturity Model

BICC Monthly – DG Maturity Model Newsletter, 10/17/2011

Monday, October 17th, 2011

Newsletter 2: The Stanford DG Maturity Model

BICC Monthly – DG Newsletter, 9/19/2011

Monday, September 19th, 2011

DG Newsletter 1: Data Governance Overview

BICC Monthly – DG Presentation, 9/19/2011

Friday, September 9th, 2011

Presentation: Data Governance at Stanford