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 Analytics for Dynamics 365 for Finance & Operations

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


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


Jet Analytics Certification for Dynamics 365 F&O Exam Information and Study Guide

To ensure a successful implementation for D365 F&O customers, we need to certify that your organization is prepared to handle the technical requirements of a Jet Analytics implementation. If you are not familiar with these details or do not have the capacity to take it on, please outsource to one of our recommended Jet Service Partners. (https://jetglobal.allbound.com/knowledge-base/outsourced-service-partner-list/) If you are interested in servicing these customers, we ask that you become certified to service them through Jet Global.

Certification Process:

  1. Attend 3 day Training Workshop
  2. 2 hour online Q&A follow up session
  3. Certification exam with Jet Global
  4. Receive your Jett Global F&O badge

Periodically we will host 3 day F&O training workshops around the world. Seats are available on a first come, first serve basis so sign up quickly. The number of seats available for the class will be dependent on the location of the class. Our maximum class size will be 12 for any location. There is no training fee associated with the workshop. Participants are responsible for covering all travel, per diem, accommodations, and other incidentals. If you are interested in attending a class in North America, please reach out to Peter Jennings (peterj@jetglobal.com). For all other regions, please reach out to Tine Plambech Brown (tinep@jetglobal.com).

Training Workshop agenda

  • Day 1: Overview of the Jet D365 flow and Data Entities.  The focus will be on how to create and maintain data entities.
  • Day 2: Create and Build D365 BI Projects.  Participants will create a new Jet Analytics project from scratch.  We will be creating the data entities, publishing, and exporting the data.  Then we will build the data in the JDM.  We will not be training on the JDM, but how to extract data from the SQL Azure site.
  • Day 3:   Workshop. Open to any outstanding questions that come up during the previous 2 days and to ensure you have all you need to be successful. Follow up and work through any questions and issues.

Practicalities and requirements for the Training Workshop:

  • The duration of the training is 3 days from 8 am to 5 pm.
  • The training free of charge but you will be covering your own travel, accommodation and expenses.
  • Participants are expected to have an understanding of the basics of D365 F&O. This class will not teach you how to use D365 F&O.
  • Participants are expected to have an understanding of how to use the Jet Data Manager. This class will not to teach you how to configure and use the Jet Data Manager.  We will be using the JDM in this class.
  • You are required to have working knowledge of Visual Studio Development Environment.
  • This class is not to teach you how to setup and configure SQL Azure.  You must have a SQL Azure DB setup prior to attending.  You must also be able to whitelist your IP address because during the training your IP address will be different then when you set it up.
  • You must have access to a D365 F&O environment.
    • If there are more than 1 person from you company attending, you will need your own instance of D365 and your own SQL Azure DB.  You will not be able to complete the exercises while sharing an instance.
    • If you just want to use the VM instance of D365 you will need a machine that will host a VM while allocating at least 16 GB of ram and 125 GB of disk space.  This means if you bring a laptop it needs to have 32 GB of RAM and plenty of extra disk space.  SSD HD would be ideal.  Hosting the VM disk image on an external drive will be slower.  Jet Global can provide you with an image if requested 2 weeks prior to the class.  This will allow you to host it on your Server and then remote into it during the training.
    • Additional setup steps will be required to the provided VM. These must be completed prior to the training class as we will not be taking class time to complete these tasks.

Q&A Follow up after Training

Approximately 2 weeks after the training workshop is complete, Jet will host a 2 hour Q&A session. This will be your opportunity to resolve any outstanding issues you have come across while practicing after the class. If you cannot make the allotted time, Jet Global will do our best to accommodate and schedule a second session.

Certification Exam

  • The exam is free form and consists of a list of tasks to complete for a D365 F&O Jet Analytics implementation.
  • You will have 2 hours to complete the exam.
  • The exam will be online and proctored by Jet Global.

If you feel you are capable of passing the exam without taking the 3 day Training Workshop, please reach out to rons@jetglobal.com to schedule your exam. Please be sure that you know how to create and maintain data entities in F&O, and create a new project for F&O in the JDM.