Is your Data Warehouse / BI solution PASS or No PASS?

PASS stands for

• Performance
• Accuracy
• Security
• Scalability

  

Performance

- Extracting data

- Data cleansing

- Transformation

- Loading to Data Warehouse

- Fetching data from DWH / marts

   

Accuracy

- Business logic understanding

- Error Handling

- Missing data

- Data configuration

- Multiple source integration

- SCD

- KPI Calculation

- Aggregations / Roll ups

- Single Version of Truth

   

Security

- Dimension Security

- AD user access

- Sharepoint Taxonomy

- Kerberos

   

Scalable

- Expansion of scope

- Adding more sources

- Adding more vertical information

- Adding more users

- Handling more volume of data

- Change of Hardware architecture

- Support multiple Visualization Tools