BI Specialist

Core Training

The BI Specialist training will equip specialists with the necessary practical knowledge to test at all key stages of the BI process.

  • Prerequisites: General IT knowledge and basic knowledge of SQL
  • Learn how to use Tosca to quickly test your BI process
  • Self-paced or instructor-led training
  • Practical experience with Tricentis Tosca

What is BI Specialist?

BI Specialist is an introduction to the principles of data warehouse (DWH) / Business intelligence (BI) testing using Tricentis Tosca BI.

As well as core BI functionalities such as Database queries, File tests and using the Vital Checks Wizard, you will also learn the basics of test automation within Tricentis Tosca, allowing you to create basic automated TestCases as well as expand your knowledge to fully test the BI process.

By the end of the course, you will have the understanding to test at all the key stages of the BI process.

What skills will you have upon completing the course?
By the end of the course you will be able to automate a basic HTML TestCase, execute database queries, run pre-screening file tests, use the Wizard for both Vital Checks and Field Tests, run dataset comparisons and use the parallel execution functions.

Course details

The following are prerequisites, and are required on the machine used for training to be able to complete this course:

  • MS SQL Server (2014+)
  • Adventure Works 2014 Database
  • DB Browser for SQLite and SQLite Driver (32 and 64 bit)
  • MS SQL Server Management Studio
  • Basic knowledge of SQL (to generate SQL/SQLite queries) is also required to successfully complete the course

How can you take the training?

The form your learning will take is completely up to you.

You can choose to learn only using self-paced learning or you can choose to take part in instructor-led training.

The Self-Paced Training is especially suitable for individuals and groups who need to fit their Tosca learning around a busy schedule.

Delivery method

  • Self-paced learning
  • Learning material is provided online
  • Approx. 15-20 hours average duration for completion


  • General IT knowledge


  • Courseware: English

The Instructor-Led Training is especially suitable for groups whose main focus is to become highly proficient users of Tosca Testsuite in very short time period.

Delivery method

  • Instructor-led classroom training
  • Learning material is provided online
  • 2 days of classroom training*
    * Classroom training is limited to a group size of max. 10 students


  • General IT knowledge


  • Instructor-led training delivery: English or German
  • Courseware: English