Agile BI: Test Automation and Test-Driven Database Development Training

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