OlapCube

This tool helps analyze data and find business insights.

You could analyze mass of data and generate business insights and create professional reports based on them. OlapCube creates data cubes locally on your computer. The standard data cubes are stored in local storage. The program is stand alone and no other program is required for it to complete its job. There will be no need for a server, a SQL Server database or other OLAP products. The data cubes thus created could be used by various software tools including OlapCube Reader to quickly browse and analyze your data, Microsoft Excel to create professional reports, and OlapCube Dashboard to share and collaborate online. It does not take much effort to get started. To start with, you would need to connect the software with a data source of course. You would have to add your tables and then drag and drop the fields that define dimensions and measures.

A built-in cube designer has transformation features that can transform data to suit your needs. All you need to do after that is to build the cube and the whole thing is set up. This tool is compatible with all the major databases and data file formats. Creating suitable dashboards is easy with the most recent version. These dashboards could be sent by email to others or even be stacked on FTP sites. If you wanted to publish it in your company or personal blogs, that’s possible too. Several chart option allow easy visualization of data. These include Geo chart, Scatter chart, Column Chart, Line Chart, Bubble Chart, Table, Sparklines, Gauge, Pie Chart, etc. Excel could be used to create professional reports. This is a very good product. If you are looking for a similar solution, you should try it in your exact workflow.

OlapCube is a simple, yet powerful tool to analyze data. OlapCube will let you create local cubes (files with .cub extension) from data stored in any relational database (including MySQL, PostgreSQL, Microsoft Access, SQL aServer, SQL Server Express, Oracle, Oracle Express).
You can explore the resulting cube with our OlapCube Reader. Or you can use Microsoft Excel to create rich and customized reports.
The OLAP cube consists of numeric facts called measures which are categorized by dimensions. An OLAP cube is a data structure that allows fast analysis of data. The arrangement of data into cubes overcomes a limitation of relational databases. Relational databases are not well suited for near instantaneous analysis and display of large amounts of data. Instead, they are better suited for creating records from a series of transactions. Although many report-writing tools exist for relational databases, these are slow when the whole database must be summarized.
OLAP cubes can be thought of as extensions to the two-dimensional array of a spreadsheet. For example a company might wish to analyze some financial data by product, by time-period, by city, by type of revenue and cost, and by comparing actual data with a budget. These additional methods of analyzing the data are known as dimensions.
A financial analyst might want to view or "pivot" the data in various ways, such as displaying all the cities down the page and all the products across a page. This could be for a specified period, version and type of expenditure
Each of the elements of a dimension could be summarized using a hierarchy. The hierarchy is a series of parent-child relationships, typically where a parent member represents the consolidation of the members which are its children. Parent members can be further aggregated as the children of another parent. For example May 2005 could be summarized into Second Quarter 2005 which in turn would be summarized in the Year 2005.