SBA Data Explorer is a robust Business Intelligence OLAP analysis and reporting tool.  It is extremely powerful, flexible and robust while maintaining a unique easy-to-use capability.  It is the window into the managerial reporting and analysis of your accounting database.

Dimension and Measures
Data Explorer is your window into the data stored in the Microsoft Office Accounting system.  It provides access through multi-dimensional data cubes defined by one or more Dimensions and a set of measures. 

Each of these dimensions - Customer, Item, Invoice, Job, Employee, Vendor, Time and Growth - are represented by different hierarchical levels of attributes such as product category and class for the Item dimension or customer and job type for the Job dimension. 

Each of these dimensions can be represented as a row or column in a tabular table or as an axis on a graph or plot.  Combined with these dimension are a set of Key Performance Indicators or Measures that provides values for each cell in the data cube.  Typical measures might be Sales, Units sold, Gross Profit, Gross Margin, Rank, etc. 

Cubes
Six specific cubes are provided for managerial analysis and reporting:

• Item/Job Sales
• Item/Job Sales & Profit
• Invoice & Transaction Documents
• Employee Hours
• Purchases
• Profit & Loss.Statements

Combined, these dimensions, measures and cubes provide a robust set of data for managing the various functional areas of the company - Sales, Marketing, Operations, Finance, etc.

Features
To see a list of selected Data Explorer functional features click below:

 Selected Feature List ►