CONSULTING
SOLUTIONS
PARTNERS
RESOURCES
CORPORATE
Twitter Facebook LinkedIn
Email [email protected]
Phone +1 713.457.7474

RESOURCES CATEGORY: Company News

High-Value Health Check to Enhance Existing BI Solutions

NWS

PREDICTif Delivered a High-Value Health Check to Enhance Existing BI Solutions and Develop a Master BI Implementation Plan

CUSTOMER:

A leading Oil and Gas Equipment services company.

REQUIRED CAPABILITIES

  • Remedied performance and instability issues existed with the BI applications
  • Delivered a master Implementation roadmap for an enterprise BI and FPM architecture

CHALLENGES

The customer has over 25 subsidiaries, many acquired through acquisition. Each subsidiary had built out its own business intelligence (BI) and finance performance management (FPM) solutions using a myriad of BI and FPM products. As one of the leading global equipment service and pipeline construction companies, the customer faced numerous challenges related to instability, inconsistency and slow performance of BI applications. In preparation for the opportunities and demands of becoming part of a publicly held company, the customer needed to expand its BI and FPM architecture beyond the business unit level.  Before further expansion could take place, the customer needed to consolidate their division level BI and FPM initiatives as well as map out a strategy and roadmap to establish an enterprise BI architecture. The existing BI systems presented numerous deficiencies in terms of people, process and infrastructure:

  • All its business units had their own BI and FPM technologies, support teams and project initiatives without an enterprise level governance and standard;
  • There was no single version of truth in terms of data on the enterprise level which rendered the enterprise level reporting and financial consolidation inaccurate and labor intensive;
  • The existing BI infrastructure contained a myriad of technologies and products making support and maintenance difficult and cost of ownership extremely high; and
  • Lack of a BI competency center rendered uneven quality of delivered BI applications that resulted in slow performance and instability.

SCOPE                      

Conducted a health check to identify areas of risks and opportunities, recommend remedial measures, and produce a master implementation plan and a roadmap to build an enterprise level BI architecture.

  • Examined existing BI infrastructure and organizations in terms of people, process and infrastructure to discover areas of risks and opportunities, and more importantly, produce a list of actionable recommendations to improve the overall BI strategy and execution;
  • Reviewed the existing architecture, configurations and codes;
  • Identified bottlenecks that were causing slow performance and instability;
  • Aligned business objectives and priorities with BI initiatives;
  • Created organizational philosophy and culture to support an enterprise BI strategy; and
  • Developed a master implementation plan and roadmap for an enterprise level BI architecture.

SOLUTION

PREDICTif Solutions was engaged to provide a 2-week health check. PREDICTif’s senior architects reviewed the existing BI infrastructure, made recommendations for improvement and delivered a master implementation plan for rolling out BI to the entire enterprise.

Based on PREDICTif’s standard health check agenda and customer priorities, PREDICTif and the customer created a detailed agenda before the engagement. The agenda addressed both tactical and strategic aspects of the customers business. The tactical aspects were to analyze the existing BI solutions to identify areas of risk and opportunity as well as provide recommendations on both. The strategic aspect was to understand the customer’s business priorities and deliver an enterprise BI implementation plan.

The two week agenda was filled with workshops, interviews and document reviews during which, PREDICTif’s architects met customer’s personnel from numerous areas of the business to discuss business objectives, current BI architecture and business user concerns. Conversations focused on areas such as data quality, data governance, data modeling, report requirement gathering processes, architecture, support/maintenance and technology best practices. The architects also discussed future plans, business initiatives, short term and long term business goals as well as technological direction in the BI and FPM arena.

