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

RESOURCES CATEGORY: Reporting & Dashboarding

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.

Scalable financial reporting solution for healthcare management

NWS

PREDICTif delivered a scalable financial reporting solution for a leading health management services and equipment company

CUSTOMER:

A leading health management and diagnostic services and equipment company.

REQUIRED CAPABILITIES

  • Financial consolidation and reporting
  • Interactive analysis
  • Forecasting and Budgeting
  • Cognos TM1 Web

CHALLENGES

As one of the leading construction multimedia companies, this customer is faced with the following challenges: inefficient central financial reports, reliance on manual inputs, and cumbersome Excel intensive reporting tool. With financial data coming from 8 different data sources, a central reporting tool to consolidate all the reports is needed. The business is presented in six platforms and each platform gets the data from its own data source.

The chart of accounts is compiled from a string with over 20 characters.  The accounts dimension hierarchy was set up in such a way as to hinder reporting leading to miss interpretation of data and errors in reports.  Each of the six platforms has their own chart of accounts and reporting method making it difficult to consolidate in a single tool. Therefore, a lot of manual methods are involved in creating reports.   Heavy reliance on Microsoft Excel to input budgeting data is present.  As a Solution, PREDICTif Solutions proposes an end to end solution to centralize the financial reporting system to provide budgeting and forecasting for the organization.

SCOPE

  • The objective of the project was to deliver a solution that leveraged TM1’s in-memory OLAP capabilities and simplified the monthly financial consolidation and reporting process.
  • Centralized, efficient and ease of use access application which can reduce preparation time. Instead of spending time on preparing reports, users can now focus on analyzing data.
  • Instill ‘one version of the truth’ consolidation reporting system that can be applied to six platforms
  • Provide a proficient budgeting and forecasting web based process that allows users to input data at the line item level.
  • Give ability to end users to build and analyze reports without reliance on IT or the Accounting department

SOLUTIONS

After evaluating several world class solutions, IBM Cognos TM1 was selected for a number of reasons – one of them being that IBM Cognos TM1 provides a real-time approach to consolidating, viewing, and editing enormous volumes of multidimensional data.

PREDICTif was engaged to provide an end-to-end solution delivering 25 Cubes with dimensions ranging from 5 to 15 in order to provide Financials and Assumptions models. Changes in financial forecasts, assumption metrics and indirect expenses were made via customizable Excel templates as well as directly through the TM1 interface.   Reports created both in TM1 and Excel were readily accessible through the web with no additional effort.

  • PREDICTif Solutions was able to create a set of multidimensional cubes utilizing OLAP technology that can dynamically slice and dice through data sources.
  • Design a user-friendly excel input templates which can access through TM1 web. The cubes support consolidation and reporting of both budgeting and forecasting data as well as allocation.
  • An automated data extraction using by TI processes (ETL) tool that can update multi dimensional cubes from 8 different data sources.
  • Users can use dimension editor as primary method to maintain or update dimensions that are not from the source system
  • Setting up different instances for security purposes and separate the finance consolidation modules, budgeting applications and compensation modules will be given access by corporate controller.
  • Substantially reduce time spend on creating monthly financial reports. Reports are easily access and produce with little or no reliance on the accounting and IT department.
  • Provide a real-time consolidation reports and offer an automated tool for producing annual budget and monthly forecast process.
  • Eliminate manual effort and errors of gathering data from multiple reports, spreadsheet and data sources
  • Provide power users training and knowledge transfer to the client so they will be able to build additional reports, budget templates and forecasting procedures out of the cubes.

RESULTS

PREDICTif solutions delivered measurable results to the client.  Now the client is able to provide “one version of the truth” in their reporting system.  Customers can now use the centralized financial reporting cube to analyze data across six platforms and they now have an automated ETL process to update dimensions and cubes from 8 different data sources.  The TM1 web based input budgeting and forecasting system also allows users across the enterprise system to input data at the line item level.  The application significantly speeds up the budgeting and forecasting process and empowers users to create or modify input templates without IT department influence.

  • With the deployment of the TM1 solution, the number of hours spent generating consolidated financial statements were reduced considerably, allowing more time for analysis;
  • Multiple disparate business units were brought together under one streamlined reporting process with a standardized company-wide output;
  • The finance group supported and upgraded the solution and the accompanying infrastructure through its own staff, without dependence on the IT support; and
  • Consolidated financial reports have obtained further reach as a result of the use of TM1 web.

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.

