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

4/22/13 ¡ 1 ¡ 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 !!!

4/22/13 ¡ 2 ¡ 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

4/22/13 ¡ 3 ¡ 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

4/22/13 ¡ 4 ¡ 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
• ter Data
• Tax Data

4/22/13 ¡ 5 ¡ 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

4/22/13 ¡ 6 ¡

Where Do I Get Data and How Do I Use It?

Whoa!!! How do I get on top of all this data??!!!!

Business Intelligence Cube

4/22/13 ¡ 7 ¡ 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

How am I doing?

2

Why is this the situation?

3

What does the future look like?

Business Intelligence Business Analytics

Financial paradigm shift

Planning Then… Planning Now…

4/22/13 ¡ 8 ¡ Issues competing for attention

Increasing the need for decision support tools

Regulatory & Legal Financial Student Performance

Developing the Strategic Plan

Student Experience Financial 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

4/22/13 ¡ 9 ¡

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