BI Testing Table of Contents


Table of Content
 

 

Software Testing Basics

  • Scope
  • Functional vs. Non-Functional testing
  • Defects and Failures
  • Finding Faults Early
  • Compatibility
  • Input Combinations and Preconditions
  • Static vs. Dynamic Testing
  • Software Verification and Validation
  • The Software Testing Team
  • Software Quality Assurance (SQA)
  • Testing Methods - The box approach

SQL Basics

  • Relational Model
  • Normalization
  • DDL Commands
  • DML Commands
  • Joins
  • Functions
  • Cursor
  • Procedures

Data Warehousing Basics

  • Introduction to Data Warehousing
  • Data Warehousing Characteristics
  • OLAP and OLTP
  • Data Warehousing Architecture
  • Data Models
  • Data Schemas (Star and Snow Flake)
  • Data Mart
  • Data Lake

BI Basics

  • Evolution and Need
  • Data Mining
  • Data Reconciliation
  • ETL Process
  • ETL Transformations
  • ETL Testing Types

BI Test Design

  • Test Design
  • BI Test Scenarios
  • BI Reports Testing Scenarios
  • BI Testing Challenges
  • BI Testing Requirements Gathering
  • BI Testing High Level Design
  • BI Testing Low level Design

BI Test Execution

  • Unit Testing
  • Integration Testing
  • BI Test Development
  • BI Testing Defects
  • Defects Reporting

BI Functional Testing

  • What is BI Functional Testing
  • BI Testing for Data Accuracy
  • BI Testing for Metadata
  • BI Testing for Data Transformations
  • BI Testing for Data Quality
  • BI Testing for Data Completeness

Adhoc Report Testing

  • What is Adhoc Report Testing
  • Subject Area Design Check
  • Mapping Check
  • Joins Check

BI Security Testing

  • What is BI Security Testing
  • Report Access Security
  • Data Security (or Position based Security)
  • Single Sign-on Security
  • Integrated Security

BI Regression Testing

  • What is BI Regression Testing
  • Reference Data Testing
  • Incremental BI Testing

BI Stress Testing

  • What is BI Stress Testing
  • BI Testing for Scalability



Apply for Certification

https://www.vskills.in/certification/testing/bi-testing-certification

 For Support