KU Technologies delivers a wide-range of IT services to the subsidiaries of Knowledge Universe, which include KinderCare Learning Centers and CCLC, serving 300,000 children across the U.S. The company’s enterprise Business Intelligence (BI) team is responsible for multiple products and projects that provide critical insight into financials and other operational metrics for more than 1,800 early education centers.
In the Fall of 2009, the BI team began examining methods that would enable them to better gather and access information from Oracle E-Business Suite (EBS) for reporting and analysis purposes. For example, they wanted the ability to look at an individual education center and to analyze how annual revenue related to employee turnover and then to compare these metrics with other facilities. They wanted to be able to determine food costs at facilities so they could negotiate lower prices with vendors.
At the time, managers were using a variety of methods to come up with this type of information, from Excel sheets to e-mail compilation.
The BI team determined they needed a new, robust reporting solution for Oracle EBS and after much research and due diligence, the team decided to purchase Noetix® Analytics. The Noetix solution would be used to augment the existing data warehouse and to do so in a way that enabled the team to quickly and accurately deploy a complementary solution, thereby reducing time to market and costs that would have been involved with a ‘from scratch’ approach.
Noetix Analytics is built on a module-based approach, which allowed KU Technologies to select modules specific to what they utilize in Oracle EBS (General Ledger, Receivables, Payables, Fixed Assets, Project Accounting, and Human Capital Management) and to expand to additional modules as the need arises. The information is consolidated in a near-real time standards-based Operational Data Store (ODS) and a Kimball approach (fact table, dimensions) Data Mart.
“We could have spent 12 to 15 months and up to $2 million creating a customized data warehouse from scratch or we could have gone with Noetix Analytics,” said Wade Anderson, director of Business Intelligence. “The end result was a solution that was 80 percent of the way to what we needed at go-live, shifting the focus of our implementation effort away from creating an architecture from scratch and instead working on areas and business needs that are unique to Knowledge Universe business lines.”
The BI team was live with Noetix Analytics within 90 days of the initial implementation. A few months later, they had a data warehouse populated with 1.3 terabytes of data available for operational reporting and analytics.
Noetix Analytics works in conjunction with existing BI platforms from a wide range of vendors, enabling KU Technologies to employ its existing Cognos 8.4 reporting tool to view information from Oracle EBS in a familiar format. The BI Team built a series of dashboards and has conducted extensive training to empower the end users to use the solution to create their own operational reports.
Today, initial ‘consumers’ in Human Resources, Finance, Legal, and Procurement are retrieving information from the new BI environment and creating their own operational reports—accessing information wherever and whenever they need it.
The finance organization in conjunction with the BI team recently launched a balanced scorecard for one of KU Technologies’ major business lines. The information provided in Noetix Analytics played a key part in achieving this in 30 days time. Center directors and field management now have the ability to log in and retrieve a common set of information unique to their business area.
“We could not have implemented this balanced score card with its systematized approach without the solution pieces provided by Noetix Analytics,” said Anderson. “And when you imagine that this information will be available for the first time to 1,800 center directors and their staff, you can see that the impact on the business overall will be enormous.”
Director Of Business Intelligence
As part of the Magnitude Software family of products, Noetix world-class business intelligence solutions are used by hundreds of industry leading customers worldwide. Armed with immediate access to Oracle E-Business Suite data, users finally have the answers they need to make better business decisions.
Magnitude Software leads the way in delivering corporate performance management (CPM), master data management (MDM) and connectivity in heterogeneous environments.
© Magnitude Software, Inc.