Interactive data analytics boosts enrollment and student success

Sinclair Community College uses SAS® Visual Analytics to help attract students, ensure degree progression and completion 

Most organizations have competition. Even community colleges need to be aware of other options in front of their students to make sure they’re providing the best educational experience possible. 

Ranked among the top community colleges in the United States, Sinclair Community College in Dayton, Ohio, is committed to helping students reach their educational goals and pursue their career aspirations. And that’s a commitment that Karl Konsdorf doesn’t take lightly. 

We're seeing anywhere from 25 percent to 33 percent increases in enrollments year-over-year ... We've been able to use data gleaned from SAS to position Sinclair as a leader in higher education.

Karl Konsdorf
Director of Research, Analytics and Reporting

As the Director of Research, Analytics and Reporting at Sinclair, Konsdorf leads a team responsible for database administration, institutional research, report development and data quality. The goal is to better understand student registration, success and outcomes to increase enrollment numbers. 

“Enrollment had been declining over a five-year period, and we were unsure why,” Konsdorf says. “While everybody had their own gut feeling, no one knew exactly what was going on.”

When the president of the college asked Konsdorf to investigate, he turned to SAS.

New insights into enrollment and degree progress

After thoroughly analyzing its student data along with data from the Integrated Postsecondary Education Data System (IPEDS) and social networking sites, Konsdorf’s team discovered that Sinclair's enrollment was fairly steady over the last 15 years. However, other institutions had seen significant jumps in enrollment over that time.

“These insights set the stage for our new strategy of tackling enrollment issues by looking at our whole marketing portfolio,” Konsdorf says.

With SAS Visual Analytics, Sinclair can analyze student enrollment from different angles. Daily enrollment management reports give deans and directors insight into how Sinclair’s enrollment compares to previous years.

“We have 19 different characteristics that they can go in and filter,” Konsdorf says. “They can simply go in to this report, and in a few clicks see current enrollment compared to the same time in previous years. And they can do further analysis, like break down results by sex, race or ethnicity.”

To help students continue on the path toward graduation, the team created a degree audit report within SAS Visual Analytics that allows Sinclair’s chairs and advisers to look at students’ degree progress. They can pinpoint the students who haven't been enrolled within the last year, and view them by advisor, school, major and more. Staff can get a list of all students who are close to completing their degrees – then reach out to advise them on courses to help them complete their studies. 

Pre-college program leads to higher completion rates

Sinclair created another report pertaining to College Credit Plus, a pre-college program designed to provide students the opportunity to earn high school and college credit before high school graduation.

“Ohio is a performance-based funding state, so we're funded on credit completion rather than access,” Konsdorf explains. “Statewide, the college credit completion for high school students who are enrolled in pre-college courses is 93-95 percent, versus 73 percent for general community college students. So there's incentive to bring these enrollments to the institution.

“There’s also a bit of competition, because there's a lot of overlap between the districts and the colleges that serve within those 30-mile radiuses. You can go beyond the 30-mile radius if you’d like, and Sinclair wants to serve after high schools outside our region as well.”

SAS Visual Analytics allows the College Credit Plus office to look at historical enrollments and see if they differ by region, high school, course, demographics and more.

“The office can access completion information and cumulative credit information and turn into helpful fact sheets for high school administration,” Konsdorf says. “We’ve been told things like, ‘Sinclair is the only institution in the region that can show me how my students are performing in their college coursework,’ and, ‘No other college has been able to lay out and present this kind of data.’ It’s a huge competitive advantage to build and cultivate those relationships, and an opportunity to garner more enrollment from those districts.”

In fact, College Credit Plus has become one of the fastest-growing programs at Sinclair. “We're seeing anywhere from 25 percent to 33 percent increases in enrollments year-over-year from our College Credit Plus partners,” Konsdorf says. “We've been able to use data gleaned from SAS to position Sinclair as a leader in higher education.”

Deeper analysis to find ‘things that matter’

Konsdorf’s team also has dramatically reduced the number of reports it creates and maintains. Previously, the team would generate one-off reports as they were requested.

“If we got a request for enrollment report from three different departments, we would need to generate three different reports for each case,” Konsdorf explains. “But with SAS Visual Analytics, we provide the reports for staff to go into the system, pick the department they’re interested in, and pivot down to get to the information in a self-sufficient manner. In fact, we condensed 1,600 reports down to just 20 reports.”

Not only does this save the team a tremendous amount of time and maintenance, but users are becoming more self-sufficient and comfortable working with data. “Nobody calls us anymore to ask what our enrollment is day-to-day,” Konsdorf says. “This means we can truly focus on things that matter, like deeper analysis and looking for more ways to apply analytics.”

On the horizon, Konsdorf plans to tackle intelligent scheduling, which would help Sinclair determine the ideal number of courses to offer, when and where to offer them (both high schools and campus locations) and the number of faculty members needed for instruction. “That’s our vision, and we’re excited about the opportunities ahead, thanks to the capabilities of SAS Visual Analytics.”

Sinclair logo


  • Better understand student enrollment.
  • Develop a self-service model for decision support.
  • Provide high school students with college-level courses to encourage future enrollment.
  • Encourage students to complete the necessary coursework to graduate and secure employment.



  • Daily enrollment management reports can be compared to previous years and broken down by department, program and other demographics for analysis and action.
  • A degree audit report allows chairs and advisers to track students’ progress toward graduating, helping them reach out to students to encourage completion.
  • College Credit Plus has become one of the fastest-growing programs, with 25 percent to 33 percent increases in enrollments year-over-year.
  • The Research, Analytics and Reporting team is freed from mundane reporting requests so they can devote more time to deeper analytics.
  • 1,600 reports have been condensed down to just 20 by using SAS Visual Analytics reports.
The results illustrated in this article are specific to the particular situations, business models, data input, and computing environments described herein. Each SAS customer’s experience is unique based on business and technical variables and all statements must be considered non-typical. Actual savings, results, and performance characteristics will vary depending on individual customer configurations and conditions. SAS does not guarantee or represent that every customer will achieve similar results. The only warranties for SAS products and services are those that are set forth in the express warranty statements in the written agreement for such products and services. Nothing herein should be construed as constituting an additional warranty. Customers have shared their successes with SAS as part of an agreed-upon contractual exchange or project success summarization following a successful implementation of SAS software. Brand and product names are trademarks of their respective companies.