Dickinson College Integrates and Analyzes Data Using Rapid Insight

  • By Dian Schaffhauser
  • 01/05/09

Dickinson College has implemented Rapid Insight Analytics and Data Integration software to help predict student enrollment, financial aid allocation, diversity, class size, and other operational variables using data analysis and integration applications.

"Accuracy is absolutely critical when analyzing student enrollment against the average tuition each student will pay, financial aid included," said Mike Johnson, director of institutional research. "If we miss that calculation, called the discount rate, by as little as one percent, we're talking about a half million dollars. Rapid Insight Analytics and Data Integration allow us to look at more data in more ways to get a more precise view of these figures so we can strike the right balance."

Dickinson uses Data Integration to pull data from different departments stored on different servers into one repository. "Data Integration gives me transparent sourcing, allowing me to access all of my systems including Banner, Cognos, and Recruitment Plus," said Johnson. His team uses the software's graphical interface to drag and drop icons and use arrows to connect the data sources in order to perform a number of functions, including merge, filter, cleanse, aggregate, de-dupe, flatten, append, sort, and rename.

Additionally, the college uses Rapid Insight Analytics to automate such operations as exploratory analysis, predictive modeling, profiling, automated scoring, univariate analysis, and reporting for PowerPoint presentations. The software has allowed users to complete some internal and external reports, including for the Integrated Postsecondary Education Data System (IPEDS), in hours instead of weeks. "I live by automated reports," said Johnson. "Since there is almost no opportunity for human error, I have confidence in the answers and can explain them fully in understandable terms. That confidence has helped grow our wish list of things to study."

Among those new analyses Johnson would like to conduct are a more detailed study of alumni to help the development office better prioritize whom to approach for annual giving and a more comprehensive look at common traits of the few students who leave the institution before graduation to help reduce that number.

The college, located in Carlisle, PA, has 2,353 students.

About the Author

Dian Schaffhauser is a former senior contributing editor for 1105 Media's education publications THE Journal, Campus Technology and Spaces4Learning.

Featured

  • abstract illustration of a glowing AI-themed bar graph on a dark digital background with circuit patterns

    Stanford 2025 AI Index Reveals Surge in Adoption, Investment, and Global Impact as Trust and Regulation Lag Behind

    Stanford University's Institute for Human-Centered Artificial Intelligence (HAI) has released its AI Index Report 2025, measuring AI's diverse impacts over the past year.

  • modern college building with circuit and brain motifs

    Anthropic Launches Claude for Education

    Anthropic has announced a version of its Claude AI assistant tailored for higher education institutions. Claude for Education "gives academic institutions secure, reliable AI access for their entire community," the company said, to enable colleges and universities to develop and implement AI-enabled approaches across teaching, learning, and administration.

  • lightbulb

    Call for Speakers Now Open for Tech Tactics in Education: Overcoming Roadblocks to Innovation

    The annual virtual conference from the producers of Campus Technology and THE Journal will return on September 25, 2025, with a focus on emerging trends in cybersecurity, data privacy, AI implementation, IT leadership, building resilience, and more.

  • From Fire TV to Signage Stick: University of Utah's Digital Signage Evolution

    Jake Sorensen, who oversees sponsorship and advertising and Student Media in Auxiliary Business Development at the University of Utah, has navigated the digital signage landscape for nearly 15 years. He was managing hundreds of devices on campus that were incompatible with digital signage requirements and needed a solution that was reliable and lowered labor costs. The Amazon Signage Stick, specifically engineered for digital signage applications, gave him the stability and design functionality the University of Utah needed, along with the assurance of long-term support.