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 is a suite of products, made up of the Jet Data Manager and Jet Dashboard Builder.
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.
Certain types of users, called Designers, can use the Jet Dashboard Builder to create dashboards for online or mobile consumption by anyone in the company with permission to do so.
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.