1 / 12

Data Delivery - the Evolving Model

Data Delivery - the Evolving Model. Data Sources. Student Reporting Data Service (RDS) HR Flattened Reporting Tables Finance Dimensional Model. Data Flow. Reporting. Insight (Microsoft Reporting Service). Warehouse. Finance (Dimensional Model). Student (Expanded RDS).

rob
Download Presentation

Data Delivery - the Evolving Model

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Delivery - the Evolving Model

  2. Data Sources • Student • Reporting Data Service (RDS) • HR • Flattened Reporting Tables • Finance • Dimensional Model

  3. Data Flow Reporting Insight(Microsoft Reporting Service) Warehouse Finance(Dimensional Model) Student(Expanded RDS) HR(Reporting Tables) ETL Cognos PL/SQL Sources Oracle (Peoplesoft) Sql Server(multiple apps) MySQL(multiple apps) Flat Files(ERSS, multiple extracts, etc)

  4. ETL Tools • OWB: Old Finance System (2002 - 2005) • Ascential: Finance Jumpstarts (2005 – 2009) • SSIS: Auxillary systems (2008 – 2009) • Cognos: RDS (2005 – Present) • PL/SQL: Multiple (2008 – Present)

  5. Microsoft Reporting Service • Gartner Group Placement • Part of our campus license • Inexpensive, ease of use • Rolling out at MIT, University of Washington, University of Seattle • This is only one module of the Microsoft BI solution

  6. Insight (Reporting Service)

  7. http://DATA.csuchico.edu

  8. Wiki Documentation Wiki.csuchico.edu

  9. The Knowledge Management Architecture What’s The Score?

  10. Benefit to Campus • Users will have the data they need readily available to make decisions • We are prepared to respond to upcoming demands that require getting data out to our decision-makers

  11. Reporting Demo

  12. Questions

More Related