Reporting Panel – ODS / Informer / SQL Server Reporting Services

Please download to get full document.

View again

All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
 4
 
  Reporting Panel – ODS / Informer / SQL Server Reporting Services. Jeremy Brinkman, University of Northwestern Ohio Alan Crowley, Alma College Jonathan Martindell , Franklin University Diane Pack, Macomb Community College Jay Schwellenbach, Northwood University.
Share
Transcript
Reporting Panel – ODS / Informer / SQL Server Reporting ServicesJeremy Brinkman, University of Northwestern OhioAlan Crowley, Alma CollegeJonathan Martindell, Franklin UniversityDiane Pack, Macomb Community CollegeJay Schwellenbach, Northwood UniversityIntroducing: Jeremy BrinkmanJeremy BrinkmanAssistant VP for Information TechnologyUniversity of Northwestern Ohiowww.unoh.eduUniversity of Northwestern Ohio
  • Private, Non-profit Institution
  • Founded in 1920
  • 4600+ students from all 50 states and 24 foreign countries
  • Five Colleges: College of Applied Technologies, College of Business, College of Occupational Professions, College of Health Professions, Graduate College
  • www.unoh.eduUNOH: Reporting Environment
  • Windows + SQL Server
  • Reporting Tools
  • Crystal Reports
  • SAP BusinessObjects with Web Intelligence
  • SQL Server Management Studio
  • SQL Server Business Intelligence Development Studio
  • Custom Data Warehouse (No ODS)
  • www.unoh.eduUNOH: Business Objects Examplewww.unoh.eduIntroducing: Alan CrowleyAlan CrowleyDirector of Enterprise Information SystemsAlma Collegewww.alma.eduAlma College: Reporting Environment
  • Private, Non Profit ~ 1400 Students
  • Windows + SQL Server
  • Purchased and had Datatel Install
  • Datatel ODS
  • SAP BusinessObjects with Web Intelligence
  • Issues
  • Small IT Staff – Strong SQL Skills
  • Costly, Complex, Security, and losing records
  • Users needed reports Now
  • Easier to automate and run SQL queries
  • www.alma.eduAlma College: Reporting Environment
  • Moved to Custom Warehouse
  • Created Stored Procedures to populate Custom Data Warehouse Tables
  • Continue to expand Warehouse as new Report requests come in.
  • End Users Run Crystal Reports
  • IT Created Report templates
  • Power Users get full version of Crystal
  • Non Power Users use “free” version of LogicCity Desktop (Report Viewer) to run Reports.
  • www.alma.eduIntroducing: Jonathan MartindellJonathan MartindellProgrammer AnalystFranklin Universitywww.franklin.eduFranklin University
  • Private, Non-profit Institution
  • Columbus, OH
  • Serves Adult Students
  • Expanding Globally and Domestically
  • Community College Consortium Agreements
  • GoArmyEd Institution
  • Online Courses
  • Franklin University: Reporting
  • Data Warehouse in 2009
  • Information Builders WebFOCUS
  • ODS in 2011
  • Microsoft Report Manager / BIDS
  • Operational Reports
  • ‘Views’ of data meant to be further filtered/sorted
  • Utilize Subversion plugin in development process
  • AnkhSVN: http://ankhsvn.open.collab.net/
  • Franklin UniversityFranklin UniversityFranklin UniversityFranklin UniversityFranklin UniversityFranklin UniversityIntroducing: Diane PackDiane PackMacomb Community Collegewww.macomb.eduMacomb Community Collegewww.macomb.edu
  • Four Campuses
  • Enroll more than 50,000 students annually
  • The largest grantor of associate's degrees in the State of Michigan and consistently ranks in the top 2% nationally.
  • MCC: Reporting Environmentwww.macomb.edu
  • Reporting Tools
  • Colleague Query Builder (phasing out by department)
  • SAP BusinessObjects with Web Intelligence
  • SQL Server Management Studio
  • ODS (nightly refresh)
  • Introducing: Jay SchwellenbachJay SchwellenbachProgrammer AnalystNorthwood Universitywww.northwood.eduNorthwood University has:
  • Three residential campuses:
  • West Palm Beach, Florida
  • Midland, Michigan
  • Cedar Hill (Dallas), Texas
  • Over 20 Adult Degree Program satellite centers across eight states.
  • DeVos Graduate School of Management located in Michigan, Florida, and Texas, as well as in Montreux, Switzerland.
  • Northwood University also has
  • International Program Centers in:
  • China (2)
  • Malaysia
  • Sri Lanka
  • Switzerland
  • NU: Reporting Environment
  • ODS
  • Microsoft SQL Server 2008 – SQL Server Management Studio
  • Microsoft SQL Server 2008 – R2 Report Builder 3.0
  • SQL Server 2008 R2 Reporting Services
  • Questions for the Panel?
    Related Search
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks
    SAVE OUR EARTH

    We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

    More details...

    Sign Now!

    We are very appreciated for your Prompt Action!

    x