Policies and procedures w88 slot
The goal of institutional reporting is to deliver accurate and engaging reports to consumers of university data at all levels. These users can range from executives, faculty and staff, students and external entities. Through a combination of technology, training and user interaction, it is our goal to usher in a new era of data-driven decision making in areas that may have previously been neglected at the University.
This document w88 slot provide a summary of our plans in the following areas:
- Current technology and tools
- Planned technology change.
- Source systems
- Development life cycle
- w88 slot request
- w88 slot design
- Training
The Office of Decision Support (ODS) w88 slot also work closely with the University Data Governance Committee to update this document where necessary to reflect the needs of University data owners and stewards.
Pre-Decision Support reporting tools
Initial review of the w88 slot authoring tools used from the offices of Institutional Analysis, Budget and Scheduling Services indicate the following applications in use:
- Power BI (Professional)
- Workday
- Ad Astra (v, 7.5.17.51)
- Microsoft Access
- Microsoft Excel
Consolidated reporting tools
The following tools w88 slot used moving forward for data mentioned above.
- Power BI / Power BI w88 slot Server (Premium)
- Anaplan
- Ad Astra (v. 8.0 – Cloud)
This will eliminate the use of both Microsoft Access and Microsoft Excel as delivery vehicles for institutional reporting. Standard/static reports w88 slot distributed via email, or viewable in a browser, while dynamic and ad-hoc reporting w88 slot delivered on the web via the user’s preferred browser, or via mobile app (where available).
Source Systems
A 2018 review of software applications in use on campus, conducted as part of the initial rollout of data governance initiatives, identified 190 systems used across various departments on campus for collecting, storing or processing data (appendix A). Of these, 134 applications have been identified as the recognized system of record for data within these applications. ODS w88 slot work with the University Data Government committee to prioritize areas where business intelligence and standard reporting may best benefit the campus community.
Source Systems
Oracle PeopleSoft Campus Solutions
Raiser's Edge NXT
Workday
infoED Global
Slate
Enterprise Data Warehouse
ODS Tools/Output
B.I. Tools
Power BI
Anaplan
AdAstra
Interactive Reports/Dashboards
Standard/static reports
Ad hoc reporting
Interactive Reports/Dashboards
Standard/static reports
Ad hoc reporting
The Office of Information Technology (OIT) w88 slot responsible for the creation of Extract, Transform and Load processes to handle the data and merge source systems within the Oracle data warehouse. Once complete, these data w88 slot available to ODS for use in institutional reporting.
As shown above, reporting w88 slot done in three different ways:
- Dynamic Reports and Dashboards. Developed within the BI tool for user consumption via web or mobile device.
- Static Reports. Standard, non-changing reports generally delivered by email or browser.
- Ad-Hoc reporting. User self-service reporting done against the ODS data source.
w88 slot Development Life Cycle
The w88 slot development life cycle can be broken into the following steps:
- w88 slot Request. User submits a w88 slot request via ODS website using TeamDynamix.
- Request Evaluation. Request is evaluated to determine if a suitable w88 slot already exists in the ODS catalog.
- w88 slot Design. In instances where an acceptable w88 slot cannot be found to satisfy the demand of the request, a w88 slot design consultation will be undertaken to determine if a current w88 slot can be modified to meet the needs of the requestor, or whether a new w88 slot will be required. In the case of a new w88 slot, ODS will consult with the requestor to determine the acceptable layout and design considerations to be included within the w88 slot.
- Data review. ODS will determine whether the requested data exists within the w88 slot dataset. If the data exists in the w88 slot dataset, ODS will undertake the design using the appropriate data. In the event that the w88 slot dataset does not include the requested data, ODS will submit the new data request to the Data Governance Committee for review and approval. Upon approval, ODS will submit the request for new data to OIT for inclusion in the w88 slot dataset. Once the data has been added to the w88 slot dataset, ODS will proceed to the design phase for the w88 slot request.
- User Acceptance Testing. Once complete, ODS will submit the w88 slot to the requestor for User Acceptance Testing (UAT). If issues with the design or output are reported during UAT, ODS will work with the requestor to ensure that the proper fields/formatting/data are in place. Once UAT has completed, ODS will publish the w88 slot to the w88 slot server.
- Data Governance Approval. After publication, ODS will consult with the data governance committee to address access standards for the completed w88 slot. DGC will recommend security based on w88 slot output, audience and scope.
- Final Publication. Following data governance acceptance, ODS will apply the appropriate security roles to the w88 slot and inform those users in the target audience that the w88 slot is now available on the reporting platform.
w88 slot Request
w88 slot requests will be handled via the ODS website (URL to be determined upon completion). All request will be submitted and tracked using an application developed in-house by ODS using Microsoft PowerApps and Microsoft Flow (included in the University’s license for Office 365), via a workflow developed by ODS. Both new w88 slot and change requests will be handled using the same method for ease of ticket tracking to ensure that w88 slot requests are not lost or orphaned after the request has been submitted.
Changes to the warehouse data will be submitted to OIT using a method they have deemed appropriate (via TeamDynamix, email, etc.) ODS will submit these requests following OIT guidelines. Updates to all requests will be submitted back to the requestor using our custom application to ensure a historical record of w88 slot requests and approvals.
Training
ODS will provide training to end-users in a variety of ways. These methods may include face-to-face instruction and demonstration, classroom sessions, online tutorials/videos and user-group meetings. Additionally, personalized one-on-one instruction w88 slot made available when necessary and as time permits.