1 / 15

Planning and Deploying Enterprise Reporting and BI

Agenda. IntroductionBanner @ ESU Project OverviewOperational Data Store and Enterprise Data Warehouse OverviewEnterprise Reporting Goals and ObjectivesReporting Tool Evaluation and Selection ProcessImplementationLessons Learned

arleen
Download Presentation

Planning and Deploying Enterprise Reporting and BI

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. Planning and Deploying Enterprise Reporting and BI TJ Rains, PMP ERP Administrator/Banner Project Manager Emporia State University trains@emporia.edu

    2. Agenda

    3. Banner @ ESU Project Background Kicked Off in March of 2005 Will Close Out in December of 2007 Guiding Principles and Objectives Replace in house developed heterogeneous legacy administrative systems with an integrated ERP system. Improve Business Processes and Streamline Operational Efficiencies. Create a Secure Single Point of Entry to University Information Resources. Expand Self Service Information Access to all University Constituents. Refine Security Standards and Procedures.

    4. Banner @ ESU Project Background Banner and Partner Systems Implemented Luminis Portal – Live March 2006 Banner Advancement - Live July 2006 Banner Finance – Live July 2006 ODS – Live July 2006 Cognos 8 BI – Live July 2006 Appworx – Live July 2006 Evisions – Live July 2006 Workflow – Live July 2006 ePrint – Live July 2006 RMS Housing – Live January 2007 Banner Financial Aid – Live March 2007 Banner Student – Live March 2007 Touchnet Payment Gateway – Live May 2007 Banner HR – Live July 2007 EDW – Live December 2007

    5. ODS

    6. EDW

    7. ODS/EDW/Cognos - Diagram

    8. Enterprise Reporting Driving Goals and Objectives Provide users with the ability to sort, filter, drill down, query, and build ad hoc reports on the web in a user-friendly environment. Reduce paper based reports. Provide reports with drill down capability. Eliminate Shadow reporting data stores and report development systems. Consolidate reporting and analysis skills by using one primary reporting and analysis toolset for operational and analytical reporting. Develop reports and analytics to accurately measure University strategy performance.

    9. Align with Institutional Strategy

    10. Project Staff and Org Banner @ ESU Executive Committee Banner @ ESU Steering Committee Banner @ ESU Project Director – CIO Banner @ ESU Project Manager DBA Staff Report Developers Institutional Research Staff

    11. Charge To deploy the Sungard HE ODS and EDW systems to support each Banner functional area’s reporting needs utilizing the Cognos Reporting tool. Assumptions for this project include: We will use a common data source We will work to develop common data definitions (i.e. FTE) We will develop a process to freeze historical data We will discuss data needs not delivered in the ODS and define an approach to fit these gaps We will endeavor to share reports We will discuss the owner, access, and distribution of reports for quality control and standardization We will commit appropriate time to this project as negotiated by the group We will change our input and processing procedures if necessary to meet our reporting needs We will ensure the appropriate level of security has been implemented to control data access We will define all requirements for a new reporting toolset. We will evaluate top reporting products and choose a system for purchase and implementation.

    12. Reporting Tool Evaluation

    13. Reporting Tool Evaluation

    14. Cognos 8 BI Implementation

    15. Lessons Learned… so far

More Related