1 / 24

Reporting Panel – ODS / Informer / SQL Server Reporting Services

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.

lalo
Download Presentation

Reporting Panel – ODS / Informer / SQL Server Reporting Services

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

  2. Introducing: Jeremy Brinkman Jeremy Brinkman Assistant VP for Information Technology University of Northwestern Ohio www.unoh.edu

  3. University 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.edu

  4. UNOH: 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.edu

  5. UNOH: Business Objects Example www.unoh.edu

  6. Introducing: Alan Crowley Alan Crowley Director of Enterprise Information Systems Alma College www.alma.edu

  7. Alma 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.edu

  8. Alma 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.edu

  9. Introducing: Jonathan Martindell Jonathan Martindell Programmer Analyst Franklin University www.franklin.edu

  10. Franklin University • Private, Non-profit Institution • Columbus, OH • Serves Adult Students • Expanding Globally and Domestically • Community College Consortium Agreements • GoArmyEd Institution • Online Courses

  11. 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/

  12. Franklin University

  13. Franklin University

  14. Franklin University

  15. Franklin University

  16. Franklin University

  17. Franklin University

  18. Introducing: Diane Pack Diane Pack Macomb Community College www.macomb.edu

  19. Macomb Community College www.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.

  20. MCC: Reporting Environment www.macomb.edu • Reporting Tools • Colleague Query Builder (phasing out by department) • SAP BusinessObjects with Web Intelligence • SQL Server Management Studio • ODS (nightly refresh)

  21. Introducing: Jay Schwellenbach Jay Schwellenbach Programmer Analyst Northwood University www.northwood.edu

  22. Northwood 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

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

  24. Questions for the Panel?

More Related