Developing BGSU ’ s Data Warehouse Power Point Available at: http://www.bgsu.edu/offices/cio/datawarehouse/page46293.h

1. Developing BGSU’s Data Warehouse Power Point Available at: http://www.bgsu.edu/offices/cio/datawarehouse/page46293.html(as of 2/11/08)

2. The Vision • To contribute to Bowling Green State University’s • planning and decision making capabilities; • To contribute to the University’s competitive • advantage and distinctiveness in the higher • education marketplace; • To contribute to the realization of Bowling Green • State University’s aspiration to be a “Premier • Learning Community.”

3. The Challenge • To succeed in an increasingly demanding and dynamic higher education market place, it is important that the University maximize the value and impact realized from all its assets including one of its most valuable assets—institutional data. • By more effectively transforming data to information and information to knowledge and by leveraging this knowledge toward operational, tactical, and strategic decision making, BGSU can foster its competitive advantage and distinctiveness.

4. Data to Action, Value, and Impact

5. The Current Environment Although a level of useful business intelligence is available to the University, the current environment is disadvantaged by factors such as: • Inconsistent data available, • Resources wasted resolving reporting inconsistencies, • Uncertainty regarding data quality, • Data not easily accessible, • Lack of reporting standards and coordination, • Lack of common data definitions • Data not integrated—including data and knowledge silos • Shadow systems • An underdeveloped reporting and analytic culture.

6. Data Warehouse Goals • To construct a single, secure source of high quality, timely, consistent, integrated, and appropriately modeled data from disparate data sources both internal and external to the University. • To provide approved users with the tools necessary to facilitate easy access to and the capability of examining data necessary to support their reporting and analytic requirements. • To foster the creation of a robust, collaborative, and coordinated reporting and analytic culture that promotes the use of business intelligence across the University to support decision making at the operational, tactical, and strategic levels.

7. The Way • Build an Enterprise Wide: Data Warehouse • Link to the Warehouse Effective: Business Intelligence Tools • Facilitate Growth of a: University Wide Analytic Culture Beginning with the Formation of a: Report Author Collaborative

8. A Data Warehouse: • Is a single, complete, consistent store of data available to users for decision support. • Is maintained separately from operational databases. • Is subject oriented, integrated, time-variant, nonvolatile. • Is designed and modeled to support inquiry. • Is generally designed to support reporting and analytic efforts, however, the nature and direction of these efforts are somewhat unpredictable and will evolve over time. • Represents a “single source of truth.”

9. Business Intelligence: • Has become a popular phrase used to depict related concepts, methods, and technologies. As used here, BI is focused on the use of various reporting and analytic methodologies to transform data, to information, to knowledge toward promoting the University’s competitive advantage and distinctiveness. • Is about promoting collaboration, creative imaginings, improved performance, and succeeding in an increasingly challenging environment. • Is not technology dependent, but the application of effective BI tools linked to a robust data source (a data warehouse) greatly enhances the potential benefits BI brings to the organization.

11. Building the Data Warehouse Building BGSU’s DW will be accomplished via a 10 step iterative cycle: • (1) Design the DW’s core architecture. This phase is essentially complete. √ • (2) Development efforts will focus on a specific subject area—e.g. human resources, financial, student, and others. Human resources has been selected for the first iteration. √ • (3) A kickoff meeting will be held to introduce individuals to the project and the development process involved. √

12. Building the Data Warehouse Cont. • (4) A requirements gathering phase related to the selected subject area will be completed. • (5) A scope document and detailed project plan will be developed. (Note: The scope for each iteration of the warehouse is intentionally designed to be small and doable. The idea is to start small and grow big via a series of iterative cycles.) • (6) Based on the scope document, required data will be extracted from source systems, loaded to the warehouse’s staging area for quality review, cleansing, transformation, and modeling.

13. Building the Data Warehouse Cont. • (7) Required data will be modeled and extracted from the staging area and stored in the actual warehouse. • (8) Data from warehouse will be used to build and publish required data marts that are accessible to users for reporting and analytic activity. • (9) Users develop reports and analysis. (Report Author Collaborative) • (10) The cycle is evaluated, adjustments made, and a new iterative cycle begins.

14. The Report Author Collaborative • The RAC is a group of functional users from across campus working together to promote the University’s analytic culture and to assist each other in the development of reports and analysis used to support decisions at the operational, tactical, and strategic levels. • The RAC shall coordinate the development of training programs and other user help/support processes. • The RAC shall coordinate the development of reporting standards, schedules, and provide other coordinative functions. • The RAC shall contribute to the development of University wide data standards, data reference sources, and contribute to efforts designed to educate members of the BGSU community regarding data and information available.

15. Current Project Organization Structure Data Warehouse Core Project Team: Sponsors: Bill Knight, Asst VP, Bruce Petryshak, CIO Proj. Mgrs.: Phil Kocher, ITS, Conrad McRoberts, IR Brian Rellinger, ITS Report Author Collaborative DW Subject Area (A) Implementation Team: Becca Ferguson Phil Kocher John Konecny Conrad McRoberts Larry Smith Sharon Swartz Donna Wittwer DW Subject Area (…n) Implementation Team DW Subject Area (B) Implementation Team DW Subject Area (C) Implementation Team

16. The Vision Restated • To contribute to Bowling Green State University’s planning and decision making capabilities; • To contribute to the University’s competitive advantage and distinctiveness in the higher education marketplace; • To contribute to the realization of Bowling Green State University’s aspiration to be a “Premier Learning Community.”

17. “The possession of facts is knowledge, the use of them is wisdom.” —Thomas Jefferson Thank You If Additional Questions, Contact: Phil Kocher, 2-4865, kocherp@bgsu.edu Conrad McRoberts, 2-2867, cmcrobe@bgsu.edu