The Power of Data in Decision Making Better Informed Decision Making through Geospatial Technology A Case Study Presented by TeamWorks International, Inc. in Partnership with the MN Child Care Resource & Referral Network MN Council for Quality – PIN Network Meeting April 2, 2009
TeamWorks International, Inc. Our Mission Toenhance capacity for strategic, constructive change in mission-driven organizations Our Philosophy • We help our clients gain Insight through a comprehensive, data-informed assessment of their current condition. • Through partnership we create a Strategic Roadmap, Operational Plan and Success System leading to stronger Alignment of their people, systems, structures and goals. • We develop and inspire leaders to take Action leading to their desired outcomes.
TeamWorks International, Inc. • Dennis Cheesebrow, President & Founder – 1995 • Strategic and Systemic Change Consulting • LeaderShift Development • FrameWorks™ Author • Amy Anderson, Client Relations – 2007 • Client Relations • Business Development • Benjamin Anderson, Insight Services – 2005 • Insight Services Consulting / Training • Project Management • Research and Development
Insight Services (Analytics) Insight Services is the customized synthesis of client data with relevant external data derived from demographic research, surveys and cultural analyses to deepen the clients’ understanding of the current reality as well as future challenges and opportunities. We customize the data, analysis and deliverables based on the unique circumstances and desired goals of each client to best inform strategic decision making. We utilize geospatial information technology to provide effective visualization and analysis of various data sources based on the unique strategic questions of our clients
Insight Services Research Examples Public Education – How do we “right-size” our school district to manage open-enrollment, leverage community support and increase high-quality educational opportunities for our students? Religious Diocese – How can we continue to provide equitable access to liturgy and sacraments considering the continued decline / relocation of church members and resources? Private School – What is the threshold at which our tuition is no longer affordable based on the national, regional and local socio-economic trends? Healthcare – Where do we actually need MRI scanners and how do we manage their locations and use based on that need? Private Business – How do I establish areas of highest market potential based on my current and historical client base? And how do I most effectively market my services to these identified geographical areas?
Minnesota Child Care Resource& Referral Network Mission Toprovide statewide leadership in shaping collaborations that build a diverse, high quality child care system accessible to all Minnesota families through local child care resource and referral services. This Mission is accomplished through: • Supporting Parent Choice • Building the Supply • Engaging Employers • Advocating for Improved Quality, Accessibility and Affordability • Improving the Quality of Care and Education The MNCCRR Network receives the majority of its funding through a grant from the MN Department of Human Services.
Strategic Capacity Question How can we provide regional CCR&R network managers with access to all network data sources to increase effectiveness and efficiencies in both their day to day (tactical) work and also their longer term planning efforts (strategic)?
Strategic Solution Build an integrated computer mapping application as a tool for CCR&R regional managers to access the data they need to make better informed decisions regarding tactical and strategic planning efforts.
Description of Tool Provided Placement of all known state, regional and local child care and 5 year demographic data in the hands of the Child Care Resource & Referral (CCR&R) system. This data is used and viewed on the client’s computers through the ArcReader™ tool.
Benefits and Impact To-Date • CCR&R sites are integrating these tools into their planning and technical assistance efforts. They have recently used the tools to: • Target their Family, Friend, Neighbor outreach efforts to areas of high concentration • Identify English Language Learner communities who would benefit from mailings in languages other than English • Provide insightful technical assistance to potential child care providers on the demand for child care in their area • Manage timely crisis situations (such as the current Red River flooding) and provide emergency services
Keys to Success • Ongoing training and skill growth throughout the system. • A well-informed CCR&R system empowered by usable, translatable data sources. • Increased data use in planning, implementation and communication efforts.
Insight Services – Process • Data Collection & Integration • Building a Geo-database • Application Build & Design • Geographic Information Systems (GIS) • Training Workshops • Statewide & Regional
CCR&R Data MN Child Care Providers Contact Info, Type, Capacity, Rates by Age (hourly & daily) Trainings, Grants DHS Development Regions MN TRECC Reservation Boundaries ESRI Demographics (2000, 2008, 2013) Population by Age Group 0 – 3 years, 6 – 9 years, Etc. Population by Race Asian, Black, Hispanic, Native American, Etc. Socio-economics Median/Disposable Income, Home Value Auxiliary Data (reference) Streets, Lakes, Municipalities, Etc. Geo-database & Information System Geographic Information System
Supporting Grant Applications Email from CCR&R staff member to TeamWorks: “Hello Ben, I am not sure if you have heard, but CCRR sites can apply for a grant due Jan. 15th, using info from GIS and ARCreader. I especially want to use the demographic data, trends, projections on children and Hispanic population in Long Prairie, Todd County. I need to get started on the grant right away, but ARCreader is the problem for me. I am not all techy. Not only have I been unable to download the software, I also had real problems understanding things at the training and the reference guide makes very little sense to me.”
CCR&R Staff Testimonial Email from CCR&R staff member to Regional Manager: “Hi Terry, I emailed Ben and Jim from their office called me. He was great teacher! I have learned so much. Already printed maps and have a really good start on the grant. Just this morning, I had a provider call thinking of starting a child care in Todd County around Long Prairie/Clarissa/Browerville area. She was not sure which of these little towns might be better. They are all in a 15-20 mile radius. I got out my GIS ARCreader map of Todd County,with the 0-5 population % of change for 2008-2013. Guess what, Browerville was the Block that will have 4.5-12.5% change. That felt really good to be able to give her that kind of very helpful info. She can use that data and other data that I shared with her to make the best, informed decision for the success of her potential child care program/business.”
Desktop Mapping Application Email from CCR&R staff member to Regional Manager:
Desktop Mapping Application Email from CCR&R staff member to Regional Manager:
Browerville, MN – Demographic Trends Email from CCR&R staff member to Regional Manager:
Regional Managers Application • Identifying Regional Trends • Analyzing Current and Forecasted Demographic Details • Assessing Local Communities Need for Services • Managing Child Care Providers • Rates, Training, Risks, etc.
St. Paul Demographic Trends – White Pop. Email from CCR&R staff member to Regional Manager:
St. Paul Demographic Trends – Minority Pop. Email from CCR&R staff member to Regional Manager:
St. Paul Demographic Trends - Income Email from CCR&R staff member to Regional Manager:
Managing Providers Email from CCR&R staff member to Regional Manager:
Emergency Flood Planning Scenario: CCR&R Regional manager in Moorehead, MN called TeamWorks for technical support on identifying which child care providers are within proximity to flooding rivers and lakes in the Red River watershed.
Emergency Flood Planning Solution: TeamWorks quickly integrated current flood forecast data to overlay peak areas of expected flooding revealing child care provider locations at risk. The data was used to identify and support these providers with essential crises management resources.
Emergency Flood Planning Protected by Levee Email from CCR&R staff member to Regional Manager: Peak Flood Areas
Emergency Flood Planning Email from CCR&R staff member to Regional Manager:
Insight Services in Other Markets • Member-based Organizations • Faith, Non-profit and Professional Associations • Public and Private Education • Private Business • Healthcare Providers • State & Local Government
Insight Services for Nonprofit / Faith Demographic Trends – Mapping and analysis of student and community demographics including age, gender, ethnicity, and socio-economics. Member Density – Revealsthe relationship between member distribution and population densities. Financial Capacity Analysis – Based on the correlation between various demographics and member contributions / gifts / tuition as a percentage of disposable income. Market Share & Potential – Identifies the demographic characteristics of current and historical members of the organization and then reveals performance in the current market while revealing the potential geographical areas with the highest market potential for future strategic planning. Custom Research / Analysis – Includes regional studies across multiple organizations for shared or executive decision making.
Insight Services for Public Education • Enrollment Projections • Student Achievement Analysis • Boundary Change Modeling • Facility Utilization Analysis • School / Program Site Analysis • Referendum Voting Trends • Bus Routing Analysis • Real Estate Trends • Demographic Trends
Insight Services in Health Care • Analyzing patient locations / patterns / density • Mapping demographic trends associated with patient locations • Defining health service areas (HSA) based on drive time • Depicting insured versus uninsured patient distributions • Defining health professions shortage areas • Where physicians or hospitals may be better served • Tracking immunizations / injuries (or any type of visit) • Tracking injuries (types, who, where, when) • Market trends based on service lines • Where could or should advertising take place • Identifying where emergency visits come from • Prevent non-essential visits • Gauging profitability • patients vs. household income, disposable income, etc • Custom Research & Analysis • What type of physicians would be best suited for a particular hospital/clinic based on service area demographics
Comments / Questions? Thank You!