The PREDICTif resources combined our own set of BI and FPM best practices and standards with information gathered from the discussions in order to produce a  set of documents:

  • The tactical health check deliverable is in the form of a Microsoft Word document and a Microsoft PowerPoint presentation both of which outlined areas of opportunity, improvement and identified risks as well as the necessary steps to mitigate those risks.
    • In this case, the PREDICTif architects discovered that the BI architecture was not designed appropriately for the increased number of users and business cases which caused significant degradation of performance and stability;
    • The customer did not have a well defined data governance process that was accepted by all business units. It resulted in poor data and metadata modeling as well as an overall lack of data quality and transparency;
    • The architects made recommendations to improve the Bi architecture in terms of performance and stability; and
    • The architects applied PREDICTif developed and tailor-made data governance and data modeling best practices to the customer’s business and IT environment.
  • A master BI implementation plan and roadmap was delivered in order to consolidate the dispersed BI architecture as well as establish an enterprise level BI infrastructure.
    • The implementation plan entailed a multi-phased project plan that detailed the sequence of activities, dependencies and high-level estimate of effort as well as timelines;
    • It illustrated a 18-month BI architecture evolution through the phases of implementation;
    • The roadmap also considered the trend and best-in-class BI technologies; and
    • The implementation plan included the steps to establish an enterprise level BI competency center and governance process.

RESULTS

PREDICTif delivered considerable value to the customer’s return on the software and IT infrastructure investment. The health check’s findings and recommendations significantly improved both the performance and the stability of the customer’s existing BI architecture. The implementation plan provided a clear roadmap to establish an enterprise level, world class BI architecture.

  • The improvement decreased the rendering time of a complex report from an average of 6 min to less than 30 seconds, greatly increasing the productivity;
  • The upgrade and addition of hardware and software instance increased the overall uptime from 95% to that of 99% which was a requirement of the business;
  • The customer completed all three phases of PREDICTif’s recommended implementation plan and the overall BI initiatives continue to gain adoption and approval from the business use population.

EPM Success for Geophysical Survey Company

NWS

PREDICTif  successfully assists major geophysical survey company to select the right Enterprise Performance Management product for its financial reporting and analysis needs

CUSTOMER:

A leading seismic data-acquisition imaging and software systems company who assists petroleum exploration companies to identify and measure subsurface geological structures.

REQUIRED CAPABILITIES

  • Financial consolidation and reporting
  • Interactive analysis
  • Forecasting and Budgeting
  • Oracle Hyperion Planning, Essbase, Financial Reporting, Financial Data Management

CHALLENGES

The Customer used an out-dated solution that was under-utilized and deficient in terms of data mining and planning automation. As a result, the business was heavily dependent upon IT for both support of its existing solution and development of new functionality when the enterprise required. The software deployed was also 2 major versions behind that of the publicly released version and had run out of vendor support. Significant growth in its Solutions business units served as a catalyst to replace its manual, error-prone, labor intensive financial reporting and planning solution with a more automated, streamlined and efficient one.

The company, comprised of multiple legal entities that span the globe, was challenged with having to manage all of its financial operations in a single, multicurrency environment. It also had needs to transform individual financial plans from a group of entities into a single, consolidated corporate level plan.  All this made the existing solution severely limiting in terms of the ability to predict its revenue and costs for each of its business units.

SCOPE

Needing objective and unbiased professional advice on various EPM solutions on the market, the Customer engaged with PREDICTif who led a rigorous product selection process to ensure that they procured the right EPM product for its current and future needs. The overall goal was to assist the Customer in identifying an EPM product that met its current and future business needs:

  • Integrate seamlessly with its main ERP solution (Infor’s Syteline), its existing Microsoft SQL Server based data warehouse and miscellaneous data sources;
  • Upgrade its antiquated and unsupported EPM architecture to a modern and sustainable one;
  • Automate and streamline its financial reporting and planning processes eliminating manual, redundant and time-consuming steps;
  • Enable drill-downs and what-if analysis for gaining insight and better financial plans;
  • Establish a single version of the truth and generate accurate/ up-to-date reports;
  • Leverage both web and Excel as available interfaces for ad-hoc analysis, interactive report authoring and viewing;
  • Offer an easy-to-learn and easy-to use tool that enables the business to achieve self-sufficiency; and
  • Ensure long term, advantageous total cost of ownership.

 

SOLUTION

