[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_1766980857859{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1766980840018{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1766980819969{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Business Intelligence Application Enhancements Improved Business Decision Making
[/vc_column_text][vc_column_text css=”.vc_custom_1766979447905{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client is an independent special district that provides high-quality drinking water, reliable sewage collection and treatment, ground-breaking recycled water programs, and environmentally sound urban runoff treatment to its customers. [/vc_column_text][vc_column_text css=”.vc_custom_1766979502874{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]
Background
[/vc_column_text][vc_column_text css=”.vc_custom_1766979552586{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client had implemented Oracle E-Business Suite (EBS) in the year 2011 as its Enterprise Resource Planning (ERP) system. It had also implemented Oracle Analytics as its Business Intelligence (BI), Analytics, and Reporting platform in the same year. Oracle BI Applications version 7.9.6.2 (OBIA) was deployed on top of the Oracle Analytics platform (Release 10g) to provide analysis of data from EBS and used Informatica 8.6.1 as the Extract, Transform, Load (ETL) tool.[/vc_column_text][vc_column_text css=”.vc_custom_1766979658007{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]
DiLytics’ Solution
[/vc_column_text][vc_column_text css=”.vc_custom_1766979699881{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics has had a long-standing relationship with the client. DiLytics has been an integral part of the client’s analytics journey across different engagements, briefly described below:[/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_1766979848339{margin-bottom: 10px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- 2015-2016: Performed OBIA upgrade from 7.9.6.2 to 11.1.1.9.2 that included:
[/rt_list_style][vc_column_text css=”.vc_custom_1766979793188{margin-top: 0px !important;margin-bottom: 10px !important;padding-left: 55px !important;}” el_class=”text-block”]– Technical Discovery
– Upgrade of data warehouse & BI
– Migration of BI repository, web catalog and security
– Upgrade of ETL mappings
– Migration of configuration & loading data [/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_1766980000476{margin-bottom: 10px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- 2016: Implemented Human Resources Analytics:
[/rt_list_style][vc_column_text css=”.vc_custom_1766979950852{margin-top: 0px !important;margin-bottom: 10px !important;padding-left: 55px !important;}” el_class=”text-block”]– Demographics
– Employee Assignment Details
– Employee Turnover
– Employee Separation
– Performance Rating
– Benefits
– Payroll [/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_1766980171133{margin-bottom: 10px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- 2017-2019: Installed DR Instance for Oracle BI Applications; implemented reports and dashboards in the following functional areas:
[/rt_list_style][vc_column_text css=”.vc_custom_1766980109931{margin-top: 0px !important;margin-bottom: 10px !important;padding-left: 55px !important;}” el_class=”text-block”]– Engineering
– Purchase
– Inventory
– Human Resources
– General Ledger
– Payables
– Payroll
– Budgeting [/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_1766980352687{margin-bottom: 10px !important;}” list_extra_class=”text-block”]
- 2019 Onwards: Providing analytics application support for objects such as:
[/rt_list_style][vc_column_text css=”.vc_custom_1766980308765{margin-top: 0px !important;margin-bottom: 35px !important;padding-left: 55px !important;}” el_class=”text-block”]– Reports and dashboards
– Metrics and Attributes
– Data Model and Data Integration [/vc_column_text][vc_column_text css=”.vc_custom_1766980401352{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Business Benefits
[/vc_column_text][vc_column_text css=”.vc_custom_1766980993604{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]Key business benefits to the client 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_1766980498592{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Improved business decision-making via the enablement of insights across business areas
- Availability of consolidated and updated technology stack empowered end users, reduced costs and allowed clients to up-take new capabilities.
- High quality of service across a wide spectrum of analytics areas at an economical cost from a dependable partner
[/rt_list_style][vc_column_text css=”” el_class=”text-block”]
Technical Stack
[/vc_column_text][vc_column_text css=”” el_class=”text-block”]Source System(s): Oracle EBS
Data Integration Tool: Oracle Data Integrator (ODI)
Monitoring Tool: Oracle BI Data Warehouse Administration Console (DAC)
Reporting Tool: Oracle Analytics, Oracle Analytics Cloud (OAC)[/vc_column_text][vc_column_text css=”” el_class=”text-block”]
What Does the Client Say?
[/vc_column_text][vc_column_text css=”.vc_custom_1766980710872{margin-bottom: 0px !important;}” el_class=”text-block”]“DiLytics team is very competent and professional. They did an excellent job performing our Oracle BI upgrade. We were very satisfied with the work completed. DiLytics completed the work in accordance with the scope of work and the services were provided accurately and in a competent manner. They are very thorough with research and verification of content. The work was completed on time and within budget. DiLytics provides superior professional expertise with Oracle BI.” – Executive Director of Finance and Administration [/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=”” 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]