Business Intelligence (BI)

BLG

Business intelligence (BI), once a competitive differentiator, is now a commodity. Most companies have implemented BI solutions that provide historical reporting, dashboarding, metrics and scorecarding for past events. Companies know what has happened but the ability to know what will happen will be the competitive advantage that companies need to excel in this volatile and ultra-competitive environment. Predictability is the next step in the evolutionary process of Business Intelligence.

Traditional Business Intelligence and data warehousing focus on strategic, long term decision support. While strategic Business Intelligence continues to be a requirement to support long range vision, Predictive Business Intelligence (PBI) takes business Intelligence beyond a process that has traditionally looked backwards and has been reactive in nature. PBI empowers the enterprise in realizing competitive advantages and provides the business with the necessary agility to meet the challenges of today’s rapidly changing business environment by mitigating risks and maximizing opportunities. PBI greatly improves both long term strategic decision making and near team operational decisions.

The ability to make Predictive strategic decisions will separate enabled companies from their competition enabling them to capitalize on opportunities and reduce exposure to risk. Statistical analysis on operational and transactional data will provide insightful information on business trends and enable the business to make strategic decisions quickly and more effectively. For example, when a retail chain is determining whether to establish a presence in an unfamiliar territory, it could utilize growth data from other locations and combine it with the local data as well as current projection data to provide support for the decision making. The data might be sketchy and sparse, but statistical analysis will offer a sound basis for decision making. Other examples can be found in oil & gas exploration or pharmaceutical development projects for instance. These projects often entail long development cycles and considerable up-front cost the outcome of which has significant impact on the overall performance of the business. Predictive decision making will enable those companies to analyze more data in order to gain a complete view of the business cases and leverage proven statistical models to aid those impactful decisions. The completeness and quality of the data analyzed are critical to determine the accuracy of the prediction. Although companies in these verticals go to great lengths to develop elaborate risk management models to address common concerns, predictive business intelligence In support of existing risk management processes, provides a richer set of data and more interactive analysis to ensure a better outcome.

 

JB Poindexter makes substantial hardware cost savings thanks to IBM Cognos Express

NWS

With help from IBM Cognos Express and PREDICTif Solutions, JB Poindexter and Co. was able to upgrade, consolidate, and standardize their diverse reporting systems, saving at least $50,000-75,000 a year in hardware costs, and increasing productivity by 100-125%.

CUSTOMER:

J.B. Poindexter & Co., Inc. is a privately held diversified manufacturing company with operating subsidiaries engaged in the production of commercial van bodies, step-vans, funeral coaches, limousines, mid-sized buses, pick-up truck bed enclosures and tonneau covers, precision machined components and expandable foam plastics.

The company operates with a decentralized management and operating structure. Subsidiaries have complete operational, financial and administrative responsibility, with professional and executive management support provided by the corporate staff.

“The highly knowledgeable consultants at PREDICTif understand business intelligence. That’s why they recommended IBM Cognos technology to fit our business needs, technology that we are very happy with. IBM Cognos is intuitive, can be owned and managed by the business, and has amazing reporting, planning, and dashboard features. It also happens to be one of the best bargains on the market.”

Jay Krishnamurthy Vice President-IT, J.B. Poindexter and Co.

CHALLENGES

J.B. Poindexter & Co. has grown significantly in the last few years, acquiring six separate business units. As each unit maintained its own staff, product lines, customers, as well as its own ERP system, reporting processes were difficult to manage. The business and corporate units had limited visibility into crucial arenas, such as performance at plant levels, costs, margins, overhead, material savings, etc. Due to the nature of their sustainable growth, they lacked consistency in information and standardization processes.

