Getting acquainted with BI testing

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

Transcript

1. GETTING ACQUAINTED WITH BI TESTING Alyona Tudan, QA Engineer, N-iX
2. IMAGINE YOU HAVE A REPORT
4. YOU NEED TO TEST IT  How will you do that?  What do you need for that?
5. IMAGINE…  The reports’ results are influencing the salary of the person
6. IMAGINE…  You’ve passed a bug and now your family is cursed
7.  So how you will test it?
8. LET’S TRY TOGETHER
9. FIRST OF ALL  We need to understand what are we testing  Specification  Description  Task in bug-tracker  Names
10. INVESTIGATE  What does the report show?  Where are the data from?  Test-design
11. TESTING  Compare data from the source and the report  Check the aggregations  Check the functions  Provide acceptance testing
12. WHAT IS THE SOURCE?  Database  DWH  Analysis programs
13. LET’S TAKE A LOOK ON POSSIBLE SOURCES
14. DATABASE  Unit testing  Mappings  CRUD  Triggers  Constraints  Procedures
15. 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
16. DWH  Facts tables  Dimensions tables  Integration testing  Unit testing (data)  Mappings
17. OLAP - ONLINE ANALYTICAL PROCESSING  a computer-based technique for analyzing business data in the search for business intelligence.
18. OLAP  Measures  Dimensions  Aggregations
19. OLAP FUNCTIONS  Roll-up: aggregate on higher level  Drill-down: aggregate on lower level  Slice: selection on one dimension  Dice: selection on more dimensions
20. 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
21. OLAP VIEW  Mappings  Naming  Translations
22. ONE MORE THING
23. HOW DO THE DATA PASS TO THE DWH?
24. 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
25. TESTING ETL  Functional testing  Acceptance testing  White-box testing  Mappings  Test samples (incoming, outgoing data)
26. 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
27. REPORTS’ TESTING  Functional testing  Acceptance testing  White-box testing  Mappings  Test samples (incoming, outgoing data)  UI  Usability
28. DO NOT FORGET ABOUT FAMILY CURSE!
30. UI VS BI
31. BI QA MINDSET  Excitement  Perfectionism  Perseverance  Accuracy  Technicality  Something I’ve missed 
32. LET’S SUMMARIZE
33. WHAT’S BI?
34. 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
35. BI STARTS FROM DATA
36. DATABASE
37. BI PURPOSE Data Information Knowledge
38. HOW TO MANAGE DATA FROM DB?
39. DWH - DATA WAREHOUSE
40. HOW TO MOVE DATA INTO DWH?
41. DB -> ETL -> DWH -> OLAP DB Data Data Data DWH
42. FROM DATABASE TO CUBE DWH Database ETL Database Processing Cube 1 2 1 – staging tables 2 – fact and dimension tables Transform
43. OLAP: ONLINE ANALYTICAL PROCESSING
45. QUESTIONS