Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Getting acquainted with BI testing

ymkocv
September 16, 2015
74

Getting acquainted with BI testing

What's BI
DB, ETL, OLAP, reports overview
BI test activities

ymkocv

September 16, 2015
Tweet

Transcript

  1. YOU NEED TO TEST IT  How will you do

    that?  What do you need for that?
  2. FIRST OF ALL  We need to understand what are

    we testing  Specification  Description  Task in bug-tracker  Names
  3. TESTING  Compare data from the source and the report

     Check the aggregations  Check the functions  Provide acceptance testing
  4. DWH - DATA WAREHOUSE  a system used for reporting

    and data analysis. Data Warehouses are central repositories of integrated data from one or more disparate sources
  5. OLAP - ONLINE ANALYTICAL PROCESSING  a computer-based technique for

    analyzing business data in the search for business intelligence.
  6. OLAP FUNCTIONS  Roll-up: aggregate on higher level  Drill-down:

    aggregate on lower level  Slice: selection on one dimension  Dice: selection on more dimensions
  7. OLAP FUNCTIONS  Rotate  Drill across: more facts for

    few dimensions  Drill-through: to the bottom level  Cross tab: returns values based on criteria you specify
  8. ETL: EXTRACT, TRANSFORM, LOAD1  Extract is the process of

    reading data from a database  Transform is the process of converting the extracted data  Load is the process of writing the data into the target database 1) http://www.webopedia.com/TERM/E/ETL.html
  9. TESTING ETL  Functional testing  Acceptance testing  White-box

    testing  Mappings  Test samples (incoming, outgoing data)
  10. COMING BACK TO REPORT  Be sure what do you

    need to test  Be sure you understand well what is going on  Be sure you will do your best
  11. REPORTS’ TESTING  Functional testing  Acceptance testing  White-box

    testing  Mappings  Test samples (incoming, outgoing data)  UI  Usability
  12. BI QA MINDSET  Excitement  Perfectionism  Perseverance 

    Accuracy  Technicality  Something I’ve missed 
  13. BI = BUSINESS INTELLIGENCE  the set of techniques and

    tools for the transformation of raw data into meaningful and useful information for business analysis purposes1  the ability of an organization to collect, maintain, and organize knowledge2. The goal is to support business decision‐making. Thus a BI system can be called a decision support system (DSS) 1) https://en.wikipedia.org/wiki/Business_intelligence 2) http://www.fgfoa.org/assets/files/tedgrable_presentation.pdf
  14. FROM DATABASE TO CUBE DWH Database ETL Database Processing Cube

    1 2 1 – staging tables 2 – fact and dimension tables Transform