In addition, the information reporting and planning processes that were in place were antiquated. With manual and laborious systems in place that included spreadsheet formatting, crucial business information was often inconsistent and difficult to come by in a timely manner.

J.B. Poindexter & Co. needed away to upgrade their system into an automated, consolidated, and standardized. That way, corporate and business units would be able to quickly and easily view crucial information at both a detailed and broad level, allowing them to manage effectively and respond to any potential problems or risks immediately.

APPROACH

  • Leverage PREDICTif’s recognized experience and expertise to implement a business intelligence solution tailored to JB Poindexter and CO.’s needs.
  • Purchase multiple IBM Cognos Express modules.
  • Consolidate, standardize, and automate reporting and forecasting processes across all distinct business and corporate units.

RESULTS

  • Implementing IBM Cognos and PREDICTif services, provided end users with an intuitive budgeting, forecasting, and reporting solution with BI capabilities.
  • Created a system of easy-to-understand dashboards that automatically provide critical information across all business units, allowing management and corporate to assess performance and risk in a timely manner.
  • Implemented a cost-effective solution, saving $50-75,000 a year in hardware costs alone.
  • Eliminated the need for report builders by empowering end users with an easy-to-use system.
  • Allowed IT staff to focus on IT needs instead of spending several hours a day loading data and fixing reporting issues.
  • Increased productivity by 100-125%.
  • Reduced time to deliver manual reports by well over 200%.

BENEFITS AT A GLANCE

  • Upgrade and consolidate budgeting, forecasting, and reporting systems into one easy-to-use solution, IBM Cognos Express.
  • Using IBM Cognos Express, significantly reduce manual reporting from the separate business units by over 200%.
  • Generate consolidated, standardized reports that include product line costs and margins, fast and efficiently to make better business decisions.
  • Create easy-to-use reporting dashboards across all business units and corporate units, so that all levels of management can assess performance and risk in real time.
  • Increased productivity by 100-125%.
  • Employ PREDICTif Solutions  consultants to install a cost-effective solution, and even complete phase one of the project early and on-budget.
  • Leverage PREDICTif’s proven expertise to build a solution specifically tailored to J.B. Poindexter’s needs.

Financial reporting & consolidations solution for a leading Oil and Gas Equipment services company

NWS

Delivered a financial reporting and consolidations solution in a multi-currency and multi-account environment

CUSTOMER:

A leading Oil and Gas Equipment services company.

REQUIRED CAPABILITIES

  • Financial consolidation and reporting
  • Finance group’s self sufficiency
  • User friendly interfaces

CHALLENGES

As one of the leading global equipment service and pipeline construction companies, the customer faced numerous challenges related to monthly financial consolidation processing. In preparation for the opportunities and demands of being part of a publicly held company, the customer and its 25 plus legal entities had to manage all of their financial operations in a multicurrency environment, transforming individual financial statements from a group of entities into a single financial statement.  Their legacy solution which consisted of putting consolidated statements together using spreadsheets had severe limitations.

  • Disparate spreadsheets were not a scalable solution to implement across multiple lines of business;
  • Manual consolidations processes were complex, error prone and left no time for analysis; and
  • Currency translation with exception rates for items like intercompany receivables and common stock became a maintenance dilemma.

SCOPE

Efficiency, user-friendliness and self sufficiency were the three main objectives of this project.

  • Deliver a Cognos TM1 based solution to streamline the monthly financial consolidation process;
  • Provide a user-friendly user interface for analysis, ,reporting and dissection of data in an interactive manner; and
  • Establish self sufficiency so that the customer’s business users can easily support and upgrade the solution independent of its IT group.

SOLUTION

PREDICTif was engaged to provide an end-to-end solution and after evaluating several potential software vendors, IBM Cognos TM1 was selected for a number of reasons most notably,  the ability to provide a real-time approach to consolidating, viewing, and editing enormous volumes of multidimensional data.

