Service Catalog

The primary method of a BICC/BI Community adoption is through the offering of services. If a service is offered, it then fosters the adoption of the Campus standards and utilization of the standard BI framework and toolsets. This results in overtime in the reduction of rogue data and reporting systems throughout campus and an overall reduction in IT expenditures.

Submit a Data Management & Analytics Request Form for any service requests.

Data Management Request:

Strategic Data Management
1. Purpose: Establishment of data into either the Operational Data Store or Data Warehouse with establishment of business process identification, data quality metrics, logical/physical design, metadata, and semantic layers
2. Timeline: Long
3. Responsible Party: UIT-BI Team
AdHoc Data Management
1. Purpose: Establishment of data into either the Operational Data Store or another temporary solution which then becomes an input to the Strategic BI Planning Committee
2. Timeline: Short
3. Responsible Party: IDMV/UIT-BI Team

Report Request:

The University has 2 primary reporting tools already purchased, Web Intelligence and Tableau. Web Intelligence serves the standard reporting and data science requirements while Tableau serves the dashboard and advanced graphical analysis requirements.

Web Intelligence Reporting:
1. Standard Report Addition
  1. Purpose: The addition of a new report into an established SAP Universe
  2. Timeline: Short
  3. Responsible Party: UIT-BI Team/IDMV
  4. Prerequisite: An established SAP Universe

Web Intelligence Universe:
1. New Universe Creation
  1. Purpose: The creation of a new self-service SAP Universe
  2. Timeline: Long
  3. Responsible Party: UIT-BI Team
  4. Prerequisite: An established data source in the EDW

Tableau Reporting:
1. New Environment Setup
  1. Purpose: Creation of a new Tableau site
  2. Timeline: Short
  3. Responsible Party: IDMV
  4. Prerequisite: The requesting group must be part of the BI Community
2. New Dashboard Request
  1. Purpose: Creation of a new dashboard in an established Tableau Site
  2. Timeline: Short
  3. Responsible Party: IDMV
  4. Prerequisite: A Tableau site must exist and the data must exist in the EDW, ODS, or another temporary data store

Official Data Requests:
1. Request for data that goes external of the University
  1. Purpose: Federal, state, or other public reporting.
    1. http://www.obia.utah.edu/util/request.php
  2. Timeline: Short
  3. Responsible Party: OBIA
  4. Prerequisite: The data must be available

Analysis Request:

Descriptive Analysis
1. (The past) (lag information)
  1. Purpose: To understand a historical data set and to summarize and describe different aspects of the data
  2. Timeline: Short
  3. Responsible Party: OBIA
  4. Prerequisite: The data must be available

Predictive Analysis
1. (Understand the Future) (lead information)
  1. Purpose: To predict what “may” happen – estimates the likelihood of future outcomes based on current data
  2. Timeline: Short/Moderate
  3. Responsible Party: OBIA
  4. Prerequisite: A sufficient historical data set must exist and the business must have a thorough understanding of the current inputs and what possible changes they are considering.

Training Request:

Tableau Training
1. Tableau Training Request
  1. Purpose: Training offered in the usage of Tableau Desktop
  2. Timeline: Short
  3. Responsible Party: IDMV
  4. Prerequisite: A Tableau desktop license must be purchased by the group and a Tableau site created

Web Intelligence Training
1. Web Intelligence Training Request
  1. Purpose: Training offered in the usage of Web Intelligence
  2. Timeline: Short
  3. Responsible Party: Embedded BI/UIT-BI/IDMV
  4. Prerequisite: A user of one of the defined BI Universes