[vc_section full_width=”stretch_row” css=”.vc_custom_1532085157436{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;background-color: #ffffff !important;}”][vc_row full_width=”stretch_row” css=”.vc_custom_1764307075966{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 50px !important;padding-bottom: 10px !important;}”][vc_column css=”.vc_custom_1764303433160{padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1764325320340{margin-top: 0px !important;}” el_class=”text-block”]

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

[/vc_column_text][vc_column_text css=”.vc_custom_1764302183926{margin-top: 0px !important;}” el_class=”text-block”]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.[/vc_column_text][vc_column_text css=”.vc_custom_1764302162676{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Background

[/vc_column_text][vc_column_text css=”.vc_custom_1764302243661{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]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.[/vc_column_text][vc_column_text css=”.vc_custom_1764302302795{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

[/vc_column_text][vc_column_text css=”.vc_custom_1764302355886{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics implemented Oracle Analytics Cloud solution: [/vc_column_text][rt_list_style list_style=”seven” list_content=”

• List Item Text One
• List Item Text Two
• List Item Text Three

” list_css=”.vc_custom_1764302728070{margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• 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

[/rt_list_style][vc_column_text css=”.vc_custom_1764302493493{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics solution included: [/vc_column_text][rt_list_style list_style=”seven” list_content=”

• List Item Text One
• List Item Text Two
• List Item Text Three

” list_css=”.vc_custom_1764325347439{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• 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 

[/rt_list_style][vc_column_text css=”.vc_custom_1764325360705{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Results

[/vc_column_text][vc_column_text css=”.vc_custom_1764302825370{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]The initiative delivered a broad range of business benefits, including:[/vc_column_text][rt_list_style list_style=”seven” list_content=”

• List Item Text One
• List Item Text Two
• List Item Text Three

” list_css=”.vc_custom_1764303645722{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• 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

[/rt_list_style][vc_column_text css=”.vc_custom_1764303000065{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Technical Stack

[/vc_column_text][vc_column_text css=”.vc_custom_1764303075772{margin-top: 0px !important;margin-bottom: 0px !important;}” el_class=”text-block”]

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

[/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1684237429473{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 35px !important;background-color: #ffffff !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column width=”1/3″ css=”.vc_custom_1531997568277{margin-top: 0px !important;margin-bottom: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][/vc_column][vc_column width=”1/3″][vc_column_text css=”.vc_custom_1764303465338{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

DiLytics Delivers

[/vc_column_text][/vc_column][vc_column width=”1/3″][vc_custom_heading text=”View all Success Stories →” font_container=”tag:h6|font_size:16px|text_align:right|color:%23dd3333|line_height:26px” use_theme_fonts=”yes” css=”.vc_custom_1660717315754{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”font-weight-medium” link=”url:https%3A%2F%2Fdilytics.com%2Fsuccess-stories%2F|title:Success%20Stories”][/vc_column][vc_column css=”.vc_custom_1661424713241{margin-bottom: 25px !important;}”][rt_case_study_style case_study_style_variation=”seven” case_study_display_filter=”no” case_study_enable_title=”yes” case_study_enable_excerpt=”yes” case_study_spacing=”30″ case_study_looping_sort=”ASC” no_of_case_studies=”3″][/vc_column][/vc_row]