SCHOOL DISTRICTS !!! 1 4/22/13 Using Data to Make More - PDF document

4/22/13 ¡ BUSINESS INTELLIGENCE: NOT AN OXYMORON MASBO Spring Conference May 2, 2013 § Steve Pumper § Vice President, PMA Financial Network, Inc. spumper@pmafinancial.com § § Vladimir Dragosavljevic Chief Operating Officer § vlad@forecast5analytics.com § Business Intelligence: Who Does This? • Coke vs. Pepsi • Arby’s vs. Wendy’s vs. Burger King vs. McDonald’s • Crest vs. Colgate • Dentyne vs. Carefree • Minnesota Twins • Watergate Business Intelligence: Who Does This? SCHOOL DISTRICTS !!! 1 ¡

4/22/13 ¡ Using Data to Make More Informed Decisions! Why? • Better use of resources to meet the needs of students! • Tighter resources, more expectations and demands. • Greater demands on reporting and accountability. Using Data to Make More Informed Decisions! Why? • Greater expectations to use technology to improve collections and reporting. • Ongoing comparison to operations of the “business world,” and our need to be more like that. • Expectations by: • Board • Public • Media Using Data to Make More Informed Decisions! Why? • Increasing rules and regulations on reporting • Marketing • Validation 2 ¡

4/22/13 ¡ Using Data to Make More Informed Decisions! Why? Better use of resources to meet the needs of students!!!! Districts Already Collect Data • MARRS • EDRS • UFARS Reporting Districts Already Collect Data • Summer Levy Info • MSBA Salary Settlements • STARS 3 ¡

4/22/13 ¡ Districts Already Collect Data • Association Surveys • Budget Publications • Department of Ed Requests Districts Already Collect Data • Association Surveys • Budget Publications • Department of Ed Requests Other Data? • Census Data • Birthrate Data • Test Scores • V oter Data • Tax Data 4 ¡

4/22/13 ¡ Current Tools • Individual district specific • Historical only data • Static comparisons or comparison groups Current Tools • Limited comparison elements • What others see as important and how they see it • Little flexibility Current Tools • Inability to address the “next” question as data is reviewed • Difficulty on exporting and presenting data 5 ¡

4/22/13 ¡ Where Do I Get Data and Whoa!!! How do I get on top of How Do I Use It? all this data??!!!! Business Intelligence Cube 6 ¡

4/22/13 ¡ What are Analytics? § Tools to make data driven decisions. Why use Analytics? § To better align financial plans with strategic plans. Analytics - The 3 Big Questions 1 2 3 How am I Why is this What does the doing? the situation? future look like? Business Intelligence Business Analytics Financial paradigm shift Planning Then … Planning Now … 7 ¡

4/22/13 ¡ Issues competing for attention Increasing the need for decision support tools Regulatory & Legal Student Financial Performance Developing the Strategic Plan Student Financial Experience Resources Analytics for Schools • Business analytics • Forecasting … a paradigm shift of its own • Business intelligence (“BI”) • Multi-dimensional data modeling • Data discovery • Decision support • Data visualization • Competitive and comparative analysis 8 ¡

4/22/13 ¡ How Schools Are Using Business Intelligence • Budgeting • Hiring/staffing • Negotiations • Evaluating program costs • Communication with stakeholders How will I use this level of data to make a more informed budget decision? • Understand my own information better • Peer comparison • Identify trends • Establish benchmarks • Resource allocation and optimization 9 ¡