Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device.
Atlassian cookies and tracking notice, (opens new window)
Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
SPU Wiki
Welcome to the SPU Wiki Space Directory

Technology Service Catalog
Results will update as you type.
  • Active Directory
  • Argos
  • Audio Visual Equipment Checkout
  • Audio Visual Installation Consultation
  • Banner
  • Calendar
  • CallXpress
  • Canvas
  • Computer Build (image)
  • Computer Deployment
  • Wiki/Confluence
  • Course Support
  • Data Warehouse
  • Departmental Documentation
  • Email
  • EMS - Campus Space Management
  • Formstack
  • HelpDesk
  • Host a Webinar
  • ID Cards
  • Jira
  • Live Streaming
  • MARS
  • Microsoft Teams
  • Multi-Function Printers
  • Online File Sharing
  • NuPark
  • Office 365
  • Office Move Checklist
  • On-Call Services
  • PaperCut
  • Personal Devices
  • Services by Category
  • SharePoint
  • Single Sign On
  • Percipio
  • Skype
  • Software Center
  • Tableau
  • Telephone Functions
  • Multi-Factor Authentication
  • Whitepages
  • WiFi
  • Zoom
  • CourseLeaf
  • Panopto
  • SensusAccess
  • WordPress
  • Slate
  • StarRez
  • TMA iServiceDesk
  • JumpForward
  • Raiser's Edge

    You‘re viewing this with anonymous access, so some content might be blocked.
    Teams
    , (opens new window)
    /
    Data Warehouse
    Updated Dec 21, 2023

    Data Warehouse

    Dec 21, 2023

    Overview


    The SPU Data Warehouse is a cross platform collection of objects and records that aids in the aggregate analysis of institutional data.

    These objects are intended to be structured in such a way that facilitates use across departments and business cases, incorporating the data definitions of stakeholders, which serves to provide a common vocabulary among our data consumers. The Data Warehouse, also known as EDW (Electronic Data Warehouse), promotes un-siloed access to data, providing a central point of contact for answers to business analysis questions.

     

    Features


    Cross platform data access - The EDW contains data from many integrated systems, making their business objects accessible in one place.

    High performance queries - Storing data in well structure ways in the EDW simplifies querying and joining data, resulting in more performant analysis.

    Common vocabulary - Storing data from multiple sources in one EDW promotes data dictionary definition of terms to inform users of the source and usage of data objects.

    Business Intelligence - Analysis is made possible by thoughtful architecture and meaningful, subject-oriented structures in the EDW.

     

    Designed For


    The EDW is designed for report writers and dashboard creators for staff and faculty to use as their source of data.

     

    Getting Started


    Access to the EDW is currently limited to a small group of technical users. As we build the repository and add entities, we will make considerations of extending access while maintaining appropriate data security. If you believe you need access to the data warehouse, please request it via Jira.

     

    Support


    Technical support and training for the EDW is provided by CIS. Problems or issues with the EDW can be submitted to CIS via Jira.

    Technical documentation for the EDW has been collected and stored in the Technical Documentation wiki space. SPU's data dictionary can be found on the Data Warehouse SharePoint site.

     

    Administration and Maintenance


    CIS administrates and maintains the EDW and its server environment. 

     

    Learn More


    Data Warehouse FAQs

    SPU's data dictionary can be found on the Data Warehouse SharePoint site.

    Highlights


    Eligibility

    • Faculty and staff report writers and dashboard creators.

    Support & Training

    • Support requests can be submitted via Jira

    • EDW technical documentation

    Get Started

    • Request access via Jira

    • Request a new report

    • Request a new object

    {"serverDuration": 29, "requestCorrelationId": "ebea56f6a8d34c2ca3907d3d262b7c48"}