Information Builders > 实例探究 > State of California Deploys WebFOCUS

State of California Deploys WebFOCUS

Information Builders Logo
公司规模
1,000+
地区
  • America
国家
  • United States
产品
  • WebFOCUS
  • iWay Software
  • Information Builders Consulting
技术栈
  • Microsoft SQL Server 2000
  • Microsoft Access
  • Web-based reporting environment
实施规模
  • Enterprise-wide Deployment
影响指标
  • Cost Savings
  • Productivity Improvements
技术
  • 分析与建模 - 实时分析
  • 应用基础设施与中间件 - 数据交换与集成
适用行业
  • 医疗保健和医院
适用功能
  • 商业运营
用例
  • 质量预测分析
  • 实时定位系统 (RTLS)
服务
  • 软件设计与工程服务
  • 系统集成
关于客户
The California Department of Health Services (DHS), with over 5,000 employees, is one of the largest departments in the state’s government. The department is responsible for administering a variety of programs that keep residents safe and healthy. These programs are related to issues such as AIDS, drinking water quality, food and drug inspections, and other programs that keep Californians healthy and safe. Program managers need to complete those missions, and they must make decisions about how to spend state budgets at every step along the way.
挑战
The California Department of Health Services (DHS) was facing a challenge in making it easier for program managers to stay on budget by accelerating access to critical financial data. The department was using a variety of software applications to help managers stay on budget. However, the speed at which users could get the information they needed and react was not satisfactory. The department was using the California State Accounting and Reporting System (CALSTARS) – a mainframe accounting system developed in the early 1980s. CALSTARS is a powerful and comprehensive system, but its limited reporting functionality made it difficult for budget managers to obtain specific information when they needed it most. The department wanted to enhance its support services to keep up with the growth of the state.
解决方案
The California DHS deployed Information Builders technology to deliver a real-time view of financial data directly to the desktops of more than 5,000 DHS employees. The Web-based solution includes an expenditure forecast reporting system that allows program managers to project end-of-fiscal-year balances so they can avoid overspending. They used iWay technology to create several ETL processes for accessing VSAM, Adabas, and sequential flat files, transforming it into the correct format, and loading it into a Microsoft SQL Server 2000 database structured for reporting. The development team also created two WebFOCUS applications to report against the data: the CALSTARS Online Reporting Environment (CORE) and the Expenditure Forecast Reporting System (EFR).
运营影响
  • Users can instantly access financial data needed to accomplish directives.
  • Managers can forecast results of monthly expenditures to get an accurate prediction of year-end balances.
  • Accounting professionals can obtain month-end reports one week sooner than before.
  • The DHS has improved its analysis capabilities by enabling managers to sort, summarize, and drill down on information as required, as well as export data directly into Excel for further analysis.
数量效益
  • The department has saved an estimated $1 million in paper and printing costs alone.
  • The improved efficiency of thousands of state employees is considered as an over-all savings.

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 的任何营销电子邮件。
提交

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