PREDICTif led a systematic product selection process leveraging its extensive experience with EPM solutions, vertical specific evaluation criteria and its own, proprietary production selection templates to ensure a thorough evaluation was undertaken. PREDICTif led the preparation of the PoC, the coordination of the vendors and finally, the short-listing and evaluation/selection of vendors who best addressed Customer’s business requirements.

Over the course of the evaluation, PREDICTif:

  • Assisted the Customer in its identification of the appropriate use cases that addressed all critical business needs;
  • Prepared the use case documentation and accompanying data;
  • Worked with Customer personnel in order to facilitate software vendors’ involvement in the PoC;
  • Supported the Customer as needed throughout their participation in the evaluation process;
  • Administered the different software vendors’ PoC’s and validated their results;
  • Incorporated PREDICTif’s proprietary software evaluation process and compared/contrasted its weighted scoring criteria against that of the differing, competing vendor technologies;
  • Led vendor’ demos and meetings in an effort to contribute towards the information gathering process;
  • Provided cost estimates for license and implementation costs; and
  • Produced a high level roadmap and long term implementation plan for each technology so that the Customer understood not only the current state, but also the future vision of the chosen technology.

The PoC was conducted in parallel by three vendors over the course of a two-week period.  We aggregated all the gathered information and then, used PREDICTif’s weighted software selection criteria to contrast that against the Customer’s business objectives to render an option on a best of breed solution.

After evaluating several leading vendors, Oracle Hyperion/Essbase was selected for a number of reasons:

  • Oracle Hyperion Enterprise Performance Management (EPM) software meets the key business requirements, enables the automation of planning and reporting processes and powers the finance team to perform data mining and ad-hoc analysis;
  • Oracle Hyperion is easy to use, easy to implement and easy to support/maintain;
  • It is a cost effective, high return investment, conducive to quick wins, resulting in lower total cost of ownership;
  • It establishes a solid platform for future reporting and analysis needs; and
  • Oracle utilizes updated and modern technologies, presents a strategic product development roadmap and enjoys both financial as well as organizational stability.

RESULTS

Post product selection, the Customer negotiated with Oracle and ultimately procured the Hyperion product stack including Essbase, Hyperion Financial Reporting, Hyperion Planning and Financial Data Manager (FDM). Utilizing the acquired Oracle stack of products, the PREDICTif team successfully implemented and replaced the customer’s outdated solution with that of a new one fully automating countless functions and in the process, eliminating nearly half of the Excel worksheets it previously utilized resulting in increased productivity. Additionally, PREDICTif:

  • Upgraded the customer’s financial reporting and analysis architecture to a modern and fully supported technology;
  • Increased the architectures performance resulting in a more robust and stable environment;
  • Eliminated a multitude of manual, error-prone and time-consuming steps resulting in a more efficient and accurate financial analysis and reporting process;
  • Delivered to the business users the ability to do ad-hoc analysis and create their own reports;
  • Delivered a solution to the business that the customer personnel were able to support and maintain without significant IT support or involvement; and
  • Provided the business a solution that resulted in a significant return on investment.

Oracle BI Enterprise edition solution for UK Based Leeds Teaching Hospitals

NWS

Leeds Teaching Hospitals NHS Trust Builds Budget Reports Six Times Faster, Achieves 100% ROI in 12 Months

CUSTOMER:

Leeds Teaching Hospitals National Health Service (NHS) Trust is one of the largest hospital systems in the United Kingdom and includes Europe’s largest teaching hospital. The trust provides acute services for the population of Leeds; is a regional center for specialist services, including cancer and cardiac surgery; and treats more than 1 million patients each year.

CUSTOMER QUOTE:

“Oracle Business Intelligence Enterprise Edition enabled us to move to a balanced scorecard approach for strategy management and planning. The insights it provides will be critical to our ability to identify where we can make operational savings of US$33 million each year for the next four years while continuing to deliver excellent quality healthcare to the public”

Robert Angel, Assistant Director of Finance, Leeds Teaching Hospitals NHS Trust

