Jet Reports allows users to 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 Jet Function Wizard or create Pivot Tables from a Jet cubes data source.
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 that allows companies to 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. Jet Reports allows users to 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.