110 likes | 224 Views
The World Bank’s Business Warehouse (BW): Interpreting and Analyzing Procurement Data Marcelo Donolo, OPCPR May 10, 2005. Objectives - Overview of Business Warehouse (BW) - Interpreting BW datasets - Analyzing results.
E N D
The World Bank’s Business Warehouse (BW): Interpreting and Analyzing Procurement Data Marcelo Donolo, OPCPRMay 10, 2005
Objectives- Overview of Business Warehouse (BW)- Interpreting BW datasets- Analyzing results
Overview of Business Warehouse (BW)- SAP Reporting system - Cube structure- Captures data entered through SAP/R3
Interpreting BW Datasets- Captured data includes:- Excel format - IDA/IBRD commitments (investment lending) - Contracts > prior review threshold - Contracts under client-executed TF’s - Amounts in US$
Interpreting BW Datasets- Captured data does not include:- Actual disbursed amounts @ contract level - Loan disbursement categories - Currency payment terms - Ex-post review contracts - Adjustment lending
Interpreting BW Datasets- Report Types- Summary Reports (5 types) - Detailed Reports (for 29 PSLO countries)- Report Availability- Click hereto access the report page - Update Frequency: 1 month after end of quarter- Q1 = Jul, Aug, Sept = Updated by Oct 1 - Q2 = Oct, Nov, Dec = Updated by Jan 5 - Q3 = Jan, Feb, Mar = Updated by Apr 1 - Q4 = Apr, May Jun = Updated by July 1
Interpreting BW Datasets- Summary Reports - Contract volume - Aggregate amounts - 4-5 year trends - Types of summary breakdown- By region - By OECD status category - By type of contract
Interpreting BW Datasets- Detailed Reports - Country-specific (29 PSLO countries) - Detailed data attributes
Interpreting BW Datasets- Detailed Data Attributes- Region - Borrower - Sector - Category (goods, works, consult, srvcs) - Type of contract - Method of selection (ICB, NCB, QCBS…) - Project ID & name - Loan/Credit # - Agreement type (IDA, IBRD, GEF, etc) - Contract description - Supplier name - Amount in US$ or US$ equivalent