Cubes having dimensions ranging from 3 to 10 were created. GAAP entries, Eliminations and Adjusting entries were made through the TM1 Consolidations product.   Reports created both in TM1 and Excel were readily accessible through the web with no additional effort.

  • TM1 is an in-memory OLAP server, which means that can typically respond to queries more quickly than its competing products;
  • By implementing TM1, the customer was able to compress the consolidations process into a matter of hours, giving analysts much more time for data analysis; and
  • The customer found out that it could eliminate numerous steps from the process itself further contributing towards more time on analytic activity rather than the mechanics of generating month-end reports.

PREDICTif provided a training curriculum that was tailored to the customer’s needs and culture. Power users received comprehensive technology and solution specific training and as a result, quickly became proficient enough to instruct other end users.

RESULTS

PREDICTif delivered significant value to the customer’s return on investment related to the software and IT infrastructure investment. The solution received positive feedback from the customer’s user population and significantly improved the financial consolidation and reporting process.

  • The deployment of the TM1 Consolidations and Reporting solution reduced the number of hours spent generating the consolidated financial reports and freed up considerable more time for analysis;
  • The network traffic due to large volumes of attachment in the email has decreased;
  • Financial analysts can generate reports and dissect large volumes of data using an interface they are familiar with; and
  • The customer’s finance group uses, supports and enhances the solution without dependence on the IT support.

crc1
Consolidations Process After TM1

crc2

PREDICTif help find an enterprise dashboard & scorecard solution for energy company

NWS

A global integrated energy company seeks PREDICTif’s help to find an enterprise dashboard and scorecard solution to track KPIs

CUSTOMER:

A global major integrated energy company.

REQUIRED CAPABILITIES

  • An Enterprise Level Dashboard and Scorecards that tracks KPIs against Refinery Actual, Planned, and Scheduled Metrics with reduced data latency and enhanced ease of use

CHALLENGES

As one of the world’s largest integrated energy companies, our customer conducts business in every aspect of the crude oil and natural gas industry, including exploration and production, manufacturing, marketing and transportation, chemicals manufacturing and sales, geothermal energy, and power generation. Our customer sought an enterprise solution to track key financial and operational KPIs.

  • The customer did not have Metrics for key performance indicators in critical financial and operation categories;
  • Unable to track down any change in the key metrics and identify the contributing factors to the change;
  • No dashboarding capabilities to provide a snapshot view into operational performance at world wide refineries; and
  • There was 1-2 day of data latency, and as a result, the reports did not contain up-to-date information.

SCOPE

The customer’s requirement was to create an enterprise level dashboard that tracked key KPI’s against their Actual, Planned and Scheduled Metrics. The scope also included the creation of dashboards and scorecards to give a high level representation of critical operational data.

  • Increase visibility — create dashboards that allow the business a high-level view of  granular data in order to get to timely address business problems immediately;
  • Increase accountability — assigns owners for each metric as well as the accompanying responsibility for performance;
  • Increase focus — concentrate on priorities and eliminate distractions;
  • Improve communication — communicate results and actions taken to manage performance; and
  • Improve collaboration — use metrics to link together people, departments and processes.

SOLUTIONS

After evaluating several world class solutions, IBM Cognos BI was selected for a number of reasons – one of which being IBM Cognos BI provides a highly customizable and informational dashboard and scorecard solution. Cognos metrics studio, metrics designer and framework Manger version 8.4 provide needed metrics functionality to meet the requirements. PREDICTif was engaged to provide an end-to-end BI solution and develop Refinery Metrics and Balanced Scorecards using Cognos Metrics Studio/Metrics Designer 8.4.

  • Analyzed existing requirements for the need to created metrics, metrics types, planned values, actual values, charts and various scorecards;
  • Installed and configured Metrics Studio and Metrics Designer on the existing Cognos BI 8.4 environment;
  • Used Framework Manager to initially model a package that will be used to as a source for creating the metric designer package;
  • Created various Metrics and Metrics Types (Actual Vs Scheduled, Actual Vs Planned, Planned Vs Scheduled etc) and compared the different metrics;
  • Developed customized Report Studio Reports to be used as part of this metrics analysis;
  • Used Metric Designer to create a metric package for use in Metrics Studio;
  • Used Custom calendar and performed various admin tasks like pushing data into staging area and then into metric store etc;
  • Developed a balanced scorecard based on the various metrics created earlier; and
  • Trained Administrators, BA’s and Developers to maintain this metrics model and package and also them on used metric studio.

