Jet Global Certification Program

Become a part of the elite group of experts we recommend as technical and instructional masters, by earning certifications that showcase your skills and proficiency with Jet Reports.

The Jet Global Certification Program is designed for partners and resellers who support all aspects of Jet Reports and/or Jet Analytics solutions, from product installation, implementation, customization, report writing, and training.

Jet Reports Certificate

The Jet Reports Certification proves that you are highly proficient in the use, maintenance and report creation in Jet Reports. This includes building reports as a Jet Global designer, installation, configuration, implementation, and support. If you can manage and execute nearly all aspects of Jet Reports like a pro, including the Jet Excel Add-In, Jet Administration Console, Jet Hub, then the Jet Reports Certificate is right for you.

To qualify, you must pass the Jet Reports Certification Exam.

Prepare for this exam and learn more about the exam contents and requirements now.

Take the exam now.

This certification is valid for two years.

Jet Analytics Certificate

The Jet Analytics Certificate proves that you have a deep understanding of general business intelligence (BI) and data warehousing concepts. Additionally, you can demonstrate skill in the installation, configuration, customization, implementation, security, and support of Jet Analytics. If you can manage, execute, and administer nearly all aspects of the Jet Data Manager, the Jet Administration Console, Jet Hub, Jet Mobile, and Dashboard Builder, then the Jet Analytics Certification is right for you.

To qualify, you must pass the Jet Analytics Certification Exam.

Prepare for this exam and learn more about the exam contents and requirements now.

Take the exam now.

This certification is valid for two years.

Jet Reports Certification Exam Information and Study Guide

Individuals that are certified for Jet Reports are well-rounded experts for the flexible financial and business reporting solution inside of Excel. They can truly, and confidently, build “fast and accurate reports anywhere.” They are competent with all aspects of installation, implementation, and troubleshooting, so that we can be certain they will provide the best support to users. If your company or customers rely on you for all things around Jet Reports, this certification level is for you. Remember, this is an elite group of industry experts, so anticipate a rigorous examination of your skills!

What to expect and how to prepare:
In order to receive your certification, simply sign up for and pass the Jet Reports Certification Exam. The exam consists of 55 questions about advanced Jet Reports functionality, functions, implementation, support, and troubleshooting. You’ll need to achieve a score of 75% or better to pass.

Here is what the process looks like:

  1. Take the exam: when you’re ready, click on the link below to access the test. Be sure to fill out all the necessary professional contact information at the beginning.
  2. Watch your time: while you’re taking the exam, pay attention to the 60 minute time limit. When you’re finished with the exam, click “Submit”.
  3. View your results: follow the on-screen instructions to see your score and how you did.
  4. Get your certificate: once you pass the exam, you will have the ability to download a printable document confirming your certification which will be valid for two years from the exam date. You can then contact your regional Jet Global office to request the appropriate certification logo.
  5. Retry: if you didn’t pass, don’t worry! You’ll be able to study and take the exam again by clicking the link and going through the process again. You will need to resubmit all your contact information a second time.

Topics that are covered:

  •  Jet Reports Features
    • Browser, Wizards, Favorites, Snippets, Jet Hub, Jet Administration Console
  • Report Writing
    • NL Function
      • Rows, Columns, Sheets, First, Sum, Count, CountUnique, Lookup, Filter, Link, Table
      • Filter Syntax
      • Special FilterField arguments
      • Advanced filtering concepts
    • NF Function
    • NP Function
      • Union, Intersect, Difference, Join, Split, Companies, DataSources, Dates, Integers, DateFilter, Eval
    • Excel knowledge
      • Functions, cell references, PivotTables, slicers
    • Database Terminology
    • Basic-to-Advanced Function/Report Scenarios
    • Basic-to-Advanced Report Development Concepts
    • Multi-level Grouping, Table Linking, Troubleshooting
    • Sorting
    • Jet Keywords
  • Installation
  • System Requirements and Configuration
    • Jet Excel Add-In
    • Jet Service Tier
    • Jet Hub
    • Jet Administration Console
    • Common End-User Support Questions
      • Errors and troubleshooting

