UNITED Courses

Certified Data & Analytics Tester

A 2-day training to advance your software testing career and influence global software development.

Course overview:

Data & Analytics United – Certified Data & Analytics Tester (DAU – CDAT) is a 2-day interactive certification course to help you develop the skills and knowledge to survive as a tester in a data and analytics environment.

This course enables testers to define the test strategy for data intensive applications and teaches them on how to apply it to an efficient test approach in data-oriented environments and projects.  Test specification and design techniques specific to data and analytics projects are covered as a part of the syllabus.

It teaches different data quality attributes, essential data profiling techniques, privacy aspects of the data and specifics of test environment for data and analytics testing.

Major takeaways:

➜   Understand the complexity and elements in a Business Intelligence (BI) & Data Analytics (DA) environment
➜   Understand the specific aspects of testing in a BI & DA environment
➜   Learn and apply different test techniques practiced in a BI & DA environment
➜   Understand the different test aspects of a BI & DA environment compared to traditional testing, e.g., OLAP testing, Transformation testing, Completeness testing
➜   Understand the difference between quality attributes for system requirements and the specific quality attributes applied to data environments
➜   Understand and assess risk analysis and how to apply this in a BI & DA environment given the specific aspects of the environment
➜   Understand and assess the complexity of data and the importance of the use in DA
➜   Have knowledge about the complexity of DTAP environments (Development, Test, Acceptance and Production) in a BI & DA environment
➜   Understand the effects of privacy and data protection regulations for testing in DA projects

Best suited for:

This certification program is designed for test engineers, test coordinators, managers, business analysts, data leads, data warehouse developers and BI-consultants. Testers who are testing BI and DA projects and people who are managing such projects will benefit from this program.

Course outline:

1. Introduction to Business Intelligence (BI) and Data & Analytics (DA)
  • Business Intelligence
  • Challenges when turning corporate data into information
  • Data Warehouse
  • Data Mart
  • Data Lake
  • Data Analytics
  • Big Data
  • Data Mining
  • OLTP vs OLAP
  • Reporting and Data
  • Visualization
  • Data Modeling
  • The ETL-Process
  • Internationalization and Localization
  • Testing and Test Methodologies
  • BI & DA Testing in a traditional approach
  • BI & DA Testing in an agile approach
  • Risk based Testing in a BI & DA environment
  • Testing Roles and Skills
  • Set-up a test-strategy and approach in a BI environment
  • What are test techniques
  • Different techniques
  • Mapping techniques on a BI & DA Environment
  • Reports- and Dashboards Testing
  • Testing of OLAP Cubes
  • Testing the Data Model
  • Testing in Data Mining
  • Completeness Testing
  • Transformation Testing
  • E2E testing
  • Quality
  • Quality Characteristics
  • Data Quality Characteristics
  • Data Profiling
  • Test environments according to DTAP
  • Multidimensional DTAP in a BI environment
  • Impact of Security Standards like ISO/IEC 27001 on Analytics Testing
  • Impact of Privacy Regulations on Testing in the Analytics Environment
  • Encryption methodologies for Anonymization and Pseudonymization
  • Common Pitfalls using Production Data



What is the duration and timings of this course?

This is a 2 full day course which will start at 09:30 AM and end at 05:30 PM on all the 2 days.

No. We do not provide any tools with this course.

Yes this certification is valid for lifetime.

No, we do not provide placement.

The maximum batch size is 20 members in one batch.

Yes post training support will be provided, you can contact the trainers for any queries which you may have.

No, coding is not a prerequisite.

We strongly recommend that the participants attend the batch which they have specifically registered for. There can be exceptions in case of emergencies but the difference in fee(if any) will have to be borne by the participant.

No we do not provide refunds upon cancellation.

Yes we can arrange for an in-house batch for your company given there are a minimum of 10 participants per batch.

data analytics united



Dr. Srinivas Padmanabhuni

Program highlights:

Book your slot

Other trending courses

Speak to an Expert

Please call on the below contact numbers directly or fill in your details for a call back from our team.

Mr. Vinay +91 99101 05147 
Mr. Anil +91 98230 64054