Locii Solutions is an exciting new IT company that specialises in the design and implementation of Business Intelligence (BI) solutions under the name locii Insight.  Review benefits for business managers.

Using in-house techniques, Locii Solutions has developed a new methodology that dramatically accelerates and simplifies the creation of data warehouses and ETL (Extract, Transform, Load) software. Even small organisations can now benefit from tailor made BI solutions.

In addition, locii Insight includes a new breed of Microsoft Excel formulas that allow an unskilled user to easily link spreadsheet cells to organisational data. This Excel formula approach revolutionises the production of reporting as a user simply opens a new Excel workbook and types a formula that creates an instantaneously updating data link. For example a user can enter product codes into cells and write a formula to return the current sales, or enter account codes and type a formula to return the balance on the accounts. The user then saves the workbook on their hard drive and the data link is updated any time the user reopens their workbook.

Insight Server: supplied hardware is integrated with your network and is specifically configured by Locii Solutions for high speed loading, updating and reporting.

Insight Loader: utilising SQL Server Integration Services and code generation techniques, Insight can update from a range of systems (SQL, AS400/DB2, Text Files, MS Access, Excel...)

Insight Database: a high performance data warehouse using SQL Server 2008, tailored for maximum reporting speed.The Insight system ‘cleanses’ data automatically to ensure it is fully relational and identifies problematic or unusual data.

Insight Cubes: built on the Insight database, and using SQL Analysis Services to build multidimensional images of company data, Insight cubes provide near-instantaneous reporting on over 200 million transactional records.

Insight Excel Client: with all the power of Excel and the exciting new BI features in Excel 2007 this client allows rapid navigation using pivot tables and charts with minimal training.

Excel Ribbon Interface: Unique to locii Insight, the ribbon interface offers a revolutionary new environment for more advanced users to manipulate Insight data directly in Excel 2007.

Insight Web Reports/SharePoint: with SharePoint 2007 and/or SQL Reporting Services Insight can extend reports, dynamic dashboards and spreadsheets etc. directly to end users.