Incorta drives operational success for university’s land and operations department with Oracle EBS integration
THE CHALLENGE
With 24 brands in its portfolio, SeaLink relies on accurate analysis and reporting to effectively set prices for its various products. But with so many products and data sources, the process was slow — one monthly report took over 100 hours to compile. SeaLink was using a legacy BI system that had reached its end of life and was showing signs of failure.
With support no longer available, this exposed the company to significant risk. In addition, users found the tool difficult which made them reliant on IT to get things done. And analysts didn’t have control over its configuration, making it even harder to implement logic.
THE SOLUTION
SeaLink partnered with software design and development specialists Kanerika for its Incorta implementation. The new solution gives 100 business users access to on-demand data, with sub-second drill-down across billions of records. Incorta’s built-in logic makes enriched data sets available through the SQL interface to analytical engines, short-circuiting development time. Incorta displays the output in a way that’s user friendly and intuitive. SeaLink is using this data to develop a dynamic pricing model that adapts fares according to key factors, including time of day/week/month and competitor activity.
Unlocking the ability to rapidly develop logic has made reports meaningful and accessible, giving senior decision-makers a quick and easy way to view overall performance trends and make strategic decisions. The speed and efficiency of integration also saved the company significant time and money. Kanerika worked with real-time streams of internal SeaLink data, as well as third-party data to enable a holistic view of the business that supports daily functional management and executive decision-making.
To keep buildings operational and safe for faculty, staff and students, the Land and Buildings Department oversees a team of technicians that staff a variety of workshops. Work orders are generated within Oracle EBS, but a manager must estimate the work hours required for completion and assign the task to a technician. The department’s previous BI solution often experienced delays as it pulled data from EBS in response to basic queries, frustrating users and slowing work down. When technicians would try to look up active work orders, they would sometimes have to wait up to 15 minutes for a response, eating into billable time and impacting the budget.
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.