Agile BI: Test Automation and Test-Driven Database Development, New Zealand

We can host this training at your preferred location. Contact us!

Agile testing involves three key elements: tools and technology, principles and practices, and mindset and behaviors. This course will introduce you to agile testing principles, test-first development practices, the importance of testing as a front-end development driver rather than a back-end quality assurance activity, and effective open source database testing tools. This class will also introduce the mindset that testing and quality is everyone’s job, and that each person on an agile analytics team has a part in testing.

There are no prerequisites for this course.

Data warehouse architects, designers, developers, and administrators
Business intelligence practitioners
Business analysts and product owners
Data warehousing project managers

How to keep a continuous focus on quality
Agile testing framework versus conventional testing
Database testing techniques
Principles for developing robust test suites
Open source testing tools such as Fitnesse/DbFit and Cucumber
How to version control your test suites
Behavior Driven Development (BDD)
Test-Driven Development (TDD)
Testing roles and responsibilities
Writing good Acceptance Criteria for DW/BI user stories

1. Agile Overview

Agile Manifesto & Guiding Principles

2. Agile Testing Values & Principles

Perspectives and Mindset
Whole Team Approach
Attitudes and Culture
Customer Collaboration

3. Agile BI Testing Overview

Conventional Testing Approach
Agile Demands Something Different
Scrummerfall Anti-Pattern
Testing Feedback Loop
Agile Testing Model

4. Database Testing Strategies

Critical Testing Points
Component Under Test
Test Data
Test Queries
Data Testing Tactics
Testing Type 2 Dimensions
When Test Data Grows Stale

5. Test Automation

Test Automation Pyramid
Automation Approach
Sandbox Infrastructure
DW/BI Test Automation Tools

6. Definition of Done and Acceptance Criteria

Definition of Done
Acceptance Criteria
Acceptance Criteria Process
What Happens if a Story Isn't Accepted?
Example BI User Story and Acceptance Criteria

7. Story Testing

Story Testing Example
Test-Driven Development
Story-Test-Driven Development
Behavior-Driven Development (BDD)
BDD Tools

Upcoming Trainings

Join our public courses in our New Zealand facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom

20 May 2024