BI-DBA - Data Cookbook API Link to Reporting Tools

0 %

Status

Project is 0 % complete, starting on Mon 11/15/21 and ending on Mon 1/31/22.

New [New]

0% complete, updated on Mon 11/29/21 3:34 PM by Diane Kitson

Converted Project Request with Status of Requested to Project with Status of New and a Health of None.

Changed Portfolio(s) from "" to "ITS Projects".

Details

Dates
Mon 11/15/21 - Mon 1/31/22
Acct/Dept
ITS
Service
Project & Portfolio Management / Project Request
Type
Software / Hardware / Integration (connecting systems)
Health
None - No health has been set
Portfolio(s)
Classification
Transform
Requirements
Develop an API that calls specifications/definitions from Data Cookbook and displays them to the user in Tableau and Cognos.
Created
Mon 11/29/21 3:34 PM
Modified
Mon 11/29/21 3:42 PM

New Project Request

How can we help you?
Please provide details regarding your request? Do you have a solution defined or do you need support identifying a solution?
Based on the attached guidlines provided by Data Cookbook, we need to develop an API that calls specifications/definitions from Data Cookbook and displays them to the user in Tableau and Cognos.
Provide the background of this request.
What events or discussions preceded this request? Have there been previous efforts related to this request? Are you working with a vendor already? What are the benefits of this initiative?
Data Cookbook is our institutional data governance tool. It will be a single repository for business and technical definitions, report specifications and system integration specifications. Once populated, report specifications can be tied to the relevant report in that report's native environment using an API. The result is that the metadata for a report can be at the user's fingertips as they are selecting or running a report, greatly enhancing data literacy and ensuring consumers understand the report's output and intended use cases.
What is the desired completion date?
Please note that projects will be completed based on resource availability and prioritization.
01/31/2022
What are the factors driving the desired completion date?
Are there campus activities, legal requirements, dependent efforts or goals that are driving a date?
Executive leadership are driving towards data consistency and quality in institutional reporting. This project will greatly enhance the institution's ability to provide accurate and consistent context to that end.
Provide the executive leader(s) who will champion this initiative?
These individuals support the success of this effort, such as removing obstacles, sending strategic communication and promoting necessary policy changes.
Tricia Douthit
What team members have been identified to help drive this initiative?
Please note that involvement of department team members is critical to the success of this inititive.
Jackie Twehues, Tricia Douthit, Scott Harper
Any additional information about this request that you would like to include?
Who does this project help? What happens if this project is not completed?
The desired resulting functionality of the project is exemplified in Purdue's Data Digest Tableau dashboards. Selecting the Data Cookbook logo opens the report specification in a new browser window: https://www.purdue.edu/datadigest/

Description

Data Cookbook is our institutional data governance tool. It will be a single repository for business and technical definitions, report specifications and system integration specifications. Once populated, report specifications can be tied to the relevant report in that report's native environment using an API. The result is that the metadata for a report can be at the user's fingertips as they are selecting or running a report, greatly enhancing data literacy and ensuring consumers understand the report's output and intended use cases.

Systems Affected

  1. Cognos

    Also - Tableau

Manager

Alternate Manager(s)

Sponsor

Stakeholders (3)

JT
Jackie Twehues
Business Intelligence Manager
Consulted, Informed
Fri 11/5/21 11:34 AM
SH
Scott Harper
Data Scientist
Responsible
Fri 11/5/21 11:34 AM
Tricia Douthit
Tricia Douthit
Chief Data Officer
Consulted, Informed
Fri 11/5/21 11:34 AM