RESULTS

PREDICTif delivered a Cognos BI solution that increased the visibility to significant business events and enhanced the customer’s ability to detect and resolve business issues and maximize market opportunities.

  • The Cognos BI Dashboard provided a consolidated view of refinery operational metrics from all of the customer’s worldwide refinery units;
  • The Scorecard solution offered insight into operational issues and enabled teams to design and implement measures to resolve issues;
  • The data integration solution significantly reduced the latency and delivered up-to-date information to business users; and
  • The customer was able to support and upgrade the solution independently after PREDICTif provided extensive and specific training and detailed documentations.

Electronics Distributor Solves Migration, Logistics and Billing Problems

NWS

A major independent electronics distributor solves migration, logistics and billing problems with performance management.

CUSTOMER:

A leading, global independent distributors of semiconductors, electronic components, and computer products to the world’s major manufacturers

REQUIRED CAPABILITIES

  • Single-version of truth
  • Interactive reporting
  • Operation and finance dash-boarding
  • Real-time data access

CHALLENGES

This multinational organization relies on the ability to quickly and accurately report, analyze, plan and forecast across its entire global enterprise. On time delivery of components to customers is a critical business event for the client and a principle reason why the client is a leading company in the electronics distribution industry.

The analysis of continuously changing operational data is routine; planning and developing “what-if” scenarios for operations and logistics must be conducted not just annually, but on a daily and weekly basis. Data from multiple sources is constantly being entered by myriad users; the data is then manipulated and accessed as orders are placed to buy, sell, and deliver electronic components around the clock through numerous global offices and warehouses.

 

  • A lack of transparency into freight data lead to significant billing allocation issues, a lack of control over expenses, and delays in internal departmental’ budgeting. The customers standard reports only enabled limited visibility into the business leaving key insights buried;
  • Significant opacity into actual freight costs developed because of the multiple sources and means by which charge data were handled;
  • There was concern over the continuity of knowledge and information at both inter- and intra-department levels. Additionally, knowledge and data sharing were limited and as a result, hindered productivity and responsiveness;
  • Due to the absence of a BI platform, freight and inventory levels along with their associated costs were extremely difficult to manage effectively due to the lack of real-time interconnectivity of data across departments as well as locations; and
  • The business stake-holders did not have visibility into the inventory and freight related data;
  • Accurately planning and forecasting based on available data was becoming an impossible task to accomplish because of the number of disparate data sources; and
  • There was increasing concern over data validity due to data opacity;
  • Data opacity and resulting billing problems were estimated to be costing the client one-half of a million dollars in 2007.

SCOPE

The initiative is to deliver an end-to-end enterprise performance management (EPM) solution to increase cross business unit data sharing and as a result, enhance the customer’s agility to maximize short- and mid-term market opportunities given the real-time nature of the client’s business.

 

  • Delivered an end-to-end EPM solution, its accompanying infrastructure and data integration services;
  • Integration of the Accounting and Finance Departments with that of Operations in order to improve strategic planning, forecasting (including rolling forecast capabilities), analytics and various reporting for freight and inventory;
  • Provide real-time internal data for financial and operational planning to reduce data latency and accelerate response time-to-market opportunities;
  • Establish mechanisms for knowledge sharing to increase productivity of the workforce;
  • Addresses BI performance issues resulting from disparate systems that were not interconnected;
  • Provide back up and lock down document functionality that traditional spreadsheets are not capable of;
  • Resolve conflicting cross-departmental data issues to simplify Inter-department reporting; and
  • Establish a single version of truth by implementing a suite of tools for use in extracting, reporting, analyzing and forecasting the existing data while at the same time, compiling and cohering that data

SOLUTION

