slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Data Delivery - the Evolving Model PowerPoint Presentation
Download Presentation
Data Delivery - the Evolving Model

Loading in 2 Seconds...

play fullscreen
1 / 12

Data Delivery - the Evolving Model - PowerPoint PPT Presentation


  • 106 Views
  • Uploaded on

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).

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Data Delivery - the Evolving Model' - rob


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
data sources
Data Sources
  • Student
    • Reporting Data Service (RDS)
  • HR
    • Flattened Reporting Tables
  • Finance
    • Dimensional Model
slide3

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)

etl tools
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)
microsoft reporting service
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
wiki documentation
Wiki Documentation

Wiki.csuchico.edu

benefit to campus
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