CHALLENGES

Consolidate financial and non-financial clinical and corporate data from all hospital departments into balanced scorecards to monitor performance against national and local indicators, deliver timely and accurate statistical returns to the Department of Health and central NHS, and achieve near 100% accuracy for strategic planning

Allow senior clinicians in radiology, neurology, oncology, trauma, orthopedics, pathology and analysts to access and interrogate real-time cost and performance statistics for the medical procedures carried out by their departments, identify the cost of each patient episode, and compare costs and outcomes between departments

Enable hospital managers to drill down into financial data on both clinical spend and non-clinical expenses, such as administration, catering, cleaning, utilities, and estate management, and enable analyzing multi period extracts of expenses in each area and identifying variances against the plan

Minimize training requirements for nontechnical medical and administrative staff and deliver new analytical and reporting capabilities at the speed of user and business demand

Meet government target of saving US$33 million for the next four years without negatively impacting critical factors, such as the availability of beds, wait times for appointments with consultants, timeliness of operations, and the quality of patient care

Solutions

Used Oracle Business Intelligence Enterprise Edition to deliver personalized budget and Leeds Teaching Hospitals NHS Trust

Nominal roll reports via monthly dashboard e-mails, delivering extensive management reports to 750 clinical and nonclinical cost center managers from all disciplines

Enabled Corporate Finance to see individual transactions in just a few clicks, using Oracle Business Intelligence Answers to drill down from high-level summary to journal and subledger details, accessing scanned-in invoices from links embedded in the dashboard e-mail

Enabled all budget holders to render up to eight reports simultaneously on a single page in approximately three seconds, a process that took up to six minutes with the legacy system and involved opening multiple workbooks Gained immediate adoption from previously resistant users who gained competency with minimal training

Leveraged Oracle Business Intelligence Enterprise Edition’s intuitive development tools so key users could build new reports, meeting rapidly expanding user demand in 5 to 30 minutes instead of three to four hours using legacy tools

Used drag-and-drop functionality to feed quarterly balance sheet statements and statistics from the enterprise resource planning (ERP) system and other sources into Oracle Business Intelligence Enterprise Edition

Conducted rapid modeling of complex data to compile balanced scorecards

Benefited from Oracle Business Intelligence Answers to shift the focus from extracting data to gaining timely business knowledge

Studied period-on-period comparisons and analyzed price and volume element variances to assist forecasting and future planning with 99.9% accuracy for outturn projections based

Benefited from Oracle Business Intelligence Answers to shift the focus from extracting data to gaining timely business knowledge

Studied period-on-period comparisons and analyzed price and volume element variances to assist forecasting and future planning with 99.9% accuracy for outturn projections based on half yearly figures when tested on historic data over a three-year period

Conducted detailed spend analyses to determine how best to achieve US$33 million annual savings while minimizing impact on front-line services

Gained 100% payback on investment in Oracle Business Intelligence Enterprise Edition within 12 months, an outstanding achievement for a complex and large-scale solution

Progressed with Oracle Business Intelligence Delivers roll out to provide budget holders with automated e-mail alerts if KPI thresholds were being exceeded, facilitating exception-based management

Committed to further roll out of Oracle Business Intelligence Enterprise Edition to all hospital departments within two years

Leeds Teaching Hospitals National Health Service Trust chose Oracle over alternative business intelligence solutions for its unrivalled functionality and scalability and because it could extract data from multiple sources without manual intervention.

“The leading competitor tools that we evaluated could not offer automated data extraction. It would have taken an IT team member around one-and-a-half days per month to manually extract the data into spreadsheets and load it into the solution for analysis with alternative solutions. Or we would have been looking at solutions where revenue costs increased with each step change in functionality or data refresh,” Robert Angel, Assistant Director of Finance, Leeds Teaching Hospitals NHS Trust.

email [email protected]
phone +1 713.457.7474
Twitter Facebook LinkedIn
© PREDICTif Solutions. All rights reserved.