PREDICTif was chosen first to evaluate a number of technologies to be used for the initiative. After a careful product selection process, IBM’s Cognos tool set was selected due to its capabilities that allowed for real-time data drill-down and analyses, rolling forecasts, multi-level management tasking, visibility, interaction across departments and management levels.

 

PREDICTif then architected, designed and implemented a solution to address a set of logistics and billing related issues based on PREDICTif’ proven BI and EPM solution offerings. PREDICTif’s ability to provide an immediate implementation of Cognos TM1 mapped to a short-term scalable plan was of paramount importance to the customer as short term return on investment was a critical variable in the decision making process related to engaging with a solutions provider.

 

The PREDICTif team, comprised of financial and operational business experts, Data and BI solutions architects, along with PMI® certified consultants, adopted a proven project delivery methodology. The methodology consists of three main phases: Foundation, Implementation and Evolution. The Foundation Phase establishes the project readiness in terms of people, infrastructure and processes. The Implementation Phase entails a typical project lifecycle that constitutes many steps including requirement gathering, design, development, testing and deployment. The Evolution Phase establishes the customer’s self sufficiency in terms of the abilities to support, maintain and upgrade the delivered solution.  The solution provided:

 

  • Real-time access to multiple data sources from a single point
  • Agile forecasting and reporting
  • Product specific drill-down capabilities
  • Multi-level management reach and connectivity
  • The interconnection of operational and financial data across multiple departments
  • The ability for Client executives along with managers across departments to interact and manipulate data collaboratively, approve or amend changes, forecasts, and formulate budgets in real-time

 

RESULTS

PREDICTif established an IBM Cognos BI and TM1 infrastructure that the customer uses to enhance their operational excellence processes in order to drive maximum business value.

 

  • Delivered an IBM Cognos TM1 user-friendly Freight Analysis Model that was first deployed on a 32-bit environment and later upgraded to a full 64-bit environment for enhanced performance;
  • Created a new suite of analysis, forecasting, and reporting tools providing visibility into the inventory and freight data across multiple dimensions. This transparency allows executives and managers to connect different data elements in order to meet various business needs, such as allocating freight costs to different parties as well as building strategic plans and forecasting with precision;
  • Offered end users the ability not only to view and analyze reports, but also to accurately view the impact of changes to freight and inventory mix and thereby create rolling forecasts to better manage operations and budgets;
  • Achieved improved ROI as a result of enhanced analytic capabilities, forecasting and reporting across the enterprise because the data is no longer opaque;
  • Ushered in a new dimension of responsiveness by delivering a flexible, real-time environment for the organization in order to perform multiple business functions and improve strategic planning in real-time for immediate and future cycles.

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.

Cognos BI 10 Migration and Lifecycle Manager

BLG

At PREDICTif Solutions, we have successfully migrated Cognos 8.4 to Cognos BI 10. The migration was pretty straight forward.   We imported Cognos 8 content to Cognos BI 10 and verified it through Lifecycle Manager. We discovered that about 85% of the reports migrated successfully without any special attention and only a handful of reports required the same amount of attention as the most complex reports from a Cognos 7 to Cognos 8 migration.

By far, the most time consuming part of the migration process was verifying reports.  We used Lifecycle Manager (Upgrade Manager in previous releases) to speed up this process.   Lifecycle Manager allowed for a systematic way to compare original and updated reports automatically. If there were any differences between each version of Cognos, reports could be compared side-by-side and any discrepancies are marked in red.

Lifecycle Manager is an invaluable tool, but it does have its limitations that require some additional effort. Other than multiple report formats, it is not designed to verify a report on multiple scenarios. A user could run the report multiple times with different scenarios, but without history, there is no way to keep track of previous results.   There is also a similar limitation in dealing with multiple data sources. Normally, if there were multiple data sources in Cognos BI, the user is prompted to choose which data source to use. However, Lifecycle Manager does not prompt the user. The only way to process the report in Lifecycle Manager would be to disable multiple data sources in Cognos Administration or manually set the report in Cognos BI to use a specific data source.   Still, both of these limitations can be further minimized by having multiple projects Lifecycle Manager. Different reports scenarios or data sources can be accounted for by different projects.

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