实例探究 > Westminster College Breaks Through Data Boundaries with Informer

Westminster College Breaks Through Data Boundaries with Informer

公司规模
Mid-size Company
地区
  • America
国家
  • United States
产品
  • Informer
技术栈
  • SQL
  • MultiValue Database
实施规模
  • Enterprise-wide Deployment
影响指标
  • Productivity Improvements
  • Customer Satisfaction
  • Employee Satisfaction
技术
  • 应用基础设施与中间件 - 数据可视化
  • 分析与建模 - 预测分析
  • 应用基础设施与中间件 - 数据交换与集成
适用行业
  • 教育
适用功能
  • 商业运营
服务
  • 软件设计与工程服务
  • 系统集成
关于客户
Westminster College is an educational institution that faced significant challenges with its data reporting and integration systems. The college had a SQL database for the admissions office and a MultiValue database for the rest of the campus, leading to data integrity and integration issues. The existing reporting system was static and required IT intervention for every new report, consuming a lot of time and resources. The college sought a solution that would empower users to create and customize reports independently, thereby saving time and improving efficiency.
挑战
Kyle Rima, Database Administrator at Westminster College researched reporting options for about a year and had finally given up, deciding to stay with colon prompt reporting. However, users still suffered as these reports lacked interactivity, were in a static format, and requests had to be made to IT each time a new report was needed. As a result, creating reports took up a lot of IT’s time. Alternate reporting solutions they tested were very expensive, extremely time consuming to setup, and not user friendly. In addition, like many schools, Westminster has a SQL database for the admissions office and a MultiValue database for the rest of campus and struggle with data integrity and integration issues between the two systems.
解决方案
When Westminster discovered Informer in 2006, they were immediately impressed by the simplicity, ease of setup, and flexibility. Users have created reports in Informer that look at the data between the two systems to uncover discrepancies. They use Informer’s calculated columns feature to compare data coming from both systems, and then sort and group report data on select fields to easily see errors. They are also using Informer to pull status reports for both systems. 'Possibly the nicest thing is having all reports accessible from one consolidated place', says Rima. Informer enabled Westminster to push report creation out to more users, and empower users to modify and customize reports based on their individual needs. 'The ability to export data easily has been great and the ability to schedule reports is awesome', says Rima.
运营影响
  • Many users are now able to create 90% of their reports on their own, reducing the dependency on IT.
  • Informer has made it easier to uncover discrepancies between multiple database systems in one place.
  • The ability to export and schedule reports has been highly beneficial.
  • The ease of setup and use has led to widespread adoption across the campus.
  • The consolidated reporting system has saved significant time for both users and IT staff.
数量效益
  • In the month of September, they ran 5,761 reports.
  • They have 90 scheduled reports just from their main database, with many more from their alumni database.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。