1 / 16

Developing Business Intelligence at St. Cloud State University

Developing Business Intelligence at St. Cloud State University. Minnesota State Colleges & Universities CAO/CSAO/Deans Conference [May 29, 2008]. What is business intelligence?.

cera
Download Presentation

Developing Business Intelligence at St. Cloud State University

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. Developing Business Intelligence at St. Cloud State University Minnesota State Colleges & Universities CAO/CSAO/Deans Conference [May 29, 2008]

  2. What is business intelligence? The term business intelligence (BI) refers to technologies, applications and practices for the collection, integration, analysis, and presentation of business information and also sometimes to the information itself. The purpose of business intelligence is to support better business decision making. Source: Wikipedia

  3. Measurement concepts • Data: collection of facts from which information can be derived • Base measure: quantifying data value in context of the thing that it quantifies • Derived measure: complex measure deduced from multiple data points • Metric: system of measures based upon standard units • Business metric: metric with the context of business goal • Indicator: business metric used to track performance • Index: composite of indicators used to assess overall health

  4. Decision support framework Decision Type Strategic Broad and infrequent Tactical Process/Group Specific High Volume/ Transactional Operational Type of Analysis Fully automated Custom analysis

  5. SCSU’s BI system framework Scorecard/dashboard reporting Data analysis & decision support Automated standard reports Central data access & storage

  6. Central data access & storage

  7. Automated standard reports

  8. Data analysis & decision support

  9. Scorecard/dashboard reporting

  10. Development timeline Sept 2005 Initial BI planning Spring 2006 Investigated BI options Summer 2006 Developed first prototype Aug 2006 Initiated collaboration w/Winona Fall 2006 Involvement w/Microsoft BI Council Winter 2007 Initial DataMart development Winter 2007 Proof of concept development Aug 2007 Full project plan developed Fall 2007 Instructional workload project defined April 2008 Presented Dashboard concept to the Microsoft National BI Council

  11. Pilot: Instructional Workload Cube Fact/Qualifier Analysis Instructional Workload/Department Productivity Cube Business Questions 1. What is the faculty’s teaching assignment(s)? 2. What other assignments does a faculty member have? 3. What are the number of student credit hours generated? 4. What is the revenue generated by the faculty member and department? 5. What are the expenses associated with the faculty member and department?

  12. Fact/Qualifier Matrix

  13. Things we’ve learned • Start from a business need • Definitions are key • Building infrastructure takes time • Dirty data • History • Department table • Security • Hardware integration

  14. Next steps • Operationalize and refine of workload cube • Integrate faculty scholarship • Security access • Assessment • Enrollment analysis

More Related