Arke recommended the Microsoft SharePoint 2010 system, a web-based application that would integrate with the company’s financial and reporting software to allow international franchise locations to upload and interact with data.
Their server was upgraded to Microsoft SQL 2008 R2 and Arke was able to use all the best functionality of the SQL 2008R2 and Arke was able to use all the best functionality of the SQL 2008 business intelligence (BI) stack. Additionally, Arke implemented Forms Based Authentication (FBA), which allowed Outback to manage their 500 users, without having to manually load them into their headquarters’ Active Directory.
Outback has become much more efficient since Arke helped them launch their new SharePoint 2010 Intranet and SQL 2008 R2 server. Outback was able to move their data reporting from having 250 stored report procedures, to having one data warehouse database, with five analysis cubes for each major reporting category.
With the use of the analysis cubes, which are precalculated data structures in the SQL server that facilitate high performance reporting, Outback can now process a full report in under 1 minute, versus the previous reporting time of 1 hour. It equates to a 6000% reduction in the time it takes to process a report. In terms of maintenance, the systems take less than 4 hours per month to maintain, which they consider a considerable reduction.