Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Jet Reports vs. Jet Analytics

Jet Reports

With Jet Reports , you can query a database using Excel-like functions to return real-time results into Excel.  It consists of a Jet ribbon that is installed, enabled and configured within Excel.  This ribbon contains all the tools needed to create reports via wizards such as the Report Wizard and the Jet Function Wizard , or to create Pivot Tables from a Jet cubes data source.

Jet Reports also includes the Jet Service Tier and Jet Hub, which are all included in the consolidated installer (Jet Reports.exe).

Jet Reports is the product used to create reports .

Jet Analytics

Jet Analytics is a suite of products , made up of the Jet Data Manager.

The Jet Data Manager is a back-end solution. With Jet Data Manager, companies can create and maintain data warehouses and OLAP cubes.  It contains six predefined cubes built specifically for storing data for reporting. Typically, this component is only installed on one machine, and only accessible by a select few within the company with database management or IT experience.

To optionally pull data, build reports and build Pivot Tables, users can use Jet Reports within Excel, as detailed above.  With Jet Reports, you can create and run reports from the database, the data warehouse, or cubes.  This component is the one that is typically installed and used by the majority of users within the company.

Read more about the difference between Analytics and Reporting

Published:

Jet Reports vs. Jet Analytics

Jet Reports

With Jet Reports , you can query a database using Excel-like functions to return real-time results into Excel.  It consists of a Jet ribbon that is installed, enabled and configured within Excel.  This ribbon contains all the tools needed to create reports via wizards such as the Report Wizard and the Jet Function Wizard , or to create Pivot Tables from a Jet cubes data source.

Jet Reports also includes the Jet Service Tier and Jet Hub, which are all included in the consolidated installer (Jet Reports.exe).

Jet Reports is the product used to create reports .

Jet Analytics

Jet Analytics is a suite of products , made up of the Jet Data Manager.

The Jet Data Manager is a back-end solution. With Jet Data Manager, companies can create and maintain data warehouses and OLAP cubes.  It contains six predefined cubes built specifically for storing data for reporting. Typically, this component is only installed on one machine, and only accessible by a select few within the company with database management or IT experience.

To optionally pull data, build reports and build Pivot Tables, users can use Jet Reports within Excel, as detailed above.  With Jet Reports, you can create and run reports from the database, the data warehouse, or cubes.  This component is the one that is typically installed and used by the majority of users within the company.

Read more about the difference between Analytics and Reporting

For an optimal Community experience, Please view on Desktop