Tips for Preparation:

  • Make sure you find a time and a space where you will have no interruption while taking the exam. You will be timed, so you will need your full concentration!
  •  If you don’t know the answer, don’t fret! Remember you need 75% to pass, so you don’t have to get them ALL right.
  • Practice reading Jet functions in the formula bar of Excel. Since the exam is given in a text format, all functions will be represented in “sentence” format rather than visually. Here’s an example of the format you should be ready for: =NL(“Rows”, “Customer”,, “City”, “Berlin”, “Status”, “Active”). Please also note that all formats are displayed in US format so parameters of Jet functions will be separated by commas.
  • Read the answers carefully. There are some tricky choices in there, so stay alert.
  • Watch the Jet Reports videos.
  • Get involved on the Community site. Ask and answer questions!
  • Read our Knowledgebase articles.
  • Read the Help accessible from the Jet Ribbon inside Excel.
  • Connect with other Jet Global experts.

Ready to take the test?
Click Here

Jet Analytics Certification Exam Information and Study Guide

Individuals that are certified for Jet Analytics are well-versed in the corporate analytics and reporting platform. They can truly, and confidently, build “flexible dashboards accessible from anywhere,” and they possess a deep understanding of general business intelligence (BI) and data warehousing concepts. If you are competent with using and administering the Jet Data Manager, Jet Administration Console, Jet Service Tier, Jet Hub, and Dashboard Builder, and have been doing customizations on your own, then this is the certification for you. Practical knowledge of the platform will be needed in order to successfully pass the exam.

What to expect and how to prepare:
In order to receive your certification, simply sign up for and pass the Jet Analytics Certification Exam. The exam consists of 55 questions covering advanced Jet Analytics functionality, installation, support, and troubleshooting, implementation of the data warehouse and cubes, the Jet Data Manager, Jet Hub, the Jet Service Tier, the Jet Administration Console and the Dashboard Builder. You’ll need to achieve a score of 75% or better to pass.

Here’s what the process looks like:
1. Take the exam: when you’re ready, click on the link below to access the test. Be sure to fill out all the necessary professional contact information at the beginning.
2. Watch your time: while you’re taking the exam, pay attention to the 60 minute time limit. When you’re finished, click “Submit”.
3. View your results: follow the on-screen instructions to see your score and how you did.
4. Get your certificate: once you pass the exam, you will have the ability to download a printable document confirming your certification which will be valid for two years from the exam date. You can then contact your regional Jet Global office to request the appropriate certification logo.
5. Retry: if you didn’t pass, don’t worry! You’ll be able to study and take the exam over by clicking the link and going through the process again. You will need to resubmit all your contact information a second time.

Topics that are covered:

  • Basic Business Intelligence (BI) Concepts
  • The Kimball Methodology
  • Installation
    • Installation environments for the Jet Data Manager
    • SQL Components needed prior to installation
    • SQL Versions that the Jet Data Manager is compatible with
    • Setting up execution packages
    • Setting up security
    • Which database collation to use
    • Other general installation rules and guidelines
  • Data Warehouse Design
    • Database objects that can be created using the Jet Data Manager
    • Enabling/disabling Integration Services packages in a project
    • Configuring incremental loading of tables
    • Adding and moving objects between the data source, staging database, and Data Warehouse database
    • Using field transformations
    • Other Data Warehouse design guidelines
  • OLAP Cube Design
    • Dimension structure
    • Adding and customizing dimensions
    • Different types of measures and what each type will do
    • Adding and customizing measures
    • Minimum requirements needed to build new cubes
    • Business Functions and Calculated Measures
    • General concepts around scripts
    • Configuring OLAP security
  • Dashboard Builder
  • System Requirements and Configuration
    • Jet Service Tier
    • Jet Hub
    • Jet Administration Console
  • General Installation, Configuration, Security, and Support Questions
  • Troubleshooting

Tips for Preparation:

  • Make sure you find a time and a space where you will have no interruption while taking the exam. You will be timed, so you will need your full concentration!
  • If you don’t know the answer, don’t fret! Remember you need 75% to pass, so you don’t have to get them ALL right.
  • Read the questions and answers carefully. There are some tricky choices in there, so stay alert!
  • Watch the Jet Analytics Videos.
  • Get involved on the Community site.
  • Read our Knowledgebase Articles.
  • Read the Help accessible from the Jet Data Manager and the Jet Ribbon inside Excel.
  • Connect with other Jet Global experts.

Ready to take the test?
Click Here