Incorta speeds access to information and improves employee productivity
THE CHALLENGE
The team largely depends on data hosted within disparate software solutions, including Workday, Oracle ERP, Model N, Oracle Demantra and Microsoft Excel. Before Incorta, generating a new analytical dashboard or report based on this siloed data took 6-12 weeks. Despite investments in a traditional data warehouse and multiple data marts, Broadcom was still faced with a long delay between business requests and production.
Their objective was to shorten the build/development time for dashboards and reports and reduce report run times. “Our employees can’t wait weeks for the information they need to do their jobs,” said Alan Davidson, Director of IT Infrastructure. “But at the same time, we have billions of rows of data in our database. It’s no small challenge to quickly slice and dice that amount of information.”
THE SOLUTION
Broadcom had two goals when selecting a new analytics solution: 1. It had to reduce the time it took to get information to employees; 2. It had to increase department productivity without draining internal resources. Other selection criteria included cost-effectiveness, self-service capability, ease of maintenance, and minimal support from other technologies. Topping this list was easy integration with external applications — especially Microsoft Excel. With Incorta, the Broadcom team could easily combine data from existing enterprise systems, enable access to point solutions like Excel, and ultimately accelerate the creation of new analytical applications — all while reducing report run times.
With the implementation of Incorta, users can see work orders and billable and non-billable work hours in seconds. When users log into EBS, the first thing they see is an Incorta dashboard, and they can seamlessly switch between Oracle transactions and Incorta analytics with a single sign-on (SSO). The SSO and the option to leverage roles and responsibilities already assigned to university users within EBS increases data security. And with the ability to click on individual work orders and make changes to its EBS transaction record (like adding hours or shifting due dates from within Incorta), users can work quickly and effectively.