Business Intelligence XLCubed Excel Edition

Home
Products
About Us
Services
Navision
Jigsaw Blog
Articles
Microsoft Dynamics Nav
Microsoft Dynamics CRM
Business Intelligence

Microsoft Dynamics NAV

ERP Solutions - Integrating financial management, manufacturing, supply chain management, customer relationship management, project management, e-commerce and business intelligence reporting.

Microsoft Dynamics CRM

Customer Relationship Management – Building Relationships with a clear picture of forecast sales from existing customers and new prospects.

Business Intelligence

Delivering dashboard reporting and performance scorecards for key business data across the whole organisation.

E-Commerce Portal Dynamics NAV

Providing Customers access to their purchase history, backorder status and the ability to place orders directly into NAV, eliminating data entry errors and the high cost of data entry.

Jigsaw Technology is a full service, IT consulting firm who partner with you to provide the technical resources and project management skills required to manage all your information technology systems.

WebReporting

Web-based Reports are formatted similarly to existing reports and are generated via a web browser. The user has the option to print the report or saved the file as PDF/Excel/Text file.

WebPO

This web based purchase order system has been designed to control of company expenses and comes complete with : unlimited approval levels, supports order revisions, filtering of orders by user or group, prints of order online (once approved) and includes one WebReporting Licence.

Pocket Agent

PocketAgent is a Pocket PC based "Property Listings" application designed for Real Estate Agents. It carries an up-to-date list of all available properties along with photographs.

Puzzle

This MS Excel addin allows users to directly access data held in ODBC/ADO compliant databases (MS SQL, MS Access, dBase, FoxPro) to allow Financial Reporting spreadsheets to be accessed from accounting systems databases.

eClaim

Is a web based Expense Claim System designed to streamline the creation and processing of expense claims.

Kaspersky Anti-Virus Software

Protecting your data and essential business applications with the most secure, updated and most cost effective Anti-virus software solution.

XLCubed Excel Edition

XLCubed Excel Edition brings the full power and flexibility of OLAP reporting to Excel. The strengths of Excel as a familiar and powerful calculation and modelling environment are retained, while the risk of Excel as a data store is removed.

Connecting to Microsoft Analysis Services cubes (the BI component of Sql Server) and SQL etc, XLCubed provides slice and dice analytics, free format asymmetric reporting, and a rich environment for interactive, data connected Excel dashboards.

Analytics
XLCubed provides an easy to use yet powerful analytics environment. With XLCubed Grids, users can explore and understand their data through slice and dice, drill through the available hierarchies, and quickly specify level or descendant based selections for dynamic reporting. User defined calculations are simple to add, but olap aware, and respect drill downs and hierarchy repositioning.

Report sections can be linked together by hierarchy, and the selection criteria can use the XLCubed dialogs, native Excel drop downs, or direct user entry. Any number can be quickly broken down to its constituent parts, and in-grid visualisation is available within a fully interactive environment.

exceled1

Reporting

For some reporting layout is key, and there are precise corporate templates which must be adhered to. Asymmetric reporting is also a requirement in many environments. XLCubed's formula model means that it's possible to create a data-connected report of any shape and layout achievable in native Excel. The key formulae are simple in concept and are created through intuitive dialogs, or the conversion of an XLCubed Grid.

Despite the free format layout, the reports still offer drill down, drill through, and number decomposition (breakout).

Dashboards
Excel is a highly effective environment for dashboard reporting. The user has fine grain control over the positioning, layout and sizing of charts and tables, and the ability to easily calculate additional metrics using Excel itself.

The primary issue has always been that of Excel as an isolated data island, or 'Spreadmart'. XLCubed maintains an active connection to the data, taking away the maintenance burden associated with most traditional Excel dashboards, but retains the full flexibility of layout available in native excel. The in-cell charting available with MicroCharts, a licensed component of XLCubed Excel Edition, significantly extends what is achievable in terms of data visualization, and is ideally suited to dashboard reporting.

Despite the free format layout, the reports still offer drill down, drill through, and number decomposition (breakout).

exceled2