Modernizing Data & Analytics for a Human Services Agency with Oracle Business Intelligence Cloud Solution

The client is a department in one of the major cities in the US and is the central resource for public assistance in the city.

Background

The client faced challenges with their existing data management systems, which were scattered across multiple platforms and databases. This fragmentation hindered their ability to access pertinent and reliable data in a timely manner. As a result, the client recognized the need for an integrated solution that would streamline data collection, processing, storage, reporting, and analysis, enabling them to retrieve and share essential managerial information more efficiently throughout the organization.

 

To address these issues, the client embarked on a project to implement a new Business Intelligence (BI) solution. This solution aimed to support their strategic analytical reporting and analysis initiatives, as well as provide improved operational reporting capabilities. By adopting a comprehensive BI system, the client sought to consolidate their disparate data sources, enhance data accessibility, and enable faster and more accurate decision-making processes.

DiLytics’ Solution

DiLytics implemented Oracle Analytics Cloud solution: 

  • For Employment Services Business Group: providing reports/dashboards related to case load, work eligibility, time on aid, welfare to work 
  • For Benefits Net Business Groups: providing reports/dashboards related to customer satisfaction, phone call handling, error rate and quality assurance, application processing, accuracy and errors, staff shrinkage

DiLytics solution included: 

  • Designing and developing a relational star schema-based data warehouse to integrate data from multiple sources 
  • Designing and building Extract Transform Load (ETL) mappings from the relevant fields in the tables to integrate data into the relational star schema-based data warehouse
  • Implementing Oracle Analytics Cloud business model to create KPIs, Metrics and dimensional attributes from the relational data warehouse
  • Creating reports/dashboards in Oracle Analytics Cloud leveraging the business model
  • Training the Business users and the IT team 

Results

The initiative delivered a broad range of business benefits, including:

  • Greater Insight into program metrics, task performance, program effectiveness and efficiency with ability to perform ad hoc analysis
  • Improved productivity and ease-of-use of report generation by replacing multiple tools with a unified one
  • Improved speed-to-delivery of analytical reports for IT, planning, and programs staff

Technical Stack

Data Sources: Customer Information System (CIS), Avaya, Qflow, Livelink, iTasks 

Data Integration: Microsoft SQL Server Integration Services (SSIS) 

Data Warehouse: Oracle Database Cloud Service (DBCS)

Data Visualization Tool: Oracle Analytics Cloud

DiLytics Delivers

View all Success Stories →

Manufacturing Analytics

DiLytics implemented a Manufacturing Analytics solution for a Biotechnology Company in a short period of 100 days.

Enterprise Data Warehouse Implementation Enabled Better Business Performance

DiLytics implemented a custom data warehouse solution for a Leading Container Leasing Company in a short span of 150 days.

Center of Excellence

DiLytics established a Business Intelligence Center of Excellence to help a Video Game and Digital Entertainment Company maximize RoI.